public void DelLabel(int id, string label) { var ctx = new ShopContext(); var temp = ctx.Label.Where(x => x.Id == id).FirstOrDefault(); temp.Name = label; ctx.SaveChanges(); }
public void AddLabel(string label) { var ctx = new ShopContext(); var temp = new Label(); temp.Name = label; ctx.Label.Add(temp); ctx.SaveChanges(); }
private void dtGrSale_CellClick(object sender, DataGridViewCellEventArgs e) { txtHiddenId.Text = dtGrSale.Rows[e.RowIndex].Cells["Id"].Value.ToString(); var ctx = new ShopContext(); var temp = dtGrSale.Rows[e.RowIndex].Cells["Name"].Value.ToString(); txtHiddenIdProduct.Text = ctx.Product.Where(x => x.Name == temp).FirstOrDefault().Id.ToString(); txtHiddenCount.Text = dtGrSale.Rows[e.RowIndex].Cells["Count"].Value.ToString(); }
public List<DataViewLabel> GetAllLabel() { var ctx = new ShopContext(); var result = ctx.Label.Select(x => new DataViewLabel() { Id = x.Id, NameLabel = x.Name }).ToList(); return result; }
public bool DeleteProduct(int id) { try { var ctx = new ShopContext(); ctx.Product.Remove(ctx.Product.Where(x => x.Id == id).FirstOrDefault()); ctx.SaveChanges(); return true; } catch (Exception) { return false; } }
public List<DataViewSaleProduct> GetAllSale() { var ctx = new ShopContext(); var result = ctx.SaleProduct.Select(x => new DataViewSaleProduct() { Id = x.Id, LabelName = x.Label.Name, Name = x.Name, Count = x.Count, Price = x.Price, Discount = x.Discount, DateTimeSale = x.DateTimeSale }).ToList(); return result; }
public bool DelSale(int id, int count) { try { var ctx = new ShopContext(); var temp = ctx.Product.Where(x => x.Id == id).FirstOrDefault(); temp.Count += count; ctx.SaveChanges(); return true; } catch (Exception) { return false; } }
public bool AddProduct(Product product, string label) { try { var ctx = new ShopContext(); var temp = ctx.Label.Where(x => x.Name == label).SingleOrDefault(); product.Label = temp; ctx.Product.Add(product); ctx.SaveChanges(); return true; } catch (Exception) { return false; } }
public bool AddSale(SaleProduct sale, string label) { try { var ctx = new ShopContext(); var temp = ctx.Label.Where(x => x.Name == label).FirstOrDefault(); sale.Label = temp; sale.Price = (sale.Price * sale.Count) - sale.Discount; ctx.SaleProduct.Add(sale); ctx.SaveChanges(); return true; } catch (Exception) { return false; } }
private void btnAdd_Click(object sender, EventArgs e) { try { if (MessageBox.Show("Добавить этот товар?", "Добавить", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes) { return; } else { var ctx = new ShopContext(); var helper = new Product() { Name = txtNameProduct.Text.ToString(), Volume = Convert.ToInt32(txtVolumeProduct.Text), Price = Convert.ToInt32(txtPriceProduct.Text), Count = Convert.ToInt32(txtСountProduct.Text) }; var temp = new ProductManager(); if (temp.AddProduct(helper, cmbLabel.Text.ToString())) { dtGridProducts.DataSource = temp.GetAllProduct(); txtCountProductGrid.Text = temp.GetAllProductCount(temp.GetAllProduct()).ToString(); txtAllPriceGrid.Text = temp.GetAllProductPrice(temp.GetAllProduct()).ToString(); MessageBox.Show("Товар добавлен!"); } else { MessageBox.Show("Упс! Что-то пошло не так!"); } } } catch (Exception) { MessageBox.Show("Упс! Что-то пошло не так!"); } }
private void cmbLabel_Click(object sender, EventArgs e) { try { var ctx = new ShopContext(); txtHiddenIdLabel.Text = ctx.Label.Where(x => x.Name == cmbLabel.Text).FirstOrDefault().Id.ToString(); } catch (Exception) { //throw; } }
public bool SaveProduct(Product product, string label) { try { var ctx = new ShopContext(); var temp = ctx.Label.Where(x => x.Name == label).FirstOrDefault(); var tempProduct = ctx.Product.Where(x => x.Id == product.Id).FirstOrDefault(); tempProduct.Label = temp; tempProduct.Name = product.Name; tempProduct.Volume = product.Volume; tempProduct.Price = product.Price; tempProduct.Count = product.Count; ctx.SaveChanges(); return true; } catch (Exception) { return false; } }
public List<DataViewSaleProduct> GetSaleBetween(DateTime dateBegin, DateTime dateEnd) { var ctx = new ShopContext(); var tempSale = ctx.SaleProduct.Where(x => (x.DateTimeSale >= dateBegin.Date)).ToList(); var tempResult = tempSale.Where(x => x.DateTimeSale < dateEnd.Date.AddDays(1).Date).ToList(); var result = tempResult.Select(x => new DataViewSaleProduct() { Id = x.Id, LabelName = x.Label.Name, Name = x.Name, Price = x.Price, Discount = x.Discount, Count = x.Count, DateTimeSale = x.DateTimeSale }).ToList(); return result; }
public List<DataViewSaleProduct> GetSaleToday(DateTime date) { var ctx = new ShopContext(); var temp = ctx.SaleProduct.Where(x => x.DateTimeSale > date.Date).ToList(); var result = temp.Select(x => new DataViewSaleProduct() { Id = x.Id, LabelName = x.Label.Name, Name = x.Name, Price = x.Price, Discount = x.Discount, Count = x.Count, DateTimeSale = x.DateTimeSale }).ToList(); return result; }
private void dtGridProducts_CellClick(object sender, DataGridViewCellEventArgs e) { try { txtHiddenId.Text = dtGridProducts.Rows[e.RowIndex].Cells["Id"].Value.ToString(); txtNameProduct.Text = dtGridProducts.Rows[e.RowIndex].Cells["Name"].Value.ToString(); txtVolumeProduct.Text = dtGridProducts.Rows[e.RowIndex].Cells["Volume"].Value.ToString(); txtPriceProduct.Text = dtGridProducts.Rows[e.RowIndex].Cells["Price"].Value.ToString(); txtСountProduct.Text = dtGridProducts.Rows[e.RowIndex].Cells["Count"].Value.ToString(); var tempNameLabel = dtGridProducts.Rows[e.RowIndex].Cells["LabelName"].Value.ToString(); var ctx = new ShopContext(); cmbLabel.SelectedValue = ctx.Label.Where(x => x.Name == tempNameLabel).FirstOrDefault().Id; txtDiscount.Text = "0"; txtHiddenIndex.Text = dtGridProducts.CurrentRow.Index.ToString(); } catch (Exception) { MessageBox.Show("Но-но-но!!"); } }
public List<DataViewProducts> GetProductLabel(string label) { var ctx = new ShopContext(); var helper = ctx.Label.Where(x => x.Name == label).FirstOrDefault(); var temp = ctx.Product.Where(m => m.Label.Name == helper.Name).ToList(); var result = temp.Select(x => new DataViewProducts() { Id = x.Id, LabelName = x.Label.Name, Name = x.Name, Volume = x.Volume, Price = x.Price, Count = x.Count }).ToList(); return result; }
private void btnUpdate_Click(object sender, EventArgs e) { try { if (MessageBox.Show("Изменить этот товар?", "Изменить", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes) { return; } else { var ctx = new ShopContext(); var helper = new Product() { Id = Convert.ToInt32(txtHiddenId.Text), Name = txtNameProduct.Text.ToString(), Volume = Convert.ToInt32(txtVolumeProduct.Text), Price = Convert.ToInt32(txtPriceProduct.Text), Count = Convert.ToInt32(txtСountProduct.Text) }; var temp = new ProductManager(); if (temp.SaveProduct(helper, cmbLabel.Text.ToString())) { dtGridProducts.DataSource = temp.GetAllProduct(); if (Convert.ToInt32(txtHiddenIndex.Text) < dtGridProducts.RowCount) { dtGridProducts.ClearSelection(); dtGridProducts.Rows[Convert.ToInt32(txtHiddenIndex.Text)].Selected = true; dtGridProducts.FirstDisplayedScrollingRowIndex = Convert.ToInt32(txtHiddenIndex.Text); dtGridProducts.Update(); } txtCountProductGrid.Text = temp.GetAllProductCount(temp.GetAllProduct()).ToString(); txtAllPriceGrid.Text = temp.GetAllProductPrice(temp.GetAllProduct()).ToString(); MessageBox.Show("Товар изменен"); } else { MessageBox.Show("Упс! Что-то пошло не так!"); } } } catch (Exception) { MessageBox.Show("Упс! Что-то пошло не так!"); } }
public List<DataViewProducts> GetAllProduct() { var ctx = new ShopContext(); var result = ctx.Product.Select(x => new DataViewProducts() { Id = x.Id, LabelName = x.Label.Name, Name = x.Name, Volume = x.Volume, Price = x.Price, Count = x.Count }).ToList(); return result; }
public void ZeroCountProduct() { var ctx = new ShopContext(); foreach (var item in ctx.Product) { item.Count = 0; } ctx.SaveChanges(); }