void txtBookingNo_TextChanged(object sender, EventArgs e)
{
int Status;
if (!string.IsNullOrEmpty(txtBookingNo.Text))
{
if (ExportBLBLL.CheckBookingLocation(txtBookingNo.Text, _userLocation) == true)
{
Status = ExportBLBLL.CheckExpBLExistance(txtBookingNo.Text);
if (Status != 0)
{
LoadExportBLHeaderForAdd(txtBookingNo.Text, Status);
lblErr.Text = "";
}
else
{
lblErr.Text = "Error!!! Container(s) Missing or B/L Exists against Booking";
return;
}
}
else
{
rfvBookingNo.Visible = true;
}
}
}
private void LoadExportBL()
{
if (!ReferenceEquals(Session[Constants.SESSION_USER_INFO], null))
{
IUser user = (IUser)Session[Constants.SESSION_USER_INFO];
if (!ReferenceEquals(Session[Constants.SESSION_SEARCH_CRITERIA], null))
{
SearchCriteria searchCriteria = (SearchCriteria)Session[Constants.SESSION_SEARCH_CRITERIA];
if (!ReferenceEquals(searchCriteria, null))
{
BuildSearchCriteria(searchCriteria);
gvExportBL.PageIndex = searchCriteria.PageIndex;
if (searchCriteria.PageSize > 0)
{
gvExportBL.PageSize = searchCriteria.PageSize;
}
gvExportBL.DataSource = ExportBLBLL.GetExportBLForListing(searchCriteria);
gvExportBL.DataBind();
}
}
}
}
protected void btnClose_Click(object sender, EventArgs e)
{
long exportBLId = 0;
exportBLId = Convert.ToInt64(ViewState["BLID"]);
ExportBLBLL.CloseOpenBL(exportBLId, _userId, btnClose.Text);
Response.Redirect("~/Export/ExportBL.aspx");
}
protected void gvExportBL_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName.Equals("Sort"))
{
if (ViewState[Constants.SORT_EXPRESSION] == null)
{
ViewState[Constants.SORT_EXPRESSION] = e.CommandArgument.ToString();
ViewState[Constants.SORT_DIRECTION] = "ASC";
}
else
{
if (ViewState[Constants.SORT_EXPRESSION].ToString() == e.CommandArgument.ToString())
{
if (ViewState[Constants.SORT_DIRECTION].ToString() == "ASC")
{
ViewState[Constants.SORT_DIRECTION] = "DESC";
}
else
{
ViewState[Constants.SORT_DIRECTION] = "ASC";
}
}
else
{
ViewState[Constants.SORT_DIRECTION] = "ASC";
ViewState[Constants.SORT_EXPRESSION] = e.CommandArgument.ToString();
}
}
LoadExportBL();
}
else if (e.CommandName == "Edit")
{
RedirecToAddEditPage(Convert.ToString(e.CommandArgument));
}
else if (e.CommandName == "Dashboard")
{
string encryptedId = GeneralFunctions.EncryptQueryString(Convert.ToString(e.CommandArgument));
Response.Redirect("~/Export/Export-bl-query.aspx?BLNumber=" + encryptedId);
}
else if (e.CommandName == "RemoveData")
{
bool IsActive = false;
//if (((System.Web.UI.WebControls.LinkButton)(e.CommandSource)).Text == "Active")
// IsActive = false;
//else
// IsActive = true;
//Active/InActive
ExportBLBLL.ChangeBLStatus(Convert.ToString(e.CommandArgument), IsActive);
LoadExportBL();
}
}
private void SaveExportBLContainers(long exportBLId)
{
List <IExportBLContainer> lstData = new List <IExportBLContainer>();
int totalRows = gvwContainers.Rows.Count;
for (int r = 0; r < totalRows; r++)
{
GridViewRow thisGridViewRow = gvwContainers.Rows[r];
HiddenField hdnContainerId = (HiddenField)thisGridViewRow.FindControl("hdnContainerId");
DropDownList ddlPart = (DropDownList)thisGridViewRow.FindControl("ddlPart");
DropDownList ddlUnit = (DropDownList)thisGridViewRow.FindControl("ddlUnit");
TextBox txtSealNo = (TextBox)thisGridViewRow.FindControl("txtSealNo");
TextBox txtPackage = (TextBox)thisGridViewRow.FindControl("txtPackage");
TextBox txtGrossWeight = (TextBox)thisGridViewRow.FindControl("txtGrossWeight");
TextBox txtShippingBillNumber = (TextBox)thisGridViewRow.FindControl("txtShippingBillNumber");
TextBox txtShippingBillDate = (TextBox)thisGridViewRow.FindControl("txtShippingBillDate");
lstData = ViewState["DataSource"] as List <IExportBLContainer>;
lstData.Where(d => d.ContainerId == Convert.ToInt64(hdnContainerId.Value))
.Select(d =>
{
d.BLId = exportBLId;
d.BookingId = Convert.ToInt64(ViewState["BOOKINGID"]);
d.Part = Convert.ToBoolean(ddlPart.SelectedValue);
d.Unit = ddlUnit.SelectedValue;
d.SealNumber = txtSealNo.Text.Trim();
d.Package = Convert.ToInt32(txtPackage.Text);
d.GrossWeight = Convert.ToDecimal(txtGrossWeight.Text);
d.ShippingBillNumber = txtShippingBillNumber.Text.Trim();
if (txtShippingBillDate.Text != string.Empty)
{
d.ShippingBillDate = Convert.ToDateTime(txtShippingBillDate.Text.Trim());
}
else
{
d.ShippingBillDate = null;
}
return(d);
}).ToList();
}
if (!Convert.ToBoolean(ViewState["ISEDIT"]))
{
ExportBLBLL.InsertBLContainers(lstData);
}
else
{
ExportBLBLL.UpdateBLContainers(lstData);
}
ViewState["DataSource"] = lstData;
}
private void LoadShipmentModeDDL()
{
DataTable dt = ExportBLBLL.GetShipmentModes();
if (dt != null && dt.Rows.Count > 0)
{
DataRow dr = dt.NewRow();
dr["ModeId"] = "0";
dr["ModeName"] = "--Select--";
dt.Rows.InsertAt(dr, 0);
ddlShipmentMode.DataValueField = "ModeId";
ddlShipmentMode.DataTextField = "ModeName";
ddlShipmentMode.DataSource = dt;
ddlShipmentMode.DataBind();
}
}
private void LoadDeliveryAgentDDL(int FPOD)
{
DataTable dt = ExportBLBLL.GetDeliveryAgents(FPOD);
if (dt != null && dt.Rows.Count > 0)
{
DataRow dr = dt.NewRow();
dr["AgentId"] = "0";
dr["AgentName"] = "--Select--";
dt.Rows.InsertAt(dr, 0);
ddlAgent.DataValueField = "AgentId";
ddlAgent.DataTextField = "AgentName";
ddlAgent.DataSource = dt;
ddlAgent.DataBind();
}
}
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);
}
private void LoadExportBLHeaderForEdit(string BLNumber)
{
try
{
IExportBL exportBL = ExportBLBLL.GetExportBLHeaderInfoForEdit(BLNumber);
LoadDeliveryAgentDDL(exportBL.fk_FPOD);
if (!ReferenceEquals(exportBL, null))
{
txtBookingNo.Text = exportBL.BookingNumber;
ViewState["BOOKINGID"] = exportBL.BookingId;
txtBookingDate.Text = exportBL.BookingDate.ToString("dd-MM-yyyy");
txtBLDate.Enabled = false;
txtBLNo.Text = exportBL.BLNumber;
ViewState["BLID"] = exportBL.BLId;
txtBLDate.Text = exportBL.BLDate.ToString("dd-MM-yyyy");
txtBookingParty.Text = exportBL.BookingParty;
txtRefBookingNo.Text = exportBL.RefBookingNumber;
txtLocation.Text = exportBL.Location;
ViewState["LOCATIONID"] = exportBL.LocationId;
txtLine.Text = exportBL.Nvocc;
ViewState["NVOCCID"] = exportBL.NvoccId;
txtVessel.Text = exportBL.Vessel;
ViewState["VESSELID"] = exportBL.VesselId;
txtVoyage.Text = exportBL.Voyage;
ViewState["VOYAGEID"] = exportBL.VoyageId;
txtPOR.Text = exportBL.POR;
txtPorDesc.Text = exportBL.PORDesc;
txtPOL.Text = exportBL.POL;
txtPolDesc.Text = exportBL.POLDesc;
txtPOD.Text = exportBL.POD;
txtPodDesc.Text = exportBL.PODDesc;
txtFPOD.Text = exportBL.FPOD;
txtFPodDesc.Text = exportBL.FPODDesc;
txtCommodity.Text = exportBL.Commodity;
txtContainers.Text = exportBL.Containers;
rdoOriginal.SelectedValue = exportBL.NoOfBL.ToString();
hdnShipmentType.Value = exportBL.ShipmentType.ToString();
ddlBLClause.SelectedValue = exportBL.BLClause;
if (exportBL.BLthruEdge == true)
{
hdnBLThruEdge.Value = "1";
}
else
{
hdnBLThruEdge.Value = "0";
}
if (exportBL.ShipmentType != 0)
{
txtNetWt.Enabled = true;
txtNetWt.Text = exportBL.GrossWeight.ToString();
}
if (ddlBLClause.SelectedValue == "R")
{
if (!ReferenceEquals(Session[Constants.SESSION_USER_INFO], null))
{
IUser user = (IUser)Session[Constants.SESSION_USER_INFO];
if (user.UserRole.Id == (int)UserRole.Admin)
{
btnClose.Visible = true;
if (exportBL.CloseBL == true)
{
btnClose.Text = "Open";
}
else
{
btnClose.Text = "Close";
}
}
else
{
btnClose.Visible = false;
}
}
txtBLReleaseDate.Enabled = true;
}
else
{
txtBLReleaseDate.Enabled = false;
btnClose.Visible = false;
}
rdoBLType.SelectedValue = exportBL.BLType;
ddlShipmentMode.SelectedValue = exportBL.ShipmentMode.ToString();
((TextBox)txtIssuePlace.FindControl("txtPort")).Text = exportBL.BLIssuePlace;
ViewState["BLISSUEID"] = exportBL.BLIssuePlaceId;
TxtNtWt.Text = exportBL.NetWeight.ToString();
txtBLReleaseDate.Text = exportBL.BLReleaseDate.ToString();
if (hdnBLThruEdge.Value == "" || hdnBLThruEdge.Value == "0")
{
txtBLNo.Enabled = true;
rfvShipperName.Enabled = false;
rfvConsigneeName.Enabled = false;
rfvGoodsDescription.Enabled = false;
rfvMarks.Enabled = false;
rfvNotify.Enabled = false;
rfvAgent.Enabled = false;
}
else
{
txtBLNo.Enabled = false;
rfvShipperName.Enabled = true;
rfvConsigneeName.Enabled = true;
rfvGoodsDescription.Enabled = true;
rfvMarks.Enabled = true;
rfvNotify.Enabled = true;
rfvAgent.Enabled = true;
}
txtShipperName.Text = exportBL.ShipperName;
txtShipper.Text = exportBL.Shipper;
txtConsignee.Text = exportBL.Consignee;
txtConsigneeName.Text = exportBL.ConsigneeName;
txtNotify.Text = exportBL.NotifyParty;
txtNotifyName.Text = exportBL.NotifyPartyName;
txtGoodsDescription.Text = exportBL.GoodDesc;
txtMarks.Text = exportBL.MarksNumnbers;
ddlAgent.SelectedValue = exportBL.AgentId.ToString();
txtCBookingNo.Text = exportBL.BookingNumber;
txtCBookingDate.Text = exportBL.BookingDate.ToString("dd-MM-yyyy");
txtCBLNo.Text = exportBL.BLNumber;
txtCBLDate.Text = exportBL.BLDate.ToString("dd-MM-yyyy");
txtTon.Text = exportBL.TotalTon;
txtCbm.Text = exportBL.TotalCBM;
if (exportBL.TotalTEU != null)
{
txtTeu.Text = exportBL.TotalTEU.ToString();
}
else
{
txtTeu.Text = "0";
}
if (exportBL.TotalFEU != null)
{
txtFeu.Text = exportBL.TotalFEU.ToString();
}
else
{
txtFeu.Text = "0";
}
if (exportBL.CloseVoyage == true)
{
btnSave.Visible = false;
}
if (exportBL.CloseBL == true)
{
btnSave.Visible = false;
}
LoadExportBLContainers(0, exportBL.BLId, 0);
}
}
catch (Exception ex)
{
throw ex;
}
}
private void LoadExportBLHeaderForAdd(string BookingNumber, int Status)
{
try
{
IExportBL exportBL = ExportBLBLL.GetExportBLHeaderInfoForAdd(BookingNumber);
if (!ReferenceEquals(exportBL, null))
{
if (exportBL.BookingId != 0)
{
ViewState["BOOKINGID"] = exportBL.BookingId;
txtBookingDate.Text = exportBL.BookingDate.ToString("dd-MM-yyyy");
txtBLDate.Text = exportBL.BLDate.ToString("dd-MM-yyyy");
//txtBLDate.Text = DateTime.Now.ToString("dd-MM-yyyy");
txtBLDate.Enabled = false;
txtBookingParty.Text = exportBL.BookingParty;
txtRefBookingNo.Text = exportBL.RefBookingNumber;
txtLocation.Text = exportBL.Location;
ViewState["LOCATIONID"] = exportBL.LocationId;
txtLine.Text = exportBL.Nvocc;
ViewState["NVOCCID"] = exportBL.NvoccId;
txtVessel.Text = exportBL.Vessel;
ViewState["VESSELID"] = exportBL.VesselId;
txtVoyage.Text = exportBL.Voyage;
ViewState["VOYAGEID"] = exportBL.VoyageId;
txtPOR.Text = exportBL.POR;
txtPorDesc.Text = exportBL.PORDesc;
txtPOL.Text = exportBL.POL;
txtPolDesc.Text = exportBL.POLDesc;
txtPOD.Text = exportBL.POD;
txtPodDesc.Text = exportBL.PODDesc;
txtFPOD.Text = exportBL.FPOD;
txtFPodDesc.Text = exportBL.FPODDesc;
txtCommodity.Text = exportBL.Commodity;
hdnShipmentType.Value = exportBL.ShipmentType.ToString();
LoadDeliveryAgentDDL(exportBL.fk_FPOD);
txtBLReleaseDate.Enabled = false;
if (exportBL.BLthruEdge == false)
{
hdnBLThruEdge.Value = "0";
txtBLNo.Enabled = true;
//rfvShipper.Enabled = false;
rfvShipperName.Enabled = false;
//rfvConsignee.Enabled = false;
rfvConsigneeName.Enabled = false;
rfvGoodsDescription.Enabled = false;
rfvMarks.Enabled = false;
rfvNotify.Enabled = false;
//rfvNotifyName.Enabled = false;
rfvAgent.Enabled = false;
}
else
{
txtBLNo.Enabled = false;
hdnBLThruEdge.Value = "1";
//rfvShipper.Enabled = true;
rfvShipperName.Enabled = true;
//rfvConsignee.Enabled = true;
rfvConsigneeName.Enabled = true;
rfvGoodsDescription.Enabled = true;
rfvMarks.Enabled = true;
rfvNotify.Enabled = true;
//rfvNotifyName.Enabled = true;
rfvAgent.Enabled = true;
}
txtCBookingNo.Text = exportBL.BookingNumber;
txtCBookingDate.Text = exportBL.BookingDate.ToString("dd-MM-yyyy");
txtCBLDate.Text = txtBLDate.Text;
if (exportBL.ShipmentType != 0)
{
txtNetWt.Enabled = true;
txtNetWt.Text = exportBL.GrossWeight.ToString();
}
if (exportBL.TotalTon != null)
{
txtTon.Text = exportBL.TotalTon;
}
else
{
txtTon.Text = "0";
}
if (exportBL.TotalCBM != null)
{
txtCbm.Text = exportBL.TotalCBM;
}
else
{
txtCbm.Text = "0";
}
if (exportBL.TotalTEU != null)
{
txtTeu.Text = exportBL.TotalTEU.ToString();
}
else
{
txtTeu.Text = "0";
}
if (exportBL.TotalFEU != null)
{
txtFeu.Text = exportBL.TotalFEU.ToString();
}
else
{
txtFeu.Text = "0";
}
LoadExportBLContainers(exportBL.BookingId, 0, Status);
}
else
{
rfvBookingNo.Visible = true;
}
}
}
catch (Exception ex)
{
throw ex;
}
}
private void LoadExportBLContainers(long BookingId, long BLId, int Status)
{
try
{
bool isEdit = Convert.ToBoolean(ViewState["ISEDIT"]);
List <IExportBLContainer> objData = new List <IExportBLContainer>();
if (!ReferenceEquals(ViewState["DataSource"], null) && ((List <IExportBLContainer>)(ViewState["DataSource"])).Count > 0)
{
objData = ViewState["DataSource"] as List <IExportBLContainer>;
}
else
{
if (!isEdit)
{
objData = ExportBLBLL.GetExportBLContainersForAdd(BookingId, Status);
if (ExportBLBLL.CheckBookingBLContainer(BookingId, Status) == false && objData.Count() > 0)
{
btnSave.Visible = false;
}
else
if (_canEdit == true)
{
btnSave.Visible = true;
}
else
{
btnSave.Visible = false;
}
}
else
{
objData = ExportBLBLL.GetExportBLContainersForEdit(BLId);
}
}
//objData = objData.Where(d => d.IsDeleted == false).ToList();
ViewState["DataSource"] = objData;
gvwContainers.DataSource = objData;
gvwContainers.DataBind();
List <Unit> lstUnit = new List <Unit>();
DataTable dtUnits = ExportBLBLL.GetUnitsForExportBlContainer();
foreach (DataRow dr in dtUnits.Rows)
{
lstUnit.Add(new Unit {
Value = dr[0].ToString(), Text = dr[1].ToString()
});
}
if (hdnShipmentType.Value.ToString() == "0")
{
txtNetWt.Text = objData.Where(o => o.IsDeleted == false).Sum(o => o.GrossWeight).ToString(); // + " " + lstUnit.Where(u => u.Value == objData[0].Unit).ToList()[0].Text;
}
txtContainers.Text = objData.Where(o => o.IsDeleted == false).Where(o => o.ContainerSize == "20").Count().ToString() + " x 20 - " + objData.Where(o => o.IsDeleted == false).Where(o => o.ContainerSize == "40").Count().ToString() + " x 40";
}
catch (Exception ex)
{
throw ex;
}
}
protected void gvwContainers_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
//Part
List <Part> lstPart = new List <Part>();
lstPart.Add(new Part {
Text = "Yes", Value = "True"
});
lstPart.Add(new Part {
Text = "No", Value = "False"
});
// Bind drop down to Part
DropDownList ddlPart = (DropDownList)e.Row.FindControl("ddlPart");
ddlPart.DataTextField = "Text";
ddlPart.DataValueField = "Value";
ddlPart.DataSource = lstPart;
ddlPart.DataBind();
IExportBLContainer cntr = e.Row.DataItem as IExportBLContainer;
ddlPart.SelectedValue = cntr.Part.ToString();
if (cntr.Part)
{
ddlPart.Enabled = false;
}
else
{
ddlPart.Enabled = true;
}
//Unit
List <Unit> lstUnit = new List <Unit>();
DataTable dtUnits = ExportBLBLL.GetUnitsForExportBlContainer();
foreach (DataRow dr in dtUnits.Rows)
{
lstUnit.Add(new Unit {
Value = dr[0].ToString(), Text = dr[1].ToString()
});
}
DropDownList ddlUnit = (DropDownList)e.Row.FindControl("ddlUnit");
ddlUnit.DataTextField = "Text";
ddlUnit.DataValueField = "Value";
ddlUnit.DataSource = lstUnit;
ddlUnit.DataBind();
if (cntr.Unit.ToString() != null)
{
ddlUnit.SelectedValue = cntr.Unit.ToString();
}
ImageButton btnRemove = (ImageButton)e.Row.FindControl("btnRemove");
if ((e.Row.DataItem as IExportBLContainer).IsDeleted)
{
btnRemove.ImageUrl = "~/Images/undelete.png";
btnRemove.Attributes.Add("onclick", "javascript:return confirm('Are you sure about undelete?');");
btnRemove.CommandName = "UnDelete";
btnRemove.ToolTip = "Undelete";
}
else
{
btnRemove.ImageUrl = "~/Images/remove.png";
btnRemove.Attributes.Add("onclick", "javascript:return confirm('Are you sure about delete?');");
btnRemove.CommandName = "Delete";
btnRemove.ToolTip = "Delete";
}
}
}
