public string getTruck(int truckID)
{
JavaScriptSerializer j = new JavaScriptSerializer();
Trucks t = new Trucks();
t.TruckID = truckID;
Trucks truck = t.getTruck();
return(j.Serialize(truck));
}
public List <Orders> getDriverOrdersList(int driverID, int func)
{
#region DB functions
string query = "select *"
+ " from Orders o"
+ " inner join OrderStatus os on o.OrderStatusID=os.StatusID"
+ " where 1=1"
+ " and o.InShift='Y'"
+ " and o.DriverID=" + driverID;
#region selecting Period
if (func == 1)
{
query += " and o.OrderDate = convert(date, GETDATE())";
}
if (func == 2)
{
query += " and o.OrderDate = convert(date,DATEADD(day, 1, GETDATE()))";
}
if (func == 3)
{
query += " and o.OrderDate >= convert(date, DATEADD(day, -7, GETDATE())) and o.OrderDate <= convert(date, GETDATE()) ";
}
if (func == 4)
{
query += " and o.OrderDate >= convert(date, DATEADD(day, -30, GETDATE())) and o.OrderDate <= convert(date, GETDATE()) ";
}
#endregion
query += " order by o.OrderDate desc, o.ShiftSort asc";
List <Orders> list = new List <Orders>();
DbService db = new DbService();
DataSet ds = db.GetDataSetByQuery(query);
foreach (DataRow dr in ds.Tables[0].Rows)
{
Orders tmp = new Orders();
tmp.OrderID = (int)dr["OrderID"];
tmp.OrderName = dr["OrderName"].ToString();
tmp.OrderDate = (DateTime)dr["OrderDate"];
tmp.OrderStatus = new OrderStatus((int)dr["OrderStatusID"], dr["Status"].ToString());
tmp.Comments = dr["Comments"].ToString();
tmp.TotalPrice = Convert.ToSingle(dr["TotalPrice"]);
tmp.AddTime = Convert.ToSingle(dr["AddTime"]);
tmp.Container = dr["Container"].ToString();
tmp.InShift = dr["InShift"].ToString();
tmp.DeliveryDuration = Convert.ToSingle(dr["DeliveryDuration"]);
if (tmp.InShift == "Y")
{
tmp.ShiftSort = (int)dr["ShiftSort"];
Drivers d = new Drivers();
d.DriverID = (int)dr["DriverID"];
tmp.Driver = d.getDriver();
Trucks t = new Trucks();
t.TruckID = (int)dr["TruckID"];
tmp.Truck = t.getTruck();
}
Customers c = new Customers();
c.CustomerID = (int)dr["CustomerID"];
tmp.Customer = c.getCustomer();
Services s = new Services();
s.ServiceID = (int)dr["ServiceID"];
tmp.OrderService = s.getService();
Addresses sf = new Addresses();
sf.AddressID = (int)dr["ShipFromID"];
tmp.ShipFrom = sf.getAddress();
Addresses st = new Addresses();
st.AddressID = (int)dr["ShipToID"];
tmp.ShipTo = st.getAddress();
DriverLicenseTypes dlt = new DriverLicenseTypes();
dlt.DriverLicenseTypeID = (int)dr["DriverLicenseTypeID"];
tmp.OrderLicenseType = dlt.getDriverLicenseType();
DriverLicenseTypes dct = new DriverLicenseTypes();
dct.DriverLicenseTypeID = (int)dr["DriverCertificationTypeID"];
tmp.OrderCertificationType = dct.getDriverLicenseType();
list.Add(tmp);
}
#endregion
return(list);
}
