public static IBLHeader GetBLHeaderinformation(long BlId)
{
string strExecution = "uspGetBLHeaderInfo";
IBLHeader header = null;
using (DbQuery oDq = new DbQuery(strExecution))
{
oDq.AddBigIntegerParam("@BLID", BlId);
DataTableReader reader = oDq.GetTableReader();
while (reader.Read())
{
header = new BLHeaderEntity(reader);
}
reader.Close();
}
return(header);
}
public int SaveImportBL(IBLHeader blHeader)
{
int blId = 0;
int blFooterId = 0;
blId = ImportBLDAL.SaveImportBL(blHeader);
if (blId > 0)
{
if (!ReferenceEquals(blHeader.BLFooter, null))
{
foreach (IBLFooter footer in blHeader.BLFooter)
{
footer.BLID = blId;
blFooterId = ImportBLDAL.SaveImportBLFooter(footer);
}
}
}
return(blId);
}
public static int SaveImportBL(IBLHeader blHeader)
{
string strExecution = "uspSaveImportBLHeader";
int blId = 0;
using (DbQuery oDq = new DbQuery(strExecution))
{
oDq.AddBigIntegerParam("@BLID", blHeader.BLID);
oDq.AddBigIntegerParam("@BLIssuePortID", blHeader.BLIssuePortID);
//oDq.AddVarcharParam("@CACode", 10, blHeader.CACode.ToUpper());
oDq.AddVarcharParam("@BillOfEntryNo", 50, blHeader.BillOfEntryNo.ToUpper());
oDq.AddVarcharParam("@CargoMovement", 2, blHeader.CargoMovement.ToUpper());
oDq.AddVarcharParam("@CargoNature", 2, blHeader.CargoNature.ToUpper());
oDq.AddVarcharParam("@CargoType", 1, blHeader.CargoType.ToUpper());
oDq.AddIntegerParam("@DetentionFree", blHeader.DetentionFree);
oDq.AddVarcharParam("@DetentionSlabType", 1, blHeader.DetentionSlabType.ToUpper());
oDq.AddBooleanParam("@DOLock", blHeader.DOLock);
oDq.AddVarcharParam("@DOLockReason", 100, blHeader.DOLockReason.ToUpper());
oDq.AddBooleanParam("@DPT", blHeader.DPT);
oDq.AddBigIntegerParam("@FinalDestination", blHeader.FinalDestination);
oDq.AddBooleanParam("@FreeOut", blHeader.FreeOut);
oDq.AddVarcharParam("@FreightType", 2, blHeader.FreightType.ToUpper());
oDq.AddBooleanParam("@HazFlag", blHeader.HazFlag);
oDq.AddVarcharParam("@FreigthToCollect", 60, blHeader.FreigthToCollect.ToString().ToUpper());
oDq.AddVarcharParam("@GrossWeight", 60, blHeader.GrossWeight.ToString().ToUpper());
oDq.AddDateTimeParam("@IGMBLDate", blHeader.IGMBLDate);
oDq.AddVarcharParam("@IGMBLNumber", 60, blHeader.IGMBLNumber.ToUpper());
oDq.AddVarcharParam("@IMOCode", 60, blHeader.IMOCode.ToUpper());
oDq.AddVarcharParam("@ImpLineBLNo", 60, blHeader.ImpLineBLNo.ToUpper());
oDq.AddDateTimeParam("@ImpLineBLDate", blHeader.ImpLineBLDate);
oDq.AddBigIntegerParam("@ImpVesselID", blHeader.ImpVesselID);
oDq.AddBigIntegerParam("@ImpVoyageID", blHeader.ImpVoyageID);
oDq.AddVarcharParam("@ItemLineNo", 6, blHeader.ItemLineNo.ToUpper());
oDq.AddVarcharParam("@ItemLinePrefix", 8, blHeader.ItemLinePrefix.ToUpper());
oDq.AddVarcharParam("@ItemSubLineNo", 6, blHeader.ItemSubLineNo.ToUpper());
oDq.AddVarcharParam("@ItemType", 2, blHeader.ItemType.ToUpper());
oDq.AddVarcharParam("@LineBLType", 2, blHeader.LineBLType.ToUpper());
oDq.AddIntegerParam("@LocationID", blHeader.LocationID);
oDq.AddVarcharParam("@MLOCode", 16, blHeader.MLOCode.ToUpper());
oDq.AddIntegerParam("@NVOCCID", blHeader.NVOCCID);
oDq.AddIntegerParam("@NoofFEU", blHeader.NoofFEU);
oDq.AddIntegerParam("@NoofTEU", blHeader.NoofTEU);
oDq.AddVarcharParam("@PackageDetail", 30, blHeader.PackageDetail.ToUpper());
oDq.AddBooleanParam("@PartBL", blHeader.PartBL);
oDq.AddIntegerParam("@PGR_FreeDays", blHeader.PGR_FreeDays);
oDq.AddBigIntegerParam("@PortDischarge", blHeader.PortDischarge);
oDq.AddBigIntegerParam("@PortLoading", blHeader.PortLoading);
oDq.AddBooleanParam("@Reefer", blHeader.Reefer);
oDq.AddBigIntegerParam("@StockLocationID", blHeader.StockLocationID);
oDq.AddIntegerParam("@SurveyorAddressID", blHeader.SurveyorAddressID); //NOT FOUND
oDq.AddBooleanParam("@TaxExemption", blHeader.TaxExemption);
//oDq.AddVarcharParam("@TPBondNo", 10, blHeader.TPBondNo.ToUpper());
oDq.AddVarcharParam("@TransportMode", 1, blHeader.TransportMode.ToUpper());
oDq.AddIntegerParam("@UnitOfVolume", blHeader.UnitOfVolume);
oDq.AddIntegerParam("@UnitOfWeight", blHeader.UnitOfWeight);
oDq.AddIntegerParam("@UnitPackage", blHeader.UnitPackage);
oDq.AddVarcharParam("@UNOCode", 5, blHeader.UNOCode.ToUpper());
oDq.AddVarcharParam("@Volume", 60, blHeader.Volume.ToString().ToUpper());
oDq.AddVarcharParam("@WaiverPercent", 60, blHeader.WaiverPercent.ToString().ToUpper()); //NOT FOUND
oDq.AddVarcharParam("@WaiverType", 60, blHeader.WaiverType.ToUpper()); //NOT FOUND
oDq.AddVarcharParam("@TranShipment", 500, blHeader.TranShipment.ToUpper());
oDq.AddVarcharParam("@ShipperInformation", 500, blHeader.ShipperInformation.ToUpper());
oDq.AddVarcharParam("@ShipperName", 60, blHeader.ShipperName.ToUpper()); //NOT FOUND
oDq.AddVarcharParam("@MarksNumbers", 500, blHeader.MarksNumbers.ToUpper());
oDq.AddVarcharParam("@GoodDescription", 500, blHeader.GoodDescription.ToUpper());
oDq.AddVarcharParam("@ConsigneeInformation", 500, blHeader.ConsigneeInformation.ToUpper());
oDq.AddVarcharParam("@ConsigneeName", 100, blHeader.ConsigneeName.ToUpper()); //NOT FOUND
oDq.AddVarcharParam("@BLComment", 300, blHeader.BLComment.ToUpper());
oDq.AddVarcharParam("@NotifyName", 100, blHeader.NotifyName.ToUpper()); //NOT FOUND
oDq.AddVarcharParam("@NotifyPartyInformation", 500, blHeader.NotifyPartyInformation.ToUpper());
oDq.AddDateTimeParam("@dtAdded", blHeader.dtAdded);
oDq.AddDateTimeParam("@dtEdited", blHeader.dtEdited);
oDq.AddBooleanParam("@RsStatus", blHeader.RsStatus);
oDq.AddBooleanParam("@ONBR", blHeader.ONBR);
oDq.AddIntegerParam("@CompanyID", blHeader.CompanyID);
oDq.AddBooleanParam("@Billing", blHeader.Billing); //NOT FOUND
oDq.AddBigIntegerParam("@NumberPackage", blHeader.NumberPackage);
oDq.AddDateTimeParam("@WaiverDate", blHeader.WaiverDate); //NOT FOUND
oDq.AddVarcharParam("@Commodity", 20, blHeader.Commodity.ToUpper());
oDq.AddVarcharParam("@LineBLVesselDetail", 100, blHeader.LineBLVesselDetail.ToUpper());
oDq.AddVarcharParam("@CANTo", 500, blHeader.CANTo.ToUpper());
oDq.AddIntegerParam("@WaiverFk_UserID", blHeader.WaiverFk_UserID); //NOT FOUND
oDq.AddBigIntegerParam("@UserAdded", blHeader.UserAdded);
oDq.AddBigIntegerParam("@UserEdited", blHeader.UserEdited);
if (!string.IsNullOrEmpty(blHeader.WaiverLetterUpload))
{
oDq.AddVarcharParam("@WaiverLetterUpload", 60, blHeader.WaiverLetterUpload.ToUpper()); //NOT FOUND
}
oDq.AddVarcharParam("@CFSNomination", 1, blHeader.CFSNomination.ToUpper());
oDq.AddIntegerParam("@AddressCFSId", blHeader.AddressCFSId);
oDq.AddBigIntegerParam("@PortFrtPayableID", blHeader.PortFrtPayableID);
oDq.AddIntegerParam("@DPTId", blHeader.DPTId);
oDq.AddBigIntegerParam("@CHAId", blHeader.CHAId);
oDq.AddBigIntegerParam("@CarrierID", blHeader.CarrierID);
blId = Convert.ToInt32(oDq.GetScalar());
}
return(blId);
}
