public override bool DeleteData(int id, out Notification notification) { notification = new Notification { Type = NotificationType.Success }; try { using (TransportCIChargeEntities context = CreateContext()) { TransportCICharge dbItem = context.TransportCICharge.FirstOrDefault(o => o.TransportCIChargeID == id); if (dbItem == null) { return(true); } context.TransportCICharge.Remove(dbItem); context.SaveChanges(); } return(true); } catch (Exception ex) { notification.Type = NotificationType.Error; notification.Message = ex.Message; notification.DetailMessage.Add(ex.Message); return(false); } }
public override bool UpdateData(int userId, int id, ref object dtoItem, out Notification notification) { DTO.TransportCIChargeDto dtoEditItem = ((JObject)dtoItem).ToObject <DTO.TransportCIChargeDto>(); notification = new Notification { Type = NotificationType.Success }; try { using (var context = CreateContext()) { TransportCICharge dbItem; if (id > 0) { dbItem = context.TransportCICharge.FirstOrDefault(o => o.TransportCIChargeID == id); } else { dbItem = new TransportCICharge(); context.TransportCICharge.Add(dbItem); dbItem.CreatedBy = userId; dbItem.CreatedDate = DateTime.Now; } if (dbItem == null) { notification.Message = string.Format("TransportCostForwarder [id={0}] not found!", id); return(false); } converter.DTO2DB_TransportCICharge(dtoEditItem, ref dbItem); dbItem.UpdatedBy = userId; dbItem.UpdatedDate = DateTime.Now; // remove orphan items context.TransportCIChargeDetail.Local.Where(o => o.TransportCICharge == null).ToList() .ForEach(o => context.TransportCIChargeDetail.Remove(o)); context.SaveChanges(); dtoItem = GetData(dbItem.TransportCIChargeID, out notification).Data; return(true); } } catch (Exception ex) { notification.Type = NotificationType.Error; notification.Message = ex.Message; return(false); } }
public void DTO2DB_TransportCICharge(DTO.TransportCIChargeDto dtoItem, ref TransportCICharge dbItem) { if (dtoItem.TransportCIChargeDetail != null) { foreach (var item in dbItem.TransportCIChargeDetail.ToArray()) { if (!dtoItem.TransportCIChargeDetail.Select(s => s.TransportCIChargeDetailID).Contains(item.TransportCIChargeDetailID)) { dbItem.TransportCIChargeDetail.Remove(item); } } foreach (var dto in dtoItem.TransportCIChargeDetail) { TransportCIChargeDetail item; if (dto.TransportCIChargeDetailID < 0) { item = new TransportCIChargeDetail(); dbItem.TransportCIChargeDetail.Add(item); } else { item = dbItem.TransportCIChargeDetail.FirstOrDefault(o => o.TransportCIChargeDetailID == dto.TransportCIChargeDetailID); } if (item != null) { Mapper.Map <DTO.TransportCIChargeDetailDto, TransportCIChargeDetail>(dto, item); } } } // Convert string to DateTime Transport Invoice Date if (!string.IsNullOrEmpty(dtoItem.InvoiceDate)) { dbItem.InvoiceDate = dtoItem.InvoiceDate.ConvertStringToDateTime(); } else { dbItem.InvoiceDate = null; } // Mapping from dto to db Mapper.Map <DTO.TransportCIChargeDto, TransportCICharge>(dtoItem, dbItem); }