List of Record RSS

• • Reply
  jagjit saini

  Member

  46 Points

  181 Posts

  List of Record

  Jan 15, 2021 11:06 AM|jagjit saini|LINK

  Hi

     I have below 2 methods (RecordNavigation , DataRecords). How i can use these 2 methods  in GetAllLocation

  public bool RecordNavigation(string SrcSql, SqlParameter[] paramArr, SrcType SourceType = SrcType.SqlQuery)
          {
              SqlCommand comm = new SqlCommand();
  
              try
              {
                  comm.CommandText = SrcSql;
  
                  if (SourceType == SrcType.SqlQuery)
                      comm.CommandType = CommandType.Text;
                  else if (SourceType == SrcType.Table)
                      comm.CommandType = CommandType.TableDirect;
                  else if (SourceType == SrcType.StoredProcedure)
                      comm.CommandType = CommandType.StoredProcedure;
  
                  comm.Connection = Cnn;
  
                  foreach (SqlParameter param in paramArr)
                      comm.Parameters.Add(param);
  
                  comm.Connection.Open();
                  if (comm.Connection.State == ConnectionState.Open)
                  {
                      if (comm.ExecuteNonQuery() > 0)
                          return true;
                  }
              }
              catch (Exception ex)
              {
  
              }
              finally
              {
                  comm.Parameters.Clear();
                  comm.Connection.Close();
              }
              return false;
          }
          public DataSet DataRecords(string SrcSql, SrcType SourceType = SrcType.SqlQuery)
          {
              DataSet ds = new DataSet();
              SqlDataAdapter da = new SqlDataAdapter(SrcSql, Cnn);
              da.Fill(ds);
              return ds;
          }
  
  public IEnumerable<Location> GetAllLocation()
          {
              List<Location> lstLocation = new List<Location>();
              using (SqlConnection con = Cnn)
              {
                  SqlCommand cmd = new SqlCommand("sp_Location", con);
                  cmd.CommandType = CommandType.StoredProcedure;
                  cmd.Parameters.AddWithValue("@Action", "L");
                  con.Open();
                  SqlDataReader rdr = cmd.ExecuteReader();
  
                  while (rdr.Read())
                  {
                      Location location = new Location();
                      location.Code = Convert.ToInt32(rdr["Code"]);
                      location.Name = rdr["Name"].ToString();
                      location.Street = rdr["Street"].ToString();
                      location.City = rdr["City"].ToString();
                      lstLocation.Add(location);
                  }
                  con.Close();
              }
              return lstLocation;
          }

  Thanks

• • Reply
  Jerry Cai

  Participant

  990 Points

  327 Posts

  Re: List of Record

  Jan 18, 2021 07:19 AM|Jerry Cai|LINK

  Hi,jagjit saini

  jagjit saini

  How i can use these 2 methods  in GetAllLocation

  What do you mean about use these 2 methods in GetAllLocation?

  If you want to use these method, you can call them with their corresponding parameter, like:

  public IEnumerable<Location> GetAllLocation()
          {
              SqlParameter[] parameters =
              {
                  new SqlParameter("parm1", SqlDbType.VarChar)
              };
              bool bool1 = RecordNavigation("string", parameters, SrcType.SqlQuery);
              DataSet ds1 =DataRecords("string", SrcType.SqlQuery);
  
              List<Location> lstLocation = new List<Location>();
              //.....
              return lstLocation;
          }

  Edit: If you mean call these two methods from models while the GetAllLocation() method is in controller, then add static to these two methods

  and then call them like:

  model:
  public static DataSet DataRecords(string SrcSql, SrcType SourceType = SrcType.SqlQuery)
          {
              DataSet ds = new DataSet();
              //...
              return ds;
          }

  controller:
  DataSet ds1 = ModelName.DataRecords("string", SrcType.SqlQuery);

  Best Regards,

  Jerry Cai

  .NET forums are moving to a new home on Microsoft Q&A, we encourage you to go to Microsoft Q&A for .NET for posting new questions and get involved today.