public int InsertCountry(Country c) { DBAccess db = new DBAccess(); SqlParameter p = new SqlParameter("@iCountryID", 0); p.Direction = ParameterDirection.Output; db.AddParameter("@sCountryName", c.CountryName); db.AddParameter(p); return db.ExecuteNonQuery("JobsDb_Countries_Insert"); }
public int UpdateCountry(Country c) { DBAccess db = new DBAccess(); db.AddParameter("@iCountryID", c.CountryID); db.AddParameter("@sCountryName", c.CountryName); return db.ExecuteNonQuery("JobsDb_Countries_Update"); }