public JsonResult DeleteInvoice(int invoiceDetailID)
{
Trading.BLL.Trade trade = new BLL.Trade();
trade.TradeDBConnectionString = ConfigurationManager.ConnectionStrings["TradeConnectionString"].ConnectionString;
trade.DeleteCourierInvoice(invoiceDetailID);
return(Json(invoiceDetailID));
}
public ActionResult AddNewDocument(IncomingCourierMasterVM master, List <IncomingCourierDetailsVM> detailRows)
{
Trading.BLL.Trade trade = new BLL.Trade();
trade.TradeDBConnectionString = ConfigurationManager.ConnectionStrings["TradeConnectionString"].ConnectionString;
List <IncomingCourierDetailsVMSave> incomingCourierDetailsList = new List <IncomingCourierDetailsVMSave>();
int parentDetailID = 0;
detailRows.Where(detail => detail.IsSubDetail == false).ToList().ForEach(element => {
IncomingCourierDetailsVMSave saveElement = element;
parentDetailID = element.DetailsID;
saveElement.DetailsID = element.DetailsID;
saveElement.MasterID = master.MasterID;
saveElement.CompanyID = master.CompanyID;
incomingCourierDetailsList.Add(saveElement);
});
detailRows.Where(detail => detail.IsSubDetail == true).ToList().ForEach(element => {
IncomingCourierDetailsVMSave saveElement = element;
saveElement.DetailsID = element.DetailsID;
saveElement.MasterID = master.MasterID;
saveElement.CompanyID = master.CompanyID;
saveElement.ParentDetailsID = parentDetailID;
incomingCourierDetailsList.Add(saveElement);
});
int masterId = trade.SaveIncomingCourierDetails(incomingCourierDetailsList);
return(Json(detailRows));
}
public List <ViewModel.ShippingAdviceVM> GetDetailsFromShippingAdvice()
{
Trading.BLL.Trade trade = new BLL.Trade();
trade.TradeDBConnectionString = ConfigurationManager.ConnectionStrings["TradeConnectionString"].ConnectionString;
List <ViewModel.ShippingAdviceVM> shippingAdviceModel = trade.GetShippingAdvice();
return(shippingAdviceModel);
}
public JsonResult GetCourierDetailsRecord(string parentDetailID)
{
List <IncomingCourierDetailsVM> result = new List <IncomingCourierDetailsVM>();
Trading.BLL.Trade trade = new BLL.Trade();
trade.TradeDBConnectionString = ConfigurationManager.ConnectionStrings["TradeConnectionString"].ConnectionString;
parentDetailID = parentDetailID.IndexOf("_") > 0 ? parentDetailID.Split(new char[] { '_' }, StringSplitOptions.RemoveEmptyEntries)[1] : parentDetailID;
IncomingCourierMasterVM incomingCourierMasterVM = trade.GetCourierDocumentDetails(parentDetailID == ""? 0 : Convert.ToInt32(parentDetailID));
List <IncomingCourierDetailsVM> incomingDetails = new List <IncomingCourierDetailsVM>();
if (parentDetailID == "" || incomingCourierMasterVM.CourierDetails.Count == 0)
{
incomingCourierMasterVM.CourierDetails.AddRange(new List <IncomingCourierDetailsVM>()
{
new IncomingCourierDetailsVM()
{
DocDetail = "B/L-Bill of Leading", IsSubDetail = true
},
new IncomingCourierDetailsVM()
{
DocDetail = "C/0-Country of origin", IsSubDetail = true
},
new IncomingCourierDetailsVM()
{
DocDetail = "v/C-Vessel Certficate", IsSubDetail = true
},
new IncomingCourierDetailsVM()
{
DocDetail = "P/L-Packing List", IsSubDetail = true
},
new IncomingCourierDetailsVM()
{
DocDetail = "Verning List", IsSubDetail = true
},
new IncomingCourierDetailsVM()
{
DocDetail = "Serail Number List", IsSubDetail = true
}
}
);
}
if (incomingCourierMasterVM != null)
{
incomingDetails = incomingCourierMasterVM.CourierDetails.ToList();
var getMainItemDetails = incomingDetails.Where(x => x.IsSubDetail == false); //&& x.SINo == masterID
incomingCourierMasterVM.CourierDetails.Clear();
foreach (var details in incomingDetails.Where(x => x.IsSubDetail == true))
{
details.ArraySubItem = CompressSubDetails(incomingDetails, details.DetailsID);
incomingCourierMasterVM.CourierDetails.Add(details);
result.Add(details);
}
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult CourierList()
{
List <Courier> courierList = new List <Courier>();
//get data
Trading.BLL.Trade trade = new BLL.Trade();
trade.TradeDBConnectionString = ConfigurationManager.ConnectionStrings["TradeConnectionString"].ConnectionString;
courierList = trade.GetCourierList();
return(View(courierList));
}
public ActionResult Trade(string shippingId)
{
int cnvrtShippingID = Convert.ToInt32(shippingId);
ViewBag.Message = "Your Trade page.";
Trading.BLL.Trade trade = new BLL.Trade();
trade.TradeDBConnectionString = ConfigurationManager.ConnectionStrings["TradeConnectionString"].ConnectionString;
UploadTradeVM uploadTrade = trade.GetShippingTradeDetails(cnvrtShippingID);
uploadTrade = ReEvaluateUploadTrade(uploadTrade);
return(View(uploadTrade));
}
public IncomingCourierMasterVM GetIncomingCourierandDetails(int masterID)
{
Trading.BLL.Trade trade = new BLL.Trade();
trade.TradeDBConnectionString = ConfigurationManager.ConnectionStrings["TradeConnectionString"].ConnectionString;
IncomingCourierMasterVM incomingCourierMasterVM = trade.GetCourierMasterDetails(masterID);
List <IncomingCourierDetailsVM> incomingDetails = new List <IncomingCourierDetailsVM>();
if (incomingCourierMasterVM.CourierDetails.Count == 0)
{
incomingCourierMasterVM.CourierDetails.AddRange(new List <IncomingCourierDetailsVM>()
{
new IncomingCourierDetailsVM()
{
DocDetail = "B/L-Bill of Leading", IsSubDetail = true
},
new IncomingCourierDetailsVM()
{
DocDetail = "C/0-Country of origin", IsSubDetail = true
},
new IncomingCourierDetailsVM()
{
DocDetail = "v/C-Vessel Certficate", IsSubDetail = true
},
new IncomingCourierDetailsVM()
{
DocDetail = "P/L-Packing List", IsSubDetail = true
},
new IncomingCourierDetailsVM()
{
DocDetail = "Verning List", IsSubDetail = true
},
new IncomingCourierDetailsVM()
{
DocDetail = "Serail Number List", IsSubDetail = true
}
}
);
}
if (incomingCourierMasterVM != null)
{
incomingDetails = incomingCourierMasterVM.CourierDetails.ToList();
var getMainItemDetails = incomingDetails.Where(x => x.IsSubDetail == false);
incomingCourierMasterVM.CourierDetails.Clear();
foreach (var details in getMainItemDetails)
{
details.ArraySubItem = CompressSubDetails(incomingDetails, details.DetailsID);
incomingCourierMasterVM.CourierDetails.Add(details);
}
}
return(incomingCourierMasterVM);
}
public ActionResult Trade(UploadTrade uploadTrade, HttpPostedFileBase postedFile, string submitButton)
{
UploadTradeVM uploadTradeVM = new UploadTradeVM();
try
{
switch (submitButton)
{
case "Search":
ModelState.Clear();
Trading.BLL.Trade trade = new BLL.Trade();
trade.TradeDBConnectionString = ConfigurationManager.ConnectionStrings["TradeConnectionString"].ConnectionString;
uploadTradeVM = trade.GetShippingTradeDetails(uploadTrade.ShippingId);
uploadTradeVM = ReEvaluateUploadTrade(uploadTradeVM);
if (uploadTrade.Shipping.SINo == null || uploadTrade.Shipping.SINo == string.Empty)
{
uploadTrade.IsSINoAvailable = false;
}
break;
case "Upload":
if (postedFile != null)
{
string path = Server.MapPath("~/TradeShippingSheets/");
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
postedFile.SaveAs(path + Path.GetFileName(postedFile.FileName));
uploadTradeVM = new UploadTradeVM()
{
Shipping = new ViewModel.Shipping(),
DocumentInstructions = new List <DocumentInstructionVM>(),
ShippingModels = new List <ShippingModelVM>()
};
ProcessInputFile((path + Path.GetFileName(postedFile.FileName)));
}
break;
}
return(View(uploadTradeVM));
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult AddNewCourierMaster(IncomingCourierMasterVMSave courierMaster)
{
Guid companyId = Guid.NewGuid();
courierMaster.CompanyID = companyId;
courierMaster.CreationDate = courierMaster.UpdatedDate = DateTime.Now;
courierMaster.CreatedBy = courierMaster.UpdatedBy = 999;
Trading.BLL.Trade trade = new BLL.Trade();
trade.TradeDBConnectionString = ConfigurationManager.ConnectionStrings["TradeConnectionString"].ConnectionString;
int masterId = trade.SaveIncomingCourierMaster(courierMaster);
courierMaster.MasterID = masterId;
return(Json(courierMaster));
}
public void ProessSASheet(string fileFullPath)
{
try
{
Trading.BLL.Trade trade = new BLL.Trade();
trade.TradeDBConnectionString = ConfigurationManager.ConnectionStrings["TradeConnectionString"].ConnectionString;
List <ShippingAdviceVM> currentMothTimeSheetList = new List <ShippingAdviceVM>();
FileStream currentTimeSheetFile = new FileStream(fileFullPath, FileMode.Open, FileAccess.Read);
XSSFWorkbook hssfwb = new XSSFWorkbook(currentTimeSheetFile);
XSSFFormulaEvaluator formula = new XSSFFormulaEvaluator(hssfwb);
ISheet WorkerTimeSheet = hssfwb.GetSheet("mike");
ICellStyle style1 = hssfwb.CreateCellStyle();
IDataFormat dataFormatCustom = hssfwb.CreateDataFormat();
style1.DataFormat = dataFormatCustom.GetFormat("dd/MM/yyyy HH:mm:ss");
Guid companyID = Guid.Parse("CCAA3E3F-4486-4465-B5A1-723F647EAD17");
//DateTime TimeSheetDateValue = WorkerTimeSheet.GetRow(2).GetCell(3).DateCellValue;
//int days = DateTime.DaysInMonth(TimeSheetDateValue.Year, TimeSheetDateValue.Month);
for (int row = 5; row < WorkerTimeSheet.LastRowNum - 1; row++) //Loop the records upto filled row
{
//System.IO.File.AppendAllText(log, "Reading " + row + " row For EMPCode " + getValueFromCell(WorkerTimeSheet.GetRow(row).GetCell(1), formula));
ShippingAdviceVM shippingAdviceVM = new ShippingAdviceVM();
var currentCellValue2 = WorkerTimeSheet.GetRow(row);
// string currentCellValue = getValueFromCell(WorkerTimeSheet.GetRow(row).GetCell(2), formula);
//if (currentCellValue != "" && currentCellValue.ToLower().Equals("total"))
//{
// break;
//}
if (currentCellValue2 == null)
{
continue;
}
string currentCellValue = WorkerTimeSheet.GetRow(row).GetCell(2).StringCellValue;
if (currentCellValue != null && currentCellValue != "") //null is when the row only contains empty cells
{
//int validRow = Regex.Matches(currentCellValue.Substring(0, 1), @"[a-zA-Z]").Count;
//if (validRow == 0)
//{
shippingAdviceVM.CompanyID = companyID;
var valueFrom2thCell = WorkerTimeSheet.GetRow(row).GetCell(2);
if (valueFrom2thCell == null)
{
shippingAdviceVM.SCInvoiceNo = " ";
}
else
{
shippingAdviceVM.SCInvoiceNo = WorkerTimeSheet.GetRow(row).GetCell(2).StringCellValue;
}
var valueFrom3thCell = WorkerTimeSheet.GetRow(row).GetCell(3);
if (valueFrom3thCell == null)
{
shippingAdviceVM.InvoiceAmount = 0;
}
else
{
shippingAdviceVM.InvoiceAmount = Convert.ToDecimal(WorkerTimeSheet.GetRow(row).GetCell(3).NumericCellValue);
}
var valueFrom4thCell = WorkerTimeSheet.GetRow(row).GetCell(4);
if (valueFrom4thCell == null)
{
shippingAdviceVM.Consignee = string.Empty;
}
else if (valueFrom4thCell.CellType == CellType.Numeric)
{
shippingAdviceVM.Consignee = Convert.ToString(WorkerTimeSheet.GetRow(row).GetCell(4).NumericCellValue);
}
else
{
shippingAdviceVM.Consignee = WorkerTimeSheet.GetRow(row).GetCell(4).StringCellValue;
}
var valueFrom5thCell = WorkerTimeSheet.GetRow(row).GetCell(5);
if (valueFrom5thCell == null)
{
shippingAdviceVM.BLDate = DateTime.Now;
}
else
{
shippingAdviceVM.BLDate = DateTime.Parse(WorkerTimeSheet.GetRow(row).GetCell(5).StringCellValue);
}
var valueFrom6thCell = WorkerTimeSheet.GetRow(row).GetCell(6);
if (valueFrom6thCell == null)
{
shippingAdviceVM.ReceivedDate = DateTime.Now;
}
else
{
shippingAdviceVM.ReceivedDate = DateTime.Parse(WorkerTimeSheet.GetRow(row).GetCell(6).StringCellValue);
}
var valueFrom7thCell = WorkerTimeSheet.GetRow(row).GetCell(7);
if (valueFrom7thCell == null)
{
shippingAdviceVM.Shiper = string.Empty;
}
else
{
shippingAdviceVM.Shiper = WorkerTimeSheet.GetRow(row).GetCell(7).StringCellValue;
}
var valueFrom8thCell = WorkerTimeSheet.GetRow(row).GetCell(8);
if (valueFrom8thCell == null)
{
shippingAdviceVM.BLNo = string.Empty;
}
else if (valueFrom8thCell.CellType == CellType.Numeric)
{
shippingAdviceVM.Consignee = Convert.ToString(WorkerTimeSheet.GetRow(row).GetCell(4).NumericCellValue);
}
else
{
shippingAdviceVM.BLNo = WorkerTimeSheet.GetRow(row).GetCell(8).StringCellValue;
}
var valueFrom9thCell = WorkerTimeSheet.GetRow(row).GetCell(9);
if (valueFrom9thCell == null)
{
shippingAdviceVM.Factory = " ";
}
else
{
shippingAdviceVM.Factory = WorkerTimeSheet.GetRow(row).GetCell(9).StringCellValue;
}
var valueFrom10thCell = WorkerTimeSheet.GetRow(row).GetCell(10);
if (valueFrom10thCell == null)
{
shippingAdviceVM.Department = string.Empty;
}
else
{
shippingAdviceVM.Department = WorkerTimeSheet.GetRow(row).GetCell(10).StringCellValue;
}
var valueFrom11thCell = WorkerTimeSheet.GetRow(row).GetCell(11);
if (valueFrom11thCell == null)
{
shippingAdviceVM.Material = string.Empty;
}
else
{
shippingAdviceVM.Material = WorkerTimeSheet.GetRow(row).GetCell(11).StringCellValue;
}
var valueFrom12thcell = WorkerTimeSheet.GetRow(row).GetCell(12);
if (valueFrom12thcell == null)
{
shippingAdviceVM.Quantity = 0;
}
else if (valueFrom12thcell.CellType == CellType.Numeric)
{
shippingAdviceVM.Quantity = Convert.ToInt32(WorkerTimeSheet.GetRow(row).GetCell(12).NumericCellValue);
}
else
{
shippingAdviceVM.Quantity = Convert.ToInt32(WorkerTimeSheet.GetRow(row).GetCell(12).NumericCellValue);
}
var valueFrom13thCell = WorkerTimeSheet.GetRow(row).GetCell(13);
if (valueFrom13thCell == null)
{
shippingAdviceVM.FOB = 0;
}
else
{
shippingAdviceVM.FOB = Convert.ToDecimal(WorkerTimeSheet.GetRow(row).GetCell(13).NumericCellValue);
}
var valueFrom14thCell = WorkerTimeSheet.GetRow(row).GetCell(14);
if (valueFrom14thCell == null)
{
shippingAdviceVM.PurchaseDocumentNo = 0;
}
else
{
shippingAdviceVM.PurchaseDocumentNo = Convert.ToInt32(WorkerTimeSheet.GetRow(row).GetCell(14).NumericCellValue);
}
var valueFrom15thCell = WorkerTimeSheet.GetRow(row).GetCell(15);
if (valueFrom15thCell == null)
{
shippingAdviceVM.Item1 = 0;
}
else
{
shippingAdviceVM.Item1 = Convert.ToInt32(WorkerTimeSheet.GetRow(row).GetCell(15).NumericCellValue);
}
var valueFrom16thcell = WorkerTimeSheet.GetRow(row).GetCell(16);
if (valueFrom16thcell == null)
{
shippingAdviceVM.SAPSO = string.Empty;
}
else
{
shippingAdviceVM.SAPSO = Convert.ToString(WorkerTimeSheet.GetRow(row).GetCell(16).NumericCellValue);
}
var valueFrom17thCell = WorkerTimeSheet.GetRow(row).GetCell(17);
if (valueFrom17thCell == null)
{
shippingAdviceVM.Item2 = 0;
}
else
{
shippingAdviceVM.Item2 = Convert.ToInt32(WorkerTimeSheet.GetRow(row).GetCell(17).NumericCellValue);
}
var valueFrom18thcell = WorkerTimeSheet.GetRow(row).GetCell(16);
if (valueFrom18thcell == null)
{
shippingAdviceVM.SAPDO = string.Empty;
}
else
{
shippingAdviceVM.SAPDO = Convert.ToString(WorkerTimeSheet.GetRow(row).GetCell(18).NumericCellValue);
}
var valueFrom19thCell = WorkerTimeSheet.GetRow(row).GetCell(19);
if (valueFrom19thCell == null)
{
shippingAdviceVM.PInt = 0;
}
else
{
shippingAdviceVM.PInt = Convert.ToInt32(WorkerTimeSheet.GetRow(row).GetCell(19).NumericCellValue);
}
var valueFrom20thcell = WorkerTimeSheet.GetRow(row).GetCell(20);
if (valueFrom20thcell == null)
{
shippingAdviceVM.SLoc = string.Empty;
}
else if (valueFrom20thcell.CellType == CellType.Numeric)
{
shippingAdviceVM.SLoc = Convert.ToString(WorkerTimeSheet.GetRow(row).GetCell(20).NumericCellValue);
}
else
{
shippingAdviceVM.SLoc = WorkerTimeSheet.GetRow(row).GetCell(20).StringCellValue;
}
var valueFrom21stcell = WorkerTimeSheet.GetRow(row).GetCell(21);
if (valueFrom21stcell == null)
{
shippingAdviceVM.Temp1 = string.Empty;
}
else
{
shippingAdviceVM.Temp1 = WorkerTimeSheet.GetRow(row).GetCell(21).StringCellValue;
}
var valueFrom22thCell = WorkerTimeSheet.GetRow(row).GetCell(22);
if (valueFrom22thCell == null)
{
shippingAdviceVM.Seq = 0;
}
else
{
shippingAdviceVM.Seq = Convert.ToInt32(WorkerTimeSheet.GetRow(row).GetCell(22).NumericCellValue);
}
var valueFrom23rdcell = WorkerTimeSheet.GetRow(row).GetCell(23);
if (valueFrom23rdcell == null)
{
shippingAdviceVM.Del = string.Empty;
}
else
{
shippingAdviceVM.Del = WorkerTimeSheet.GetRow(row).GetCell(23).StringCellValue;
}
var valueFrom24thCell = WorkerTimeSheet.GetRow(row).GetCell(24);
if (valueFrom24thCell == null)
{
shippingAdviceVM.Comp = string.Empty;
}
else
{
shippingAdviceVM.Comp = WorkerTimeSheet.GetRow(row).GetCell(24).StringCellValue;
}
//var valueFrom25thcell = WorkerTimeSheet.GetRow(row).GetCell(25);
//if (valueFrom25thcell == null)
// shippingAdviceVM.DeliveryDate = DateTime.Now;
//else
var sd = WorkerTimeSheet.GetRow(row).GetCell(25).StringCellValue;
if (sd == null)
{
shippingAdviceVM.DeliveryDate = DateTime.Now;
}
else
{
shippingAdviceVM.DeliveryDate = DateTime.Parse(sd, new CultureInfo("en-IN", true));
}
currentMothTimeSheetList.Add(shippingAdviceVM);
// }
//Here for sample , I just save the value in "value" field, Here you can write your custom logics...
}
}
if (currentMothTimeSheetList.Count() > 0)
{
trade.SaveShippingAdvice(currentMothTimeSheetList);
TempData["SuccessMessage"] = "ShippingAdvice data appended to DB";
}
}
catch (Exception ex)
{
//TempData["ErrorMessage"] = "There is a Issues on Uploading Workers OT Data .Please contact IT Support";
//Console.Write(ex.Message);
throw ex;
}
}
