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