public void DTO2DB_PriceListClientCharge(DTO.PriceListClientChargeDto dtoItem, PriceListClientCharge dbItem)
{
if (dtoItem.PriceListClientChargeDetail != null)
{
foreach (var item in dbItem.PriceListClientChargeDetail.ToList())
{
if (!dtoItem.PriceListClientChargeDetail.Select(s => s.PriceListClientChargeDetailID).Contains(item.PriceListClientChargeDetailID))
{
dbItem.PriceListClientChargeDetail.Remove(item);
}
}
foreach (var dto in dtoItem.PriceListClientChargeDetail.ToList())
{
PriceListClientChargeDetail item = null;
if (dto.PriceListClientChargeDetailID < 0)
{
item = new PriceListClientChargeDetail();
// Add item in PriceListClientChargeDetail
dbItem.PriceListClientChargeDetail.Add(item);
}
else
{
item = dbItem.PriceListClientChargeDetail.FirstOrDefault(o => o.PriceListClientChargeDetailID == dto.PriceListClientChargeDetailID);
}
if (item != null)
{
AutoMapper.Mapper.Map <DTO.PriceListClientChargeDetailDto, PriceListClientChargeDetail>(dto, item);
}
}
}
// Convert string to date
dbItem.StartDate = dtoItem.StartDate.ConvertStringToDateTime();
dbItem.EndDate = dtoItem.EndDate.ConvertStringToDateTime();
AutoMapper.Mapper.Map <DTO.PriceListClientChargeDto, PriceListClientCharge>(dtoItem, dbItem);
}
public override bool UpdateData(int userId, int id, ref object dtoItem, out Notification notification)
{
DTO.PriceListClientChargeDto dtoConvert = ((Newtonsoft.Json.Linq.JObject)dtoItem).ToObject <DTO.PriceListClientChargeDto>();
// Define type of notification, convert object
notification = new Notification {
Type = NotificationType.Success
};
try
{
using (var context = CreateContext())
{
PriceListClientCharge dbItem;
if (id > 0)
{
dbItem = context.PriceListClientCharge.FirstOrDefault(o => o.PriceListClientChargeID == id);
}
else
{
dbItem = new PriceListClientCharge();
context.PriceListClientCharge.Add(dbItem);
dbItem.CreatedBy = userId;
dbItem.CreatedDate = DateTime.Now;
}
if (dbItem == null)
{
notification.Type = NotificationType.Error;
notification.Message = string.Format("Price List Client Charge [id = {0}] not found!", id);
return(false);
}
// Call method convert object to database
converter.DTO2DB_PriceListClientCharge(dtoConvert, dbItem);
dbItem.UpdatedBy = userId;
dbItem.UpdatedDate = DateTime.Now;
// remove orphan detail
context.PriceListClientChargeDetail.Local.Where(o => o.PriceListClientCharge == null).ToList()
.ForEach(o => context.PriceListClientChargeDetail.Remove(o));
context.SaveChanges();
// Load again data
dtoItem = GetData(dbItem.PriceListClientChargeID, out notification);
return(true);
}
}
catch (Exception ex)
{
notification.Type = NotificationType.Error;
notification.Message = ex.Message;
return(false);
}
}
