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