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