public override bool DeleteData(int id, out Library.DTO.Notification notification)
{
notification = new Library.DTO.Notification()
{
Type = Library.DTO.NotificationType.Success
};
try
{
using (ImageGalleryMngEntities context = CreateContext())
{
ImageGallery dbItem = context.ImageGallery.FirstOrDefault(o => o.ImageGalleryID == id);
if (dbItem == null)
{
notification.Message = "Item not found!";
return(false);
}
else
{
if (!string.IsNullOrEmpty(dbItem.FileUD))
{
// remove image
fwFactory.RemoveImageFile(dbItem.FileUD);
}
//dbItem.ImageGalleryClient
foreach (ImageGalleryVersion version in dbItem.ImageGalleryVersion.ToArray())
{
if (!string.IsNullOrEmpty(version.FileUD))
{
// remove image
fwFactory.RemoveImageFile(version.FileUD);
}
context.ImageGalleryVersion.Remove(version);
}
foreach (ImageGalleryClient client in dbItem.ImageGalleryClient.ToArray())
{
context.ImageGalleryClient.Remove(client);
}
context.ImageGallery.Remove(dbItem);
context.SaveChanges();
return(true);
}
}
}
catch (Exception ex)
{
notification.Type = Library.DTO.NotificationType.Error;
notification.Message = ex.Message;
return(false);
}
}
public override bool UpdateData(int id, ref DTO.ImageGalleryMng.ImageGallery dtoItem, out Library.DTO.Notification notification)
{
notification = new Library.DTO.Notification()
{
Type = Library.DTO.NotificationType.Success
};
try
{
using (ImageGalleryMngEntities context = CreateContext())
{
ImageGallery dbItem = null;
if (id == 0)
{
dbItem = new ImageGallery();
context.ImageGallery.Add(dbItem);
}
else
{
dbItem = context.ImageGallery.FirstOrDefault(o => o.ImageGalleryID == id);
}
if (dbItem == null)
{
notification.Message = "Item not found!";
return(false);
}
else
{
// check concurrency
if (dbItem.ConcurrencyFlag != null && !dbItem.ConcurrencyFlag.SequenceEqual(Convert.FromBase64String(dtoItem.ConcurrencyFlag_String)))
{
throw new Exception(DALBase.Helper.TEXT_CONCURRENCY_CONFLICT);
}
// process image
foreach (DTO.ImageGalleryMng.ImageGalleryVersion dtoVersion in dtoItem.ImageGalleryVersions.Where(o => o.HasChange))
{
//dbItem.FileUD = (new Framework.DataFactory()).CreateFilePointer(this._TempFolder, dtoItem.NewFile, dtoItem.FileUD);
string[] videoExtension = { "avi", "mp4", "wmv", "flv" };
if (videoExtension.Contains(dtoVersion.NewFile.Substring(dtoVersion.NewFile.Length - 3, 3).ToLower()))
{
dtoVersion.FileUD = fwFactory.CreateNoneImageFilePointer(this._TempFolder, dtoVersion.NewFile, dtoVersion.FileUD);
}
else
{
dtoVersion.FileUD = fwFactory.CreateFilePointer(this._TempFolder, dtoVersion.NewFile, dtoVersion.FileUD);
}
}
converter.DTO2DB(dtoItem, ref dbItem);
// remove orphan
context.ImageGalleryClient.Local.Where(o => o.ImageGallery == null).ToList().ForEach(o => context.ImageGalleryClient.Remove(o));
foreach (ImageGalleryVersion dbVersion in context.ImageGalleryVersion.Local.Where(o => o.ImageGallery == null).ToList())
{
// remove images
if (!string.IsNullOrEmpty(dbVersion.FileUD))
{
fwFactory.RemoveImageFile(dbVersion.FileUD);
}
}
context.ImageGalleryVersion.Local.Where(o => o.ImageGallery == null).ToList().ForEach(o => context.ImageGalleryVersion.Remove(o));
context.SaveChanges();
dtoItem = GetData(dbItem.ImageGalleryID, 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(DTO.ImageGalleryMng.ImageGallery dtoItem, ref ImageGallery dbItem)
{
// map fields
AutoMapper.Mapper.Map <DTO.ImageGalleryMng.ImageGallery, ImageGallery>(dtoItem, dbItem);
dbItem.UpdatedBy = dtoItem.UpdatedBy;
dbItem.UpdatedDate = DateTime.Now;
DateTime tmpDate;
if (DateTime.TryParse(dtoItem.SampleImportDate, new System.Globalization.CultureInfo("vi-VN"), System.Globalization.DateTimeStyles.None, out tmpDate))
{
dbItem.SampleImportDate = tmpDate;
}
// map client detail
if (dtoItem.ImageGalleryClients != null)
{
// check for child rows deleted
foreach (ImageGalleryClient dbClient in dbItem.ImageGalleryClient.ToArray())
{
if (!dtoItem.ImageGalleryClients.Select(o => o.ImageGalleryClientID).Contains(dbClient.ImageGalleryClientID))
{
dbItem.ImageGalleryClient.Remove(dbClient);
}
}
// map child rows
foreach (DTO.ImageGalleryMng.ImageGalleryClient dtoClient in dtoItem.ImageGalleryClients)
{
ImageGalleryClient dbClient;
if (dtoClient.ImageGalleryClientID <= 0)
{
dbClient = new ImageGalleryClient();
dbItem.ImageGalleryClient.Add(dbClient);
}
else
{
dbClient = dbItem.ImageGalleryClient.FirstOrDefault(o => o.ImageGalleryClientID == dtoClient.ImageGalleryClientID);
}
if (dbClient != null)
{
AutoMapper.Mapper.Map <DTO.ImageGalleryMng.ImageGalleryClient, ImageGalleryClient>(dtoClient, dbClient);
}
}
}
// map version
if (dtoItem.ImageGalleryVersions != null)
{
// check for child rows deleted
foreach (ImageGalleryVersion dbVersion in dbItem.ImageGalleryVersion.ToArray())
{
if (!dtoItem.ImageGalleryVersions.Select(o => o.ImageGalleryVersionID).Contains(dbVersion.ImageGalleryVersionID))
{
dbItem.ImageGalleryVersion.Remove(dbVersion);
}
}
// map child rows
foreach (DTO.ImageGalleryMng.ImageGalleryVersion dtoVersion in dtoItem.ImageGalleryVersions)
{
ImageGalleryVersion dbVersion;
if (dtoVersion.ImageGalleryVersionID <= 0)
{
dbVersion = new ImageGalleryVersion();
dbItem.ImageGalleryVersion.Add(dbVersion);
}
else
{
dbVersion = dbItem.ImageGalleryVersion.FirstOrDefault(o => o.ImageGalleryVersionID == dtoVersion.ImageGalleryVersionID);
}
dbVersion.UpdatedBy = dtoItem.UpdatedBy;
dbVersion.UpdatedDate = DateTime.Now;
if (dbVersion != null)
{
AutoMapper.Mapper.Map <DTO.ImageGalleryMng.ImageGalleryVersion, ImageGalleryVersion>(dtoVersion, dbVersion);
}
}
}
}