protected void grdCountries_OnRowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
if (e.CommandName == "EditRow")
{
var row = ((Control)e.CommandSource).NamingContainer as GridViewRow;
if (row != null)
{
txtCountryName.Text = ((Label)(row.FindControl("lblCountryName"))).Text;
_countryId = Convert.ToInt32(((Label)(row.FindControl("lblCountryId"))).Text);
}
}
else if (e.CommandName == "Del")
{
var row = ((Control)e.CommandSource).NamingContainer as GridViewRow;
if (row != null)
{
var oCountry = new TMSLibrary.Country();
var countryId = Convert.ToInt32(((Label)(row.FindControl("lblCountryId"))).Text);
MasterDataMethods.DeleteCountry(countryId);
FillGrid();
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
}
protected void btnAdd_OnClick(object sender, EventArgs e)
{
if (txtCountryName.Text.Trim() != "")
{
int res = 0;
var oCountry = new TMSLibrary.Country()
{
CountryId = _countryId,
CountryName = txtCountryName.Text
};
if (_countryId == 0)
{
res = TMSLibrary.MasterDataMethods.AddCountry(oCountry.CountryName);
}
else if (_countryId > 0)
{
res = TMSLibrary.MasterDataMethods.UpdateCountry(oCountry);
}
if (res > 0)
{
ValidatePopup("Operation Successfull.");
}
else if (res <= 0)
{
ValidatePopup("Please Try Again");
}
_countryId = 0;
FillGrid();
}
else
{
ValidatePopup("Country name cannot be empty.");
}
}
/// <summary>
/// Updates a country.
/// </summary>
/// <param name="oCountry"></param>
/// <returns></returns>
public static int UpdateCountry(Country oCountry)
{
return TMSDataLibrary.MasterData.UpdateCountry(oCountry.CountryId, oCountry.CountryName);
}
/// <summary>
/// Get Country List
/// </summary>
/// <returns></returns>
public static List<Country> GetAllCountries()
{
List<Country> countrylist = new List<Country>();
DataTable dt = TMSDataLibrary.MasterData.GetCountry();
if (dt.Rows.Count > 0)
{
int count = dt.Rows.Count;
Country _country = new Country();
for (int i = 0; i < count; i++)
{
_country = new Country();
_country.CountryId = Convert.ToInt32(dt.Rows[i][CONSTS.CountryColumnIndex.CountryId]);
_country.CountryName = (dt.Rows[i][CONSTS.CountryColumnIndex.CountryName]).ToString();
countrylist.Add(_country);
}
}
return countrylist;
}
