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();
}