public static void InsertOrder(string custCVR, double price, int sessionId, int cargoId, string status)
{
using (var db = new SpeedSharkModelDataContext())
{
var order = new Order();
int maxOrderId = 0;
var query = db.Orders.OrderByDescending(ord => ord.orderId).SingleOrDefault().orderId;
if (query != 0 && query != null)
{
maxOrderId = query;
}
string orderNo = DateTime.Now.ToString("YYYY-MM-DD") + "/" + Convert.ToString(maxOrderId + 1);
order.orderNo = orderNo;
order.custCVR = custCVR;
order.price = price;
order.sessionId = sessionId;
order.cargoId = cargoId;
order.status = status;
db.Orders.InsertOnSubmit(order);
db.SubmitChanges();
}
}
public static Order GetOrder(int orderId)
{
var order = new Order();
using (var db = new SpeedSharkModelDataContext())
{
order = db.Orders.SingleOrDefault(ord => ord.orderId == orderId);
}
return(order);
}
public static Session GetSession(int sessionId)
{
var session = new Session();
using (var db = new SpeedSharkModelDataContext())
{
session = db.Sessions.SingleOrDefault(sess => sess.sessionId == sessionId);
}
return(session);
}
public static Cargo GetCargo(int cargoId)
{
var cargo = new Cargo();
using (var db = new SpeedSharkModelDataContext())
{
cargo = db.Cargos.SingleOrDefault(carg => carg.cargoId == cargoId);
}
return(cargo);
}
public static void InsertCargo(double weight)
{
using (var db = new SpeedSharkModelDataContext())
{
var cargo = new Cargo();
cargo.weight = weight;
db.Cargos.InsertOnSubmit(cargo);
db.SubmitChanges();
}
}
public static Truck GetTruck(int truckId)
{
var truck = new Truck();
using (var db = new SpeedSharkModelDataContext())
{
truck = db.Trucks.SingleOrDefault(trk => trk.truckId == truckId);
}
return(truck);
}
public static void CreateTruck(string status)
{
using (var db = new SpeedSharkModelDataContext())
{
var truck = new Truck();
truck.status = status;
db.Trucks.InsertOnSubmit(truck);
db.SubmitChanges();
}
}
//get a customer
public static Customer GetCustomer(string cvr)
{
var customer = new Customer();
using (var db = new SpeedSharkModelDataContext())
{
var query = db.Customers.SingleOrDefault(cust => cust.CVR == cvr);
customer = query;
}
return(customer);
}
//get an employee
public static Employee GetEmployee(string username)
{
var employee = new Employee();
using (var db = new SpeedSharkModelDataContext())
{
var query = db.Employees.SingleOrDefault(emp => emp.username == username);
employee = query;
}
return(employee);
}
public static List <Session> GetSessions()
{
var sessions = new List <Session>();
using (var db = new SpeedSharkModelDataContext())
{
var query = db.Sessions.ToList();
sessions = query;
}
return(sessions);
}
public static List <Truck> GetTrucks()
{
List <Truck> trucks = new List <Truck>();
using (var db = new SpeedSharkModelDataContext())
{
var query = db.Trucks.ToList();
trucks = query;
}
return(trucks);
}
//get all customers
public static List <Customer> GetCustomers()
{
List <Customer> customers = new List <Customer>();
using (var db = new SpeedSharkModelDataContext())
{
var query = db.Customers.ToList();
customers = query;
}
return(customers);
}
public static List <Session> GetOngoingSession()
{
var sessions = new List <Session>();
using (var db = new SpeedSharkModelDataContext())
{
var query = db.Sessions.Where(sess => sess.arrivalTime >= DateTime.Now).ToList();
sessions = query;
}
return(sessions);
}
public static List <Cargo> GetCargoes()
{
List <Cargo> cargoes = new List <Cargo>();
using (var db = new SpeedSharkModelDataContext())
{
var query = db.Cargos.ToList();
cargoes = query;
}
return(cargoes);
}
public static void CancelOrder(int sessionId)
{
var order = new Order();
using (var db = new SpeedSharkModelDataContext())
{
order = db.Orders.SingleOrDefault(ord => ord.sessionId == sessionId);
order.status = "Canceled";
db.SubmitChanges();
}
}
public static List <Order> GetCompletedOrders()
{
List <Order> orders = new List <Order>();
using (var db = new SpeedSharkModelDataContext())
{
var query = db.Orders.Where(ord => ord.status.Equals("Completed")).ToList();
orders = query;
}
return(orders);
}
public static List <Order> GetOrders()
{
List <Order> orders = new List <Order>();
using (var db = new SpeedSharkModelDataContext())
{
var query = db.Orders.ToList();
orders = query;
}
return(orders);
}
//get all employees
public static List <Employee> GetEmployees()
{
List <Employee> employees = new List <Employee>();
using (var db = new SpeedSharkModelDataContext())
{
var query = db.Employees.ToList();
employees = query;
}
return(employees);
}
public static int GetMaxId()
{
int maxId = 0;
using (var db = new SpeedSharkModelDataContext())
{
var query = db.Sessions.OrderByDescending(sess => sess.sessionId).SingleOrDefault().sessionId;
if (query != 0 && query != null)
{
maxId = query;
}
}
return(maxId);
}
public static int GetMaxId()
{
int maxId = 0;
using (var db = new SpeedSharkModelDataContext())
{
var query = db.Cargos.OrderByDescending(carg => carg.cargoId).SingleOrDefault().cargoId;
if (query != 0 && query != null)
{
maxId = query;
}
}
return(maxId);
}
public static void UpdateTruck(int truckId, string status)
{
var truck = new Truck();
using (var db = new SpeedSharkModelDataContext())
{
truck = db.Trucks.SingleOrDefault(trk => trk.truckId == truckId);
if (truck != null)
{
truck.status = status;
db.SubmitChanges();
}
}
}
//create employee
public static void CreateEmployee(string fName, string lName, string username, string password, string type)
{
using (var db = new SpeedSharkModelDataContext())
{
var emp = new Employee();
emp.fName = fName;
emp.lName = lName;
emp.username = username;
emp.password = password;
emp.type = type;
db.Employees.InsertOnSubmit(emp);
db.SubmitChanges();
}
}
public static void UpdateCargo(int cargoId, double weight)
{
var cargo = new Cargo();
using (var db = new SpeedSharkModelDataContext())
{
cargo = db.Cargos.SingleOrDefault(carg => carg.cargoId == cargoId);
if (cargo != null)
{
cargo.weight = weight;
db.SubmitChanges();
}
}
}
//get the truck ids that are not currently in service
public static List <int> GetFunctionalTrucks()
{
var truckNumb = new List <int>();
using (var db = new SpeedSharkModelDataContext())
{
var query = db.Trucks.Where(trk => trk.status.Equals("Available") == true).ToList();
List <Truck> trucks = query;
foreach (Truck truck in trucks)
{
truckNumb.Add(truck.truckId);
}
}
return(truckNumb);
}
//create customer
public static void CreateCustomer(string cvr, string fName, string lName, string city, string address,
string phoneNo,
string email)
{
using (var db = new SpeedSharkModelDataContext())
{
var cust = new Customer();
cust.CVR = cvr;
cust.fName = fName;
cust.lName = lName;
cust.city = city;
cust.address = address;
cust.phoneNo = phoneNo;
db.Customers.InsertOnSubmit(cust);
db.SubmitChanges();
}
}
//update employee
public static void UpdateEmployee(string fName, string lName, string username, string password, string type)
{
var employee = new Employee();
using (var db = new SpeedSharkModelDataContext())
{
employee = db.Employees.SingleOrDefault(emp => emp.username == username);
if (employee != null)
{
employee.fName = fName;
employee.lName = lName;
employee.username = username;
employee.password = password;
employee.type = type;
db.SubmitChanges();
}
}
}
public static void CreateSession(int cargoId, string departureTime, string arrivalTime, int truckId,
string destAddress, string destCity)
{
using (var db = new SpeedSharkModelDataContext())
{
var session = new Session();
var deparTime = Convert.ToDateTime(departureTime);
var arriTime = Convert.ToDateTime(arrivalTime);
session.cargoId = cargoId;
session.departureTime = deparTime;
session.arrivalTime = arriTime;
session.truckId = truckId;
session.destCity = destCity;
session.destAddress = destAddress;
db.Sessions.InsertOnSubmit(session);
db.SubmitChanges();
}
}
//login
public static string EmployeeLogin(string username, string password)
{
var employee = new Employee();
string employeeType = "";
using (var db = new SpeedSharkModelDataContext())
{
employee = db.Employees.SingleOrDefault(emp => emp.username == username && emp.password == password);
if (employee == null)
{
employeeType = "Fail";
}
else
{
employeeType = employee.type;
}
}
return(employeeType);
}
public static void UpdateOrder(int orderId, string custCVR, double price, int sessionId, int cargoId,
string status)
{
var order = new Order();
using (var db = new SpeedSharkModelDataContext())
{
order = db.Orders.SingleOrDefault(ord => ord.orderId == orderId);
if (order != null)
{
order.custCVR = custCVR;
order.price = price;
order.sessionId = sessionId;
order.cargoId = cargoId;
order.status = status;
db.SubmitChanges();
}
}
}
//update customer
public static void UpdateCustomer(string cvr, string fName, string lName, string city, string address,
string phoneNo, string email)
{
var customer = new Customer();
using (var db = new SpeedSharkModelDataContext())
{
customer = db.Customers.SingleOrDefault(cust => cust.CVR == cvr);
if (customer != null)
{
customer.fName = fName;
customer.lName = lName;
customer.city = city;
customer.address = address;
customer.phoneNo = phoneNo;
customer.email = email;
db.SubmitChanges();
}
}
}
