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