public IncomingCourierMasterVM GetCourierDocumentDetails(int parentDetailsID) { DAL.Trade trade = new DAL.Trade(); trade.TradeDBConnectionString = this.TradeDBConnectionString; IncomingCourierMasterVM masterCourierWithDetails = trade.GetCourierDocumentDetails(parentDetailsID); return(masterCourierWithDetails); }
public void ProcessSheet(dynamic sheetDetails) { UploadTrade uploadTradeDetails = new UploadTrade(); UploadTradeLog uploadTradeLog = new UploadTradeLog() { ImportDate = DateTime.Now, WorkBookName = sheetDetails.Sheet.SheetName, TradeRequest = string.Empty, ExceptionMessage = string.Empty }; DAL.Trade trade = new DAL.Trade(); trade.TradeDBConnectionString = this.TradeDBConnectionString; int shippingId = -1; string shippingMissedElements = string.Empty; try { uploadTradeDetails.Shipping = GetShipping(sheetDetails.Sheet, sheetDetails.ShippingDetailsRowIndex, sheetDetails.DocumentInstructionsRowIndex); uploadTradeDetails.Shipping.TradeSheetName = sheetDetails.Sheet.SheetName; uploadTradeDetails.DocumentInstructions = GetDocumentInstructions(sheetDetails.Sheet, sheetDetails.DocumentInstructionsRowIndex); uploadTradeDetails.ShippingModels = GetShippingModels(sheetDetails.Sheet, sheetDetails.ShippingModelsRowIndex); var CheckIsSINoAlreadyExist = trade.CheckIsSINoAlreadyExist(uploadTradeDetails.Shipping.SINo); if (CheckIsSINoAlreadyExist) { throw new Exception("Import already done for this Shipping Instruction"); } else { DataTable documentInstructionsTable = JsonConvert.DeserializeObject <DataTable>(JsonConvert.SerializeObject(uploadTradeDetails.DocumentInstructions)); DataTable shippingModelsTable = JsonConvert.DeserializeObject <DataTable>(JsonConvert.SerializeObject(uploadTradeDetails.ShippingModels)); shippingId = trade.SaveShippingTradeDetails(uploadTradeDetails.Shipping, documentInstructionsTable, shippingModelsTable); } if (shippingId > 0) { uploadTradeLog.ShippingId = shippingId; uploadTradeLog.ImportStatus = "IMPORTED"; trade.WriteShippingImportLog(uploadTradeLog); } else { uploadTradeLog.ShippingId = shippingId; uploadTradeLog.ImportStatus = "VALIDATIONS"; uploadTradeLog.ExceptionMessage = shippingMissedElements; trade.WriteShippingImportLog(uploadTradeLog); } } catch (Exception ex) { uploadTradeLog.ShippingId = shippingId; uploadTradeLog.ImportStatus = "FAILED"; uploadTradeLog.ExceptionMessage = ex.Message; trade.WriteShippingImportLog(uploadTradeLog); _tradeLogger.Error("Trading.BLL.Trade.LoadSheet", ex); throw ex; } }
public int SaveIncomingCourierDetails(List <IncomingCourierDetailsVMSave> incomingCourierDetailsVMSave) { DAL.Trade trade = new DAL.Trade(); trade.TradeDBConnectionString = this.TradeDBConnectionString; DataTable incomingCourierDetailsVMTable = JsonConvert.DeserializeObject <DataTable>(JsonConvert.SerializeObject(incomingCourierDetailsVMSave)); if (incomingCourierDetailsVMTable.Columns.Contains("SubDetails")) { incomingCourierDetailsVMTable.Columns.Remove("SubDetails"); } return(trade.SaveIncomingCourierDetails(incomingCourierDetailsVMTable)); }
public int DeleteCourierInvoice(int invoiceDetailID) { DAL.Trade trade = new DAL.Trade(); trade.TradeDBConnectionString = this.TradeDBConnectionString; return(trade.DeleteCourierInvoice(invoiceDetailID)); }
public List <Courier> GetCourierList() { DAL.Trade trade = new DAL.Trade(); trade.TradeDBConnectionString = this.TradeDBConnectionString; return(trade.GetCourierList()); }
public int SaveIncomingCourierMaster(IncomingCourierMasterVMSave incomingCourierMasterVM) { DAL.Trade trade = new DAL.Trade(); trade.TradeDBConnectionString = this.TradeDBConnectionString; return(trade.SaveIncomingCourierMaster(incomingCourierMasterVM)); }
public List <ViewModel.ShippingAdviceVM> GetShippingAdvice() { DAL.Trade trade = new DAL.Trade(); trade.TradeDBConnectionString = this.TradeDBConnectionString; return(trade.GetShippingAdvice()); }
public UploadTradeVM GetShippingTradeDetails(int shippingId) { DAL.Trade trade = new DAL.Trade(); trade.TradeDBConnectionString = this.TradeDBConnectionString; return(trade.GetShippingTradeDetails(shippingId)); }
public void SaveShippingAdvice(List <ShippingAdviceVM> shippingAdvice) { DAL.Trade trade = new DAL.Trade(); trade.TradeDBConnectionString = this.TradeDBConnectionString; trade.SaveShippingAdvice(shippingAdvice); }