Beispiel #1
0
        public static long SaveExportBLHeader(IJobBL objBL)
        {
            long   exportBLId   = 0;
            string strExecution = "[fwd].[usp_fwdBLHeader_Save]";

            using (DbQuery oDq = new DbQuery(strExecution))
            {
                oDq.AddBigIntegerParam("@BLId", objBL.BLId);
                oDq.AddIntegerParam("@LocationId", objBL.LocationId);
                oDq.AddBigIntegerParam("@NvoccId", objBL.NvoccId);
                oDq.AddBigIntegerParam("@JobId", objBL.BookingId);
                oDq.AddIntegerParam("@BLIssuePlaceId", objBL.BLIssuePlaceId);
                oDq.AddVarcharParam("@BLNumber", 60, objBL.BLNumber);
                oDq.AddDateTimeParam("@BLDate", objBL.BLDate);
                oDq.AddVarcharParam("@PORDesc", 25, objBL.PORDesc);
                oDq.AddVarcharParam("@POLDesc", 25, objBL.POLDesc);
                oDq.AddVarcharParam("@PODDesc", 25, objBL.PODDesc);
                oDq.AddVarcharParam("@FPODDesc", 25, objBL.FPODDesc);
                oDq.AddVarcharParam("@ShipperName", 100, objBL.ShipperName);
                oDq.AddVarcharParam("@Shipper", 300, objBL.Shipper);
                oDq.AddVarcharParam("@ConsigneeName", 100, objBL.ConsigneeName);
                oDq.AddVarcharParam("@Consignee", 300, objBL.Consignee);
                oDq.AddVarcharParam("@NotifyPartyName", 100, objBL.NotifyPartyName);
                oDq.AddVarcharParam("@NotifyParty", 300, objBL.NotifyParty);
                oDq.AddVarcharParam("@GoodDesc", 2000, objBL.GoodDesc);
                oDq.AddVarcharParam("@MarksNumnbers", 300, objBL.MarksNumnbers);
                oDq.AddIntegerParam("@ShipmentMode", objBL.ShipmentMode);
                oDq.AddIntegerParam("@AgentId", objBL.AgentId);
                oDq.AddIntegerParam("@CreatedBy", objBL.CreatedBy);
                oDq.AddDateTimeParam("@CreatedOn", objBL.CreatedOn);
                oDq.AddIntegerParam("@ModifiedBy", objBL.ModifiedBy);
                oDq.AddDateTimeParam("@ModifiedOn", objBL.ModifiedOn);
                oDq.AddVarcharParam("@BLClause", 20, objBL.BLClause);
                oDq.AddVarcharParam("@BLType", 20, objBL.BLType);
                oDq.AddIntegerParam("@NoOfBL", objBL.NoOfBL);
                oDq.AddDecimalParam("@NetWeight", 12, 3, objBL.NetWeight);
                oDq.AddDecimalParam("@GrossWeight", 12, 3, objBL.GrossWeight);
                oDq.AddDateTimeParam("@BLReleaseDate", objBL.BLReleaseDate);
                oDq.AddBooleanParam("@BLThruEdge", objBL.BLthruEdge);
                oDq.AddVarcharParam("@FreightType", 1, objBL.FreightType);
                oDq.AddVarcharParam("@Packages", 300, objBL.Packages);
                oDq.AddVarcharParam("@Commodity", 30, objBL.Commodity);
                exportBLId = Convert.ToInt64(oDq.GetScalar());
                return(exportBLId);
            }
        }
Beispiel #2
0
 public static long SaveExportBLHeader(IJobBL objBL)
 {
     return(JobBLDAL.SaveExportBLHeader(objBL));
 }
 public JobsController(IJobBL jobBL)
 {
     _jobBL = jobBL;
 }