private void LoadData(string SortExp, string direction)
{
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;
}
BLL.DBInteraction dbinteract = new BLL.DBInteraction();
//int countryId = string.IsNullOrEmpty(txtCountryAbbr.Text) ? -1 :Convert.ToInt32(txtCountryAbbr.Text);
string countryName = string.IsNullOrEmpty(txtLocationName.Text) ? "" : txtLocationName.Text;
string countryAbbr = string.IsNullOrEmpty(txtCountryAbbr.Text) ? "" : txtCountryAbbr.Text;
try
{
System.Data.DataSet ds = dbinteract.GetCountry(-1, countryName, countryAbbr);
System.Data.DataView dv = new System.Data.DataView(ds.Tables[0]);
if (!string.IsNullOrEmpty(SortExp) && !string.IsNullOrEmpty(direction))
{
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 countryID)
{
ClearText();
int intCountryId = 0;
if (countryID == "" || !Int32.TryParse(countryID, out intCountryId))
{
return;
}
BLL.DBInteraction dbinteract = new BLL.DBInteraction();
System.Data.DataSet ds = dbinteract.GetCountry(Convert.ToInt32(countryID), "", "");//country
if (!ReferenceEquals(ds, null) && ds.Tables[0].Rows.Count > 0)
{
txtCountryName.Text = ds.Tables[0].Rows[0]["CountryName"].ToString();
txtAbbr.Text = ds.Tables[0].Rows[0]["CountryAbbr"].ToString();
txtGMT.Text = ds.Tables[0].Rows[0]["GMT"].ToString();
txtISD.Text = ds.Tables[0].Rows[0]["ISDCode"].ToString();
txtSector.Text = ds.Tables[0].Rows[0]["Sector"].ToString();
}
}