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 void InsertCargo(double weight)
{
using (var db = new SpeedSharkModelDataContext())
{
var cargo = new Cargo();
cargo.weight = weight;
db.Cargos.InsertOnSubmit(cargo);
db.SubmitChanges();
}
}
public static void CreateTruck(string status)
{
using (var db = new SpeedSharkModelDataContext())
{
var truck = new Truck();
truck.status = status;
db.Trucks.InsertOnSubmit(truck);
db.SubmitChanges();
}
}
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();
}
}
//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 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();
}
}
}
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();
}
}
}
//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 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();
}
}
}
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();
}
}
//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();
}
}
}
public static void UpdateSession(int sessionId, int cargoId, string departureTime, string arrivalTime,
int truckId, string destAddress, string destCity)
{
var session = new Session();
using (var db = new SpeedSharkModelDataContext())
{
session = db.Sessions.SingleOrDefault(sess => sess.sessionId == sessionId);
if (session != null)
{
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.SubmitChanges();
}
}
}
