Count No of Records returned

Ramco Ramco

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
Accepted 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); } } }
0
Ramco Ramco5y ago
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
0
Jignesh Kumar5y ago
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();
0