private void LoadData(string VoyageId)
{
int intVoyageId = 0;
if (VoyageId == "" || !Int32.TryParse(VoyageId, out intVoyageId))
{
return;
}
BLL.DBInteraction dbinteract = new BLL.DBInteraction();
System.Data.DataSet ds = dbinteract.GetVoyage(Convert.ToInt32(VoyageId), "a", "", "", "", 0);
if (!ReferenceEquals(ds, null) && ds.Tables[0].Rows.Count > 0)
{
ddlLoc.SelectedValue = ds.Tables[0].Rows[0]["pk_LocID"].ToString();
GeneralFunctions.PopulateDropDownList(ddlTerminalID, dbinteract.PopulateDDLDS("mstTerminal", "pk_TerminalID", "TerminalName] + '-' + [terminal", "Where fk_LocationID=" + ddlLoc.SelectedValue));
ddlTerminalID.SelectedValue = ds.Tables[0].Rows[0]["fl_TerminalID"].ToString();
txtAltLGNo.Text = ds.Tables[0].Rows[0]["AltLGNo"].ToString();
txtCargoDesc.Text = ds.Tables[0].Rows[0]["CargoDesc"].ToString();
txtExcRate.Text = ds.Tables[0].Rows[0]["ImpXChangeRate"].ToString();
txtIGMNo.Text = ds.Tables[0].Rows[0]["IGMNo"].ToString();
//txtCallSign.Text = ds.Tables[0].Rows[0]["CallSign"].ToString();
txtLGNo.Text = ds.Tables[0].Rows[0]["LGNo"].ToString();
txtLightHouse.Text = ds.Tables[0].Rows[0]["LightHouseDue"].ToString();
txtMotherDaughter.Text = ds.Tables[0].Rows[0]["MotherDaughterDtl"].ToString();
txtPCCNo.Text = ds.Tables[0].Rows[0]["PCCNo"].ToString();
txtTime.Text = ds.Tables[0].Rows[0]["ETATime"].ToString();
txtTotLine.Text = ds.Tables[0].Rows[0]["TotalLines"].ToString();
txtVCN.Text = ds.Tables[0].Rows[0]["VCN"].ToString();
ddlVessel.SelectedValue = ds.Tables[0].Rows[0]["fk_VesselID"].ToString();
txtVIA.Text = ds.Tables[0].Rows[0]["VIANo"].ToString();
txtVoyageNo.Text = ds.Tables[0].Rows[0]["VoyageNo"].ToString();
ddlCrewEffList.SelectedValue = ds.Tables[0].Rows[0]["CrewEffectList"].ToString();
ddlCrewList.SelectedValue = ds.Tables[0].Rows[0]["CrewList"].ToString();
ddlMaritime.SelectedValue = ds.Tables[0].Rows[0]["MaritimeList"].ToString();
ddlPessengerList.SelectedValue = ds.Tables[0].Rows[0]["PassengerList"].ToString();
ddlSameButton.SelectedValue = ds.Tables[0].Rows[0]["SameButtonCargo"].ToString();
ddlShipStoreSubmitted.SelectedValue = ds.Tables[0].Rows[0]["ShipStoreSubmitted"].ToString();
ddlTerminalID.SelectedValue = ds.Tables[0].Rows[0]["fl_TerminalID"].ToString();
txtdtETA.Text = ds.Tables[0].Rows[0]["ETADate"].ToString().Split(' ')[0];
txtdtLand.Text = ds.Tables[0].Rows[0]["AddLandingDate"].ToString().Split(' ')[0];
txtDtIGM.Text = ds.Tables[0].Rows[0]["IGMDate"].ToString().Split(' ')[0];
txtdtLand.Text = ds.Tables[0].Rows[0]["LandingDate"].ToString().Split(' ')[0];
hdnLandingDT.Value = ds.Tables[0].Rows[0]["LandingDate"].ToString().Split(' ')[0]; //Rajen
hdnOldLandingDT.Value = ds.Tables[0].Rows[0]["LandingDate"].ToString().Split(' ')[0];
txtdtPCC.Text = ds.Tables[0].Rows[0]["PCCDate"].ToString().Split(' ')[0];
//txtdtAddLand.Text = ds.Tables[0].Rows[0]["__"].ToString();
((TextBox)AutoCompletepPort1.FindControl("txtPort")).Text = ds.Tables[0].Rows[0]["lastport"].ToString();
((TextBox)AutoCompletepPort2.FindControl("txtPort")).Text = ds.Tables[0].Rows[0]["lastport1"].ToString();
((TextBox)AutoCompletepPort3.FindControl("txtPort")).Text = ds.Tables[0].Rows[0]["lastport2"].ToString();
((TextBox)AutoCompletepPort4.FindControl("txtPort")).Text = ds.Tables[0].Rows[0]["portDischarge"].ToString();
}
}
private void LoadData(string SortExp, string direction)
{
BLL.DBInteraction dbinteract = new BLL.DBInteraction();
string voyageType = ddlVoyageType.SelectedValue;
string VesselName = string.IsNullOrEmpty(txtVesselName.Text) ? "" : txtVesselName.Text.Trim();
string voyageNo = string.IsNullOrEmpty(txtVoyageNo.Text) ? "" : txtVoyageNo.Text.Trim();
string igmNo = string.IsNullOrEmpty(txtIGMNo.Text) ? "" : txtIGMNo.Text.Trim();
lblErrorMsg.Text = "";
if (!ReferenceEquals(Session[Constants.SESSION_SEARCH_CRITERIA], null))
{
SearchCriteria searchCriteria = (SearchCriteria)Session[Constants.SESSION_SEARCH_CRITERIA];
if (!ReferenceEquals(searchCriteria, null))
{
BuildSearchCriteria(searchCriteria);
gvwLoc.PageIndex = searchCriteria.PageIndex;
if (searchCriteria.PageSize > 0)
{
gvwLoc.PageSize = searchCriteria.PageSize;
}
try
{
System.Data.DataSet ds = dbinteract.GetVoyage(-1, voyageType, VesselName, voyageNo, igmNo, _userLocation);
System.Data.DataView dv = new System.Data.DataView(ds.Tables[0]);
if (!string.IsNullOrEmpty(SortExp) && !string.IsNullOrEmpty(direction) && SortExp != "Location")
{
dv.Sort = SortExp + " " + direction;
}
gvwLoc.DataSource = dv;
}
catch (Exception ex)
{
gvwLoc.DataSource = null;
lblErrorMsg.Text = "Error Occured.Please try again.";
}
gvwLoc.DataBind();
}
}
}