public void Delete(Model.Order element)
{
using (Database1Entities context = new Database1Entities())
{
var elementToDelete = context.Orders.SingleOrDefault(o => o.Id == element.ID);
context.Orders.Remove(elementToDelete);
context.SaveChanges();
}
}
public void Update(Model.Customer element)
{
using (Database1Entities context = new Database1Entities())
{
var elementToUpdate = context.Customers.SingleOrDefault(o => o.Id == element.ID);
elementToUpdate.Name = element.Name;
elementToUpdate.Mail = element.Mail;
elementToUpdate.PhoneNumber = element.PhoneNumber;
context.SaveChanges();
}
}
public void Create(Model.Customer element)
{
using (Database1Entities context = new Database1Entities())
{
context.Customers.Add(new Customer()
{
Name = element.Name,
Mail = element.Mail,
PhoneNumber = element.PhoneNumber
});
context.SaveChanges();
}
}
public IEnumerable <Model.Customer> Read()
{
List <Model.Customer> customerList = new List <Model.Customer>();
using (Database1Entities context = new Database1Entities())
{
Mapper mapper = new Mapper();
foreach (var i in context.Customers.ToList())
{
customerList.Add(mapper.MapToModelCustomer(i));
}
}
return(customerList);
}
public void Update(Model.Order element)
{
using (Database1Entities context = new Database1Entities())
{
var elementToUpdate = context.Orders.SingleOrDefault(o => o.Id == element.ID);
elementToUpdate.Name = element.Name;
elementToUpdate.Comments = element.Comments;
elementToUpdate.Price = element.Price;
elementToUpdate.IsPaid = element.IsPaid;
elementToUpdate.Date = element.Date;
elementToUpdate.IdCustomer = element.Customer.ID;
context.SaveChanges();
}
}
public IEnumerable <Model.Order> GetOrderListDateFromTo(DateTime dateFrom, DateTime dateTo, int ordersCount)
{
List <Model.Order> list = new List <Model.Order>();
using (Database1Entities context = new Database1Entities())
{
var dbList = context.Orders.Where(o => o.Date >= dateFrom && o.Date <= dateTo).OrderByDescending(o => o.Date).ThenByDescending(o => o.Id).Take(ordersCount);
Mapper map = new Mapper();
foreach (var i in dbList)
{
var order = map.MapToModelOrder(i);
list.Add(order);
}
return(list);
}
}
public void Create(Model.Order element)
{
using (Database1Entities context = new Database1Entities())
{
context.Orders.Add(new Order()
{
Name = element.Name,
Comments = element.Comments,
Price = element.Price,
IsPaid = element.IsPaid,
Date = element.Date,
IdCustomer = element.Customer.ID
});
context.SaveChanges();
}
}