Count No of Records returned

Question

Hi

I have below class & in Controller i want to get no of rows returned.

public Location GetById(string Id)
        {
            Location objLocation = new Location();
            try
            {
                using (SqlConnection con = new SqlConnection(Common.Con))
                {
                    con.Open();
                    SqlCommand cmd = new SqlCommand("sp_Location", con);
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Parameters.AddWithValue("@Id", Id);
                    cmd.Parameters.AddWithValue("@Action", "L");
                    SqlDataReader rdr = cmd.ExecuteReader();
                    while (rdr.Read())
                    {
                        objLocation.Id = rdr["Id"].ToString();
                        objLocation.Description = rdr["Description"].ToString();
                        objLocation.GstStateCode = rdr["GstStateCode"].ToString();
                        objLocation.GstStateName = rdr["GstStateName"].ToString();
                        objLocation.GstNo = rdr["GstNo"].ToString();
                        objLocation.IsActive = Convert.ToBoolean(rdr["IsActive"]);
                    }
                }
            }
            catch (Exception ex)
            {
                ExceptionLogging.SendExcepToDB(ex);
                return -1;
            }
            return objLocation;
        }

Thanks

Sachin Singh · Answer

public JsonResult IsExist(string Id) { var obj = dbLocation.GetById(Id); if (obj!=null) { return Json(true, JsonRequestBehavior.AllowGet); } else { return Json(false, JsonRequestBehavior.AllowGet); } } }

Ramco Ramco · Answer

Hi Jignesh I am trying like below but not working LocationDb dbLocation = new LocationDb(); public JsonResult IsExist(string Id) { int count = dbLocation.GetById(Id).Count(); if (count > 0) { return Json(true, JsonRequestBehavior.AllowGet); } else { return Json(false, JsonRequestBehavior.AllowGet); } } } ********************************************************** public Location GetById(string Id) { Location objLocation = new Location(); try { using (SqlConnection con = new SqlConnection(Common.Con)) { con.Open(); SqlCommand cmd = new SqlCommand("sp_Location", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Id", Id); cmd.Parameters.AddWithValue("@Action", "L"); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { objLocation.Id = rdr["Id"].ToString(); objLocation.Description = rdr["Description"].ToString(); objLocation.GstStateCode = rdr["GstStateCode"].ToString(); objLocation.GstStateName = rdr["GstStateName"].ToString(); objLocation.GstNo = rdr["GstNo"].ToString(); objLocation.IsActive = Convert.ToBoolean(rdr["IsActive"]); } } } catch (Exception ex) { ExceptionLogging.SendExcepToDB(ex); return -1; } return objLocation; } Thanks

Jignesh Kumar · Answer

Hi, Please check below one, you need to return list of location, Here you are returning only single location. public List GetById( string Id) { List listLocation = new List (); Location objLocation = new Location(); try { using (SqlConnection con = new SqlConnection(Common.Con)) { con.Open(); SqlCommand cmd = new SqlCommand( "sp_Location" , con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue( "@Id" , Id); cmd.Parameters.AddWithValue( "@Action" , "L" ); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { objLocation.Id = rdr[ "Id" ].ToString(); objLocation.Description = rdr[ "Description" ].ToString(); objLocation.GstStateCode = rdr[ "GstStateCode" ].ToString(); objLocation.GstStateName = rdr[ "GstStateName" ].ToString(); objLocation.GstNo = rdr[ "GstNo" ].ToString(); objLocation.IsActive = Convert.ToBoolean(rdr[ "IsActive" ]); listLocation.Add(objLocation); } } } catch (Exception ex) { ExceptionLogging.SendExcepToDB(ex); return -1; } return listLocation; } To get total count you can use count method, int totalLocationCount = GetById( string Id).Count();