public void Delete(int id) { var item = _context.Categorys.First(x => x.CategoryID == id); _context.Categorys.Remove(item); _context.SaveChanges(); }
public ActionResult PostCategory([FromBody] Category category) { if (!ModelState.IsValid) { return(BadRequest("Invalid data")); } var cats = from q in context.Categories select q; cats = cats.Where(q => q.Name.Equals(category.Name)); if (cats != null && cats.Any()) { return(BadRequest("Duplicate category name")); } context.Categories.Add(category); context.SaveChanges(); return(CreatedAtRoute( routeName: "GetCategory", routeValues: new { id = category.Id }, value: category)); }
public Categories Create(CreateCategoryRequest request) { var added = request.Adapt <Categories>(); _context.Categories.Add(added); _context.SaveChanges(); return(added); }
public ActionResult Create(Categoria category) // POST { if (ModelState.IsValid) { _context.Categorys.Add(category); _context.SaveChanges(); return(RedirectToAction("Index")); } return(View("Create", category)); }
public ActionResult Create(Category newCategory) { if (ModelState.IsValid) { _ctxCategory.Categories.Add(newCategory); _ctxCategory.SaveChanges(); return(RedirectToAction("Index")); } return(View(newCategory)); }
public void ProcessRequest(HttpContext context) { CategoryContext categoryContext = new CategoryContext(); String userName = context.Request.QueryString["uname"].ToString(); String url = context.Request.QueryString["url"].ToString(); String type = context.Request.QueryString["type"].ToString(); if (type.Equals("rss")) { String ctyname = context.Request.QueryString["ctyname"].ToString(); Category category = categoryContext.Categories.Where(c => c.Name.ToString().Equals(ctyname)).FirstOrDefault(); var reader = XmlReader.Create(url); var feed = SyndicationFeed.Load(reader); String title = feed.Title.Text.ToString(); Rss rss = new Rss { Name = title, UserName = userName, Url = url }; category.Rsses.Add(rss); categoryContext.SaveChanges(); } else if (type.Equals("essay")) { String fvtname = context.Request.QueryString["fvtname"].ToString(); Favourite favourite = categoryContext.Favourites.Where(f => (f.UserName.ToString().Equals(userName) && f.Name.ToString().Equals(fvtname))).FirstOrDefault(); List <String> tad = getWebTitleAndDescription(url); String title = tad[0]; String description = tad[1]; Essay essay = new Essay { Url = url, Title = title, Description = description }; favourite.Essays.Add(essay); categoryContext.SaveChanges(); } //context.Response.ContentType = "text/plain"; //context.Response.Write(""); }
public ActionResult Create([Bind(Include = "IdCategory,Title")] Category category) { if (ModelState.IsValid) { db.Categories.Add(category); db.SaveChanges(); return(RedirectToAction("Main", "Home")); } return(View(category)); }
public ActionResult Create([Bind(Include = "Cat_id,Cat_title")] Category category) { if (ModelState.IsValid) { db.Categories.Add(category); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(category)); }
public ActionResult Create(Category category) { try { _context.Categories.Add(category); _context.SaveChanges(); return(RedirectToAction("Index")); } catch (Exception e) { return(View(category)); } }
public void ProcessRequest(HttpContext context) { CategoryContext categoryContext = new CategoryContext(); String str = context.Request.QueryString["str"]; String str2 = context.Request.QueryString["uname"]; String type = context.Request.QueryString["type"]; if (type.Equals("cty")) { Category category = new Category { //Id = categoryContext.Configs.ToList<Config>()[0].max_cty_id, Name = str, UserName = str2 }; categoryContext.Categories.Add(category); } else if (type.Equals("fvt")) { Favourite favorite = new Favourite { //Id = categoryContext.Configs.ToList<Config>()[0].max_cty_id, Name = str, UserName = str2 }; categoryContext.Favourites.Add(favorite); } categoryContext.SaveChanges(); }
public JsonResult InsertCategory(Category category) { using (CategoryContext entities = new CategoryContext()) { entities.Categories.Add(category); entities.SaveChanges(); } return(Json(category)); }
public ActionResult Create([Bind(Include = "title, is_published")] Category categoey) { try { if (ModelState.IsValid) { categoey.created_at = DateTime.Now; categoey.modified_at = DateTime.Now; db.Categories.Add(categoey); db.SaveChanges(); return(RedirectToAction("Index")); } } catch { ModelState.AddModelError("", "Unable to save changes. Try again."); } return(View(categoey)); }
public ActionResult DeleteCategory(int prodID) { using (CategoryContext entities = new CategoryContext()) { Category product = (from c in entities.Categories where c.CategoryID == prodID select c).FirstOrDefault(); entities.Categories.Remove(product); entities.SaveChanges(); } return(new EmptyResult()); }
/// <summary> /// I denne klasse opstilles der funktioner til at tilføje data til min database, /// når mit projekt startes. Dette bliver typisk kaldt for at 'Seed' en database. /// Jeg valgte at oprette en SeedData klasse så at der er noget data at teste med, /// frem for at mine API er tomme, og skal fyldes manuelt. /// </summary> /// <param name="serviceProvider"></param> public static void AddCategories(IServiceProvider serviceProvider) { ///<summary> /// Her specificeres hvilken service og context som skal bruges. /// IServiceProvider bruges til at hente vores context, som her er Category, /// som er påkrævet for at jeg kan tilføje nye dataobjekter. ///</summary> using (var context = new CategoryContext( serviceProvider.GetRequiredService <DbContextOptions <CategoryContext> >())) { /// <summary> /// Vi bruger denne 'if' statement for at tjekke om der er nogen data elementer /// gemt via. vores context. Hvis der er, bliver de returneret. /// </summary> if (context.Categories.Any()) { return; } /// <summary> /// Her tilføjer jeg nye data elementer gennem min context. /// 'AddRange' lader mig tilføje flere elementer ad gangen, /// og vil så holde på dem indtil vi har gemt dem til databasen. /// </summary> context.Categories.AddRange( new Category { Name = "Beverages", Description = "Liquid beverages in various packaging. Includes juices, soft drinks, etc." }, new Category { Name = "Salty Snacks", Description = "Bagged salty snackfoods. Includes various chips, nuts, etc." }, new Category { Name = "Frozen Vegetables", Description = "Bagged frozen vegetable. Must be kept cool until used." }, new Category { Name = "Sweets", Description = "Sweet baked goods and candy." } ); /// <summary> /// Her gemmer vi vores ændringer, så at vores elementer /// nu vil bliver tilføjet til databasen. /// </summary> context.SaveChanges(); } }
public CategoryController(CategoryContext context) { _context = context; if (_context.GetCategories.Count() == 0) { _context.GetCategories.Add(new Category { Name = "Beer" }); _context.SaveChanges(); } }
public CategoryController(CategoryContext context) { _context = context; if (_context.Category.Count() == 0) { _context.Category.Add(new Category { Name = "Cat1" }); _context.SaveChanges(); } }
public JsonResult Insert([FromBody] Category item) { if (item != null) { try { Category apointment = new Category { Name = item.Name, Description = item.Description, }; var insertedItem = _context.Add <Category>(apointment); _context.SaveChanges(); return(Json(insertedItem.Entity)); } catch (Exception e) { return(Json(e.Message)); } } return(Json("Error")); }
public CategoriesController(CategoryContext _context) { context = _context; if (context.Categories.Count() == 0) { context.Categories.Add(new Category { Name = "Groceries" }); context.Categories.Add(new Category { Name = "Entertainment" }); context.SaveChanges(); } }
public ActionResult UpdateCategory(Category category) { using (CategoryContext entities = new CategoryContext()) { Category updatedCategory = (from c in entities.Categories where c.CategoryID == category.CategoryID select c).FirstOrDefault(); updatedCategory.CategoryName = category.CategoryName; entities.SaveChanges(); } using (ProductContext entities = new ProductContext()) { List <Product> updatedProduct = (from c in entities.Products where c.CategoryID == category.CategoryID select c).ToList(); foreach (var p in updatedProduct) { p.CategoryName = category.CategoryName; } entities.SaveChanges(); } return(new EmptyResult()); }
public void Delete(Category category) { category.Archived = true; categoryContext.SaveChanges(); }
public void Save() { _dbContext.SaveChanges(); }
public static void Initialize(CategoryContext context) { if (!context.Types.Any()) { context.Types.AddRange(Types.Select(f => f.Value)); } context.SaveChanges(); if (!context.Categories.Any()) { context.Categories.AddRange( new Category { Name = "Еда", Type = Types["Общие"] }, new Category { Name = "Техника", Type = Types["Общие"] }, new Category { Name = "Билеты", Type = Types["Командировки"] }, new Category { Name = "Такси", Type = Types["Командировки"] }, new Category { Name = "Проживание", Type = Types["Командировки"] }, new Category { Name = "Питание", Type = Types["Командировки"] }, new Category { Name = "Аренда", Type = Types["Корпоратив"] }, new Category { Name = "Еда", Type = Types["Корпоратив"] }, new Category { Name = "Напитки", Type = Types["Корпоратив"] }, new Category { Name = "Алкоголь", Type = Types["Корпоратив"] } ); } context.SaveChanges(); if (!context.Users.Any()) { context.Users.AddRange( new User { Name = "Дмитрий", Surname = "Рогожников", Middlename = "Юрьевич" }, new User { Name = "Семен", Surname = "Щелков", Middlename = "Алексеевич" }, new User { Name = "Василий", Surname = "Пупкин", Middlename = null }); } context.SaveChanges(); if (!context.Bills.Any()) { var users = context.Users; context.Bills.AddRange( new Bill { TotalSum = 0, User = users.FirstOrDefault(f => f.Id == 1) }, new Bill { TotalSum = 0, User = users.FirstOrDefault(f => f.Id == 2) }, new Bill { TotalSum = 0, User = users.FirstOrDefault(f => f.Id == 3) } ); } context.SaveChanges(); if (!context.Expenses.Any()) { var bills = context.Bills; context.Expenses.AddRange( new Expense { Bill = bills.FirstOrDefault(f => f.UserId == 1), Type = Types["Общие"], Category = context.Categories.FirstOrDefault(f => f.Type == Types["Общие"] && f.Name == "Еда"), Sum = 12300, Paid = 0, Description = "Sample Desctiption for this", Cheque = "Link to cheque 1" }, new Expense { Bill = bills.FirstOrDefault(f => f.UserId == 1), Type = Types["Корпоратив"], Category = context.Categories.FirstOrDefault(f => f.Type == Types["Корпоратив"] && f.Name == "Алкоголь"), Sum = 1300, Paid = 0, Description = "Sample Desctiption for PIVO", Cheque = "Link to cheque 2" }, new Expense { Bill = bills.FirstOrDefault(f => f.UserId == 2), Type = Types["Командировки"], Category = context.Categories.FirstOrDefault(f => f.Type == Types["Командировки"] && f.Name == "Билеты"), Sum = 15236.31, Paid = 236.31, Description = "Sample Desctiption for командировки", Cheque = "Link to cheque 1" }, new Expense { Bill = bills.FirstOrDefault(f => f.UserId == 3), Type = Types["Общие"], Category = context.Categories.FirstOrDefault(f => f.Type == Types["Общие"] && f.Name == "Техника"), Sum = 322.28, Paid = 0, Description = "Sample Description for general", Cheque = "Link to cheque 1" } ); context.SaveChanges(); } }
public ProductsController(CategoryContext context) { db = context; //db.Categories.Add(new Category { CategoryName = "Sneakers" }); //db.Categories.Add(new Category { CategoryName = "Sliders" }); //db.Categories.Add(new Category { CategoryName = "Shoes" }); //db.Categories.Add(new Category { CategoryName = "Boots" }); db.Products.Add(new Product { Title = "Nike Free", Subtitle = "Nike Air Max", Price = 139.99, Description = dummyText, Image = "assets/images/nike.png", CategoryName = "Sneakers" }); db.Products.Add(new Product { Title = "Jordan", Subtitle = "Nike Air Max", Price = 239.99, Description = dummyText, Image = "assets/images/air1.png", CategoryName = "Sneakers" }); db.Products.Add(new Product { Title = "Old Scool", Subtitle = "VANS", Price = 59.99, Description = dummyText, Image = "assets/images/vans.png", CategoryName = "Sneakers" }); db.Products.Add(new Product { Title = "Supreme", Subtitle = "Nike Air Max", Price = 559.99, Description = dummyText, Image = "assets/images/air3.png", CategoryName = "Sneakers" }); db.Products.Add(new Product { Title = "Superstar", Subtitle = "Adidas", Price = 129.99, Description = dummyText, Image = "assets/images/adidas.png", CategoryName = "Sneakers" }); db.Products.Add(new Product { Title = "Air Force", Subtitle = "Nike", Price = 169.99, Description = dummyText, Image = "assets/images/nike2.png", CategoryName = "Sneakers" }); db.Products.Add(new Product { Title = "Nike Run", Subtitle = "Nike", Price = 229.99, Description = dummyText, Image = "assets/images/nike3.png", CategoryName = "Sneakers" }); db.Products.Add(new Product { Title = "Jordan Red", Subtitle = "Nike Air Max", Price = 159.99, Description = dummyText, Image = "assets/images/air2.png", CategoryName = "Sneakers" }); db.Products.Add(new Product { Title = "Nike R", Subtitle = "Nike", Price = 99.99, Description = dummyText, Image = "assets/images/nike4.png", CategoryName = "Sneakers" }); db.Products.Add(new Product { Title = "Puma Skate", Subtitle = "Puma", Price = 89.99, Description = dummyText, Image = "assets/images/puma.png", CategoryName = "Sneakers" }); db.Products.Add(new Product { Title = "Jordan Gold", Subtitle = "Nike Air Max", Price = 459.99, Description = dummyText, Image = "assets/images/air4.png", CategoryName = "Sneakers" }); db.Products.Add(new Product { Title = "Nike Free", Subtitle = "Nike Air Max", Price = 139.99, Description = dummyText, Image = "assets/images/slid1.png", CategoryName = "Sliders" }); db.Products.Add(new Product { Title = "Jordan", Subtitle = "Nike Air Max", Price = 239.99, Description = dummyText, Image = "assets/images/slid2.png", CategoryName = "Sliders" }); db.Products.Add(new Product { Title = "Old Scool", Subtitle = "VANS", Price = 59.99, Description = dummyText, Image = "assets/images/slid3.png", CategoryName = "Sliders" }); db.Products.Add(new Product { Title = "Supreme", Subtitle = "Nike Air Max", Price = 559.99, Description = dummyText, Image = "assets/images/shoes1.png", CategoryName = "Shoes" }); db.Products.Add(new Product { Title = "Superstar", Subtitle = "Adidas", Price = 129.99, Description = dummyText, Image = "assets/images/shoes2.png", CategoryName = "Shoes" }); db.Products.Add(new Product { Title = "Air Force", Subtitle = "Nike", Price = 169.99, Description = dummyText, Image = "assets/images/shoes3.png", CategoryName = "Shoes" }); db.Products.Add(new Product { Title = "Nike Run", Subtitle = "Nike", Price = 229.99, Description = dummyText, Image = "assets/images/shoes4.png", CategoryName = "Shoes" }); db.Products.Add(new Product { Title = "Jordan Red", Subtitle = "Nike Air Max", Price = 159.99, Description = dummyText, Image = "assets/images/boots1.png", CategoryName = "Boots" }); db.Products.Add(new Product { Title = "Nike R", Subtitle = "Nike", Price = 99.99, Description = dummyText, Image = "assets/images/boots2.png", CategoryName = "Boots" }); db.Products.Add(new Product { Title = "Puma Skate", Subtitle = "Puma", Price = 89.99, Description = dummyText, Image = "assets/images/boots3.png", CategoryName = "Boots" }); db.Products.Add(new Product { Title = "Jordan Gold", Subtitle = "Nike Air Max", Price = 459.99, Description = dummyText, Image = "assets/images/boots4.png", CategoryName = "Boots" }); db.SaveChanges(); }