public IActionResult GetAll() { ProductsVM model = new ProductsVM(); model.products = _productRepo.GetAll(); return(View(model)); }
private void FormControlleriDoldur() { PackageRepo db = new PackageRepo(); ProductRepo dbpro = new ProductRepo(); var seciliPaket = lstOrder.SelectedItem as Package; foreach (var item in db.GetAll()) { if (item.ProductId == seciliPaket.ProductId) { cmbPackageProduct.SelectedItem = item.Product; txtPackageBarcode.Text = item.PackageBarcode; txtPackageName.Text = item.PackageName; nmOrderQuantity.Value = item.PackageProductQuantity; foreach (var item1 in dbpro.GetAll()) { if (item1.ProductPurchasingPrice == seciliPaket.PackagePurchasingPrice) { txtOrderPackagePrice.Text = (item1.ProductPurchasingPrice * item.PackageProductQuantity).ToString(); } } } } }
private void LoadProduct() { var list = _ProductRepo.GetAll(); ddlProduct.DataSource = list; ddlProduct.DataBind(); }
public static void DoReadOnly(Form form) { ProductRepo db = new ProductRepo(); foreach (Control control in form.Controls) { if (control is TextBox txt) { txt.ReadOnly = true; } else if (control is NumericUpDown nm) { nm.Enabled = false; } else if (control is ComboBox cmb) { foreach (var item in db.GetAll()) { if ((cmb.SelectedItem.GetType() == item.GetType())) { cmb.Enabled = false; break; } } } } }
public void CreateProduct() { //List<Product> productList = new List<Product>(repository.GetAll().ToList()); //List<Product> products = repository.GetAll().ToList(); ; //int count = repository.Count(); var p = repository.GetAll(); int c = 0; //foreach (var product in products) //{ // count++; //} //Product product = new Product //{ // Category = "Smartphone", // Name = "Name", // Price = Convert.ToDecimal(55.99), //}; //repository.Create(product); //Product productTest = productList[productList.Count - 1]; //Assert.AreEqual(productTest, product); }
public void When呼叫GetAll() { var dbContext = ScenarioContext.Current.Get <string>("dbContext"); var target = new ProductRepo(dbContext); var actual = target.GetAll(); ScenarioContext.Current.Set(actual, "actual"); }
private void LoadProduct() { var list = _ProductRepo.GetAll(); ddlProduct.DataSource = list; ddlProduct.DataBind(); ddlProduct.SelectedValue = id.ToString(); }
public Dictionary <string, Dictionary <string, double> > AnnualProfitForProducts(int year, Expression <Func <Product, bool> > productPredicate = null) { Dictionary <string, Dictionary <string, double> > Report = new Dictionary <string, Dictionary <string, double> >(); List <Product> Product = ProductRepo.GetAll(productPredicate).ToList(); Product.ForEach(x => { Report.Add(x.Name, AnnualProfitForProduct(x.Id, year)); }); return(Report); }
public ProductLModel Build() { _viewModel.PageTitle = "Employee List"; _viewModel.MetaDescription = "This is the Employee List Page"; var repo = new ProductRepo("AdventureWorks"); _viewModel.ProductList = repo.GetAll(); return(_viewModel); }
public Dictionary <string, Dictionary <string, double> > SalesForProducts(Expression <Func <Product, bool> > productPredicate = null) { Dictionary <string, Dictionary <string, double> > Report = new Dictionary <string, Dictionary <string, double> >(); List <Product> Product = new List <Product>(); Product = ProductRepo.GetAll(productPredicate).ToList(); Product.ForEach(x => { Report.Add(x.Name, SalesForProduct(x.Id)); }); return(Report); }
public ActionResult Index() { ViewBag.profits = ProfitLogic.GetProfitForProducts(x => x.StoreId == LoggedInUser.StoreId).Sum(x => x.ProfitsForProductInYear.Sum(y => y.ProfitsPerMonth.Sum(z => z.Value))); ViewBag.sales = SalesL.GetSalesForProducts(x => x.StoreId == LoggedInUser.StoreId).Sum(x => x.TransactionsForProductInYear.Sum(y => y.TransactionsPerMonth.Sum(z => z.Value))); ViewBag.transactions = TransactionRepo.GetAll(x => x.Batch.Product.StoreId == LoggedInUser.StoreId).Count(); ViewBag.products = ProductRepo.GetAll(x => x.StoreId == LoggedInUser.StoreId).Count(); ProfitLogic.GetProfitForProducts(x => x.StoreId == LoggedInUser.StoreId); return(View()); }
public void GetAll_WhenInvoked_ReturnsTheFullListOfAvailableProducts() { // Arrange var subject = new ProductRepo(products); // Act var result = subject.GetAll(); // Assert Assert.IsTrue(products.All(p => result.Any(r => r.Name == p.Name))); }
private void PaketleriGetirMalKabul() { if (cmbGoodsAcceptanceOrders.SelectedIndex == -1) { return; } ProductRepo dbpro = new ProductRepo(); OrderRepo dbord = new OrderRepo(); PackageRepo dbpck = new PackageRepo(); var orders = new List <OrderViewModel>(); try { foreach (var item in dbord.GetAll()) { if (item.OrderId == (cmbGoodsAcceptanceOrders.SelectedItem as Order).OrderId) { foreach (var item1 in dbpck.GetAll()) { if (item1.OrderId == item.OrderId) { foreach (var item2 in dbpro.GetAll()) { if (item2.ProductId == item1.ProductId) { orders.Add(new OrderViewModel() { PackageName = item1.PackageName, PackageBarcode = item1.PackageBarcode, PackageId = item1.PackageId, ProductId = item2.ProductId, ProductStock = item2.ProductStock, PackageProductQuantity = item1.PackageProductQuantity }); } } } } } } } catch (Exception ex) { MessageBox.Show(ex.Message); } cmbOrderProduct.Items.Clear(); cmbOrderProduct.Items.AddRange(orders.ToArray()); }
public List <TransactionsForProduct> GetTransactionsForProducts(Expression <Func <Product, bool> > ProductPredicate = null, Expression <Func <Transaction, bool> > transactionPredicate = null) { List <TransactionsForProduct> SaleRecordsForProducts = new List <TransactionsForProduct>(); IEnumerable <Product> Products = ProductPredicate == null?ProductRepo.GetAll() : ProductRepo.GetAll().Where(ProductPredicate); Dictionary <int, Dictionary <Month, double> > TurnoverPerYear = new Dictionary <int, Dictionary <Month, double> >(); foreach (var item in Products) { SaleRecordsForProducts.Add(GetTransactionsForProduct(item.Id, out TurnoverPerYear, transactionPredicate)); } return(SaleRecordsForProducts); }
public Dictionary <string, Dictionary <TransactionType, int> > GetSalesToAuctionInformationForProducts(Expression <Func <Product, bool> > ProductPredicate = null) { Dictionary <string, Dictionary <TransactionType, int> > SalesToAuctionInfoForProducts = new Dictionary <string, Dictionary <TransactionType, int> >(); Product[] Product = ProductPredicate == null?ProductRepo.GetAll().ToArray() : ProductRepo.GetAll().Where(ProductPredicate).ToArray(); foreach (var item in Product) { SalesToAuctionInfoForProducts.Add(item.Name, GetSalesToAuctionInformationForProduct(item.Id)); } return(SalesToAuctionInfoForProducts); }
public List <ProfitsForProduct> GetProfitForProducts(Expression <Func <Product, bool> > ProductPredicate = null) { List <ProfitsForProduct> ProfitRecordsForProducts = new List <ProfitsForProduct>(); IEnumerable <Product> Products = ProductPredicate == null?ProductRepo.GetAll() : ProductRepo.GetAll().Where(ProductPredicate); if (Products != null) { Products.ToList().ForEach(m => { ProfitRecordsForProducts.Add(GetProfitForProduct(m.Id)); }); } return(ProfitRecordsForProducts); }
public CWUnrecognizedProductViewModel(ApplicationContext context, string fileName, Window view, string ean13) { ImageSource = new BitmapImage(); ImageSource.BeginInit(); ImageSource.UriSource = new Uri(fileName); ImageSource.EndInit(); this.FilterCommand = new DelegateCommand(FilterAction, canFilter); this.CloseCommand = new DelegateCommand(CloseAction); this.ValidateCommand = new DelegateCommand(ValidateAction, canValidate); this.View = view; this.AllProducts = ProductRepo.GetAll().OrderBy(o => o.Libelle).ToList(); this.EanCode = ean13; }
private void btnProductAdd_Click(object sender, EventArgs e) { bool varMi = false; try { using (var productRepo = new ProductRepo()) { foreach (var item in productRepo.GetAll()) { if (item.ProductName.ToLower() == (txtProductName.Text).ToLower()) { varMi = true; break; } } if (varMi == false) { Product product = new Product() { CategoryId = (cmbCategory.SelectedItem as Category).CategoryId, ProductName = txtProductName.Text, ProductBarcode = txtProductBarcode.Text, ProductPurchasingPrice = Convert.ToDecimal(txtProductPurchasingPrice.Text), ProductSellingPrice = 0, ProductStock = 0 }; productRepo.Insert(product); MessageBox.Show($"{product.ProductName} Ürünü Eklendi"); System.Threading.Thread.Sleep(500); this.Close(); } else { MessageBox.Show("Bu isimde Ürün zaten mevcuttur."); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btnUpdate_Click(object sender, EventArgs e) { if (lstOrder.SelectedIndex == -1) { return; } PackageRepo packagedb = new PackageRepo(); ProductRepo productdb = new ProductRepo(); var seciliPaketGuncelle = lstOrder.SelectedItem as Package; foreach (var item in packagedb.GetAll()) { if (item.ProductId == seciliPaketGuncelle.ProductId) { foreach (var item2 in productdb.GetAll()) { if (item2.ProductId == seciliPaketGuncelle.ProductId) { item2.ProductStock = Convert.ToInt32(nmOrderQuantity.Value); item2.ProductSellingPrice = (item2.ProductPurchasingPrice * (1 + 0.18m)); } } break; } } seciliPaketGuncelle.PackageName = txtPackageName.Text; seciliPaketGuncelle.ProductId = (cmbPackageProduct.SelectedItem as Product).ProductId; seciliPaketGuncelle.OrderId = (cmbOrderName.SelectedItem as Order).OrderId; seciliPaketGuncelle.PackagePurchasingPrice = Convert.ToDecimal(txtOrderPackagePrice.Text); seciliPaketGuncelle.PackageProductQuantity = Convert.ToInt32(nmOrderQuantity.Value); seciliPaketGuncelle.PackageBarcode = txtPackageBarcode.Text; SiparisFiyatHesapla(); packagedb.Update(); productdb.Update(); PaketleriGetir(); MessageBox.Show($"Güncelleme başarılı"); }
private void btdelete_Click(object sender, EventArgs e) { if (gvbrand.SelectedRows.Count == 0) { MessageBox.Show("Tidak ada brand yang akan dihapus"); } else { //var id = Convert.ToInt32(gvbrand.Rows[gvbrand.CurrentCell.RowIndex].Cells["id"].Value); var selectedRowId = (int)gvbrand.SelectedRows[0].Cells["id"].Value; if (selectedRowId == 1) { MessageBox.Show("Anda tidak dibenarkan menghapus brand Lain-Lain"); } else { ListProducts = productRepo.GetAll(); var product = ListProducts.FirstOrDefault(x => x.brandid == selectedRowId); if (product == null) { var form = new ConfirmationDialog(); form.Message = "Apa anda yakin menghapus brand terpilih?"; form.ShowDialog(); if (form.YES) { if (!brandRepository.Delete(selectedRowId)) { MessageBox.Show("Gagal menghapus brand"); } LoadData(); } } else { MessageBox.Show("Anda tidak dibenarkan menghapus brand yang masih memiliki barang"); } } } }
public ActionResult Index(ProductCategory?category, int page = 1) { var UnorderedProducts = repo.GetAll(); if (category != null) { UnorderedProducts = UnorderedProducts.Where(p => p.Category == category.ToString()).ToList(); } ProductsListViewModel model = new ProductsListViewModel { Products = UnorderedProducts.OrderBy(p => p.ProductId).Skip((page - 1) * PageSize).Take(PageSize), PagingInfo = new PagingInfo { CurrentPage = page, ItemsPerPage = PageSize, TotalItems = UnorderedProducts.Count() }, CurrentCategory = category }; return(View(model)); }
private void lstProduct_SelectedIndexChanged(object sender, EventArgs e) { if (lstProduct.SelectedItem == null) { return; } seciliSepet = lstProduct.SelectedItem as SepetViewModel; nmQuantity.Value = seciliSepet.Quantity; ProductRepo db = new ProductRepo(); foreach (var item in db.GetAll()) { if (item.ProductId == (seciliSepet).ProductId) { cmbProductBarcode.Text = (item.ProductBarcode) + " - " + item.ProductName; } } }
private void btdelete_Click(object sender, EventArgs e) { if (gvcategories.SelectedRows.Count == 0) { MessageBox.Show("Tidak ada kategori yang akan dihapus"); } else { var selectedRowId = (int)gvcategories.SelectedRows[0].Cells["id"].Value; if (selectedRowId == 1) { MessageBox.Show("Anda tidak dibenarkan menghapus kategori Lain-Lain"); } else { ListProducts = productRepo.GetAll(); var product = ListProducts.FirstOrDefault(x => x.prodcat == selectedRowId); if (product == null) { var form = new ConfirmationDialog(); form.Message = "Apa anda yakin menghapus kategori terpilih?"; form.ShowDialog(); if (form.YES) { if (!categoryRepository.Delete(selectedRowId)) { MessageBox.Show("Gagal menghapus kategori"); } LoadData(); } } else { MessageBox.Show("Anda tidak dibenarkan menghapus kategori yang masih memiliki barang"); } } } }
public IEnumerable <Product> GetAllProducts() { return(productRepo.GetAll()); }
public List <Product> GetAll() { return(_productRepo.GetAll()); }
public IEnumerable <Product> Get() { return(_repo.GetAll()); }
public IEnumerable <ProfitForProduct> ViewProfitForProducts(Expression <Func <Product, bool> > ProductPredicate = null, Expression <Func <Batch, bool> > ProductInStorePredicate = null) { IEnumerable <Product> Products = ProductPredicate == null?ProductRepo.GetAll() : ProductRepo.GetAll().Where(ProductPredicate); return(ViewProfitForProductsBasedOnDuration(Products, ProductInStorePredicate)); }
public List <Product> GetProductsByStore(Guid storeId) { return(ProductRepo.GetAll(x => x.StoreId == storeId).ToList()); }
private void btnOrderSave_Click(object sender, EventArgs e) { if (cmbOrderProduct.SelectedIndex == -1) { return; } bool control = false; var products = new List <PackageViewModel>(); Package package = new Package(); var seciliPaket = ((cmbOrderProduct.SelectedItem as OrderViewModel).PackageId); try { products.AddRange(new PackageRepo().GetAll() .OrderBy(x => x.PackageName) .Where(x => x.PackageId == seciliPaket) .Select(x => new PackageViewModel() { PackageName = x.PackageName, PackageBarcode = x.PackageBarcode, PackageProductQuantity = x.PackageProductQuantity })); } catch (Exception ex) { MessageBox.Show(ex.Message); } foreach (var item in products) { lstGoodAcceptance.Items.Add(item); } var orders = new List <OrderViewModel>(); try { orders.AddRange(new PackageRepo().GetAll() .OrderBy(x => x.PackageName) .Select(x => new OrderViewModel() { PackageName = x.PackageName, PackageBarcode = x.PackageBarcode, PackageId = x.PackageId })); } catch (Exception ex) { MessageBox.Show(ex.Message); } PackageRepo pr = new PackageRepo(); ProductRepo prodb = new ProductRepo(); var seciliPaket1 = cmbOrderProduct.SelectedItem as OrderViewModel; foreach (var item in pr.GetAll()) { foreach (var item1 in prodb.GetAll()) { if (item.ProductId == item1.ProductId) { if (seciliPaket1.ProductId == item1.ProductId) { item1.ProductStock += seciliPaket1.PackageProductQuantity; item1.ProductSellingPrice = (item1.ProductPurchasingPrice * (1 + 0.18m)); } } } } pr.Update(); prodb.Update(); cmbOrderProduct.Items.Clear(); cmbOrderProduct.Items.AddRange(new List <Package>().ToArray()); PackageRepo db = new PackageRepo(); var orders1 = db.GetAll(x => x.OrderId == (cmbGoodsAcceptanceOrders.SelectedItem as Order).OrderId); foreach (var item in orders) { foreach (var item1 in orders1) { if (item.PackageId == seciliPaket && item.PackageId == item1.PackageId) { orders.Remove(item); db.Delete(item1); control = true; break; } } if (control == true) { break; } } control = false; db.Update(); cmbOrderProduct.Items.Clear(); cmbOrderProduct.Items.AddRange(orders.ToArray()); cmbOrderProduct.SelectedIndex = -1; cmbOrderProduct.Text = ""; }
private void LoadData() { //if (userdata.user_role == "kasir") //{ // btadditem.Visible = false; // btedititem.Visible = false; // btdeleteitem.Visible = false; // btunitmanage.Visible = false; // btmanagebrand.Visible = false; //} try { ListBrands = brandRepository.GetAll().ToList(); ListProducts = productRepository.GetAll().ToList(); ListCategories = categoryRepository.GetAll().ToList(); ListUnits = unitRepository.GetAll().ToList(); var tempproductlist = new List <TempProdColumns>(); if (ListProducts != null) { foreach (var item in ListProducts) { var prodbrand = ListBrands.FirstOrDefault(x => x.brandid == item.brandid); var prodcat = ListCategories.FirstOrDefault(x => x.catid == item.prodcat); var produnit = ListUnits.FirstOrDefault(x => x.unitid == item.produnit); var itemDetail = new TempProdColumns(); itemDetail.prodid = item.prodid; itemDetail.brandid = item.brandid; itemDetail.brand_name = prodbrand != null ? prodbrand.name : " - "; itemDetail.name = item.name; itemDetail.prodcat = item.prodcat; itemDetail.prodcat_name = prodcat != null ? prodcat.name : " - "; itemDetail.prodcode = item.prodcode; itemDetail.produnit = item.produnit; itemDetail.produnit_code = produnit != null ? produnit.unitcode : " - "; itemDetail.purchaseprice = item.purchaseprice; itemDetail.stocks = item.stocks; itemDetail.barcodeno = item.barcodeno; tempproductlist.Add(itemDetail); } gvproducts.Rows.Clear(); foreach (var item in tempproductlist.OrderBy(x => x.prodcat_name).ThenBy(x => x.brand_name).ThenBy(x => x.name)) { gvproducts.Rows.Add( item.prodid, item.prodcat_name, item.brand_name, item.prodcode, item.name, item.produnit_code, Utils.ToRupiah(item.purchaseprice), item.barcodeno, item.stocks ); } } var cbData = ListBrands; cbData.Insert(0, new BrandColumns { brandid = -1, name = "--- Pilih Merek ---" }); cbbrand.DataSource = new BindingSource(ListBrands, null); cbbrand.DisplayMember = "name"; cbbrand.ValueMember = "brandid"; var cbcatdata = ListCategories; cbcatdata.Insert(0, new CategoryColumns { catid = -1, name = "--- Pilih Kategori ---" }); cbcategory.DataSource = new BindingSource(ListCategories, null); cbcategory.DisplayMember = "name"; cbcategory.ValueMember = "catid"; } catch (Exception ex) { var errMsg = "Details : " + ex.Message + Environment.NewLine + "Stacktrace : " + ex.StackTrace; MessageBox.Show(errMsg, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } tbprodname.Focus(); }