public void DTO2DB(DTO.PriceListForwarder dtoConverter, PriceListForwarder dbItem) { if (dtoConverter.PriceListForwarderDetails != null) { foreach (var item in dbItem.PriceListForwarderDetail.ToArray()) { if (!dtoConverter.PriceListForwarderDetails.Select(s => s.PriceListForwarderDetailID).Contains(item.PriceListForwarderDetailID)) { dbItem.PriceListForwarderDetail.Remove(item); } } foreach (var dto in dtoConverter.PriceListForwarderDetails) { PriceListForwarderDetail item; if (dto.PriceListForwarderDetailID < 0) { item = new PriceListForwarderDetail(); dbItem.PriceListForwarderDetail.Add(item); } else { item = dbItem.PriceListForwarderDetail.FirstOrDefault(o => o.PriceListForwarderDetailID == dto.PriceListForwarderDetailID); } if (item != null) { AutoMapper.Mapper.Map <DTO.PriceListForwarderDetail, PriceListForwarderDetail>(dto, item); } } } // converter start date and end date dbItem.StartDate = dtoConverter.StartDate.ConvertStringToDateTime().Value; dbItem.EndDate = dtoConverter.EndDate.ConvertStringToDateTime().Value; AutoMapper.Mapper.Map <DTO.PriceListForwarder, PriceListForwarder>(dtoConverter, dbItem); }
public override bool UpdateData(int userId, int id, ref object dtoItem, out Notification notification) { notification = new Notification { Type = NotificationType.Success }; DTO.PriceListForwarder dtoConverter = ((Newtonsoft.Json.Linq.JObject)dtoItem).ToObject <DTO.PriceListForwarder>(); try { using (var context = CreateContext()) { PriceListForwarder dbItem; if (id > 0) { dbItem = context.PriceListForwarder.FirstOrDefault(o => o.PriceListForwarderID == id); } else { dbItem = new PriceListForwarder(); context.PriceListForwarder.Add(dbItem); dbItem.CreatedBy = userId; dbItem.CreatedDate = DateTime.Now; } if (dbItem == null) { notification.Message = string.Format("Price List Forwarder [id={0}] not found!", id); return(false); } // converter DTO to DB converter.DTO2DB(dtoConverter, dbItem); dbItem.UpdatedBy = userId; dbItem.UpdatedDate = DateTime.Now; // remove orphan detail context.PriceListForwarderDetail.Local.Where(o => o.PriceListForwarder == null).ToList() .ForEach(o => context.PriceListForwarderDetail.Remove(o)); context.SaveChanges(); dtoItem = GetData(dbItem.PriceListForwarderID, out notification); return(true); } } catch (Exception ex) { notification.Type = Library.DTO.NotificationType.Error; notification.Message = ex.Message; notification.DetailMessage.Add(ex.Message); if (ex.GetBaseException() != null) { notification.DetailMessage.Add(ex.GetBaseException().Message); } return(false); } }