public ActionResult BackLogDashboardInspector() { if (Convert.ToString(Session["BrowserId"]) != GenerateHashKeyForCheckBroswerEveryCall()) { return(RedirectToAction("Login", "Account")); } //int i = obj.CheckSessionEveryCall(); //if (i != 0) //{ // return RedirectToAction("Login", "Account"); //} InspectorSocietyStatusModels objISSM = new InspectorSocietyStatusModels(); objISSM = objID.BackLogGetInspectorApplicatonCountDetails(Convert.ToInt32(Session["InsceptorCode"])); ViewBag.Total = objISSM.Total; ViewBag.TotalApprove = objISSM.TotalApprove; ViewBag.TotalPending = objISSM.TotalPending; return(View()); }
public InspectorSocietyStatusModels BackLogGetInspectorApplicatonCountDetails(int InspectorCode) { InspectorSocietyStatusModels objISSM = new InspectorSocietyStatusModels(); using (SqlConnection con = new SqlConnection(ConStr)) { con.Open(); SqlCommand com = new SqlCommand("[dbo].[Blog_GetInspectorSApplicatonCountDetails]", con) { CommandType = CommandType.StoredProcedure }; com.Parameters.AddWithValue("@InspectorCode", InspectorCode); SqlDataReader rdr = com.ExecuteReader(); while (rdr.Read()) { objISSM.TotalApprove = Convert.ToInt32(rdr["TotalForwardToARCSOfficer"]); objISSM.TotalPending = Convert.ToInt32(rdr["TotalPending"]); objISSM.Total = objISSM.TotalApprove + objISSM.TotalPending; } return(objISSM); } }