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