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);
}
}
