public static List <ImpRegisterEntity> GetImportRegisterFooter(int lineId, int locId, Int64 voyageId, Int64 vesselId)
{
string strExecution = "[report].[uspGetImportRegisterFooter]";
List <ImpRegisterEntity> lstEntity = new List <ImpRegisterEntity>();
ImpRegisterEntity entity = null;
using (DbQuery oDq = new DbQuery(strExecution))
{
oDq.AddIntegerParam("@NVOCCId", lineId);
oDq.AddIntegerParam("@LocId", locId);
oDq.AddBigIntegerParam("@VoyageId", voyageId);
oDq.AddBigIntegerParam("@VesselId", vesselId);
DataTableReader reader = oDq.GetTableReader();
while (reader.Read())
{
entity = new ImpRegisterEntity();
entity.Location = Convert.ToString(reader["Location"]);
entity.Line = Convert.ToString(reader["Line"]);
entity.BLNo = Convert.ToString(reader["ImpLineBLNo"]);
entity.ContainerNo = Convert.ToString(reader["CntrNo"]);
entity.ContainerSize = Convert.ToString(reader["CntrSize"]);
entity.ContainerType = Convert.ToString(reader["ContainerType"]);
entity.SealNo = Convert.ToString(reader["SealNo"]);
if (reader["PayLoad"] != DBNull.Value)
{
entity.PayLoad = Convert.ToDecimal(reader["PayLoad"]);
}
if (reader["NumberPackage"] != DBNull.Value)
{
entity.NumberPackage = Convert.ToInt64(reader["NumberPackage"]);
}
entity.PackageUnit = Convert.ToString(reader["PackageUnit"]);
if (reader["Stat"] != DBNull.Value)
{
entity.Stat = Convert.ToString(reader["Stat"]);
}
entity.GoodsDescription = Convert.ToString(reader["GoodDescription"]);
entity.PortLoading = Convert.ToString(reader["PortLoading"]);
entity.PortDischarge = Convert.ToString(reader["PortDischarge"]);
entity.FinalDestination = Convert.ToString(reader["FinalDestination"]);
lstEntity.Add(entity);
}
}
return(lstEntity);
}
public static List <ImpRegisterEntity> GetImportRegisterHeader(int lineId, int locId, Int64 voyageId, Int64 vesselId)
{
string strExecution = "[report].[uspGetImportRegisterHeader]";
List <ImpRegisterEntity> lstEntity = new List <ImpRegisterEntity>();
ImpRegisterEntity entity = null;
using (DbQuery oDq = new DbQuery(strExecution))
{
oDq.AddIntegerParam("@NVOCCId", lineId);
oDq.AddIntegerParam("@LocId", locId);
oDq.AddBigIntegerParam("@VoyageId", voyageId);
oDq.AddBigIntegerParam("@VesselId", vesselId);
DataTableReader reader = oDq.GetTableReader();
while (reader.Read())
{
entity = new ImpRegisterEntity();
entity.Location = Convert.ToString(reader["Location"]);
entity.Line = Convert.ToString(reader["Line"]);
entity.ItemLineNo = Convert.ToString(reader["ItemLineNo"]);
entity.BLNo = Convert.ToString(reader["ImpLineBLNo"]);
entity.BLDate = Convert.ToDateTime(reader["ImpLineBLDate"]);
//if (reader["ImpLineBLDate"] != DBNull.Value) entity.BLDate = Convert.ToDateTime(reader["ImpLineBLDate"]);
if (reader["NoofTEU"] != DBNull.Value)
{
entity.TEU = Convert.ToInt32(reader["NoofTEU"]);
}
if (reader["NoofFEU"] != DBNull.Value)
{
entity.FEU = Convert.ToInt32(reader["NoofFEU"]);
}
entity.PortLoading = Convert.ToString(reader["PortLoading"]);
entity.PortDischarge = Convert.ToString(reader["PortDischarge"]);
entity.FinalDestination = Convert.ToString(reader["FinalDestination"]);
if (reader["DischargeDate"] != DBNull.Value)
{
entity.DischargeDate = Convert.ToDateTime(reader["DischargeDate"]);
}
//entity.DischargeDate = Convert.ToString(reader["DischargeDate"]);
entity.IGMNo = Convert.ToString(reader["IGMNo"]);
if (reader["GrossWeight"] != DBNull.Value)
{
entity.GrossWeight = Convert.ToDecimal(reader["GrossWeight"]);
}
entity.GoodsDescription = Convert.ToString(reader["GoodDescription"]);
if (reader["NumberPackage"] != DBNull.Value)
{
entity.NumberPackage = Convert.ToInt64(reader["NumberPackage"]);
}
entity.PackageUnit = Convert.ToString(reader["PackageUnit"]);
if (reader["RsStatus"] != DBNull.Value)
{
entity.Stat = Convert.ToString(reader["RsStatus"]);
}
if (reader["PGR_FreeDays"] != DBNull.Value)
{
entity.PGRFreeDays = Convert.ToInt32(reader["PGR_FreeDays"]);
}
entity.AddressCFS = Convert.ToString(reader["AddressCFS"]);
//entity.ICD = Convert.ToString(reader["ICD"]);
entity.TPBondNo = Convert.ToString(reader["TPBondNo"]);
entity.CACode = Convert.ToString(reader["CACode"]);
entity.CargoMovement = Convert.ToString(reader["CargoMovement"]);
entity.ConsigneeInformation = Convert.ToString(reader["ConsigneeInformation"]);
entity.NotifyPartyInformation = Convert.ToString(reader["NotifyPartyInformation"]);
entity.MarksNumbers = Convert.ToString(reader["MarksNumbers"]);
lstEntity.Add(entity);
}
}
return(lstEntity);
}
