public List <Budget_Categories_Banner> SelectAll()
{
List <Budget_Categories_Banner> Categories_BannerList = null;
try
{
string sSQL = "SELECT * FROM Categories_Banner";
DataSet ds = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, sSQL);
if (ds.Tables[0].Rows.Count > 0)
{
Categories_BannerList = new List <Budget_Categories_Banner>();
Budget_Categories_Banner categories = null;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
categories = new Budget_Categories_Banner();
categories.CategoriesCode = ds.Tables[0].Rows[i]["CategoriesCode"].ToString();
categories.CategoriesName = ds.Tables[0].Rows[i]["CategoriesName"].ToString();
Categories_BannerList.Add(categories);
}
}
}
catch (Exception ex) { }
return(Categories_BannerList);
}
public Budget_Categories_Banner SelectByCode(string CategoriesCode)
{
Budget_Categories_Banner categories = null;
try
{
string sSQL = "SELECT * FROM Categories_Banner WHERE CategoriesCode=@CategoriesCode";
SqlParameter[] sqlParam = new SqlParameter[1];
sqlParam[0] = new SqlParameter("@CategoriesCode", SqlDbType.NVarChar);
sqlParam[0].Value = CategoriesCode;
DataSet ds = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, sSQL, sqlParam);
if (ds.Tables[0].Rows.Count > 0)
{
categories = new Budget_Categories_Banner();
categories.CategoriesCode = Convert.ToString(ds.Tables[0].Rows[0]["CategoriesCode"]);
categories.CategoriesName = Convert.ToString(ds.Tables[0].Rows[0]["CategoriesName"]);
}
}
catch (Exception ex) { }
return(categories);
}