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