internal static void CreateTicket(Ticket newTicket) { using (ManagementEntity context = new ManagementEntity()) { try { Models.Management.Ticket ticket = new Models.Management.Ticket(); ticket.Created = DateTime.FromBinary(newTicket.Date); ticket.Description = newTicket.Description; ticket.Type = (int)newTicket.TicketType; ticket.EmployeeId = newTicket.EmployeeID; ticket.AutoNumber = newTicket.CarNumber; ticket.DepartmentId = newTicket.DepartmentID; ticket.CustomerId = newTicket.CustomerID; ticket.Status = 1; ///Ticket status: 0 - closed, 1 - opened context.Tickets.AddObject(ticket); context.SaveChanges(); } catch (InvalidOperationException ex) { throw ex; } } }
internal static void CloseTicket(int ticketID) { using (ManagementEntity context = new ManagementEntity()) { try { var ticketToClose = (from t in context.Tickets where t.Id == ticketID select t).FirstOrDefault(); if (ticketToClose != null) { ticketToClose.Closed = DateTime.Now; context.TicketHistories.AddObject(new TicketHistory { Ticket = ticketToClose, } ); context.SaveChanges(); } } catch (InvalidOperationException ex) { throw ex; } } }
public static void CreatePayment(Payment newPayment) { using (ManagementEntity context = new ManagementEntity()) { try { Models.Management.Payment payment = new Models.Management.Payment { TicketId = newPayment.TicketID, OrderId = newPayment.OrderID, Type = (int)e_PaymentStatus.NotPaid,//default is not paid Amount = newPayment.Amount, Date = DateTime.UtcNow, Destination = newPayment.Destination }; context.Payments.AddObject(payment); context.SaveChanges(); } catch (InvalidOperationException ex) { throw ex; } } }
public static IList<Modules.Management.Order> GetOrders() { IList<Modules.Management.Order> orders = new List<Modules.Management.Order>(); using (ManagementEntity context = new ManagementEntity()) { try { var orderList = (from ol in context.Orders select ol); foreach (var order in orderList) { Autorent.Modules.Management.Order o = new Order(); o.ID = order.Number; o.StartDateRent = (int)order.CreationDate.ToBinary(); o.ClientID = order.CustomerId; o.ManagerID = order.ManagerId; o.CarNumber = order.AutoNumber; o.StatusOrder = (e_StatusOrder)order.Status; o.Type = (OrderType)order.Type; o.XMLData = order.Data; orders.Add(o); } } catch (InvalidOperationException ex) { throw ex; } } return orders; }
public static void AddOrder(Order newOrder) { using (ManagementEntity context = new ManagementEntity()) { try { Models.Management.Order order = new Models.Management.Order(); order.CustomerId = newOrder.ClientID; order.CreationDate = DateTime.Now; order.AutoNumber = newOrder.CarNumber; order.ManagerId = newOrder.ManagerID; order.Type = (int)newOrder.Type; order.Status = (int)e_StatusOrder.NotProcessed; context.Orders.AddObject(order); context.SaveChanges(); } catch (InvalidOperationException ex) { throw ex; } } }
public static IList<Payment> GetPayments() { IList<Payment> paymentList = new List<Payment>(); using (ManagementEntity context = new ManagementEntity()) { try { var queryPayments = from p in context.Payments select p; foreach (var item in queryPayments) { Payment payment = new Payment(); payment.ID = item.Id; payment.TicketID = item.TicketId; payment.OrderID = item.OrderId; payment.CustomerID = item.CustomerId; payment.PaymentStatus = (e_PaymentStatus)item.Type; payment.Amount = item.Amount; payment.Date = (int)item.Date.ToBinary(); payment.Destination = item.Destination; paymentList.Add(payment); } } catch (InvalidOperationException ex) { throw ex; } } return paymentList; }
public static IList<Department> GetDepartments() { IList<Department> departments = new List<Department>(); using (ManagementEntity context = new ManagementEntity()) { try { var listOfDepartments = (from d in context.Departments select d); if (listOfDepartments != null) { foreach (var item in listOfDepartments) { Department department = new Department(); department.ID = item.Id; department.Address = item.Addresse; department.Name = item.Name; department.PhoneNumber = item.Phone; departments.Add(department); } } } catch (InvalidOperationException ex) { throw ex; } } return departments; }
public static void DeletePayment(int paymentID) { using (ManagementEntity context = new ManagementEntity()) { try { var queryPayment = (from p in context.Payments where p.Id == paymentID select p).FirstOrDefault(); context.DeleteObject(queryPayment); context.SaveChanges(); } catch (InvalidOperationException ex) { throw ex; } } }
public static void DeleteOrder(int orderID) { using (ManagementEntity context = new ManagementEntity()) { try { var orderToDelete = (from o in context.Orders where o.Number == orderID select o).FirstOrDefault(); if (orderToDelete != null) { context.Orders.DeleteObject(orderToDelete); context.SaveChanges(); } } catch (InvalidOperationException ex) { throw ex; } } }
public static void DeleteDepartment(Department department) { using (ManagementEntity context = new ManagementEntity()) { try { var deptToDelete = (from d in context.Departments where d.Id == department.ID select d).FirstOrDefault(); if (deptToDelete != null) { context.Departments.DeleteObject(deptToDelete); context.SaveChanges(); } } catch (InvalidOperationException ex) { throw ex; } } }
internal static void DeleteTicket(int ticketID) { using (ManagementEntity context = new ManagementEntity()) { try { var ticketToDelete = (from t in context.Tickets where t.Id == ticketID select t).FirstOrDefault(); if (ticketToDelete != null) { context.DeleteObject(ticketToDelete); context.SaveChanges(); } } catch (InvalidOperationException ex) { throw ex; } } }
public static void CreateDepartment(Department department) { using (ManagementEntity context = new ManagementEntity()) { try { Models.Management.Department dept = new Models.Management.Department(); dept.Id = department.ID; dept.Name = department.Name; dept.Phone = department.PhoneNumber; dept.Addresse = department.Address; context.Departments.AddObject(dept); context.SaveChanges(); } catch (InvalidOperationException ex) { throw ex; } } }
internal static void SaveTickets(IList<Modules.Management.Ticket> tickets) { using (ManagementEntity context = new ManagementEntity()) { try { foreach (var item in tickets) { var ticketToSave = (from t in context.Tickets where t.Id == item.ID select t).FirstOrDefault(); if (ticketToSave != null) { ticketToSave.OrderNumber = item.OrderID; ticketToSave.Description = item.Description; ticketToSave.Created = DateTime.FromBinary(item.Date); ticketToSave.Type = (int)item.TicketType; ticketToSave.EmployeeId = item.EmployeeID; ticketToSave.AutoNumber = item.CarNumber; ticketToSave.DepartmentId = item.DepartmentID; ticketToSave.CustomerId = item.CustomerID; context.SaveChanges(); List<int> i = new List<int>(); } } } catch (InvalidOperationException ex) { throw ex; } } }
public static void UpdateOrder(Modules.Management.Order order) { using (ManagementEntity context = new ManagementEntity()) { try { var queryOrder = (from o in context.Orders where o.Number == order.ID select o).FirstOrDefault(); queryOrder.AutoNumber = order.CarNumber; queryOrder.CustomerId = order.ClientID; queryOrder.ManagerId = order.ManagerID; queryOrder.CreationDate = DateTime.FromBinary(order.CreationDate); queryOrder.ExpiredDate = DateTime.FromBinary(order.EndDateRent); queryOrder.Type = (int)order.Type; queryOrder.Status = (int)order.StatusOrder; queryOrder.Data = order.XMLData; context.SaveChanges(); Random rnd = new Random(order.ID); int newTicketID = rnd.Next(1, int.MaxValue); Autorent.Modules.Management.Ticket newTicket = new Autorent.Modules.Management.Ticket { CarNumber = order.CarNumber, CustomerID = order.ClientID, Date = (int)DateTime.Now.ToBinary(), DepartmentID = Guid.NewGuid(), EmployeeID = order.ManagerID, OrderID = order.ID, ID = newTicketID, TicketType = TicketType.CarMigration }; TicketAPI.CreateTicket(newTicket); Autorent.Modules.Management.Payment newPayment = new Autorent.Modules.Management.Payment { Amount = rnd.Next(1100, 3500), CustomerID = order.ClientID.Value, Date = (int)DateTime.Now.ToBinary(), Destination = "RosPilUa", OrderID = order.ID, PaymentStatus = e_PaymentStatus.NotPaid, TicketID = newTicketID }; PaymentAPI.CreatePayment(newPayment); } catch (InvalidOperationException ex) { throw ex; } } }
public static void UpdatePayment(int paymentID, e_PaymentStatus paymentStatus, decimal amount, string destination) { using (ManagementEntity context = new ManagementEntity()) { try { var queryPayment = (from p in context.Payments where p.Id == paymentID select p).FirstOrDefault(); queryPayment.Type = (int)paymentStatus; queryPayment.Amount = amount; queryPayment.Destination = destination; context.SaveChanges(); } catch (InvalidOperationException ex) { throw ex; } } }
public static void UpdateDepartment(Guid departmentID, string departmentName, string address, string phoneNumber) { using (ManagementEntity context = new ManagementEntity()) { try { var dept = (from d in context.Departments where d.Id == departmentID select d).FirstOrDefault(); if (dept != null) { dept.Name = departmentName; dept.Addresse = address; dept.Phone = phoneNumber; context.SaveChanges(); } } catch (InvalidOperationException ex) { throw ex; } } }
internal static IList<Ticket> GetTickets() { IList<Ticket> tickets = new List<Ticket>(); using (ManagementEntity context = new ManagementEntity()) { try { var ticketsList = (from tl in context.Tickets select tl); foreach (var ticket in ticketsList) { Autorent.Modules.Management.Ticket t = new Ticket(); t.Date = (int)ticket.Created.ToBinary(); t.Description = ticket.Description; t.OrderID = (int)ticket.OrderNumber; t.TicketType = (TicketType)ticket.Type; t.CarNumber = ticket.AutoNumber; t.EmployeeID = ticket.EmployeeId; t.DepartmentID = ticket.DepartmentId; t.CustomerID = ticket.CustomerId; tickets.Add(t); } } catch (InvalidOperationException ex) { throw ex; } } return tickets; }
public static void SaveOrders(IList<Management.Order> orders) { using (ManagementEntity context = new ManagementEntity()) { try { foreach (var item in orders) { var orderToSave = (from o in context.Orders where o.Number == item.ID select o).FirstOrDefault(); if (orderToSave != null) { orderToSave.Number = item.ID; orderToSave.CreationDate = DateTime.FromBinary(item.StartDateRent); orderToSave.CustomerId = item.ClientID; orderToSave.ManagerId = item.ManagerID; orderToSave.AutoNumber = item.CarNumber; orderToSave.Status = (int)item.StatusOrder; orderToSave.Type = (int)item.Type; orderToSave.Data = item.XMLData; context.SaveChanges(); } } } catch (InvalidOperationException ex) { throw ex; } } }