private Product BLLProductToProduct(BLLProduct itemToMap) { JewType mapJewType = new JewType() { Name = itemToMap.JewType.Name }; List <Gemstone> mapGemstones = new List <Gemstone>(); if (itemToMap.Gemstone != null) { foreach (var gem in itemToMap.Gemstone) { mapGemstones.Add(new Gemstone() { Name = gem.Name, Size = gem.Size, Colour = gem.Colour, Price = gem.Price }); } } decimal productPrice = itemToMap.Gemstone.Sum(x => x.Price); Product product = new Product() { Name = itemToMap.Name, Price = productPrice, JewTypeId = itemToMap.JewTypeId, JewType = mapJewType, Gemstone = mapGemstones }; return(product); }
private void bttnadd_Click(object sender, EventArgs e) { int parsedvalue; BLLProduct blll = new BLLProduct(); DataTable dt = blll.checkallproducts(txtproduct.Text); if (txtproduct.Text == "" || txtprice.Text == "") { MessageBox.Show("input the required fields..."); } else if (!int.TryParse(txtprice.Text, out parsedvalue)) { lblmsg.Text = ("the input in price is invalid type integers..."); } else if (dt.Rows.Count > 0) { MessageBox.Show("product already exists"); } else { // values check condition is not finished.. int i = blp.addproduct(Convert.ToInt32(cbocategory.SelectedValue.ToString()), txtproduct.Text, Convert.ToDecimal(txtprice.Text)); if (i > 0) { MessageBox.Show("Product Has Been Added"); gridview1(); } } }
protected void AdminProductGrid_RowUpdating(object sender, GridViewUpdateEventArgs e) { GridViewRow row = (GridViewRow)AdminProductGrid.Rows[e.RowIndex]; Label LabelID = (Label)row.FindControl("LabelProductID"); TextBox TxtName = (TextBox)row.FindControl("TextBoxProductName"); DropDownList DropDownListCategory = (DropDownList)row.FindControl("DropDownListCategories"); TextBox TextBoxPrice = (TextBox)row.FindControl("TextBoxPrice"); CheckBox CheckBoxStock = (CheckBox)row.FindControl("CheckBoxStock"); TextBox TextBoxDescription = (TextBox)row.FindControl("TextBoxDescription"); BLLProduct.UpdateProduct(new EProduct { ProductID = Convert.ToInt32(LabelID.Text.ToString()), ProductName = TxtName.Text.ToString(), CategoryID = Convert.ToInt32(DropDownListCategory.SelectedItem.Text.ToString()), Price = Convert.ToDecimal(TextBoxPrice.Text.ToString()), Stock = CheckBoxStock.Checked, Description = TextBoxDescription.Text.ToString() }); using (System.IO.StreamWriter file = new System.IO.StreamWriter(submittedFilePath, true)) { file.WriteLine("[" + DateTime.Now + "] DB PRODUCT UPDATED"); } AdminProductGrid.EditIndex = -1; FillProductView(); feedbackProduct.Text = "Records Updated Succesfully !!!"; feedbackProduct.Visible = true; }
private BLLProduct ProductToBLLProduct(Product itemToMap) { BLLJewType mapJewType = new BLLJewType() { Id = itemToMap.JewType.Id, Name = itemToMap.JewType.Name }; List <BLLGemstone> mapGemstones = new List <BLLGemstone>(); if (itemToMap.Gemstone != null) { foreach (var gem in itemToMap.Gemstone) { mapGemstones.Add(new BLLGemstone() { Id = gem.Id, Name = gem.Name, Size = gem.Size, Colour = gem.Colour }); } } BLLProduct bllProduct = new BLLProduct() { Id = itemToMap.Id, Name = itemToMap.Name, Price = itemToMap.Price, JewTypeId = itemToMap.JewTypeId, JewType = mapJewType, Gemstone = mapGemstones }; //i dont know: shoul I for each BLLGemstone assign bllProduct as product? return(bllProduct); }
}/// <summary> /// map product from business layer to presentation layer /// </summary> /// <param name="itemToMap"></param> /// <returns></returns> private PLProduct BLLProductToPLProduct(BLLProduct itemToMap) { PLJewType mapJewType = new PLJewType() { Name = itemToMap.JewType.Name }; List <PLGemstone> mapGemstones = new List <PLGemstone>(); if (itemToMap.Gemstone != null) { foreach (var gem in itemToMap.Gemstone) { mapGemstones.Add(new PLGemstone() { Name = gem.Name, Size = gem.Size, Colour = gem.Colour }); } } //product price from DB is mapped here PLProduct plProduct = new PLProduct() { Name = itemToMap.Name, Price = itemToMap.Price, JewTypeId = itemToMap.JewTypeId, JewType = mapJewType, Gemstone = mapGemstones }; return(plProduct); }
/// <summary> /// map item from presentation layer to business layer /// </summary> /// <param name="itemToMap"></param> /// <returns></returns> private BLLProduct PLProductToBLLProduct(PLProduct itemToMap) { BLLJewType mapJewType = new BLLJewType() { Name = itemToMap.JewType.Name }; List <BLLGemstone> mapGemstones = new List <BLLGemstone>(); //send information about price of each gemstone if (itemToMap.Gemstone != null) { foreach (var gem in itemToMap.Gemstone) { mapGemstones.Add(new BLLGemstone() { Name = gem.Name, Size = gem.Size, Colour = gem.Colour, Price = gem.Price }); } } // no information about product price BLLProduct bllProduct = new BLLProduct() { Name = itemToMap.Name, JewTypeId = itemToMap.JewTypeId, JewType = mapJewType, Gemstone = mapGemstones }; //i dont know: shoul I for each BLLGemstone assign bllProduct as product? return(bllProduct); }/// <summary>
protected void FillProductView() { AdminProductGrid.DataSource = BLLProduct.GetProduct(); using (System.IO.StreamWriter file = new System.IO.StreamWriter(submittedFilePath, true)) { file.WriteLine("[" + DateTime.Now + "] DB PRODUCT DATA PULLED"); } AdminProductGrid.DataBind(); }
public BLLProduct GetById(int id) { Product getProductById = _myJewStore.GetById(id); if (getProductById != null) { BLLProduct bllProductId = ProductToBLLProduct(getProductById); return(bllProductId); } return(null); }
public void Add(PLProduct newProduct) { if (IsTypeNull(newProduct)) { Console.WriteLine("You need define product type"); return; } BLLProduct productToAdd = PLProductToBLLProduct(newProduct); _jewService.Add(productToAdd); }
public void FillGrid() { List <ELBasket> basket = BLLBasket.GetBasket(); using (System.IO.StreamWriter file = new System.IO.StreamWriter(submittedFilePath, true)) { file.WriteLine("[" + DateTime.Now + "] DB BASKET PULLED"); } DataTable dt = new DataTable(); dt.Columns.Add("Ürün"); dt.Columns.Add("Miktar"); dt.Columns.Add("Fiyat"); dt.Columns.Add("Numara"); if (basket != null) { noteID.Visible = true; TextBoxNoteID.Visible = true; payementType.Visible = true; acceptButtonImage.Visible = true; welc.Text = "Hoşgeldin " + name + " ! Sepetin tam burada !!"; welc.Visible = true; foreach (ELBasket item in basket) { DataRow dr = dt.NewRow(); EProduct pro = (EProduct)BLLProduct.SelectProduct(item.productId); using (System.IO.StreamWriter file = new System.IO.StreamWriter(submittedFilePath, true)) { file.WriteLine("[" + DateTime.Now + "] DB PRODUCT DATA SELECTED"); } dr["Ürün"] = pro.ProductName; dr["Miktar"] = item.productCount; dr["Fiyat"] = item.productCount * pro.Price; dr["Numara"] = item.id; dt.Rows.Add(dr); } BasketGrid.DataSource = dt; BasketGrid.DataBind(); } else { welc.Text = "Sepetin şu an boş"; welc.Visible = true; noteID.Visible = false; TextBoxNoteID.Visible = false; payementType.Visible = false; acceptButtonImage.Visible = false; BasketGrid.DataSource = dt; BasketGrid.DataBind(); } }
private void gvProducts_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex != -1) { int productId = int.Parse(gvProducts.Rows[e.RowIndex].Cells["colProductId"].Value.ToString()); Product product = new Product(); BLLProduct productBLL = new BLLProduct(); product = productBLL.GetProductById(productId); lbName.Text = product.ProductName; lbPrice.Text = product.OriginalPrice.ToString(); lbUnit.Text = product.ProductUnit; lbDescription.Text = product.Description; } }
protected void AdminProductGrid_RowDeleting(object sender, GridViewDeleteEventArgs e) { GridViewRow row = (GridViewRow)AdminProductGrid.Rows[e.RowIndex]; Label LabelID = (Label)row.FindControl("Label1"); BLLProduct.DeleteProduct(Convert.ToInt32(LabelID.Text)); using (System.IO.StreamWriter file = new System.IO.StreamWriter(submittedFilePath, true)) { file.WriteLine("[" + DateTime.Now + "] DB PRODUCT DELETED"); } FillProductView(); feedbackProduct.Text = "Records Deleted Succesfully !!!"; feedbackProduct.Visible = true; }
protected void Page_Load(object sender, EventArgs e) { EClient user = (EClient)Session["user"]; if (user != null) { welc.Text = "Hoşgeldin " + user.name + " ! İşte Yemeklerimiz"; welc.Visible = true; if (!IsPostBack) { ProductGrid.DataSource = BLLProduct.SelectProduct_Category(1); using (System.IO.StreamWriter file = new System.IO.StreamWriter(submittedFilePath, true)) { file.WriteLine("[" + DateTime.Now + "] DB PRODUCTS SELECTED BY CATEGORY"); } ProductGrid.DataBind(); aperatifGrid.DataSource = BLLProduct.SelectProduct_Category(2); using (System.IO.StreamWriter file = new System.IO.StreamWriter(submittedFilePath, true)) { file.WriteLine("[" + DateTime.Now + "] DB PRODUCTS SELECTED BY CATEGORY"); } aperatifGrid.DataBind(); IcecekGrid.DataSource = BLLProduct.SelectProduct_Category(3); using (System.IO.StreamWriter file = new System.IO.StreamWriter(submittedFilePath, true)) { file.WriteLine("[" + DateTime.Now + "] DB PRODUCTS SELECTED BY CATEGORY"); } IcecekGrid.DataBind(); tatlıGrid.DataSource = BLLProduct.SelectProduct_Category(4); using (System.IO.StreamWriter file = new System.IO.StreamWriter(submittedFilePath, true)) { file.WriteLine("[" + DateTime.Now + "] DB PRODUCTS SELECTED BY CATEGORY"); } tatlıGrid.DataBind(); } } else { welc.Visible = false; Response.Redirect("~/Default.aspx"); } }
public PLProduct GetById(int id) { if (id <= 0) { Console.WriteLine("Id should be positive"); return(null); } BLLProduct bllProductById = _jewService.GetById(id); if (bllProductById != null) { PLProduct plProductById = BLLProductToPLProduct(bllProductById); return(plProductById); } Console.WriteLine($"No product with id={id}"); return(null); }
protected void InsertProduct_Click(object sender, EventArgs e) { string name = ((TextBox)AdminProductGrid.FooterRow.FindControl("TextBoxInsertProductName")).Text.ToString(); int cat = Convert.ToInt32(((DropDownList)AdminProductGrid.FooterRow.FindControl("DropDownListInsertCategory")).SelectedItem.Text.ToString()); decimal price = Convert.ToDecimal(((TextBox)AdminProductGrid.FooterRow.FindControl("TextBoxInsertPrice")).Text.ToString()); bool stock = ((CheckBox)AdminProductGrid.FooterRow.FindControl("TextBoxInsertStock")).Checked; string desc = ((TextBox)AdminProductGrid.FooterRow.FindControl("TextBoxInsertDescription")).Text.ToString(); BLLProduct.CreateProduct(name, cat, price, stock, desc); using (System.IO.StreamWriter file = new System.IO.StreamWriter(submittedFilePath, true)) { file.WriteLine("[" + DateTime.Now + "] DB PRODUCT INSERTED"); } FillProductView(); feedbackProduct.Text = "Record Added Succesfully !!!"; feedbackProduct.Visible = true; }
private void bttnadd_Click(object sender, EventArgs e) { BLLProduct blll = new BLLProduct(); DataTable dt = blll.checkallproducts(txtproduct.Text); if (dt.Rows.Count > 0) { MessageBox.Show("product already exists"); } else { // values check condition is not finished.. int i = blp.addproduct(Convert.ToInt32(cbocategory.SelectedValue.ToString()), txtproduct.Text, Convert.ToDecimal(txtprice.Text)); if (i > 0) { MessageBox.Show("Product Has Been Added"); } } }
public void Add(BLLProduct newProduct) { int numberOfGems = newProduct.Gemstone.Count; //check jems number, error, if more than 10 gems in one product if (numberOfGems > 10) { Console.WriteLine($"Maximum 10 gems per product, but you have {numberOfGems}. Item add failed."); return; } Product itemToAdd = BLLProductToProduct(newProduct); //check if we have such type of product in DB, assign existing type JewType searchJewTypeInDB = _myJewStore.SearchByJewType(itemToAdd.JewType); if (searchJewTypeInDB != null) { itemToAdd.JewType = searchJewTypeInDB; } _myJewStore.Add(itemToAdd); }
private void gvBills_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex != -1) { pictureBox1.Enabled = false; pictureBox2.Enabled = false; btnEdit.Enabled = true; int billsID = int.Parse(gvBills.Rows[e.RowIndex].Cells["colBillsID"].Value.ToString()); Bill bills = new Bill(); BLLBills bllBills = new BLLBills(); bills = bllBills.GetBillsById(billsID); if (gvBills.Columns[e.ColumnIndex].Name == "colBillsDeleted") { if (MessageBox.Show("Are you sure to delete: " + gvBills.Rows[e.RowIndex].Cells["colBillsId"].Value.ToString(), "Message", MessageBoxButtons.OKCancel) == DialogResult.OK) { bllBills.Deleted(bills); LoadGridBills(); gvProductsToBills.Rows.Clear(); return; } } gvProductsToBills.Rows.Clear(); foreach (BillDetail billsDetail in bills.BillDetails) { Product product = new Product(); BLLProduct productBLL = new BLLProduct(); product = productBLL.GetProductById(billsDetail.ProductId); gvProductsToBills.Rows.Add(product.ProductId, product.ProductName, billsDetail.RealPrice, billsDetail.Amounts, billsDetail.Sum, Properties.Resources.DeleteRed); } lbTotal.Text = bills.Total.ToString(); } }
private void gvProducts_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex != -1) { int productId = int.Parse(gvProducts.Rows[e.RowIndex].Cells["colProductId"].Value.ToString()); int rowIndex = -1; Product product = new Product(); BLLProduct productBLL = new BLLProduct(); product = productBLL.GetProductById(productId); if (TestExistsProductInBills(gvProductsToBills, productId, ref rowIndex)) { gvProductsToBills.Rows[rowIndex].Cells["colAmounts"].Value = int.Parse(gvProductsToBills.Rows[rowIndex].Cells["colAmounts"].Value.ToString()) + 1; gvProductsToBills.Rows[rowIndex].Cells["colTotal"].Value = float.Parse(gvProductsToBills.Rows[rowIndex].Cells["colTotal"].Value.ToString()) + product.OriginalPrice; } else { gvProductsToBills.Rows.Add(product.ProductId, product.ProductName, product.OriginalPrice, 1, product.OriginalPrice, Properties.Resources.DeleteRed); } lbTotal.Text = SumTotal().ToString(); } }
private void cboCategories_SelectedIndexChanged(object sender, EventArgs e) { BLLProduct productBLL = new BLLProduct(); gvProducts.DataSource = productBLL.GetProductByCategoryId(int.Parse(cboCategories.SelectedValue.ToString())); }