public override bool Reset(int userId, int id, ref object dtoItem, out Library.DTO.Notification notification) { DTO.FactoryInvoice dtoFactoryInvoice = ((Newtonsoft.Json.Linq.JObject)dtoItem).ToObject <DTO.FactoryInvoice>(); notification = new Library.DTO.Notification() { Type = Library.DTO.NotificationType.Success }; try { using (FactoryInvoiceOtherMngEntities context = CreateContext()) { FactoryInvoice dbItem = context.FactoryInvoice.FirstOrDefault(o => o.FactoryInvoiceID == id); if (dbItem == null) { throw new Exception("Invoice not found!"); } dbItem.IsConfirmed = null; dbItem.ConfirmedDate = null; dbItem.ConfirmedBy = null; context.SaveChanges(); dtoItem = GetData(userId, dbItem.FactoryInvoiceID, -1, out notification).Data; return(true); } } catch (Exception ex) { notification.Type = Library.DTO.NotificationType.Error; notification.Message = ex.Message; return(false); } }
public bool DeleteData(int userId, int id, out Library.DTO.Notification notification) { notification = new Library.DTO.Notification() { Type = Library.DTO.NotificationType.Success }; try { // check permission if (id > 0 && fwFactory.CheckFactoryInvoicePermission(userId, id) == 0) { throw new Exception("Current user don't have access permission for the selected invoice data"); } using (FactoryInvoiceOtherMngEntities context = CreateContext()) { FactoryInvoice dbItem = context.FactoryInvoice.FirstOrDefault(o => o.FactoryInvoiceID == id); if (dbItem == null) { throw new Exception("Invoice not found!"); } // check if invoice already confirmed if (dbItem.IsConfirmed.HasValue && dbItem.IsConfirmed.Value) { throw new Exception("Can not delete the confirmed invoice!"); } // everything ok, delete the invoice if (dbItem.ScanFile != string.Empty) { fwFactory.RemoveImageFile(dbItem.ScanFile); } context.FactoryInvoice.Remove(dbItem); context.SaveChanges(); } } catch (Exception ex) { notification.Type = Library.DTO.NotificationType.Error; notification.Message = ex.Message; return(false); } return(true); }
public override bool UpdateData(int userId, int id, ref object dtoItem, out Library.DTO.Notification notification) { DTO.FactoryInvoice dtoFactoryInvoice = ((Newtonsoft.Json.Linq.JObject)dtoItem).ToObject <DTO.FactoryInvoice>(); notification = new Library.DTO.Notification() { Type = Library.DTO.NotificationType.Success }; int number; string indexName; try { // check permission if (fwFactory.CheckSupplierPermission(userId, dtoFactoryInvoice.SupplierID.Value) == 0) { throw new Exception("Current user don't have access permission for the selected supplier data"); } if (id > 0 && fwFactory.CheckFactoryInvoicePermission(userId, id) == 0) { throw new Exception("Current user don't have access permission for the selected invoice data"); } using (FactoryInvoiceOtherMngEntities context = CreateContext()) { FactoryInvoice dbItem = null; if (id == 0) { dbItem = new FactoryInvoice(); context.FactoryInvoice.Add(dbItem); } else { dbItem = context.FactoryInvoice.FirstOrDefault(o => o.FactoryInvoiceID == id); } if (dbItem == null) { notification.Message = "Factory invoice not found!"; return(false); } else { // check if invoice is confirmed if (dbItem.IsConfirmed.HasValue && dbItem.IsConfirmed.Value) { throw new Exception("Can not edit the confirmed invoice!"); } // check concurrency if (dbItem.ConcurrencyFlag != null && !dbItem.ConcurrencyFlag.SequenceEqual(Convert.FromBase64String(dtoFactoryInvoice.ConcurrencyFlag))) { throw new Exception(Library.Helper.TEXT_CONCURRENCY_CONFLICT); } converter.DTO2DB(dtoFactoryInvoice, ref dbItem, FrameworkSetting.Setting.AbsoluteUserTempFolder + userId.ToString() + @"\"); dbItem.UpdatedBy = userId; dbItem.UpdatedDate = DateTime.Now; context.SaveChanges(); } dtoItem = GetData(userId, dbItem.FactoryInvoiceID, -1, out notification).Data; return(true); } } catch (System.Data.DataException dEx) { notification.Type = Library.DTO.NotificationType.Error; Library.ErrorHelper.DataExceptionParser(dEx, out number, out indexName); if (number == 2601 && !string.IsNullOrEmpty(indexName)) { switch (indexName) { case "InvoiceNoUnique": notification.Message = "Duplicate invoice number (invoice no must be unique)!"; break; default: notification.Message = dEx.Message; break; } } else { notification.Message = dEx.Message; } return(false); } catch (Exception ex) { notification = new Library.DTO.Notification() { Message = ex.Message, Type = Library.DTO.NotificationType.Error }; return(false); } }
public void DTO2DB(DTO.FactoryInvoice dtoItem, ref FactoryInvoice dbItem, string _tempFolder) { // map fields AutoMapper.Mapper.Map <DTO.FactoryInvoice, FactoryInvoice>(dtoItem, dbItem); // insert file Module.Framework.DAL.DataFactory fwFactory = new Module.Framework.DAL.DataFactory(); if (dtoItem.ScanFile_HasChange) { dbItem.ScanFile = fwFactory.CreateNoneImageFilePointer(_tempFolder, dtoItem.ScanFile_NewFile, dtoItem.ScanFile); } if (!string.IsNullOrEmpty(dtoItem.InvoiceDate)) { if (DateTime.TryParse(dtoItem.InvoiceDate, nl, System.Globalization.DateTimeStyles.None, out tmpDate)) { dbItem.InvoiceDate = tmpDate; } } decimal subtotal = 0; // map extra if (dtoItem.FactoryInvoiceExtras != null) { // check for child rows deleted foreach (FactoryInvoiceExtra dbExtra in dbItem.FactoryInvoiceExtra.ToArray()) { if (!dtoItem.FactoryInvoiceExtras.Select(o => o.FactoryInvoiceExtraID).Contains(dbExtra.FactoryInvoiceExtraID)) { dbItem.FactoryInvoiceExtra.Remove(dbExtra); } } // map child rows foreach (DTO.FactoryInvoiceExtra dtoExtra in dtoItem.FactoryInvoiceExtras) { FactoryInvoiceExtra dbExtra; if (dtoExtra.FactoryInvoiceExtraID <= 0) { dbExtra = new FactoryInvoiceExtra(); dbItem.FactoryInvoiceExtra.Add(dbExtra); } else { dbExtra = dbItem.FactoryInvoiceExtra.FirstOrDefault(o => o.FactoryInvoiceExtraID == dtoExtra.FactoryInvoiceExtraID); } if (dbExtra != null) { AutoMapper.Mapper.Map <DTO.FactoryInvoiceExtra, FactoryInvoiceExtra>(dtoExtra, dbExtra); if (dtoExtra.UnitPrice.HasValue && dtoExtra.Quantity.HasValue) { dbExtra.SubTotal = Math.Round(dtoExtra.UnitPrice.Value * dtoExtra.Quantity.Value, 2, MidpointRounding.AwayFromZero); subtotal += Math.Round(dtoExtra.UnitPrice.Value * dtoExtra.Quantity.Value, 2, MidpointRounding.AwayFromZero); } } } } dbItem.SubTotalAmount = subtotal; if (dbItem.DeductedAmount.HasValue) { dbItem.TotalAmount = dbItem.SubTotalAmount.Value - dbItem.DeductedAmount.Value; } else { dbItem.TotalAmount = dbItem.SubTotalAmount; } }