public frmProduct(Product aProduct) : this() { btnSave.Text = @"Update"; label6.Text = "Add Quantity"; label7.Visible = true; availableQuantityTextBox.Visible = true; FillFieldsWith(aProduct); productID = aProduct.ProductID; }
public frmInvoice(Product product) : this() { this.product = product; if (product != null) { txtProductName.Text = product.ProductName; txtAvailableQty.Text = product.Quantity.ToString(); txtSaleQty.Text = "1"; discountTextBox.Text = product.Discount.ToString(); txtPrice.Text = product.Price.ToString(); totalPriceTextBox.Text = (product.Price - (product.Price * product.Discount / 100)).ToString(); barCodeTextBox.Text = product.BarCode; addToCateButton.PerformClick(); } }
public bool AddProduct(Product product) { try { using (SalesAndInventorySystemDataContext dataContext = new SalesAndInventorySystemDataContext()) { dataContext.Products.Add(product); dataContext.SaveChanges(); return true; } } catch (Exception exception) { throw new Exception(exception.Message); } }
public bool CheckProduct(Product product) { try { using (SalesAndInventorySystemDataContext dataContext = new SalesAndInventorySystemDataContext()) { Product aProduct = dataContext.Products.FirstOrDefault(x => x.ProductName == product.ProductName && x.CategoryID == product.CategoryID); if (aProduct == null) { return false; } return true; } } catch (Exception exception) { throw new Exception(exception.Message); } }
public bool DeleteProduct(Product product) { try { using (SalesAndInventorySystemDataContext dataContext = new SalesAndInventorySystemDataContext()) { dataContext.Products.Attach(product); dataContext.Entry(product).State = EntityState.Deleted; dataContext.SaveChanges(); return true; } } catch (Exception exception) { throw new Exception(exception.Message); } }
public bool UpdateProduct(Product product) { try { using (SalesAndInventorySystemDataContext dataContext = new SalesAndInventorySystemDataContext()) { int noOfRowUpdated = dataContext.Database.ExecuteSqlCommand("Update student set studentname ='changed student by command' where studentid=1"); //dataContext.Products.Attach(product); //dataContext.Entry<Product>(product).Property() return true; } } catch (Exception exception) { throw new Exception(exception.Message); } //_cnt.Users.Attach(user); //_cnt.Entry<User>(user).Property(u => u.PasswordHash).IsModified = true; //_cnt.SaveChanges(); }
private void FillFieldsWith(Product aProduct) { barcodeNoTextBox.Text = aProduct.BarCode; txtProductName.Text = aProduct.ProductName; descriptionTextBox.Text = aProduct.Description; priceTextBox.Text = 0.0.ToString(); quantityTextBox.Text = 0.ToString(); cmbCompany.SelectedValue = aProduct.Category.PersonType.ID; cmbCategory.SelectedValue = aProduct.Category.CategoryID; availableQuantityTextBox.Text = aProduct.Quantity.ToString(); oldPriceTextBox.Text = aProduct.Price.ToString(); }
private void btnSave_Click(object sender, EventArgs e) { if (barcodeNoTextBox.Text == string.Empty) { MessageBox.Show(@"Please enter Barcode No", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); barcodeNoTextBox.Focus(); return; } if (txtProductName.Text == "") { MessageBox.Show(@"Please enter product name", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); txtProductName.Focus(); return; } if (cmbCompany.SelectedIndex == 0) { MessageBox.Show(@"Please select company", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); cmbCompany.Focus(); return; } if (cmbCategory.SelectedIndex == 0) { MessageBox.Show(@"Please select category", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); cmbCategory.Focus(); return; } if (priceTextBox.Text == string.Empty) { MessageBox.Show(@"Please enter price.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); priceTextBox.Focus(); return; } if (quantityTextBox.Text == string.Empty) { MessageBox.Show(@"Please enter quantity.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); quantityTextBox.Focus(); return; } if (sizeTextBox.Text==String.Empty) { MessageBox.Show(@"Please enter size of product.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); sizeTextBox.Focus(); return; } if (colorComboBox.SelectedIndex==0) { MessageBox.Show(@"Please select color of product.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); colorComboBox.Focus(); return; } if (buyPriceextBox.Text == String.Empty) { MessageBox.Show(@"Please enter buy price of product.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); buyPriceextBox.Focus(); return; } try { product=new Product() { ProductID = productID, BarCode = barcodeNoTextBox.Text, ProductName = txtProductName.Text, Description = descriptionTextBox.Text, InsertDate =DateTime.Parse( DateTime.Now.ToString("dd-MM-yyyy")), UpdateDate = DateTime.Parse(DateTime.Now.ToString("dd-MM-yyyy")), Price = Double.Parse(priceTextBox.Text), Quantity = Convert.ToInt32(quantityTextBox.Text), CategoryID = Convert.ToInt32(cmbCategory.SelectedValue), Color=colorComboBox.SelectedText, Size = sizeTextBox.Text, BuyPrice = Double.Parse(buyPriceextBox.Text), Discount = Double.Parse(discountTextBox.Text), Vat = 0 }; if (btnSave.Text == "Save") { if (productGateway.CheckBarCode(product)) { MessageBox.Show(@"Barcode NO Already Exists.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); txtProductName.Focus(); return; } if (productGateway.CheckProduct(product)) { MessageBox.Show(@"Product Name Already Exists.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); txtProductName.Focus(); return; } if (productGateway.AddProduct(product)) { txtProductName.Text = string.Empty; MessageBox.Show(@"Successfully saved.", "Record", MessageBoxButtons.OK, MessageBoxIcon.Information); Reset(); return; } } else if(btnSave.Text=="Update") { } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void GetDataFromForm2(Product aNewProduct) { if (aNewProduct != null) { txtProductName.Text = aNewProduct.ProductName; txtAvailableQty.Text = aNewProduct.Quantity.ToString(); txtSaleQty.Text = "1"; discountTextBox.Text = aNewProduct.Discount.ToString(); txtPrice.Text = aNewProduct.Price.ToString(); totalPriceTextBox.Text = (aNewProduct.Price - (aNewProduct.Price * aNewProduct.Discount / 100)).ToString(); barCodeTextBox.Text = aNewProduct.BarCode; } }
private List<Product> GetAllProductONListView() { List<Product> allProducts=new List<Product>(); try { if (resultListView.Items.Count>0) { for (int i = 0; i < resultListView.Items.Count; i++) { ListViewItem item = resultListView.Items[i]; Product newProduct = (Product)item.Tag; Product aProduct = new Product() { ProductID = newProduct.ProductID, ProductName = newProduct.ProductName, BarCode = newProduct.BarCode, CategoryID = newProduct.CategoryID, Description = newProduct.Description, InsertDate = newProduct.InsertDate, UpdateDate = newProduct.UpdateDate, Price = Convert.ToDouble(resultListView.Items[i].SubItems[6].Text), Quantity = Convert.ToInt32(resultListView.Items[i].SubItems[5].Text), Size = resultListView.Items[i].SubItems[4].Text, Discount = Convert.ToDouble(resultListView.Items[i].SubItems[3].Text) }; allProducts.Add(aProduct); } } return allProducts; } catch (Exception exception) { throw new Exception(exception.Message); } }
private void barCodeTextBox_TextChanged(object sender, EventArgs e) { string barCode = barCodeTextBox.Text; if (barCode!=string.Empty) { product = productGateway.GetDataBarCode(barCode); if (product==null) { Reset(); return; } product.Category = categoryGateway.GetCategoryByID(product.CategoryID); if (product.Category==null) { //Reset(); return; } product.Category.PersonType = companyGateway.GetCompaniesByID(product.Category.CompanyID); if (product!=null) { txtProductName.Text = product.ProductName; txtAvailableQty.Text = product.Quantity.ToString(); txtSaleQty.Text = "1"; discountTextBox.Text = product.Discount.ToString(); txtPrice.Text = product.Price.ToString(); //if () //{ //} totalPriceTextBox.Text = (product.Price - (product.Price * product.Discount/100)).ToString(); addToCateButton.PerformClick(); } else { Reset(); } } else { Reset(); } }