public List <VehiclesClass> SelectAll()
{
List <VehiclesClass> ClassList = null;
try
{
string sSQL = "SELECT * FROM VehiclesClass";
DataSet ds = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, sSQL);
if (ds.Tables[0].Rows.Count > 0)
{
ClassList = new List <VehiclesClass>();
VehiclesClass Class = null;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Class = new VehiclesClass();
Class.Code = Convert.ToInt32(ds.Tables[0].Rows[i]["Code"]);
Class.Name = Convert.ToString(ds.Tables[0].Rows[i]["Name"]);
ClassList.Add(Class);
}
}
}
catch (Exception ex) { }
return(ClassList);
}
public VehiclesClass SelectByCode(int Code)
{
VehiclesClass Class = null;
try
{
string sSQL = "SELECT * FROM VehiclesClass 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)
{
Class = new VehiclesClass();
Class.Code = Convert.ToInt32(ds.Tables[0].Rows[0]["Code"]);
Class.Name = Convert.ToString(ds.Tables[0].Rows[0]["Name"]);
}
}
catch (Exception ex) { }
return(Class);
}