public static List<TelTypes> TelTypes_GetAll()
{
string query = "TelTypes_GetAll";
DataTable dt = Connection.runQuery(query, new SqlParameter[0]);
List<TelTypes> res = new List<TelTypes>();
for (int i = 0; i < dt.Rows.Count; i++ )
{
TelTypes tmp = new TelTypes();
tmp.ID = Convert.ToInt32(dt.Rows[i]["ID"].ToString());
tmp.TelTypeName = dt.Rows[i]["TelTypeName"].ToString();
res.Add(tmp);
}
return res;
}
public static TelTypes TelTypes_GetByID(int id)
{
string query = "TelTypes_GetByID";
List<SqlParameter> prms = new List<SqlParameter>();
prms.Add(new SqlParameter("@ID", id));
DataTable dt = Connection.runQuery(query,prms.ToArray());
TelTypes res = new TelTypes();
for (int i = 0; i < dt.Rows.Count; i++)
{
TelTypes tmp = new TelTypes();
tmp.ID = Convert.ToInt32(dt.Rows[i]["ID"].ToString());
tmp.TelTypeName = dt.Rows[i]["TelTypeName"].ToString();
res=tmp;
}
return res;
}