private static void CreateHamburgData()
{
var context = new ProductsContext("name=HamburgDB");
context.Database.Initialize(true);
context.Products.AddRange(new Product[]
{
new Product()
{
Id = 1, Name = "Hat", Price = 15, Category = "Apparel", Location = "Hamburg"
},
new Product()
{
Id = 2, Name = "Socks", Price = 5, Category = "Apparel", Location = "Hamburg"
},
new Product()
{
Id = 3, Name = "Scarf", Price = 12, Category = "Apparel", Location = "Hamburg"
},
new Product()
{
Id = 4, Name = "Yo-yo", Price = 4.95M, Category = "Toys", Location = "Hamburg"
},
new Product()
{
Id = 5, Name = "Puzzle", Price = 8, Category = "Toys", Location = "Hamburg"
},
});
context.SaveChanges();
}
public Order CreateOrder(Order neworder, string userId)
{
var cart = GetCart();
neworder.OrderTime = DateTime.Now;
neworder.UserId = userId;
_db.Orders.Add(neworder);
if (neworder.OrderPositions == null)
{
neworder.OrderPositions = new List <OrderPosition>();
}
decimal cartValue = 0;
foreach (var cartElement in cart)
{
var newOrderPosition = new OrderPosition()
{
ProductId = cartElement.Product.ProductId,
Amount = cartElement.Amount,
OrderPrice = cartElement.Product.Price
};
cartValue += cartElement.Amount * cartElement.Product.Price;
neworder.OrderPositions.Add(newOrderPosition);
}
neworder.OrderValue = cartValue;
_db.SaveChanges();
return(neworder);
}
public void When_Create_New_Cart_With_Product_ID2_And_Quantity2_And_Should_Be_Get_CartID1()
{
var _cartOptions = new DbContextOptionsBuilder <CartsContext>().UseInMemoryDatabase("create_new_cart_carts").Options;
var _cartContext = new CartsContext(_cartOptions);
var _productOptions = new DbContextOptionsBuilder <ProductsContext>().UseInMemoryDatabase("create_new_cart_products").Options;
var _productContext = new ProductsContext(_productOptions);
ProductsModel productsData = new ProductsModel {
id = 2,
name = "43 Piece dinner Set",
price = (Decimal)12.95,
availability = "InStock",
stockAvailability = 10,
age = "3_to_5",
gender = "FEMALE",
brand = "CoolKidz"
};
_productContext.Products.Add(productsData);
_productContext.SaveChanges();
CartsService cartsService = new CartsService(_cartContext, _productContext);
var actualResult = cartsService.add(productsData, 1);
Assert.Equal(1, actualResult.id);
}
internal void Create(Product model)
{
using (var db = new ProductsContext())
{
db.Products.Add(model);
db.SaveChanges();
}
}
internal void UpdateProduct(Product product)
{
using (var db = new ProductsContext())
{
db.Entry(product).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public void Add(Product product)
{
using (productContext = new ProductsContext())
{
productContext.Products.Add(product);
productContext.SaveChanges();
}
}
public String AddNewItem([FromBody] Product product)
{
_context.Add(product);
_context.SaveChanges();
String response = "Product added with id " + _context.Products.Count();
return(response);
}
public HttpResponseMessage Post(Supplier supplier)
{
supplier.ProductFamilies = null;
Supplier addedSupplier = _db.Suppliers.Add(supplier);
_db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.Created, addedSupplier));
}
public string AddProduct(Product product)
{
using (ProductsContext _prodContext = new ProductsContext())
{
_prodContext.Products.Add(product);
_prodContext.SaveChanges();
return("");
}
}
internal void DeleteProduct(int id)
{
using (var db = new ProductsContext())
{
Product product = db.Products.Find(id);
db.Products.Remove(product);
db.SaveChanges();
}
}
public ActionResult Create(Products products)
{
try
{
// TODO: Add insert logic here
if (ModelState.IsValid)
{
db.Products.Add(products);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(products));
}
catch
{
return(View());
}
}
public OrderState ChangeOrderStatus(Order order)
{
Order orderToModify = db.Order.Find(order.OrderId);
orderToModify.OrderState = order.OrderState;
db.SaveChanges();
return(order.OrderState);
}
public void Save()
{
_productChangedService
.AddToMessageList(_context.ChangeTracker.Entries <Product>());
_context.SaveChanges();
_productChangedService.SendMessagesAsync();
}
public OrderVm Patch(Guid key, Delta <OrderVm> patch)
{
var order = _database.Orders
.Include(o => o.ProductLines)
.SingleOrDefault(o => o.Guid == key);
if (order == null)
{
return(null);
}
var orderVm = Mapper.Map <OrderVm>(order);
patch.Patch(orderVm);
Mapper.Map(orderVm, order);
var changedPropertyNames = patch.GetChangedPropertyNames();
if (changedPropertyNames.Contains("ProductLines"))
{
_database.ProductLines.RemoveRange(order.ProductLines);
var newProductList = new List <ProductLine>();
foreach (var newProduct in orderVm.ProductLines)
{
var p = new ProductLine
{
Price = newProduct.Price,
Quantity = newProduct.Quantity,
ProductId = _database.Products.Single(x => x.Guid == newProduct.ProductId).Id,
};
if (p.ProductId != 0)
{
newProductList.Add(p);
}
}
order.ProductLines = newProductList;
}
_database.Entry(order).State = EntityState.Modified;
_database.SaveChanges();
return(orderVm);
}
public SupplierVm Patch(Guid id, Delta <SupplierVm> patch)
{
var supplier = _database.Suppliers.SingleOrDefault(s => s.Guid == id);
if (supplier == null)
{
return(null);
}
var supplierVm = Mapper.Map <SupplierVm>(supplier);
patch.Patch(supplierVm);
Mapper.Map(supplierVm, supplier);
_database.Entry(supplier).State = EntityState.Modified;
_database.SaveChanges();
return(supplierVm);
}
private static void ImportData()
{
using (var db = new ProductsContext())
{
var users = Import <User>(@"Imported\users.json");
db.Users.AddRange(users);
var categories = Import <Category>(@"Imported\categories.json");
db.Categories.AddRange(categories);
db.SaveChanges();
var products = Import <Product>(@"Imported\products.json");
AddSellersAndBuyers(products, db);
var categoryProducts = AddCategoryProducts(db);
db.CategoryProducts.AddRange(categoryProducts);
db.SaveChanges();
}
}
public ActionResult DeleteProduct(int id)
{
var dbContext = new ProductsContext();
Product product = dbContext.products.FirstOrDefault(x => x.ProductID == id);
dbContext.products.Remove(product);
dbContext.SaveChanges();
return(RedirectToAction("GetProducts"));
}
public ActionResult Create(FormCollection formCollection)
{
Product product = new Product();
product.Name = formCollection["Name"];
product.Price = Convert.ToDecimal(formCollection["Price"]);
db.ProductsTable.Add(product);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult AddProduct(Product product, HttpPostedFileBase image)
{
//var originalImage = new Bitmap(image.InputStream, false);
if (image != null)
{
// получаем имя файла
string Ext = Path.GetExtension(image.FileName);
string ImgName = Guid.NewGuid().ToString() + Ext.ToString();
// сохраняем файл в папку Files в проекте
image.SaveAs(Server.MapPath("~/Built/Images/ProductsImages/" + ImgName));
product.Image = ImgName;
}
product.Id = Guid.NewGuid().ToString();
pc.Products.Add(product);
pc.SaveChanges();
return(Json(product));
}
public void AddProduct(Product product)
{
if (product.ProductId == 0)
{
_context.Add(product);
}
else
{
_context.Update(product);
}
_context.SaveChanges();
}
private static void ImportDataXml()
{
using (var db = new ProductsContext())
{
var users = ImportUsers(@"Imported\users.xml");
db.Users.AddRange(users);
db.SaveChanges();
var categories = ImportCategories(@"Imported\categories.xml");
db.Categories.AddRange(categories);
db.SaveChanges();
var products = ImportProducts(@"Imported\products.xml");
AddSellersAndBuyers(products.ToArray(), db);
var categoryProducts = AddCategoryProducts(db);
db.CategoryProducts.AddRange(categoryProducts);
db.SaveChanges();
}
}
public Product InsertProduct(ProductApiModel insertedProduct, out bool result)
{
var product = new Product()
{
ProductId = Guid.NewGuid(),
Category = insertedProduct.Category,
Slogan = insertedProduct.Slogan,
DiscountPercentage = insertedProduct.DiscountPercentage,
HtmlProductDemonstration = insertedProduct.HtmlProductDemonstration,
Name = insertedProduct.Name,
Price = insertedProduct.Price,
ImgSource = insertedProduct.ImgSource,
ReleaseDate = DateTime.UtcNow,
Comments = insertedProduct.Comments
};
context.Products
.Add(product);
result = context.SaveChanges() > 0;
return(product);
}
public void Delete(int id)
{
using (productContext = new ProductsContext())
{
var product = productContext.Products.Find(id);
if (product != null)
{
productContext.Products.Remove(product);
productContext.SaveChanges();
}
}
}
public void Update(Product product)
{
using (productContext = new ProductsContext())
{
var item = productContext.Products.Find(product.Id);
if (item != null)
{
productContext.Entry(item).CurrentValues.SetValues(product);
productContext.SaveChanges();
}
}
}
internal ProductsResp AddProducts(ProductsDatas products)
{
using (var db = new ProductsContext())
{
db.Products.Add(products);
db.SaveChanges();
return(new ProductsResp()
{
Status = true, StatusMsg = ""
});
}
}
public async Task <IActionResult> Register(UserInfo _userData)
{
if (_userData != null && _userData.Email != null && _userData.Password != null)
{
_context.UserInfo.Add(new UserInfo {
Email = _userData.Email, FirstName = _userData.UserName, LastName = _userData.LastName, Password = _userData.Password, UserName = _userData.UserName
});
_context.SaveChanges();
return(Ok());
}
return(BadRequest());
}
public AccountController(IConfiguration config, ProductsContext context)
{
_configuration = config;
_context = context;
if (_context.UserInfo.Count() == 0)
{
_context.UserInfo.Add(new UserInfo {
Email = "*****@*****.**", FirstName = "Admin", LastName = "Gomez", Password = "******", UserName = "******"
});
_context.SaveChanges();
}
}
public async Task <Product> Add(Product product)
{
using (var transaction = _context.Database.BeginTransaction())
{
await _context.Products.AddAsync(product);
_context.SaveChanges();
transaction.Commit();
}
return(product);
}
public ProductsController(ProductsContext context)
{
_context = context;
if (_context.ProductsItems.Count() == 0)
{
_context.ProductsItems.Add(new ProductsItem {
Name = "Item 1"
});
_context.SaveChanges();
}
}
public IHttpActionResult PutSubjectOfLabor(int id, SubjectOfLabor subjectOfLabor)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != subjectOfLabor.Id)
{
return(BadRequest());
}
db.Entry(subjectOfLabor).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!SubjectOfLaborExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}