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