public bool UpdateInternalRemarkData(int userId, int id, ref object dtoItem, out Library.DTO.Notification notification) { DTO.InternalRemark.RemarkDTO dtoRemark = ((Newtonsoft.Json.Linq.JObject)dtoItem).ToObject <DTO.InternalRemark.RemarkDTO>(); notification = new Library.DTO.Notification() { Type = Library.DTO.NotificationType.Success }; try { using (Sample3MngEntities context = CreateContext()) { SampleRemark dbItem; if (id <= 0) { dbItem = new SampleRemark(); context.SampleRemark.Add(dbItem); dbItem.UpdatedBy = userId; dbItem.UpdatedDate = DateTime.Now; } else { dbItem = context.SampleRemark.FirstOrDefault(o => o.SampleRemarkID == id); } if (dbItem == null) { notification.Message = "Internal Remark not found!"; return(false); } else { // check permission if (userId != dbItem.UpdatedBy) { throw new Exception("Can not edit remark from other user!"); } if ((DateTime.Now - dbItem.UpdatedDate.Value).TotalDays > 1) { throw new Exception("Too late to edit this remark, remark can only be updatable within 2 days from the last update!"); } converter.DTO2DB_InternalRemark(dtoRemark, ref dbItem, FrameworkSetting.Setting.AbsoluteUserTempFolder + userId.ToString() + @"\"); context.SaveChanges(); } dtoItem = converter.DB2DTO_InternalRemark_Remark(context.Sample3Mng_InternalRemark_Remark_View .Include("Sample3Mng_InternalRemark_RemarkImage_View") .FirstOrDefault(o => o.SampleRemarkID == dbItem.SampleRemarkID)); return(true); } } catch (Exception ex) { notification = new Library.DTO.Notification() { Message = ex.Message, Type = Library.DTO.NotificationType.Error }; return(false); } }
public bool DeleteInternalRemarkData(int userId, int id, out Library.DTO.Notification notification) { notification = new Library.DTO.Notification() { Type = Library.DTO.NotificationType.Success }; try { using (Sample3MngEntities context = CreateContext()) { SampleRemark dbItem = context.SampleRemark.FirstOrDefault(o => o.SampleRemarkID == id); if (dbItem == null) { throw new Exception("Internal Remark not found!"); } else { // check permission if (userId != dbItem.UpdatedBy) { throw new Exception("Can not delete remark from other user!"); } if ((DateTime.Now - dbItem.UpdatedDate.Value).TotalDays > 1) { throw new Exception("Too late to delete this remark, remark can only be deleted within 2 days from the last update!"); } foreach (SampleRemarkImage dbImage in dbItem.SampleRemarkImage.ToArray()) { if (!string.IsNullOrEmpty(dbImage.FileUD)) { fwFactory.RemoveImageFile(dbImage.FileUD); } context.SampleRemarkImage.Remove(dbImage); } context.SampleRemark.Remove(dbItem); context.SaveChanges(); } return(true); } } catch (Exception ex) { notification = new Library.DTO.Notification() { Message = ex.Message, Type = Library.DTO.NotificationType.Error }; return(false); } }
public void DTO2DB_InternalRemark(DTO.InternalRemark.RemarkDTO dtoItem, ref SampleRemark dbItem, string TmpFile) { AutoMapper.Mapper.Map <DTO.InternalRemark.RemarkDTO, SampleRemark>(dtoItem, dbItem); // remark image foreach (SampleRemarkImage dbImage in dbItem.SampleRemarkImage.ToArray()) { if (!dtoItem.RemarkImageDTOs.Select(o => o.SampleRemarkImageID).Contains(dbImage.SampleRemarkImageID)) { // delete files if (!string.IsNullOrEmpty(dbImage.FileUD)) { fwFactory.RemoveImageFile(dbImage.FileUD); } dbItem.SampleRemarkImage.Remove(dbImage); } } foreach (DTO.InternalRemark.RemarkImageDTO dtoImage in dtoItem.RemarkImageDTOs) { SampleRemarkImage dbImage; if (dtoImage.SampleRemarkImageID <= 0) { dbImage = new SampleRemarkImage(); dbItem.SampleRemarkImage.Add(dbImage); } else { dbImage = dbItem.SampleRemarkImage.FirstOrDefault(o => o.SampleRemarkImageID == dtoImage.SampleRemarkImageID); } if (dbItem != null) { AutoMapper.Mapper.Map <DTO.InternalRemark.RemarkImageDTO, SampleRemarkImage>(dtoImage, dbImage); if (dtoImage.HasChanged && !string.IsNullOrEmpty(dtoImage.NewFile)) { dbImage.FileUD = fwFactory.CreateNoneImageFilePointer(TmpFile, dtoImage.NewFile, dbImage.FileUD, dtoImage.FriendlyName); } } } }