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