public ActionResult GetInternetDashboarddata()
{
try
{
DashBoardDataVM _obj = _dashboardDA.GetInternetDashboarddata() ?? new DashBoardDataVM();
return(Json(new { success = true, data = _obj }, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
throw;
}
}
public DashBoardDataVM GetInternetDashboarddata()
{
DashBoardDataVM _obj = new DashBoardDataVM();
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("gsp_getInternetDashboarddata", con);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
_obj.totalActiveUsers = Convert.ToInt32(rdr["totalActiveUsers"]);
_obj.totalInactiveUser = Convert.ToInt32(rdr["totalInactiveUser"]);
_obj.discontinuedUserThisMonth = Convert.ToDecimal(rdr["discontinuedUserThisMonth"]);
_obj.generatedBillThisMonth = Convert.ToDecimal(rdr["generatedBillThisMonth"]);
_obj.collectedThisMonth = Convert.ToDecimal(rdr["collectedThisMonth"]);
_obj.todaysCollectedAmount = Convert.ToDecimal(rdr["todaysCollectedAmount"]);
}
con.Close();
}
return(_obj);
}
