public string getTruckHandlingTypes()
{
JavaScriptSerializer j = new JavaScriptSerializer();
TruckHandlingTypes tht = new TruckHandlingTypes();
List <TruckHandlingTypes> truckHandlingTypesList = tht.getTruckHandlingTypesList();
return(j.Serialize(truckHandlingTypesList));
}
//without active
public TruckHandlings(int truckHandlingID, string truckHandlingDescription, string handlingProvider, string url, float cost, DateTime date, TruckHandlingTypes truckHandlingType, Trucks truck)
{
TruckHandlingID = truckHandlingID;
TruckHandlingDescription = truckHandlingDescription;
HandlingProvider = handlingProvider;
Url = url;
Cost = cost;
Date = date;
TruckHandlingType = truckHandlingType;
Truck = truck;
}
//without active
public TruckHandlings(int truckHandlingID, string truckHandlingDescription, string handlingProvider, float cost, DateTime date, TruckHandlingTypes truckHandlingType, Trucks truck, int imgID)
{
TruckHandlingID = truckHandlingID;
TruckHandlingDescription = truckHandlingDescription;
HandlingProvider = handlingProvider;
Active = active;
Cost = cost;
Date = date;
TruckHandlingType = truckHandlingType;
Truck = truck;
ImgID = imgID;
}
public List <TruckHandlingTypes> getTruckHandlingTypesList()
{
#region DB functions
string query = "select * from TruckHandlingTypes order by TruckHandlingType";
List <TruckHandlingTypes> list = new List <TruckHandlingTypes>();
DbService db = new DbService();
DataSet ds = db.GetDataSetByQuery(query);
foreach (DataRow dr in ds.Tables[0].Rows)
{
TruckHandlingTypes tmp = new TruckHandlingTypes((int)dr["TruckHandlingTypeID"], dr["TruckHandlingType"].ToString());
list.Add(tmp);
}
#endregion
return(list);
}
