public static List <IExportBL> GetExportBLForListing(SearchCriteria searchCriteria)
{
string strExecution = "[exp].[usp_GetExportBLForListing]";
List <IExportBL> lstBL = new List <IExportBL>();
using (DbQuery oDq = new DbQuery(strExecution))
{
oDq.AddVarcharParam("@BookingNumber", 100, searchCriteria.BookingNo);
oDq.AddVarcharParam("@EdgeBLNo", 100, searchCriteria.EdgeBLNumber);
oDq.AddVarcharParam("@RefBLNo", 100, searchCriteria.RefBLNumber);
oDq.AddVarcharParam("@POL", 100, searchCriteria.POL);
oDq.AddVarcharParam("@Line", 100, searchCriteria.LineName);
oDq.AddVarcharParam("@Location", 100, searchCriteria.Location);
oDq.AddIntegerParam("@Status", searchCriteria.IntegerOption1);
oDq.AddVarcharParam("@SortExpression", 100, searchCriteria.SortExpression);
oDq.AddVarcharParam("@SortDirection", 100, searchCriteria.SortDirection);
DataTableReader reader = oDq.GetTableReader();
while (reader.Read())
{
IExportBL bl = new ExportBLEntity(reader);
lstBL.Add(bl);
}
reader.Close();
}
return(lstBL);
}
public static IExportBL GetExportBLHeaderInfoForEdit(string BLNumber)
{
string strExecution = "[exp].[usp_GetExpBLForEdit]";
IExportBL objHeader = new ExportBLEntity();
using (DbQuery oDq = new DbQuery(strExecution))
{
oDq.AddVarcharParam("@BLNumber", 50, BLNumber);
DataTableReader reader = oDq.GetTableReader();
while (reader.Read())
{
objHeader = new ExportBLEntity(reader);
}
reader.Close();
}
return(objHeader);
}
private long SaveExportBLHeaderDetails()
{
IExportBL objBL = new ExportBLEntity();
long exportBLId = 0;
if (ddlBLClause.SelectedValue == "R" && txtBLReleaseDate.Text == string.Empty)
{
lblErr.Text = "RFS date is compulsory";
return(0);
}
if (!Convert.ToBoolean(ViewState["ISEDIT"]))
{
objBL.BLId = 0;
}
else
{
objBL.BLId = Convert.ToInt64(ViewState["BLID"]);
}
objBL.LocationId = Convert.ToInt32(ViewState["LOCATIONID"]);
objBL.NvoccId = Convert.ToInt32(ViewState["NVOCCID"]);
objBL.BookingId = Convert.ToInt64(ViewState["BOOKINGID"]);
objBL.BLIssuePlaceId = Convert.ToInt32(ViewState["BLISSUEID"]);
if (hdnBLThruEdge.Value == "1")
{
objBL.BLNumber = string.Empty;
objBL.BLthruEdge = true;
}
else
{
objBL.BLNumber = txtBLNo.Text;
objBL.BLthruEdge = false;
}
objBL.BLDate = Convert.ToDateTime(txtBLDate.Text.Trim());
objBL.PORDesc = txtPorDesc.Text.Trim();
objBL.POLDesc = txtPolDesc.Text.Trim();
objBL.PODDesc = txtPodDesc.Text.Trim();
objBL.FPODDesc = txtFPodDesc.Text.Trim();
objBL.BLIssuePlace = ((TextBox)txtIssuePlace.FindControl("txtPort")).Text.Trim();
objBL.ShipperName = txtShipperName.Text.Trim();
objBL.Shipper = txtShipper.Text.Trim();
objBL.ConsigneeName = txtConsigneeName.Text.Trim();
objBL.Consignee = txtConsignee.Text.Trim();
objBL.NotifyPartyName = txtNotifyName.Text.Trim();
objBL.NotifyParty = txtNotify.Text.Trim();
objBL.GoodDesc = txtGoodsDescription.Text.Trim();
objBL.MarksNumnbers = txtMarks.Text.Trim();
objBL.ShipmentMode = Convert.ToInt32(ddlShipmentMode.SelectedValue);
objBL.AgentId = Convert.ToInt32(ddlAgent.SelectedValue);
objBL.CreatedBy = _userId;
objBL.CreatedOn = DateTime.Now;
objBL.ModifiedBy = _userId;
objBL.ModifiedOn = DateTime.Now;
objBL.BLClause = ddlBLClause.SelectedValue;
objBL.BLType = rdoBLType.SelectedValue;
objBL.NoOfBL = Convert.ToInt32(rdoOriginal.SelectedValue);
objBL.NetWeight = Convert.ToDecimal(TxtNtWt.Text.Trim());
objBL.GrossWeight = Convert.ToDecimal(txtNetWt.Text.Trim());
//objBL.NetWeight = Convert.ToDecimal(txtNetWt.Text.Trim());
if (ddlBLClause.SelectedValue == "R")
{
objBL.BLReleaseDate = Convert.ToDateTime(txtBLReleaseDate.Text.Trim());
}
else
{
objBL.BLReleaseDate = null;
}
exportBLId = ExportBLBLL.SaveExportBLHeader(objBL);
return(exportBLId);
}
