public JsonResult DeleteGroupAndShiftMapping(int?id) { try { tblGroupAndShiftMapping groupAndShiftMapping = unitOfWork.GroupAndShiftMappingRepository.GetByID(id); if (groupAndShiftMapping == null) { return(Json(new { success = false, errorMessage = "Delete Failed" }, JsonRequestBehavior.AllowGet)); } unitOfWork.GroupAndShiftMappingRepository.Delete(groupAndShiftMapping); unitOfWork.Save(); return(Json(new { success = true, message = " Deleted Successfully" }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { success = false, errorMessage = ex.Message }, JsonRequestBehavior.AllowGet)); } }
public JsonResult AddGroupAndShiftMapping(VM_GroupAndShiftMapping groupAndShiftMapping, DateTime fromDate) { if (ModelState.IsValid) { try { var date = DateTime.Parse(fromDate.ToString()); var dateInfo = string.Format("{0:yyyy-MM-dd}", date); var inputDbDate = unitOfWork.GroupAndShiftMappingRepository.Get().Where(a => a.TransferDate.Value.Date == Convert.ToDateTime(dateInfo)).Select(x => x.TransferDate).ToList(); if (!inputDbDate.Any()) { if (groupAndShiftMapping.ShiftId == 1) { if (groupAndShiftMapping.GroupId == 1) { tblGroupAndShiftMapping aGroupAndShiftMapping = new tblGroupAndShiftMapping(); aGroupAndShiftMapping.TransferDate = fromDate; aGroupAndShiftMapping.Day = "A"; aGroupAndShiftMapping.Night = "B"; aGroupAndShiftMapping.RestaurantId = Int32.Parse(SessionManger.RestaurantOfLoggedInUser(Session).ToString()); aGroupAndShiftMapping.CreatedBy = SessionManger.LoggedInUser(Session); aGroupAndShiftMapping.CreatedDateTime = DateTime.Now; aGroupAndShiftMapping.EditedBy = null; aGroupAndShiftMapping.EditedDateTime = null; unitOfWork.GroupAndShiftMappingRepository.Insert(aGroupAndShiftMapping); unitOfWork.Save(); return (Json(new { success = true, successMessage = "Group and Shift Mapping successfully" }, JsonRequestBehavior.AllowGet)); } else { tblGroupAndShiftMapping aGroupAndShiftMapping = new tblGroupAndShiftMapping(); aGroupAndShiftMapping.TransferDate = fromDate; aGroupAndShiftMapping.Day = "B"; aGroupAndShiftMapping.Night = "A"; aGroupAndShiftMapping.RestaurantId = Int32.Parse(SessionManger.RestaurantOfLoggedInUser(Session).ToString()); aGroupAndShiftMapping.CreatedBy = SessionManger.LoggedInUser(Session); aGroupAndShiftMapping.CreatedDateTime = DateTime.Now; aGroupAndShiftMapping.EditedBy = null; aGroupAndShiftMapping.EditedDateTime = null; unitOfWork.GroupAndShiftMappingRepository.Insert(aGroupAndShiftMapping); unitOfWork.Save(); return (Json(new { success = true, successMessage = "Group and Shift Mapping successfully" }, JsonRequestBehavior.AllowGet)); } } else { if (groupAndShiftMapping.GroupId == 1) { tblGroupAndShiftMapping aGroupAndShiftMapping = new tblGroupAndShiftMapping(); aGroupAndShiftMapping.TransferDate = fromDate; aGroupAndShiftMapping.Day = "B"; aGroupAndShiftMapping.Night = "A"; aGroupAndShiftMapping.RestaurantId = Int32.Parse(SessionManger.RestaurantOfLoggedInUser(Session).ToString()); aGroupAndShiftMapping.CreatedBy = SessionManger.LoggedInUser(Session); aGroupAndShiftMapping.CreatedDateTime = DateTime.Now; aGroupAndShiftMapping.EditedBy = null; aGroupAndShiftMapping.EditedDateTime = null; unitOfWork.GroupAndShiftMappingRepository.Insert(aGroupAndShiftMapping); unitOfWork.Save(); return (Json(new { success = true, successMessage = "Group and Shift Mapping successfully" }, JsonRequestBehavior.AllowGet)); } else { tblGroupAndShiftMapping aGroupAndShiftMapping = new tblGroupAndShiftMapping(); aGroupAndShiftMapping.TransferDate = fromDate; aGroupAndShiftMapping.Day = "A"; aGroupAndShiftMapping.Night = "B"; aGroupAndShiftMapping.RestaurantId = Int32.Parse(SessionManger.RestaurantOfLoggedInUser(Session).ToString()); aGroupAndShiftMapping.CreatedBy = SessionManger.LoggedInUser(Session); aGroupAndShiftMapping.CreatedDateTime = DateTime.Now; aGroupAndShiftMapping.EditedBy = null; aGroupAndShiftMapping.EditedDateTime = null; unitOfWork.GroupAndShiftMappingRepository.Insert(aGroupAndShiftMapping); unitOfWork.Save(); return (Json(new { success = true, successMessage = "Group and Shift Mapping successfully" }, JsonRequestBehavior.AllowGet)); } } } else { return(Json(new { success = false, errorMessage = "Group and Shift Mapping Already done in this Date " }, JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { return(Json(new { success = false, errorMessage = ex.Message }, JsonRequestBehavior.AllowGet)); } } else { return(Json(new { success = false, errorMessage = "Model is not Valid" }, JsonRequestBehavior.AllowGet)); } }
public JsonResult UpdateGroupAndShiftMapping(VM_GroupAndShiftMapping groupAndShiftMapping) { try { tblGroupAndShiftMapping bGroupAndShiftMapping = unitOfWork.GroupAndShiftMappingRepository.GetByID(groupAndShiftMapping.GroupMappingId); if (bGroupAndShiftMapping == null) { return(Json(new { success = false, errorMessage = "Edit Failed" }, JsonRequestBehavior.AllowGet)); } else { if (groupAndShiftMapping.ShiftId == 1) { if (groupAndShiftMapping.GroupId == 1) { tblGroupAndShiftMapping aGroupAndShiftMapping = unitOfWork.GroupAndShiftMappingRepository.GetByID(groupAndShiftMapping.GroupMappingId); aGroupAndShiftMapping.GroupMappingId = groupAndShiftMapping.GroupMappingId; //aGroupAndShiftMapping.TransferDate = groupAndShiftMapping.TransferDate; aGroupAndShiftMapping.Day = "A"; aGroupAndShiftMapping.Night = "B"; aGroupAndShiftMapping.EditedBy = SessionManger.LoggedInUser(Session); aGroupAndShiftMapping.EditedDateTime = DateTime.Now; unitOfWork.GroupAndShiftMappingRepository.Update(aGroupAndShiftMapping); unitOfWork.Save(); return(Json(new { success = true, successMessage = "Group and Shift Mapping edited successfully" }, JsonRequestBehavior.AllowGet)); } else { tblGroupAndShiftMapping aGroupAndShiftMapping = unitOfWork.GroupAndShiftMappingRepository.GetByID(groupAndShiftMapping.GroupMappingId); aGroupAndShiftMapping.GroupMappingId = groupAndShiftMapping.GroupMappingId; //aGroupAndShiftMapping.TransferDate = groupAndShiftMapping.TransferDate; aGroupAndShiftMapping.Day = "B"; aGroupAndShiftMapping.Night = "A"; aGroupAndShiftMapping.EditedBy = SessionManger.LoggedInUser(Session); aGroupAndShiftMapping.EditedDateTime = DateTime.Now; unitOfWork.GroupAndShiftMappingRepository.Update(aGroupAndShiftMapping); unitOfWork.Save(); return(Json(new { success = true, successMessage = "Group and Shift Mapping edited successfully" }, JsonRequestBehavior.AllowGet)); } } else { if (groupAndShiftMapping.GroupId == 1) { tblGroupAndShiftMapping aGroupAndShiftMapping = unitOfWork.GroupAndShiftMappingRepository.GetByID(groupAndShiftMapping.GroupMappingId); aGroupAndShiftMapping.GroupMappingId = groupAndShiftMapping.GroupMappingId; //aGroupAndShiftMapping.TransferDate = groupAndShiftMapping.TransferDate; aGroupAndShiftMapping.Day = "B"; aGroupAndShiftMapping.Night = "A"; aGroupAndShiftMapping.EditedBy = SessionManger.LoggedInUser(Session); aGroupAndShiftMapping.EditedDateTime = DateTime.Now; unitOfWork.GroupAndShiftMappingRepository.Update(aGroupAndShiftMapping); unitOfWork.Save(); return(Json(new { success = true, successMessage = "Group and Shift Mapping edited successfully" }, JsonRequestBehavior.AllowGet)); } else { tblGroupAndShiftMapping aGroupAndShiftMapping = unitOfWork.GroupAndShiftMappingRepository.GetByID(groupAndShiftMapping.GroupMappingId); aGroupAndShiftMapping.GroupMappingId = groupAndShiftMapping.GroupMappingId; //aGroupAndShiftMapping.TransferDate = groupAndShiftMapping.TransferDate; aGroupAndShiftMapping.Day = "A"; aGroupAndShiftMapping.Night = "B"; aGroupAndShiftMapping.EditedBy = SessionManger.LoggedInUser(Session); aGroupAndShiftMapping.EditedDateTime = DateTime.Now; unitOfWork.GroupAndShiftMappingRepository.Update(aGroupAndShiftMapping); unitOfWork.Save(); return(Json(new { success = true, successMessage = "Group and Shift Mapping edited successfully" }, JsonRequestBehavior.AllowGet)); } } } } catch (Exception exception) { return(Json(new { success = false, errorMessage = exception.Message }, JsonRequestBehavior.AllowGet)); } }