public int Add(Ethnicity ethnicity)
{
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO ETHNICITY (Ethnicity) VALUES ('");
sb.Append(ethnicity.EthnicityName + "')");
string sql = sb.ToString();
DBCommand db = new DBCommand();
return(db.ExecuteCommand(sql));
}
public List <Ethnicity> GetList()
{
List <Ethnicity> list = new List <Ethnicity>();
DBCommand db = new DBCommand(DBCommand.TransactionType.WithoutTransaction);
DataTable dt = db.GetDataTable("SELECT * FROM vw_Ethnicity");
foreach (DataRow dr in dt.Rows)
{
Ethnicity eth = new Ethnicity
{
EthnicityId = (int)dr["EthnicityId"],
EthnicityName = dr["Ethnicity"].ToString()
};
list.Add(eth);
}
return(list);
}
