protected override void ProcessEnbloc <T>(FileInfo file, string programCode, int transactionId, IEnumerable <T> baselstEnblocSnapshot) { var lstEnblocSnapshot = (List <EmptyEnblocSnapshot>)baselstEnblocSnapshot; using (ExcelPackage package = new ExcelPackage(file)) { ExcelWorksheet worksheet = package.Workbook.Worksheets[1]; int rowCount = worksheet.Dimension.Rows; int ColCount = worksheet.Dimension.Columns; string transaction_no = programCode + transactionId; for (int row = 8; row <= rowCount; row++) { if (Convert.ToString(worksheet.Cells[row, 1].Value).Trim() != "") { EmptyEnblocSnapshot enblocSnapshot = new EmptyEnblocSnapshot(); enblocSnapshot.TransactionId = transaction_no; enblocSnapshot.Vessel = Convert.ToString(worksheet.Cells[row, GetColumnIndexByName(worksheet, "Vsl Name(D)")].Value).Trim(); enblocSnapshot.ViaNo = Convert.ToString(worksheet.Cells[row, GetColumnIndexByName(worksheet, "VIA(D)")].Value).Trim(); enblocSnapshot.EnblocNumber = enblocSnapshot.ViaNo.ToUpper(); enblocSnapshot.ContainerNo = Convert.ToString(worksheet.Cells[row, GetColumnIndexByName(worksheet, "Container Number")].Value).Trim(); enblocSnapshot.ContainerSize = Convert.ToString(worksheet.Cells[row, GetColumnIndexByName(worksheet, "CtrSize")].Value).Trim(); enblocSnapshot.ContainerType = Convert.ToString(worksheet.Cells[row, GetColumnIndexByName(worksheet, "CtrType")].Value).Trim(); enblocSnapshot.IsoCode = Convert.ToString(worksheet.Cells[row, GetColumnIndexByName(worksheet, "ISO")].Value).Trim(); enblocSnapshot.CreatedBy = 0; lstEnblocSnapshot.Add(enblocSnapshot); } } } //return lstEnblocSnapshot; }
private static void ProcessEnbloc(FileInfo file, string programCode, int transactionId, List <EmptyEnblocSnapshot> lstEnblocSnapshot) { //List<EmptyEnblocSnapshot> lstEnblocSnapshot = new List<EmptyEnblocSnapshot>(); using (ExcelPackage package = new ExcelPackage(file)) { ExcelWorksheet worksheet = package.Workbook.Worksheets[1]; int rowCount = worksheet.Dimension.Rows; int ColCount = worksheet.Dimension.Columns; string document_date = Convert.ToString(worksheet.Cells["C1"].Value); string vessel = Convert.ToString(worksheet.Cells["B4"].Value); string voyage = Convert.ToString(worksheet.Cells["D4"].Value); string agent_name = Convert.ToString(worksheet.Cells["B5"].Value); string via_no = Convert.ToString(worksheet.Cells["D5"].Value); string depot_name = Convert.ToString(worksheet.Cells["A3"].Value); string transaction_no = programCode + transactionId; for (int row = 8; row <= rowCount; row++) { if (Convert.ToString(worksheet.Cells[row, 1].Value).Trim() != "") { EmptyEnblocSnapshot enblocSnapshot = new EmptyEnblocSnapshot(); enblocSnapshot.TransactionId = transaction_no; enblocSnapshot.Vessel = vessel; enblocSnapshot.Voyage = voyage; enblocSnapshot.AgentName = agent_name; enblocSnapshot.DepotName = depot_name; enblocSnapshot.ViaNo = via_no; enblocSnapshot.PermissionDate = document_date; enblocSnapshot.Srl = Convert.ToString(worksheet.Cells[row, 1].Value).Trim(); enblocSnapshot.ContainerNo = Convert.ToString(worksheet.Cells[row, 2].Value).Trim(); enblocSnapshot.ContainerType = Convert.ToString(worksheet.Cells[row, 3].Value).Trim(); enblocSnapshot.Wt = Convert.ToString(worksheet.Cells[row, 4].Value).Trim(); enblocSnapshot.Cargo = Convert.ToString(worksheet.Cells[row, 5].Value).Trim(); enblocSnapshot.IsoCode = Convert.ToString(worksheet.Cells[row, 6].Value).Trim(); enblocSnapshot.SealNo1 = Convert.ToString(worksheet.Cells[row, 7].Value).Trim(); enblocSnapshot.SealNo2 = Convert.ToString(worksheet.Cells[row, 8].Value).Trim(); enblocSnapshot.SealNo3 = Convert.ToString(worksheet.Cells[row, 9].Value).Trim(); enblocSnapshot.ImdgClass = Convert.ToString(worksheet.Cells[row, 10].Value).Trim(); enblocSnapshot.ReferTemrature = Convert.ToString(worksheet.Cells[row, 11].Value).Trim(); enblocSnapshot.OogDeatils = Convert.ToString(worksheet.Cells[row, 12].Value).Trim(); enblocSnapshot.ContainerGrossDetails = Convert.ToString(worksheet.Cells[row, 13].Value).Trim(); enblocSnapshot.CargoDescription = Convert.ToString(worksheet.Cells[row, 14].Value).Trim(); enblocSnapshot.BlNumber = Convert.ToString(worksheet.Cells[row, 15].Value).Trim(); enblocSnapshot.Name = Convert.ToString(worksheet.Cells[row, 16].Value).Trim(); enblocSnapshot.ItemNo = Convert.ToString(worksheet.Cells[row, 17].Value).Trim(); enblocSnapshot.DisposalMode = Convert.ToString(worksheet.Cells[row, 18].Value).Trim(); enblocSnapshot.CreatedBy = 0;//Convert.ToString(worksheet.Cells[row, 19].Value).Trim(); lstEnblocSnapshot.Add(enblocSnapshot); } } } //return lstEnblocSnapshot; }