/// <summary>
/// Add And Edit Escalation Matrix
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public CommonResponse AddAndEditEscalationMatrix(EscalationMatrixCustom data)
{
CommonResponse obj = new CommonResponse();
CommonFunction commonFunction = new CommonFunction();
try
{
var check = db.UnitworkccsTblescalationmatrix.Where(m => m.OpNo == data.employeeId && m.EscalationId == data.escalationId && m.IsDeleted == 0).FirstOrDefault();
if (check == null)
{
UnitworkccsTblescalationmatrix tblEscalationMatrix = new UnitworkccsTblescalationmatrix();
// tblEscalationMatrix.Category = db.TblCategoryMaster.Where(m => m.CategoryId == data.categoryId).Select(m => m.CategoryName).FirstOrDefault();
tblEscalationMatrix.CategoryId = data.categoryId;
// tblEscalationMatrix.PlantId = data.plantId;
// tblEscalationMatrix.PlantCode = db.Tblplant.Where(m => m.PlantId == data.plantId).Select(m => m.PlantCode).FirstOrDefault();
// tblEscalationMatrix.Cell = db.Tblshop.Where(m => m.ShopId == data.cellId).Select(m => m.ShopName).FirstOrDefault();
tblEscalationMatrix.CellId = data.cellId;
// tblEscalationMatrix.ContactNo = data.contactNo;
tblEscalationMatrix.EmployeeId = db.UnitworkccsTbloperatordetails.Where(m => m.OperatorName == data.emaployeeName).Select(m => m.OpId).FirstOrDefault();
tblEscalationMatrix.EmployeeName = data.emaployeeName;
// tblEscalationMatrix.MachineId = data.machineId;
// tblEscalationMatrix.MachineName = db.Tblmachinedetails.Where(m => m.MachineId == data.machineId).Select(m => m.MachineName).FirstOrDefault();
tblEscalationMatrix.OpNo = data.employeeId;
// tblEscalationMatrix.Role = db.Tblroles.Where(m => m.RoleId == data.roleId).Select(m => m.RoleName).FirstOrDefault();
// tblEscalationMatrix.RoleId = data.roleId;
tblEscalationMatrix.Shift = data.shift;
// tblEscalationMatrix.ShiftId = db.TblshiftMstr.Where(m => m.ShiftName == shift).Select(m => m.ShiftId).FirstOrDefault();
tblEscalationMatrix.SmsPriority = data.smsPriority;
// tblEscalationMatrix.SubCell = db.Tblcell.Where(m => m.CellId == data.subCellId).Select(m => m.CellName).FirstOrDefault();
tblEscalationMatrix.SubCellId = data.subCellId;
// tblEscalationMatrix.TimeToBeTriggered = timeToBeTriggered;
tblEscalationMatrix.IsDeleted = 0;
tblEscalationMatrix.CreatedOn = DateTime.Now;
db.UnitworkccsTblescalationmatrix.Add(tblEscalationMatrix);
db.SaveChanges();
obj.isStatus = true;
obj.response = ResourceResponse.AddedSuccessMessage;
}
else
{
// check.Category = db.TblCategoryMaster.Where(m => m.CategoryId == data.categoryId).Select(m => m.CategoryName).FirstOrDefault();
check.CategoryId = data.categoryId;
// check.PlantId = data.plantId;
// check.PlantCode = db.Tblplant.Where(m => m.PlantId == data.plantId).Select(m => m.PlantCode).FirstOrDefault();
// check.Cell = db.Tblshop.Where(m => m.ShopId == data.cellId).Select(m => m.ShopName).FirstOrDefault();
check.CellId = data.cellId;
// check.ContactNo = data.contactNo;
check.EmployeeId = db.UnitworkccsTbloperatordetails.Where(m => m.OperatorName == data.emaployeeName).Select(m => m.OpId).FirstOrDefault();
check.EmployeeName = data.emaployeeName;
// check.MachineId = data.machineId;
// check.MachineName = db.Tblmachinedetails.Where(m => m.MachineId == data.machineId).Select(m => m.MachineName).FirstOrDefault();
// check.Role = db.Tblroles.Where(m => m.RoleId == data.roleId).Select(m => m.RoleName).FirstOrDefault();
// check.RoleId = data.roleId;
check.Shift = data.shift;
// check.ShiftId = db.TblshiftMstr.Where(m => m.ShiftName == data.shift).Select(m => m.ShiftId).FirstOrDefault();
check.SmsPriority = data.smsPriority;
// check.SubCell = db.Tblcell.Where(m => m.CellId == data.subCellId).Select(m => m.CellName).FirstOrDefault();
check.SubCellId = data.subCellId;
// check.TimeToBeTriggered = timeToBeTriggered;
check.IsDeleted = 0;
check.ModifiedOn = DateTime.Now;
db.SaveChanges();
obj.isStatus = true;
obj.response = ResourceResponse.UpdatedSuccessMessage;
//}
}
}
catch (Exception e)
{
log.Error(e); if (e.InnerException != null)
{
log.Error(e.InnerException.ToString());
}
obj.isStatus = false;
obj.response = ResourceResponse.FailureMessage;
}
return(obj);
}
public async Task <IActionResult> AddAndEditEscalationMatrix(EscalationMatrixCustom data)
{
CommonResponse response = escationMatrix.AddAndEditEscalationMatrix(data);
return(Ok(response));
}
