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.GetMLVoyage(-1, voyageType, VesselName, voyageNo);
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();
}
}
}
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.GetMLVoyage(Convert.ToInt32(VoyageId), "a", "", "");
if (!ReferenceEquals(ds, null) && ds.Tables[0].Rows.Count > 0)
{
ddlVessel.SelectedValue = ds.Tables[0].Rows[0]["fk_VesselID"].ToString();
txtVoyageNo.Text = ds.Tables[0].Rows[0]["MLVoyageNo"].ToString();
//txtdtActivity.Text = ds.Tables[0].Rows[0]["ActivityDate"].ToString();
//((TextBox)AutoCompletepPort4.FindControl("txtPort")).Text = ds.Tables[0].Rows[0]["lastport"].ToString();
}
}