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(); } } }