public ARCSSocietyStatusModels BackLogGetARCSApplicatonCountDetails(int ARCSCode)
{
ARCSSocietyStatusModels objARCSSSM = new ARCSSocietyStatusModels();
using (SqlConnection con = new SqlConnection(ConStr))
{
con.Open();
SqlCommand com = new SqlCommand("[dbo].[Blog_GetARCSApplicatonCountDetails]", con)
{
CommandType = CommandType.StoredProcedure
};
com.Parameters.AddWithValue("@ARCSCode", ARCSCode);
SqlDataReader rdr = com.ExecuteReader();
while (rdr.Read())
{
objARCSSSM.TotalApprove = Convert.ToInt32(rdr["TotalApprove"]);
objARCSSSM.TotalHold = Convert.ToInt32(rdr["TotalHold"].ToString());
objARCSSSM.TotalPending = Convert.ToInt32(rdr["TotalPending"]);
objARCSSSM.TotalReject = Convert.ToInt32(rdr["TotalReject"].ToString());
objARCSSSM.TotalForwardToInspector = Convert.ToInt32(rdr["TotalForwardToInspector"].ToString());
objARCSSSM.TotalApplicationComesFromInspector = Convert.ToInt32(rdr["TotalApplicationComesFromInspector"].ToString());
objARCSSSM.Total = objARCSSSM.TotalApplicationComesFromInspector + objARCSSSM.TotalApprove + objARCSSSM.TotalHold + objARCSSSM.TotalPending + objARCSSSM.TotalReject + objARCSSSM.TotalForwardToInspector;
}
return(objARCSSSM);
}
}
public ActionResult BackLogDashboard()
{
ARCSSocietyStatusModels objARCSSM = new ARCSSocietyStatusModels();
objARCSSM = objARCSD.BackLogGetARCSApplicatonCountDetails(Convert.ToInt32(Session["ARCSCode"]));
ViewBag.Total = objARCSSM.Total;
ViewBag.TotalApprove = objARCSSM.TotalApprove;
ViewBag.TotalHold = objARCSSM.TotalHold;
ViewBag.TotalPending = objARCSSM.TotalPending;
ViewBag.TotalReject = objARCSSM.TotalReject;
ViewBag.TotalForwardedToInspector = objARCSSM.TotalForwardToInspector;
ViewBag.TotalApplicationComesFromInspector = objARCSSM.TotalApplicationComesFromInspector;
return(View());
}
