public List <Nationality> SelectNationalities()
{
try
{
DataTable dt = dlObj.SelectNationalities();
if (dt != null)
{
List <Nationality> lst = new List <Nationality>();
foreach (DataRow dr in dt.Rows)
{
lst.Add(new Nationality(dr["CountryName"].ToString(), dr["CountryCode"].ToString()));
}
return(lst);
}
else
{
return(null);
}
}
catch// (Exception ex)
{
throw;
}
finally
{
dlObj = null;
}
}
public int DeleteNationality(string CountryName)
{
try
{
return(dlObj.DeleteNationality(CountryName));
}
catch //(Exception ex)
{
throw;
}
finally
{
dlObj = null;
}
}
public int UpdateNationality(string OldCountryName, Nationality Nat)
{
try
{
return(dlObj.UpdateNationality(OldCountryName, Nat));
}
catch// (Exception ex)
{
throw;
}
finally
{
dlObj = null;
}
}
public int InsertNationality(Nationality Nat)
{
try
{
return(dlObj.InsertNationality(Nat));
//return dlObj.AddNationality(Nat.CountryName, Nat.CountryCode);
}
catch //(Exception ex)
{
throw;
}
finally
{
dlObj = null;
}
}
public Nationality SelectNationality(string CountryName)
{
try
{
DataRow dr = dlObj.SelectNationality(CountryName);
if (dr != null)
{
return(new Nationality(dr["CountryName"].ToString(), dr["CountryCode"].ToString()));
}
else
{
return(null);
}
}
catch //(Exception ex)
{
throw;
}
finally
{
dlObj = null;
}
}
