public ActionResult EditMaintenanceSchedule(int MaintenanceScheduleId)
{
MaintenanceScheduleModel model = noticeBoardHelper.GetMaintenanceScheduleDetail(MaintenanceScheduleId);
ViewBag.CommonAreaList = CommonData.GetCommonAreaList(ClientSessionData.ClientStrataBoardId);
return(PartialView("EditMaintenanceSchedule", model));
}
public ActionResult ViewMaintenanceSchedule(int MaintenanceScheduleId)
{
MaintenanceScheduleModel maintenanceScheduleModel = new MaintenanceScheduleModel();
if (ClientSessionData.UserClientId != 0)
{
maintenanceScheduleModel = noticeBoardHelper.GetMaintenanceScheduleDetail(MaintenanceScheduleId);
}
return(PartialView("ViewMaintenanceSchedule", maintenanceScheduleModel));
}
public MaintenanceScheduleModel GetMaintenanceScheduleDetail(int MaintenanceScheduleId)
{
if (ClientSessionData.UserClientId != 0)
{
MaintenanceScheduleModel maintenanceScheduleModel = new MaintenanceScheduleModel();
try
{
var MaintenanceSchedule = _context.vw_GetMaintenanceSchedule.Where(x => x.StratasBoardId == ClientSessionData.ClientStrataBoardId && x.MaintenanceScheduleId == MaintenanceScheduleId).FirstOrDefault();
if (MaintenanceSchedule != null)
{
maintenanceScheduleModel.MaintenanceScheduleId = MaintenanceSchedule.MaintenanceScheduleId;
maintenanceScheduleModel.CommonAreaId = MaintenanceSchedule.CommonAreaId.Value;
maintenanceScheduleModel.Description = MaintenanceSchedule.Description;
maintenanceScheduleModel.StartTimeHour = MaintenanceSchedule.ScheduleDate.Value.Hour;
maintenanceScheduleModel.CommonAreaName = MaintenanceSchedule.CommonAreaName;
maintenanceScheduleModel.CreatedOn = MaintenanceSchedule.CreatedOn != null?MaintenanceSchedule.CreatedOn.Value.ToString("dd MMM, yyyy") : "N/A";
maintenanceScheduleModel.ScheduleDate = MaintenanceSchedule.ScheduleDate != null?MaintenanceSchedule.ScheduleDate.Value.ToString("dd MMM yyyy") : "";
if (maintenanceScheduleModel.StartTimeHour == 0)
{
maintenanceScheduleModel.StartTimeHour = 12;
maintenanceScheduleModel.StartTimeAmPm = "AM";
}
else if (maintenanceScheduleModel.StartTimeHour >= 12) //// For PM
{
if (maintenanceScheduleModel.StartTimeHour > 12)
{
maintenanceScheduleModel.StartTimeHour = maintenanceScheduleModel.StartTimeHour - 12;
}
maintenanceScheduleModel.StartTimeAmPm = "PM";
}
else //// For AM
{
maintenanceScheduleModel.StartTimeAmPm = "AM";
}
maintenanceScheduleModel.StartTimeMinute = Convert.ToInt32(MaintenanceSchedule.ScheduleDate.Value.Minute.ToString().PadLeft(2, '0'));
}
}
catch
{
}
return(maintenanceScheduleModel);
}
else
{
return(null);
}
}
public List <MaintenanceScheduleModel> GetAllMaintenanceSchedule(int BlockNumber, int BlockSize)
{
if (ClientSessionData.UserClientId != 0)
{
int startIndex = (BlockNumber - 1) * BlockSize;
List <MaintenanceScheduleModel> maintenanceScheduleModelList = new List <MaintenanceScheduleModel>();
try
{
var MaintenanceSchedules = _context.vw_GetMaintenanceSchedule.Where(x => x.StratasBoardId == ClientSessionData.ClientStrataBoardId).ToList();
foreach (var item in MaintenanceSchedules)
{
int i = 0;
MaintenanceScheduleModel maintenanceScheduleModel = new MaintenanceScheduleModel();
maintenanceScheduleModel.MaintenanceScheduleId = item.MaintenanceScheduleId;
maintenanceScheduleModel.Description = string.IsNullOrEmpty(item.Description) ? "N/A" : item.Description;
maintenanceScheduleModel.StartTime = item.ScheduleDate.Value.ToString("hh:mm tt");
maintenanceScheduleModel.ScheduleDate = item.ScheduleDate != null?item.ScheduleDate.Value.ToString("dd MMM, yyyy") + " at " + maintenanceScheduleModel.StartTime : "";
maintenanceScheduleModel.CreatedOn = item.CreatedOn != null?item.CreatedOn.Value.ToString("dd MMM, yyyy") : "N/A";
maintenanceScheduleModel.CommonAreaName = item.CommonAreaName;
maintenanceScheduleModelList.Add(maintenanceScheduleModel);
i++;
}
}
catch
{
}
maintenanceScheduleModelList = maintenanceScheduleModelList.Skip(startIndex).Take(BlockSize).ToList();
return(maintenanceScheduleModelList);
}
else
{
return(null);
}
}
public ActionResult EditMaintenanceSchedule(MaintenanceScheduleModel model)
{
int result = 0;
string strMsg = "";
if (ModelState.IsValid)
{
result = noticeBoardHelper.AddUpdateMaintenanceSchedule(model);
if (result == -1)
{
strMsg = "Maintenance Schedule already exists for Common Area with given date";
}
else if (result == 1)
{
strMsg = "Maintenance Schedule updated successfully.";
}
else
{
strMsg = "Maintenance Schedule updation failed.";
}
}
return(Json(new { result = result, Msg = strMsg }));
}
public int AddUpdateMaintenanceSchedule(MaintenanceScheduleModel maintenanceScheduleModel)
{
int result = 0;
try
{
tblMaintenanceSchedule tblMaintenanceScheduleDb = new tblMaintenanceSchedule();
tblMaintenanceScheduleDb.CommonAreaId = maintenanceScheduleModel.CommonAreaId;
tblMaintenanceScheduleDb.Description = maintenanceScheduleModel.Description;
tblMaintenanceScheduleDb.Status = 1;
tblMaintenanceScheduleDb.CreatedBy = ClientSessionData.UserClientId;
tblMaintenanceScheduleDb.CreatedOn = DateTime.UtcNow;
tblMaintenanceScheduleDb.CreatedFromIP = HttpContext.Current.Request.UserHostAddress;
tblMaintenanceScheduleDb.ModifiedBy = ClientSessionData.UserClientId;
tblMaintenanceScheduleDb.ModifiedOn = DateTime.UtcNow;
tblMaintenanceScheduleDb.ModifiedFromIP = HttpContext.Current.Request.UserHostAddress;
tblMaintenanceScheduleDb.StratasBoardId = ClientSessionData.ClientStrataBoardId;
tblMaintenanceScheduleDb.ScheduleDate = Convert.ToDateTime(maintenanceScheduleModel.ScheduleDate);
if (maintenanceScheduleModel.StartTimeAmPm == "PM")
{
if (maintenanceScheduleModel.StartTimeHour != 12)
{
maintenanceScheduleModel.StartTimeHour = Convert.ToInt32(maintenanceScheduleModel.StartTimeHour) + 12;
}
}
else if (maintenanceScheduleModel.StartTimeAmPm == "AM")
{
if (maintenanceScheduleModel.StartTimeHour == 12)
{
maintenanceScheduleModel.StartTimeHour = 0;
}
}
tblMaintenanceScheduleDb.ScheduleDate = tblMaintenanceScheduleDb.ScheduleDate.Value.AddHours(Convert.ToInt32(maintenanceScheduleModel.StartTimeHour)).AddMinutes(Convert.ToInt32(maintenanceScheduleModel.StartTimeMinute));
var MaintenanceSchedule = _context.tblMaintenanceSchedules.Where(x => x.CommonAreaId == tblMaintenanceScheduleDb.CommonAreaId && x.ScheduleDate == tblMaintenanceScheduleDb.ScheduleDate).FirstOrDefault();
if (MaintenanceSchedule != null)
{
result = -1;
}
else
{
if (maintenanceScheduleModel.MaintenanceScheduleId > 0)
{
tblMaintenanceScheduleDb.MaintenanceScheduleId = maintenanceScheduleModel.MaintenanceScheduleId;
_context.tblMaintenanceSchedules.Attach(tblMaintenanceScheduleDb);
_context.Entry(tblMaintenanceScheduleDb).Property(x => x.Description).IsModified = true;
_context.Entry(tblMaintenanceScheduleDb).Property(x => x.CommonAreaId).IsModified = true;
_context.Entry(tblMaintenanceScheduleDb).Property(x => x.ScheduleDate).IsModified = true;
_context.Entry(tblMaintenanceScheduleDb).Property(x => x.ModifiedBy).IsModified = true;
_context.Entry(tblMaintenanceScheduleDb).Property(x => x.ModifiedOn).IsModified = true;
_context.Entry(tblMaintenanceScheduleDb).Property(x => x.ModifiedFromIP).IsModified = true;
result = _context.SaveChanges();
}
else
{
_context.tblMaintenanceSchedules.Add(tblMaintenanceScheduleDb);
result = _context.SaveChanges();
}
}
}
catch
{
}
return(result);
}
public ActionResult AddMaintenanceSchedule()
{
MaintenanceScheduleModel model = new MaintenanceScheduleModel();
return(PartialView("AddMaintenanceSchedule", model));
}
