public DTO.ProductionFrameWeightData UpdateData(int userID, int id, Hashtable filters, out Notification notification) { DTO.ProductionFrameWeightData dtoItem = ((Newtonsoft.Json.Linq.JObject)filters["view"]).ToObject <DTO.ProductionFrameWeightData>(); notification = new Notification(); notification.Type = NotificationType.Success; try { using (var context = CreateContext()) { ProductionFrameWeight dbItem; if (id <= 0) { dbItem = new ProductionFrameWeight(); context.ProductionFrameWeight.Add(dbItem); } else { dbItem = context.ProductionFrameWeight.FirstOrDefault(o => o.ProductionFrameWeightID == id); } if (dbItem == null) { notification.Type = NotificationType.Error; notification.Message = "Can't found data of ProductionFrameWeight!"; } else { converter.DTO2DB_ProductionFrameWeight(userID, dtoItem, ref dbItem); context.SaveChanges(); dtoItem = GetData(userID, dbItem.ProductionFrameWeightID, out notification); } } } catch (Exception ex) { notification.Type = NotificationType.Error; notification.Message = Library.Helper.GetInnerException(ex).Message; } return(dtoItem); }
public bool DeleteData(int userID, int id, out Notification notification) { notification = new Notification(); notification.Type = NotificationType.Success; try { using (var context = CreateContext()) { ProductionFrameWeight dbItem = context.ProductionFrameWeight.FirstOrDefault(o => o.ProductionFrameWeightID == id); if (dbItem == null) { notification.Type = NotificationType.Error; notification.Message = "Can't found data of ProductionFrameWeight!"; return(false); } else { context.ProductionFrameWeight.Remove(dbItem); context.SaveChanges(); return(true); } } } catch (Exception ex) { notification.Type = NotificationType.Error; notification.Message = Library.Helper.GetInnerException(ex).Message; return(false); } }
public void DTO2DB_ProductionFrameWeight(int userID, DTO.ProductionFrameWeightData dtoItem, ref ProductionFrameWeight dbItem) { AutoMapper.Mapper.Map <DTO.ProductionFrameWeightData, ProductionFrameWeight>(dtoItem, dbItem); dbItem.UpdatedBy = userID; dbItem.UpdatedDate = DateTime.Now; if (dtoItem.ProductionFrameWeightHistory != null) { foreach (var dtoItemDetail in dbItem.ProductionFrameWeightHistory.ToList()) { if (!dtoItem.ProductionFrameWeightHistory.Select(s => s.ProductionFrameWeightHistoryID).Contains(dtoItemDetail.ProductionFrameWeightHistoryID)) { dbItem.ProductionFrameWeightHistory.Remove(dtoItemDetail); } } foreach (var dtoItemDetail in dtoItem.ProductionFrameWeightHistory.ToList()) { ProductionFrameWeightHistory dbItemDetail; if (dtoItemDetail.ProductionFrameWeightHistoryID <= 0) { dbItemDetail = new ProductionFrameWeightHistory(); dbItem.ProductionFrameWeightHistory.Add(dbItemDetail); if (dbItemDetail != null) { AutoMapper.Mapper.Map <DTO.ProductionFrameWeightHistoryData, ProductionFrameWeightHistory>(dtoItemDetail, dbItemDetail); dbItemDetail.UpdatedBy = userID; dbItemDetail.UpdatedDate = DateTime.Now; dbItemDetail.Remark = dtoItem.Remark; } } else { dbItemDetail = dbItem.ProductionFrameWeightHistory.FirstOrDefault(o => o.ProductionFrameWeightHistoryID == dtoItemDetail.ProductionFrameWeightHistoryID); } } } }