public void DTO2DB_ProductInfo(DTO.ProductInfo.ProductDTO dtoItem, ref SampleProduct dbItem, string TmpFile)
{
AutoMapper.Mapper.Map <DTO.ProductInfo.ProductDTO, SampleProduct>(dtoItem, dbItem);
// remark image
foreach (SampleReferenceImage dbImage in dbItem.SampleReferenceImage.ToArray())
{
if (!dtoItem.ReferenceImageDTOs.Select(o => o.SampleReferenceImageID).Contains(dbImage.SampleReferenceImageID))
{
// delete files
if (!string.IsNullOrEmpty(dbImage.FileUD))
{
fwFactory.RemoveImageFile(dbImage.FileUD);
}
dbItem.SampleReferenceImage.Remove(dbImage);
}
}
foreach (DTO.ProductInfo.ReferenceImageDTO dtoImage in dtoItem.ReferenceImageDTOs)
{
SampleReferenceImage dbImage;
if (dtoImage.SampleReferenceImageID <= 0)
{
dbImage = new SampleReferenceImage();
dbItem.SampleReferenceImage.Add(dbImage);
}
else
{
dbImage = dbItem.SampleReferenceImage.FirstOrDefault(o => o.SampleReferenceImageID == dtoImage.SampleReferenceImageID);
}
if (dbItem != null)
{
AutoMapper.Mapper.Map <DTO.ProductInfo.ReferenceImageDTO, SampleReferenceImage>(dtoImage, dbImage);
if (!string.IsNullOrEmpty(dtoImage.BringInDate))
{
if (DateTime.TryParse(dtoImage.BringInDate, nl, System.Globalization.DateTimeStyles.None, out tmpDate))
{
dbImage.BringInDate = tmpDate;
}
}
if (dtoImage.HasChanged && !string.IsNullOrEmpty(dtoImage.NewFile))
{
dbImage.FileUD = fwFactory.CreateFilePointer(TmpFile, dtoImage.NewFile, dbImage.FileUD);
}
}
}
}
public bool UpdateProductInfoData(int userId, int id, ref object dtoItem, out Library.DTO.Notification notification)
{
DTO.ProductInfo.ProductDTO dtoProduct = ((Newtonsoft.Json.Linq.JObject)dtoItem).ToObject <DTO.ProductInfo.ProductDTO>();
notification = new Library.DTO.Notification()
{
Type = Library.DTO.NotificationType.Success
};
try
{
using (Sample3MngEntities context = CreateContext())
{
SampleProduct dbItem;
if (id <= 0)
{
dbItem = new SampleProduct();
context.SampleProduct.Add(dbItem);
}
else
{
dbItem = context.SampleProduct.FirstOrDefault(o => o.SampleProductID == id);
}
if (dbItem == null)
{
notification.Message = "Sample Product not found!";
return(false);
}
else
{
converter.DTO2DB_ProductInfo(dtoProduct, ref dbItem, FrameworkSetting.Setting.AbsoluteUserTempFolder + userId.ToString() + @"\");
context.SaveChanges();
}
dtoItem = GetProductInfoData(dbItem.SampleProductID, out notification).Data;
return(true);
}
}
catch (Exception ex)
{
notification = new Library.DTO.Notification()
{
Message = ex.Message, Type = Library.DTO.NotificationType.Error
};
return(false);
}
}
public bool UpdateItemData(int userId, int id, ref object dtoItem, out Library.DTO.Notification notification)
{
DTO.ItemData.ProductDTO dtoProduct = ((Newtonsoft.Json.Linq.JObject)dtoItem).ToObject <DTO.ItemData.ProductDTO>();
notification = new Library.DTO.Notification()
{
Type = Library.DTO.NotificationType.Success
};
try
{
using (Sample3MngEntities context = CreateContext())
{
SampleProduct dbItem = context.SampleProduct.FirstOrDefault(o => o.SampleProductID == id);
if (dbItem == null)
{
notification.Message = "Sample Product not found!";
return(false);
}
else
{
converter.DTO2DB_ItemData(dtoProduct, ref dbItem);
context.SaveChanges();
}
dtoItem = GetItemData(dbItem.SampleProductID, out notification).Data;
return(true);
}
}
catch (Exception ex)
{
notification = new Library.DTO.Notification()
{
Message = ex.Message, Type = Library.DTO.NotificationType.Error
};
return(false);
}
}
public void DTO2DB_ItemData(DTO.ItemData.ProductDTO dtoItem, ref SampleProduct dbItem)
{
AutoMapper.Mapper.Map <DTO.ItemData.ProductDTO, SampleProduct>(dtoItem, dbItem);
}
public void DTO2DB_FactoryAssignment(DTO.FactoryAssignment.ProductDTO dtoItem, ref SampleProduct dbItem)
{
AutoMapper.Mapper.Map <DTO.FactoryAssignment.ProductDTO, SampleProduct>(dtoItem, dbItem);
if (!string.IsNullOrEmpty(dtoItem.FactoryDeadline))
{
if (DateTime.TryParse(dtoItem.FactoryDeadline, nl, System.Globalization.DateTimeStyles.None, out tmpDate))
{
dbItem.FactoryDeadline = tmpDate;
}
}
// monitor
foreach (SampleProductSubFactory dbSubFactory in dbItem.SampleProductSubFactory.ToArray())
{
if (!dtoItem.SubFactoryDTOs.Select(o => o.SampleProductSubFactoryID).Contains(dbSubFactory.SampleProductSubFactoryID))
{
dbItem.SampleProductSubFactory.Remove(dbSubFactory);
}
}
foreach (DTO.FactoryAssignment.SubFactoryDTO dtoSubFactory in dtoItem.SubFactoryDTOs)
{
SampleProductSubFactory dbSubFactory;
if (dtoSubFactory.SampleProductSubFactoryID <= 0)
{
dbSubFactory = new SampleProductSubFactory();
dbItem.SampleProductSubFactory.Add(dbSubFactory);
}
else
{
dbSubFactory = dbItem.SampleProductSubFactory.FirstOrDefault(o => o.SampleProductSubFactoryID == dtoSubFactory.SampleProductSubFactoryID);
}
if (dbSubFactory != null)
{
AutoMapper.Mapper.Map <DTO.FactoryAssignment.SubFactoryDTO, SampleProductSubFactory>(dtoSubFactory, dbSubFactory);
}
}
}