public IActionResult Create(Product item)
{
_context.Products.Add(item);
_context.SaveChanges();
return(CreatedAtRoute("GetProduct", new { id = item.Id }, item));
}
public void Delete(int id)
{
User user = context.Users.Find(id);
context.Users.Remove(user);
context.SaveChanges();
}
private static void TestEFProduct()
{
using (var context = new CatalogContext())
{
context.ProductGroups.Add(ProductGroup.Create("Rosa"));
context.ProductGroups.Add(ProductGroup.Create("Gerbera"));
context.ProductGroups.Add(ProductGroup.Create("Tulip"));
context.SaveChanges();
var rosa = context.ProductGroups.Where(pg => pg.Name == "Rosa").SingleOrDefault();
var rosaId = context.Entry(rosa).Property("ProductGroupId").CurrentValue;
var tulip = context.ProductGroups.Where(pg => Microsoft.EntityFrameworkCore.EF.Property <int>(pg, "ProductGroupId") == 3).SingleOrDefault();
var redBerlin = Product.Create(rosa, "R GR Red Berlin", null, "R GR Red Berlin");
var ajax = Product.Create(tulip, "TU EN AJAX", null, "TU EN AJAX");
context.Products.Add(redBerlin);
context.Products.Add(ajax);
context.SaveChanges();
}
var productGroups = CatalogQueries.GetProductGroups();
}
public T Add(T entity)
{
_dbContext.Set <T>().Add(entity);
_dbContext.SaveChanges();
return(entity);
}
public void Remove(int id)
{
//Apagando empresa
var empresa = _context.Empresa.Where(x => x.Id == id).FirstOrDefault();
_context.Empresa.Remove(empresa);
_context.SaveChanges();
}
public ActionResult Create([Bind(Include = "Id,Name,Description")] Role role)
{
if (ModelState.IsValid)
{
db.Roles.Add(role);
db.SaveChanges();
return RedirectToAction("Index");
}
return View(role);
}
public ActionResult Create([Bind(Include = "Id,Name,Login,Profiles")] User user)
{
if (ModelState.IsValid)
{
db.Users.Add(user);
db.SaveChanges();
return(RedirectToAction("AddProfilesforUser", user));//добавил юзер в параметр
}
return(View(user));
}
public IActionResult Edit(CatalogProd edit_prods)
{
//добавляем данные в БД
//db.CatalogProds.Add(catalogProd);
//сохраняем данные
db.CatalogProds.Update(edit_prods);
db.SaveChanges();
//возвращаем каталог
return(RedirectToAction("Index"));
}
public ActionResult CreateProfile([Bind(Include = "Id,Name,Roles")] Profile profile)
{
if (ModelState.IsValid)
{
db.Profiles.Add(profile);
db.SaveChanges();
//izmenil redurect
return(RedirectToAction("AddRoleforProfile", profile));
}
return(PartialView(profile));
}
public ActionResult Create([Bind(Include = "ID,PeriodNumber")] Period period)
{
if (ModelState.IsValid)
{
db.Periods.Add(period);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(period));
}
public ActionResult Create([Bind(Include = "TagId,TagName")] Tag tag)
{
if (ModelState.IsValid)
{
db.Tags.Add(tag);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tag));
}
public ActionResult Create([Bind(Include = "ID,Name,Instructor,Description,Capacity,CurrentStudentCount,PeriodID")] Elective elective)
{
if (ModelState.IsValid)
{
db.Electives.Add(elective);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.PeriodID = new SelectList(db.Periods, "ID", "ID", elective.PeriodID);
return(View(elective));
}
public async Task <ActionResult <EventItem> > UpdateEvent(int id, EventItem eventItem)
{
if (id != eventItem.Id)
{
return(BadRequest());
}
_context.Entry(eventItem).State = EntityState.Modified;
_context.SaveChanges();
return(NoContent());
}
public ActionResult AddProduct(ProductCatalog productcatalog)
{
if (ModelState.IsValid)
{
pcdb.ProductCatalogs.Add(productcatalog);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.FKCatalogID = new SelectList(db.Catalogs, "CatalogID", "Code", productcatalog.Catalog_id);
ViewBag.FKProductID = new SelectList(pdb.Products, "ProductID", "Code", productcatalog.Product_id);
return(View(productcatalog));
}
public IHttpActionResult Post([FromBody] ItemCatalog item)
{
if (ModelState.IsValid)
{
_catalogContext.ItemCatalogs.Add(item);
_catalogContext.SaveChanges();
return(Ok(item));
}
else
{
return(BadRequest());
throw new HttpResponseException(HttpStatusCode.PaymentRequired);
}
}
public async Task DeleteItemFromBasket()
{
var existingBasket = BasketBuilder.WithOneBasketItem();
_catalogContext.Add(existingBasket);
_catalogContext.SaveChanges();
await _basketItemRepository.DeleteAsync(existingBasket.Items.FirstOrDefault());
_catalogContext.SaveChanges();
var basketFromDB = await _basketRepository.GetByIdAsync(BasketBuilder.BasketId);
Assert.Equal(0, basketFromDB.Items.Count);
}
public IActionResult Post(string sku, [FromBody] int quantity)
{
Product item = _context.Products.Where(b => b.SKU.Contains(sku)).First();
if (item == null)
{
return(NotFound());
}
item.Quantity = quantity;
_context.Products.Update(item);
_context.SaveChanges();
return(NoContent());
}
//[HttpPost("Catalog")]
public IEnumerable <string> Create(ProductCreate productCreate)
{
//Validate before save to db
var validationResults = productCreate.Validate();
if (validationResults.Count() > 0)
{
return(validationResults);
}
//Map Dto to Models
var productModel = Mapper.Map <Dto.ProductCreate, Models.Product>(productCreate);
//Add productModel
catalogContext.Add(productModel);
//Add productGender
foreach (var genderId in productCreate.Genders)
{
var productGender = new Models.ProductGender
{
GenderId = genderId,
ProductId = productModel.Id
};
catalogContext.ProductGender.Add(productGender);
}
//Commit changes to db
catalogContext.SaveChanges();
return(validationResults);
}
static void Main(string[] args)
{
var ctx = new CatalogContext();
var course1 = new Course {
Title = "new course", Prereq = "Nothing"
};
Console.WriteLine(ctx.Entry(course1).State);
var course = (from c in ctx.Courses
where c.Title == "JAVA EE"
select c).FirstOrDefault();
Console.WriteLine(ctx.Entry(course).State); // Unchanged
if (course != null)
{
course.Prereq = "Java + SQL + HTML"; // Modified
Console.WriteLine(ctx.Entry(course).State);
ctx.SaveChanges();
}
else
{
Console.WriteLine("Course Not Found!");
}
}
public bool InsertAnimal(M.Animal animal)
{
bool animalInserted = false;
try
{
_dbContext.Animals.Add(animal);
_dbContext.SaveChanges();
animalInserted = true;
}
catch (Exception err)
{
Debug.WriteLine($"Error: {err.Message}");
}
return(animalInserted);
}
public async Task Get_catalog_items_custom_page_success()
{
//Arrange
var dbOptions = new DbContextOptionsBuilder <CatalogContext>()
.UseInMemoryDatabase(databaseName: $"{VersionPrefix}{nameof(Get_catalog_items_custom_page_success)}")
.Options;
using var dbContext = new CatalogContext(dbOptions);
dbContext.AddRange(GetFakeCatalog(20));
dbContext.SaveChanges();
//Act
var orderController = new CatalogController(dbContext, mapper);
var actionResult = await orderController.ItemsAsync(5, 1);
//Assert
Assert.IsType <OkObjectResult>(actionResult);
var page = Assert.IsAssignableFrom <PaginatedItems <ProductDTO> >((actionResult as OkObjectResult).Value);
Assert.Equal(20, page.Count);
Assert.Equal(1, page.PageIndex);
Assert.Equal(5, page.PageSize);
Assert.Equal(5, page.Data.Count());
}
public ActionResult Save(CodelistEditModel model)
{
var typeName = model.Name;
var type = _types.Where(t => t.Name == typeName).SingleOrDefault();
if (type != null)
{
using (CatalogContext db = new CatalogContext())
{
var keys = new object[] { model.ID };
var res = (ICodelist)db.Set(type).Find(keys);
if (res != null)
{
res.ShortDescription = model.ShortDescription;
res.LongDescription = model.LongDescription;
res.CodelistNumber = model.CodelistNumber;
res.SortOrder = model.SortOrder;
db.Entry(res).State = EntityState.Modified;
db.SaveChanges();
}
}
}
return(Redirect("~/Codelists?n=" + model.Name));
}
public async Task Get_catalog_item_success()
{
//Arrange
var dbOptions = new DbContextOptionsBuilder <CatalogContext>()
.UseInMemoryDatabase(databaseName: $"{VersionPrefix}{nameof(Get_catalog_item_success)}")
.Options;
using var dbContext = new CatalogContext(dbOptions);
dbContext.AddRange(GetFakeCatalog(2));
dbContext.SaveChanges();
//Act
var orderController = new CatalogController(dbContext, mapper);
var actionResult = await orderController.ItemByIdAsync(2);
//Assert
Assert.IsType <ActionResult <ProductDTO> >(actionResult);
var result = Assert.IsAssignableFrom <ProductDTO>(actionResult.Value);
var dbItem = GetFakeCatalog(2).ElementAt(1);
Assert.Equal(dbItem.Name, result.Name);
Assert.Equal(dbItem.Description, result.Description);
Assert.Equal(dbItem.ImgUri, result.ImgUri);
Assert.Equal(dbItem.Price, result.Price);
}
public async Task <ActionResult <bool> > Upload(int productId)
{
try
{
var existingProduct = _catalogContext.CatalogItems
.Include(e => e.CatalogType)
.Single(e => e.Id == productId);
var subFolder = existingProduct.CatalogType.Type;
var file = Request.Form.Files[0];
string folderName = $"Pics/{subFolder}";
if (!Directory.Exists(folderName))
{
Directory.CreateDirectory(folderName);
}
if (file.Length > 0)
{
string fileName = ContentDispositionHeaderValue.Parse(file.ContentDisposition).FileName.Trim('"');
string fullPath = Path.Combine(folderName, fileName);
using (var stream = new FileStream(fullPath, FileMode.Create))
{
file.CopyTo(stream);
}
existingProduct.PictureName = subFolder + "/" + fileName;
_catalogContext.SaveChanges();
await searchRepository.UpdateAsync(productId, new { PicureName = subFolder + fileName });
}
return(true);
}
catch (System.Exception ex)
{
return(false);
}
}
public async Task GetOrderAndItemsByOrderId_When_MultipleOrdersPresent()
{
//Arrange
var itemOneUnitPrice = 5.50m;
var itemOneUnits = 2;
var itemTwoUnitPrice = 7.50m;
var itemTwoUnits = 5;
var firstOrder = OrderBuilder.WithDefaultValues();
_catalogContext.Orders.Add(firstOrder);
int firstOrderId = firstOrder.Id;
var secondOrderItems = new List <OrderItem>();
secondOrderItems.Add(new OrderItem(OrderBuilder.TestCatalogItemOrdered, itemOneUnitPrice, itemOneUnits));
secondOrderItems.Add(new OrderItem(OrderBuilder.TestCatalogItemOrdered, itemTwoUnitPrice, itemTwoUnits));
var secondOrder = OrderBuilder.WithItems(secondOrderItems);
_catalogContext.Orders.Add(secondOrder);
int secondOrderId = secondOrder.Id;
_catalogContext.SaveChanges();
//Act
var orderFromRepo = await _orderRepository.GetByIdWithItemsAsync(secondOrderId);
//Assert
Assert.Equal(secondOrderId, orderFromRepo.Id);
Assert.Equal(secondOrder.OrderItems.Count, orderFromRepo.OrderItems.Count);
Assert.Equal(1, orderFromRepo.OrderItems.Count(x => x.UnitPrice == itemOneUnitPrice));
Assert.Equal(1, orderFromRepo.OrderItems.Count(x => x.UnitPrice == itemTwoUnitPrice));
Assert.Equal(itemOneUnits, orderFromRepo.OrderItems.SingleOrDefault(x => x.UnitPrice == itemOneUnitPrice).Units);
Assert.Equal(itemTwoUnits, orderFromRepo.OrderItems.SingleOrDefault(x => x.UnitPrice == itemTwoUnitPrice).Units);
}
public static void InitializeDbForTests(CatalogContext db)
{
db.CatalogBrands.AddRange(GetPreconfiguredCatalogBrands());
db.CatalogTypes.AddRange(GetPreconfiguredCatalogTypes());
db.CatalogItems.AddRange(GetPreconfiguredItems());
db.SaveChanges();
}
private void OkButton_OnClick(object sender, RoutedEventArgs e)
{
database.SaveChanges();
DialogResult = true;
Close();
}
public void RegisterAccount(Account account)
{
using (CatalogContext context = new CatalogContext())
{
context.Accounts.Add(account);
context.SaveChanges();
}
}
public CategoryController(CatalogContext context)
{
_context = context;
if (_context.Categories.Count() == 0)
{
_context.Categories.Add(new Category {
Id = 1, Name = "Обувь", ParentId = 0
});
_context.Categories.Add(new Category {
Id = 2, Name = "Туфли женские", ParentId = 1
});
_context.Categories.Add(new Category {
Id = 3, Name = "Туфли мужские", ParentId = 1
});
_context.Categories.Add(new Category {
Id = 4, Name = "Открытые", ParentId = 2
});
_context.Categories.Add(new Category {
Id = 5, Name = "Закрытые", ParentId = 2
});
_context.Categories.Add(new Category {
Id = 6, Name = "Одежда", ParentId = 0
});
_context.Categories.Add(new Category {
Id = 7, Name = "Для женщин", ParentId = 6
});
_context.Categories.Add(new Category {
Id = 8, Name = "Платья", ParentId = 7
});
_context.Categories.Add(new Category {
Id = 9, Name = "Юбки", ParentId = 7
});
_context.Categories.Add(new Category {
Id = 10, Name = "Для мужчин", ParentId = 6
});
_context.Categories.Add(new Category {
Id = 11, Name = "Брюки", ParentId = 10
});
_context.Categories.Add(new Category {
Id = 12, Name = "Свитера", ParentId = 10
});
_context.Categories.Add(new Category {
Id = 13, Name = "Кроссовки", ParentId = 1
});
_context.Categories.Add(new Category {
Id = 14, Name = "Туфли детские", ParentId = 1
});
_context.Categories.Add(new Category {
Id = 15, Name = "Тапочки", ParentId = 1
});
_context.Categories.Add(new Category {
Id = 16, Name = "Сапоги", ParentId = 1
});
_context.SaveChanges();
}
}
//[HttpPost]
//public IActionResult Post(string sku, string quantity)
public IActionResult Post(string skuquantity)
{
var _sku = skuquantity.Substring(0, skuquantity.IndexOf("-"));
var _quantity = skuquantity.Substring(skuquantity.IndexOf("-") + 1);
Product item = _context.Products.Where(b => b.SKU.Contains(_sku)).First();
if (item == null)
{
return(NotFound());
}
//item.SKU = _sku;
item.Quantity = Convert.ToInt32(_quantity);
//item.Name = item.Name;
_context.Products.Update(item);
_context.SaveChanges();
return(Ok(item));
}
