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; } }