/// <summary>
/// Add General Defect Codes
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public CommonResponse AddGeneralDefectCodes(List <AddDefectCodes> data)
{
CommonResponse obj = new CommonResponse();
try
{
var check = db.UnitworkccsTblgeneraldefectcodes.Where(m => m.IsDeleted == 0).ToList();
db.RemoveRange(check);
db.SaveChanges();
foreach (var item in data)
{
UnitworkccsTblgeneraldefectcodes UnitworkccsTblgeneraldefectcodes = new UnitworkccsTblgeneraldefectcodes();
UnitworkccsTblgeneraldefectcodes.DefectCodeName = item.defectCodeName;
UnitworkccsTblgeneraldefectcodes.DefectCodeDesc = item.defectCodeDesc;
UnitworkccsTblgeneraldefectcodes.IsDeleted = 0;
UnitworkccsTblgeneraldefectcodes.CreatedOn = DateTime.Now;
db.UnitworkccsTblgeneraldefectcodes.Add(UnitworkccsTblgeneraldefectcodes);
db.SaveChanges();
obj.isStatus = true;
obj.response = ResourceResponse.AddedSuccessMessage;
}
}
catch (Exception ex)
{
obj.isStatus = false;
obj.response = ResourceResponse.FailureMessage;
}
return(obj);
}
public CommonResponse UploadListOfStoppage(List <UploadStoppage> data)
{
CommonResponse obj = new CommonResponse();
try
{
var check = db.UnitworkccsTblstoppage.Where(m => m.IsDeleted == 0).ToList();
db.RemoveRange(check);
db.SaveChanges();
foreach (var item in data)
{
UnitworkccsTblstoppage tblStoppage = new UnitworkccsTblstoppage();
if (item.categoryName != null)
{
var categoryId = db.UnitworkccsTblcategorymaster.Where(m => m.CategoryName == item.categoryName).Select(m => m.CategoryId).FirstOrDefault();
tblStoppage.CategoryId = categoryId;
}
tblStoppage.AlramNo = item.alarmNo;
tblStoppage.AlramDesc = item.alarmDesc;
if (item.sourceName != null)
{
var sourceId = db.UnitworkccsTblsourcemaster.Where(m => m.SourceName == item.sourceName).Select(m => m.SourceId).FirstOrDefault();
tblStoppage.SourceId = sourceId;
}
tblStoppage.IsDeleted = 0;
tblStoppage.CreatedOn = DateTime.Now;
db.UnitworkccsTblstoppage.Add(tblStoppage);
db.SaveChanges();
obj.isStatus = true;
obj.response = ResourceResponse.AddedSuccessMessage;
}
}
catch (Exception e)
{
obj.isStatus = false;
obj.response = ResourceResponse.FailureMessage;
}
return(obj);
}
/// <summary>
/// Upload Child Fg Part No
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public CommonResponse UploadChildFgPartNo(List <UploadChildPartNo> data)
{
CommonResponse obj = new CommonResponse();
try
{
var check = db.UnitworkccsTblchildfgpartno.Where(m => m.IsDeleted == 0).ToList();
db.RemoveRange(check);
db.SaveChanges();
foreach (var item in data)
{
UnitworkccsTblchildfgpartno UnitworkccsTblchildfgpartno = new UnitworkccsTblchildfgpartno();
UnitworkccsTblchildfgpartno.ChildFgPartNo = item.childFgPartNo;
UnitworkccsTblchildfgpartno.ChildPartNoDesc = item.childPartNoDesc;
UnitworkccsTblchildfgpartno.FgPartNo = item.fgPartNo;
UnitworkccsTblchildfgpartno.FgPartDesc = item.fgPartDesc;
UnitworkccsTblchildfgpartno.IsDeleted = 0;
UnitworkccsTblchildfgpartno.CreatedOn = DateTime.Now;
db.UnitworkccsTblchildfgpartno.Add(UnitworkccsTblchildfgpartno);
db.SaveChanges();
obj.isStatus = true;
obj.response = ResourceResponse.AddedSuccessMessage;
}
}
catch (Exception e)
{
log.Error(e); if (e.InnerException != null)
{
log.Error(e.InnerException.ToString());
}
obj.isStatus = false;
obj.response = ResourceResponse.FailureMessage;
}
return(obj);
}
/// <summary>
/// Upload Escalation Matrix Details
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public CommonResponse UploadEscalationMatrixDetails(List <EscalationMatrixDetails> data)
{
CommonResponse obj = new CommonResponse();
CommonFunction commonFunction = new CommonFunction();
try
{
var dbCheck = db.UnitworkccsTblescalationmatrix.Where(m => m.IsDeleted == 0).ToList();
db.RemoveRange(dbCheck);
db.SaveChanges();
foreach (var item in data)
{
var check = db.UnitworkccsTblescalationmatrix.Where(m => m.OpNo == item.employeeId).FirstOrDefault();
if (check == null)
{
UnitworkccsTblescalationmatrix tblEscalationMatrix = new UnitworkccsTblescalationmatrix();
tblEscalationMatrix.Category = item.category;
string idsss = "";
if (string.IsNullOrEmpty(item.category))
{
tblEscalationMatrix.CategoryId = idsss;
}
else
{
string[] catSlipt = item.category.Split(',');
List <string> catlist = catSlipt.ToList();
foreach (var val in catlist)
{
var catid = db.UnitworkccsTblcategorymaster.Where(m => m.CategoryName == val).Select(m => m.CategoryId).FirstOrDefault();
string ids = catid + ",";
idsss = idsss + ids;
}
idsss = idsss.TrimStart(',');
idsss = idsss.TrimEnd(',');
tblEscalationMatrix.CategoryId = idsss;
}
tblEscalationMatrix.Cell = item.cell;
string cellids = "";
if (string.IsNullOrEmpty(item.cell))
{
tblEscalationMatrix.CellId = cellids;
}
else
{
string[] cellSplit = item.cell.Split(',');
List <string> cell = cellSplit.ToList();
foreach (var val in cell)
{
var celid = db.UnitworkccsTblshop.Where(m => m.ShopName == val).Select(m => m.ShopId).FirstOrDefault();
string ids = celid + ",";
cellids = cellids + ids;
}
cellids = cellids.TrimStart(',');
cellids = cellids.TrimEnd(',');
tblEscalationMatrix.CellId = cellids;
}
// tblEscalationMatrix.ContactNo = item.contactNo;
tblEscalationMatrix.EmployeeId = db.UnitworkccsTbloperatordetails.Where(m => m.OperatorName == item.employeeName).Select(m => m.OpId).FirstOrDefault();
tblEscalationMatrix.EmployeeName = item.employeeName;
// tblEscalationMatrix.MachineId = db.Tblmachinedetails.Where(m => m.MachineName == item.machineName).Select(m => m.MachineId).FirstOrDefault();
// tblEscalationMatrix.MachineName = item.machineName;
tblEscalationMatrix.OpNo = item.employeeId;
// tblEscalationMatrix.Role = item.role;
// tblEscalationMatrix.RoleId = db.Tblroles.Where(m => m.RoleName == item.role).Select(m => m.RoleId).FirstOrDefault();
tblEscalationMatrix.Shift = item.shift;
// tblEscalationMatrix.ShiftId = db.TblshiftMstr.Where(m => m.ShiftName == item.shift).Select(m => m.ShiftId).FirstOrDefault();
tblEscalationMatrix.SmsPriority = item.smsPriority;
tblEscalationMatrix.SubCell = item.subCell;
string subcellids = "";
if (string.IsNullOrEmpty(item.subCell))
{
tblEscalationMatrix.SubCellId = subcellids;
}
else
{
string[] subcellSplit = item.subCell.Split(',');
List <string> subcell = subcellSplit.ToList();
foreach (var val in subcell)
{
var subcelid = db.UnitworkccsTblcell.Where(m => m.CellName == val).Select(m => m.CellId).FirstOrDefault();
string ids = subcelid + ",";
subcellids = subcellids + ids;
}
subcellids = subcellids.TrimStart(',');
subcellids = subcellids.TrimEnd(',');
tblEscalationMatrix.SubCellId = subcellids;
}
// 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 = item.category;
string idsss = "";
if (string.IsNullOrEmpty(item.category))
{
check.CategoryId = idsss;
}
else
{
string[] catSlipt = item.category.Split(',');
List <string> catlist = catSlipt.ToList();
foreach (var val in catlist)
{
var catid = db.UnitworkccsTblcategorymaster.Where(m => m.CategoryName == val).Select(m => m.CategoryId).FirstOrDefault();
string ids = catid + ",";
idsss = idsss + ids;
}
idsss = idsss.TrimStart(',');
idsss = idsss.TrimEnd(',');
check.CategoryId = idsss;
}
// check.PlantId = data.plantId;
// check.PlantCode = db.Tblplant.Where(m => m.PlantId == data.plantId).Select(m => m.PlantCode).FirstOrDefault();
check.Cell = item.cell;
string cellids = "";
if (string.IsNullOrEmpty(item.cell))
{
check.CellId = cellids;
}
else
{
string[] cellSplit = item.cell.Split(',');
List <string> cell = cellSplit.ToList();
foreach (var val in cell)
{
var celid = db.UnitworkccsTblshop.Where(m => m.ShopName == val).Select(m => m.ShopId).FirstOrDefault();
string ids = celid + ",";
cellids = cellids + ids;
}
cellids = cellids.TrimStart(',');
cellids = cellids.TrimEnd(',');
check.CellId = cellids;
}
// check.ContactNo = data.contactNo;
check.EmployeeId = db.UnitworkccsTbloperatordetails.Where(m => m.OperatorName == item.employeeName).Select(m => m.OpId).FirstOrDefault();
check.EmployeeName = item.employeeName;
check.OpNo = item.employeeId;
check.Shift = item.shift;
//check.ShiftId = db.TblshiftMstr.Where(m => m.ShiftName == item.shift).Select(m => m.ShiftId).FirstOrDefault();
check.SmsPriority = item.smsPriority;
check.SubCell = item.subCell;
string subcellids = "";
if (string.IsNullOrEmpty(item.cell))
{
check.SubCellId = subcellids;
}
else
{
string[] subcellSplit = item.subCell.Split(',');
List <string> subcell = subcellSplit.ToList();
foreach (var val in subcell)
{
var subcelid = db.UnitworkccsTblcell.Where(m => m.CellName == val).Select(m => m.CellId).FirstOrDefault();
string ids = subcelid + ",";
subcellids = subcellids + ids;
}
subcellids = subcellids.TrimStart(',');
subcellids = subcellids.TrimEnd(',');
check.SubCellId = subcellids;
}
// 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);
}
