public void SaveBook(Book book)
{
if (book.BookId == 0)
{
context.Books.Add(book);
}
else
{
Book dbEntry = context.Books.Find(book.BookId);
if (dbEntry != null)
{
dbEntry.Name = book.Name;
dbEntry.Author = book.Author;
dbEntry.Description = book.Description;
dbEntry.Genre = book.Genre;
dbEntry.Price = book.Price;
}
}
context.SaveChanges();
}
public void SaveUser(User user)
{
var context = new EFDbContext();
if (user.UserId == 0)
{
context.Users.Add(user);
}
else
{
User dbEntry = context.Users.Find(user.UserId);
if (dbEntry != null)
{
dbEntry.UserName = user.UserName;
dbEntry.UserMail = user.UserMail;
dbEntry.UserPassword = user.UserPassword;
dbEntry.IsAdmin = false;
}
}
context.SaveChanges();
}
public void SaveDish(Dish dish)
{
if (dish.DishId == 0)
{
context.Dishes.Add(dish);
}
else
{
Dish dbEntry = context.Dishes.Find(dish.DishId);
if (dbEntry != null)
{
dbEntry.Style = dish.Style;
dbEntry.Producer = dish.Producer;
dbEntry.Description = dish.Description;
dbEntry.Type = dish.Type;
dbEntry.Price = dish.Price;
dbEntry.ImageUrl = dish.ImageUrl;
}
}
context.SaveChanges();
}
public void SaveProduct(Product product)
{
if (product.ProductId == 0)
{
context.Products.Add(product);
}
else
{
Product dbEntry = context.Products.Find(product.ProductId);
if (dbEntry != null)
{
dbEntry.Name = product.Name;
dbEntry.Description = product.Description;
dbEntry.Price = product.Price;
dbEntry.Category = product.Category;
dbEntry.ImageData = product.ImageData;
dbEntry.ImageMimeType = product.ImageMimeType;
}
}
context.SaveChanges();
}
public void SaveProduct(Product product)
{
if (string.IsNullOrEmpty(product.Guid))
{
product.Guid = Guid.NewGuid().ToString();
context.Products.Add(product);
}
else
{
Product dbEntry = context.Products.Find(product.Guid);
if (dbEntry != null)
{
dbEntry.Name = product.Name;
dbEntry.Description = product.Description;
dbEntry.Price = product.Price;
dbEntry.IsActive = product.IsActive;
dbEntry.Shop = product.Shop;
}
}
context.SaveChanges();
}
public void SaveThing(Thing thing)
{
if (thing.ThingId == 0)
{
context.Things.Add(thing);
}
else
{
Thing dbEntry = context.Things.Find(thing.ThingId);
if (dbEntry != null)
{
dbEntry.Name = thing.Name;
dbEntry.Kind = thing.Kind;
dbEntry.Material = thing.Material;
dbEntry.Description = thing.Description;
dbEntry.Producer = thing.Producer;
dbEntry.Articul = thing.Articul;
dbEntry.Price = thing.Price;
}
}
context.SaveChanges();
}
public void SaveSweet(Sweet sweet)
{
if (sweet.SweetId == 0)
{
context.Sweets.Add(sweet);
}
else
{
Sweet dbEntry = context.Sweets.Find(sweet.SweetId);
if (dbEntry != null)
{
dbEntry.Name = sweet.Name;
dbEntry.Ingredients = sweet.Ingredients;
dbEntry.Packing = sweet.Packing;
dbEntry.Expiration_date = sweet.Expiration_date;
dbEntry.Type = sweet.Type;
dbEntry.Price = sweet.Price;
dbEntry.ImageData = sweet.ImageData;
dbEntry.ImageMimeType = sweet.ImageMimeType;
}
}
context.SaveChanges();
}
public void ProcessOrder(Cart cart, Orders o, UserData ud, Characteristic ch)
{
UserData newUD = new UserData();
Orders newO = new Orders();
GamesInOrders newGIO = new GamesInOrders();
Purchase p = EF.FirstPrices
.FirstOrDefault(g => g.PurchaseId == ch.CharacteristicId);
//p.Count--;
newGIO.CharacteristicsId = ch.CharacteristicId;
newGIO.CountOfSoldGames = 1;
newGIO.PriceOfSoldGame = 200;
newUD.Addres = ud.Addres;
newUD.FirstName = ud.FirstName;
newUD.SecondName = ud.SecondName;
newUD.MiddleName = ud.MiddleName;
newO.UDId = newUD.UDId;
newO.DateOfOrder = DateTime.Now;
newO.StatusOfOrder = true;
EF.GamesInOrders.Add(newGIO);
EF.UserDatas.Add(newUD);
EF.Orders.Add(newO);
EF.SaveChanges();
}
public void SaveParams(EquationParameters equparams)
{
context.EquationParameters.Add(equparams);
context.SaveChanges();
}
public void SaveRate(Rate rate)
{
context.Rates.Attach(rate);
context.Entry(rate).State = EntityState.Modified;
context.SaveChanges();
}
public void Update(Const @const)
{
context.Consts.Attach(@const);
context.Entry(@const).State = EntityState.Modified;
context.SaveChanges();
}
public void Register(Factura factura)
{
context.Facturas.Add(factura);
context.SaveChanges();
}
public void register(Customer c)
{
context.QBCustomers.Add(c);
context.SaveChanges();
}
public static void Initialize(EFDbContext context)
{
context.Database.EnsureCreated();
if (context.RequestsStore.Any())
{
return;
}
var statuses = new List <Statuses>
{
new Statuses {
Name = "Открыта"
},
new Statuses {
Name = "Решена"
},
new Statuses {
Name = "Возврат"
},
new Statuses {
Name = "Закрыта"
}
};
foreach (var item in statuses)
{
context.Statuses.Add(item);
}
context.SaveChanges();
var requestStore = new List <RequestsStore>
{
new RequestsStore {
Date = DateTime.Now.AddDays(-10),
StatusId = 1,
Comments = "Заявка создана",
Requests = new Requests
{
CreateDate = DateTime.Now.AddDays(-10),
Name = "Что такое Lorem Ipsum?",
Content = "<ul><li>Lorem ipsum dolor sit amet, consectetur adipiscing elit.</li><li>Vivamus suscipit ante at urna efficitur blandit.</li><li>Nam venenatis tellus id velit rhoncus, in finibus augue malesuada.</li></ul></p>"
}
},
new RequestsStore {
Date = DateTime.Now.AddDays(-9),
StatusId = 1,
Comments = "Заявка создана",
Requests = new Requests
{
CreateDate = DateTime.Now.AddDays(-9),
Name = "Откуда появился Lorem Ipsum?",
Content = "<ul><li>Sed venenatis dui molestie libero elementum ultrices.</li><li>Vestibulum placerat risus eu odio accumsan viverra.</li><li>Nullam et sem ut purus egestas rutrum.</li><li>Praesent auctor tellus et mi rutrum, vel lacinia tortor luctus.</li><li>Nam at tortor euismod, gravida mi fringilla, laoreet magna.</li><li>Maecenas dictum ligula eu nibh mattis, eu pulvinar mi sodales.</li></ul>"
}
},
new RequestsStore {
Date = DateTime.Now.AddDays(-8),
StatusId = 1,
Comments = "Заявка создана",
Requests = new Requests
{
CreateDate = DateTime.Now.AddDays(-8),
Name = "Почему он используется?",
Content = "<ul><li>Sed venenatis dui molestie libero elementum ultrices.</li><li>Vestibulum placerat risus eu odio accumsan viverra.</li><li>Nullam et sem ut purus egestas rutrum.</li><li>Praesent auctor tellus et mi rutrum, vel lacinia tortor luctus.</li><li>Nam at tortor euismod, gravida mi fringilla, laoreet magna.</li><li>Maecenas dictum ligula eu nibh mattis, eu pulvinar mi sodales.</li></ul>"
}
},
new RequestsStore {
Date = DateTime.Now.AddDays(-7),
StatusId = 1,
Comments = "Заявка создана",
Requests = new Requests
{
CreateDate = DateTime.Now.AddDays(-7),
Name = "Где взять Lorem Ipsum?",
Content = "<ul><li>Sed venenatis dui molestie libero elementum ultrices.</li><li>Vestibulum placerat risus eu odio accumsan viverra.</li><li>Nullam et sem ut purus egestas rutrum.</li><li>Praesent auctor tellus et mi rutrum, vel lacinia tortor luctus.</li><li>Nam at tortor euismod, gravida mi fringilla, laoreet magna.</li><li>Maecenas dictum ligula eu nibh mattis, eu pulvinar mi sodales.</li></ul>"
}
},
new RequestsStore {
Date = DateTime.Now.AddDays(-6),
StatusId = 1,
Comments = "Заявка создана",
Requests = new Requests
{
CreateDate = DateTime.Now.AddDays(-6),
Name = "Классический текст Lorem Ipsum, используемый с XVI века",
Content = "<ul><li>Sed venenatis dui molestie libero elementum ultrices.</li><li>Vestibulum placerat risus eu odio accumsan viverra.</li><li>Nullam et sem ut purus egestas rutrum.</li><li>Praesent auctor tellus et mi rutrum, vel lacinia tortor luctus.</li><li>Nam at tortor euismod, gravida mi fringilla, laoreet magna.</li><li>Maecenas dictum ligula eu nibh mattis, eu pulvinar mi sodales.</li></ul>"
}
},
new RequestsStore {
Date = DateTime.Now.AddDays(-5),
StatusId = 1,
Comments = "Заявка создана",
Requests = new Requests
{
CreateDate = DateTime.Now.AddDays(-5),
Name = "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Cras.",
Content = "<ul><li>Sed venenatis dui molestie libero elementum ultrices.</li><li>Vestibulum placerat risus eu odio accumsan viverra.</li><li>Nullam et sem ut purus egestas rutrum.</li><li>Praesent auctor tellus et mi rutrum, vel lacinia tortor luctus.</li><li>Nam at tortor euismod, gravida mi fringilla, laoreet magna.</li><li>Maecenas dictum ligula eu nibh mattis, eu pulvinar mi sodales.</li></ul>"
}
},
new RequestsStore {
Date = DateTime.Now.AddDays(-4),
StatusId = 1,
Comments = "Заявка создана",
Requests = new Requests
{
CreateDate = DateTime.Now.AddDays(-4),
Name = "Lorem sit amet, adipiscing elit.",
Content = "<ul><li>Sed venenatis dui molestie libero elementum ultrices.</li><li>Vestibulum placerat risus eu odio accumsan viverra.</li><li>Nullam et sem ut purus egestas rutrum.</li><li>Praesent auctor tellus et mi rutrum, vel lacinia tortor luctus.</li><li>Nam at tortor euismod, gravida mi fringilla, laoreet magna.</li><li>Maecenas dictum ligula eu nibh mattis, eu pulvinar mi sodales.</li></ul>"
}
},
new RequestsStore {
Date = DateTime.Now.AddDays(-3),
StatusId = 1,
Comments = "Заявка создана",
Requests = new Requests
{
CreateDate = DateTime.Now.AddDays(-3),
Name = "What is Lorem Ipsum?",
Content = "<ul><li>Sed venenatis dui molestie libero elementum ultrices.</li><li>Vestibulum placerat risus eu odio accumsan viverra.</li><li>Nullam et sem ut purus egestas rutrum.</li><li>Praesent auctor tellus et mi rutrum, vel lacinia tortor luctus.</li><li>Nam at tortor euismod, gravida mi fringilla, laoreet magna.</li><li>Maecenas dictum ligula eu nibh mattis, eu pulvinar mi sodales.</li></ul>"
}
},
new RequestsStore {
Date = DateTime.Now.AddDays(-2),
StatusId = 1,
Comments = "Заявка создана",
Requests = new Requests
{
CreateDate = DateTime.Now.AddDays(-2),
Name = "Lorem ipsum dolor sit amet.",
Content = "<ul><li>Sed venenatis dui molestie libero elementum ultrices.</li><li>Vestibulum placerat risus eu odio accumsan viverra.</li><li>Nullam et sem ut purus egestas rutrum.</li><li>Praesent auctor tellus et mi rutrum, vel lacinia tortor luctus.</li><li>Nam at tortor euismod, gravida mi fringilla, laoreet magna.</li><li>Maecenas dictum ligula eu nibh mattis, eu pulvinar mi sodales.</li></ul>"
}
},
new RequestsStore {
Date = DateTime.Now.AddDays(-1),
StatusId = 1,
Comments = "Заявка создана",
Requests = new Requests
{
CreateDate = DateTime.Now.AddDays(-1),
Name = "Lorem ipsum dolor sit amet, consectetur adipiscing.",
Content = "<ul><li>Sed venenatis dui molestie libero elementum ultrices.</li><li>Vestibulum placerat risus eu odio accumsan viverra.</li><li>Nullam et sem ut purus egestas rutrum.</li><li>Praesent auctor tellus et mi rutrum, vel lacinia tortor luctus.</li><li>Nam at tortor euismod, gravida mi fringilla, laoreet magna.</li><li>Maecenas dictum ligula eu nibh mattis, eu pulvinar mi sodales.</li></ul>"
}
},
};
foreach (var item in requestStore)
{
context.RequestsStore.Add(item);
}
context.SaveChanges();
}
public void Create(Payout payout)
{
context.Payouts.Add(payout);
context.SaveChanges();
}
public void register(ItemQB i)
{
context.QBItems.Add(i);
context.SaveChanges();
}
public void AddUser(User user)
{
contex.Users.Add(user);
contex.SaveChanges();
}
public void AddCart(Cart cart)
{
_context.Carts.Add(cart);
_context.SaveChanges();
}