public FacilitesModel GetFacilitiesStaffDashboard(StaffDetails details) { FacilitesModel facilitiesModel = new FacilitesModel(); facilitiesModel.FacilitiesDashboardList = new List <FacilitiesManagerDashboard>(); try { using (_connection) { if (_connection.State == ConnectionState.Open) { _connection.Close(); } command.Parameters.Clear(); command.Parameters.Add(new SqlParameter("@AgencyId", details.AgencyId)); command.Parameters.Add(new SqlParameter("@userId", details.UserId)); command.Parameters.Add(new SqlParameter("@RoleId", details.RoleId)); command.Connection = _connection; command.CommandType = CommandType.StoredProcedure; // command.CommandText = "USP_FacilitiesManagerDashboard"; command.CommandText = "USP_FacilitiesStaffDashboardCount"; dataAdapter = new SqlDataAdapter(command); _dataset = new DataSet(); dataAdapter.Fill(_dataset); if (_dataset.Tables[0] != null) { if (_dataset.Tables[0].Rows.Count > 0) { facilitiesModel.FacilitiesDashboardList = (from DataRow dr in _dataset.Tables[0].Rows select new FacilitiesManagerDashboard { CenterId = Convert.ToInt64(dr["CenterId"]), Enc_CenterId = EncryptDecrypt.Encrypt64(dr["CenterId"].ToString()), CenterName = dr["CenterName"].ToString(), OpenedWorkOrders = Convert.ToInt64(dr["OpenedWorkOrders"]), CompletedWorkOrders = Convert.ToInt64(dr["CompletedWorkOrders"]), TemporarilyFixedWorkOrders = Convert.ToInt64(dr["TemporarilyFixed"]) }).ToList(); } } } } catch (Exception ex) { clsError.WriteException(ex); } finally { dataAdapter.Dispose(); command.Dispose(); _dataset.Dispose(); } return(facilitiesModel); }
public ActionResult AgencyFacilitiesManagerDashboard() { FacilitesModel model = new FacilitesModel(); StaffDetails details = new StaffDetails(); try { details.AgencyId = (Session["AgencyID"] == null)?(Guid?)null: new Guid(Session["AgencyID"].ToString()); details.UserId = new Guid(Session["UserID"].ToString()); details.RoleId = new Guid(Session["RoleID"].ToString()); model = new FacilitiesData().GetFacilitiesModelDashboard(details); } catch (Exception ex) { clsError.WriteException(ex); } return(View(model)); }