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