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);
}
}
public static long SaveExportBLHeader(IJobBL objBL)
{
return(JobBLDAL.SaveExportBLHeader(objBL));
}
public JobsController(IJobBL jobBL)
{
_jobBL = jobBL;
}