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