/// <summary>
/// Add Update List Of Stoppage
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public CommonResponse AddUpdateListOfStoppage(List <AddAndEditStoppage> data)
{
CommonResponse obj = new CommonResponse();
try
{
foreach (var item in data)
{
var check = db.UnitworkccsTblstoppage.Where(m => m.StoppagesId == item.stoppageId && m.AlramNo == item.alarmNo).FirstOrDefault();
if (check == null)
{
UnitworkccsTblstoppage tblStoppage = new UnitworkccsTblstoppage();
tblStoppage.CategoryId = item.categoryId;
tblStoppage.AlramNo = item.alarmNo;
tblStoppage.AlramDesc = item.alarmDesc;
tblStoppage.SourceId = item.sourceId;
tblStoppage.IsDeleted = 0;
tblStoppage.CreatedOn = DateTime.Now;
db.UnitworkccsTblstoppage.Add(tblStoppage);
db.SaveChanges();
obj.isStatus = true;
obj.response = ResourceResponse.AddedSuccessMessage;
}
else
{
check.CategoryId = item.categoryId;
check.AlramNo = item.alarmNo;
check.AlramDesc = item.alarmDesc;
check.SourceId = item.sourceId;
check.IsDeleted = 0;
check.ModifiedOn = DateTime.Now;
db.SaveChanges();
obj.isStatus = true;
obj.response = ResourceResponse.UpdatedSuccessMessage;
}
}
}
catch (Exception e)
{
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);
}
