public bool DeleteSaleItem(SaleItems item) { try { SalesDAO salesDAO = new SalesDAO(); SaleItemsDAO itemsDAO = new SaleItemsDAO(); ProductsDAO productsDAO = new ProductsDAO(); UserDAO userDAO = new UserDAO(); if (item != null) { if (userDAO.CheckLogin(item.Sale.User) == null) { return(false); } if (!salesDAO.CheckUserPermission(item.Sale)) { return(false); } itemsDAO.DeleteSaleItem(item); return(true); } return(false); } catch (Exception e) { throw new Exception(e.Message); } }
public bool addProductToShoppingCart() { try { using (IDbConnection connection = new SqlConnection(ConnectionString)) { if (connection.State == ConnectionState.Closed) { connection.Open(); } string query = "INSERT INTO SaleItems([idProduct],[amount],[idSale]) VALUES(@IdProduct,@Amount,@IdSale)"; Dictionary <string, object> dictionary = new Dictionary <string, object>(); dictionary.Add("@IdProduct", this.saleItems.idProduct); dictionary.Add("@Amount", this.saleItems.amount); dictionary.Add("@IdSale", this.saleItems.idSale); var result = connection.Execute(query, new DynamicParameters(dictionary)); connection.Close(); this.saleItems = null; return(true); } } catch (Exception) { this.saleItems = null; return(false); } }
public void UpdateSaleItem(SaleItems saleItem) { NpgsqlConnection connection = Database.openConnection(); try { string sql = "UPDATE negocio.itensvenda SET precounit = @unitPrice, qtd = @qtd WHERE idvenda = @idSale AND idproduto = @idProduct"; NpgsqlCommand cmd = new NpgsqlCommand(sql, connection); cmd.Parameters.Add(new NpgsqlParameter("@idProduct", saleItem.Product.Id)); cmd.Parameters.Add(new NpgsqlParameter("@idSale", saleItem.Sale.Id)); cmd.Parameters.Add(new NpgsqlParameter("@unitPrice", saleItem.UnitPrice)); cmd.Parameters.Add(new NpgsqlParameter("@qtd", saleItem.Qtd)); cmd.ExecuteNonQuery(); cmd.Dispose(); } catch (NpgsqlException npgEx) { throw new Exception("Erro ao atualizar o item da venda no banco de dados! " + npgEx.Message); } catch (Exception e) { throw new Exception("Erro ao atualizar o item da venda no banco de dados! " + e.Message); } finally { connection.Close(); } }
public void InsertSaleItem(SaleItems saleItem) { NpgsqlConnection connection = Database.openConnection(); try { string sql = "INSERT INTO negocio.itensvenda (precounit, qtd, idproduto, idvenda) VALUES (@unitPrice, @qtd, @idProduct, @idSale)"; NpgsqlCommand cmd = new NpgsqlCommand(sql, connection); cmd.Parameters.Add(new NpgsqlParameter("@unitPrice", saleItem.UnitPrice)); cmd.Parameters.Add(new NpgsqlParameter("@qtd", saleItem.Qtd)); cmd.Parameters.Add(new NpgsqlParameter("@idProduct", saleItem.Product.Id)); cmd.Parameters.Add(new NpgsqlParameter("@idSale", saleItem.Sale.Id)); cmd.ExecuteNonQuery(); cmd.Dispose(); } catch (NpgsqlException npgEx) { throw new Exception("Erro ao inserir o item da venda no banco de dados! " + npgEx.Message); } catch (Exception e) { throw new Exception("Erro ao inserir o item da venda no banco de dados! " + e.Message); } finally { connection.Close(); } }
public void DeleteSaleItem(SaleItems saleItem) { NpgsqlConnection connection = Database.openConnection(); try { string sql = "DELETE FROM negocio.itensvenda WHERE idvenda = @idSale AND idproduto = @idProduct"; NpgsqlCommand cmd = new NpgsqlCommand(sql, connection); cmd.Parameters.Add(new NpgsqlParameter("@idProduct", saleItem.Product.Id)); cmd.Parameters.Add(new NpgsqlParameter("@idSale", saleItem.Sale.Id)); cmd.ExecuteNonQuery(); cmd.Dispose(); } catch (NpgsqlException npgEx) { throw new Exception("Erro ao deletar o item da venda no banco de dados! " + npgEx.Message); } catch (Exception e) { throw new Exception("Erro ao deletar o item da venda no banco de dados! " + e.Message); } finally { connection.Close(); } }
public Int32 IncreaseQtdSaleItem(SaleItems saleItem) { NpgsqlConnection connection = Database.openConnection(); try { string sql = "UPDATE negocio.itensvenda SET qtd = qtd + 1 WHERE idvenda = @idSale AND idproduto = @idProduct"; NpgsqlCommand cmd = new NpgsqlCommand(sql, connection); cmd.Parameters.Add(new NpgsqlParameter("@idProduct", saleItem.Product.Id)); cmd.Parameters.Add(new NpgsqlParameter("@idSale", saleItem.Sale.Id)); Int32 count = cmd.ExecuteNonQuery(); cmd.Dispose(); return(count); } catch (NpgsqlException npgEx) { throw new Exception("Erro ao atualizar o item da venda no banco de dados! " + npgEx.Message); } catch (Exception e) { throw new Exception("Erro ao atualizar o item da venda no banco de dados! " + e.Message); } finally { connection.Close(); } }
public void AddSale(string productCode, int productCount) { List <SaleItems> items = new List <SaleItems>(); var saleitem = new SaleItems(); Sales sales = new Sales(); var sale = sales; Products product = Product.Find(p => p.Code == productCode); if (product != null) { product = Product.Find(p => p.Quantity >= productCount); if (product != null) { saleitem.Products = product; saleitem.Number = items.Count + 1; items.Add(saleitem); sale.Id = _sales.Count + 1; sale.Amount += productCount * product.price; sale.Date = DateTime.Now; sale.saleItems = items; _sales.Add(sale); Sales satiw = new Sales(); SaleItems item = new SaleItems(); } else { Console.WriteLine("daxil etdiyiniz say qeder mehsul yoxdur."); } } else { Console.WriteLine("daxil etdiyiniz codda mehsul yoxdur.yeniden ceh etmeye caliwin"); } }
internal ActionResult DeleteItemInternal(int productId) { _saleItems.Remove(SaleItems.FirstOrDefault(i => i.Product.Id == productId)); UpdateAmounts(); return(new ActionResult(isSuccess: true)); }
public FormSaleItemDialog(SaleItems saleItem, UnitOfWork unitOfWork) { _saleItem = saleItem; _unitOfWork = unitOfWork; InitializeComponent(); InitializeDialog(); InitializeComboBox(); }
//private void txtCbo1_TextChanged(object sender, TextChangedEventArgs e) //{ // //var txt = sender as TextBox; // //if (string.IsNullOrWhiteSpace(txt.Text)) return; // //var index = firstPanel.Children.IndexOf(txt); // //var cbo = firstPanel.Children[index - 1] as ComboBox; // //var selectedItem = cbo.SelectedItem as MDCafe.item; // //var totalAmount = string.IsNullOrWhiteSpace(txtTotalAmt1.Text) ? 0 : decimal.Parse(txtTotalAmt1.Text); // //txtTotalAmt1.Text = (totalAmount + selectedItem.CurrentPrice * int.Parse(txt.Text)).ToString(); //} private void ClearValues(SaleItems saleItems) { saleItems.CustomerId = -1; foreach (var item in saleItems.SaleItemsDetailsCollection) { item.ItemQty = 0; item.SelectedItemItem = null; item.PreviousSelectedItem = null; item.PrevItemQty = 0; } }
public ActionResult DeleteItem(int productId) { if (IsPaid || IsCancelled) { return(new ActionResult(isSuccess: false, "Cannot delete items from paid or cancelled sales")); } _saleItems.Remove(SaleItems.FirstOrDefault(i => i.Product.Id == productId)); UpdateAmounts(); return(new ActionResult(isSuccess: true)); }
private SaleItems GenerateSaleItem() { int ListProdIndex = listBoxProducts.SelectedIndex; Products product = (Products)FormMain.listProducts[ListProdIndex]; SaleItems item = new SaleItems { Product = product, Sale = sale }; return(item); }
private void OnButtonDeleteClick(object sender, EventArgs e) { if (lvSaleItems.SelectedItems.Count != 1) { MessageBox.Show("Please select one sale item.", Constant.StoreAppName); return; } SaleItems item = (SaleItems)lvSaleItems.SelectedItems[0].Tag; _unitOfWork.SaleItems.Remove(item); lvSaleItems.SelectedItems[0].Remove(); }
internal ActionResult SetItemQuantityInternal(int productId, int newQuantity) { var existingItem = SaleItems.FirstOrDefault(i => i.Product.Id == productId); if (existingItem is null) { return(new ActionResult(isSuccess: false, $"ProductId {productId} not found in sale items.")); } ReplaceItem(existingItem, new SaleItem(existingItem.Product, newQuantity)); UpdateAmounts(); return(new ActionResult(isSuccess: true)); }
private SaleItems CheckSaleItem() { try { if (listViewSaleItems.SelectedItems.Count > 0) { ListViewItem item = listViewSaleItems.SelectedItems[0]; SaleItems itemSale = new SaleItems(); bool error = false; if (int.TryParse(item.SubItems[0].Text, out int qtdItem)) { itemSale.Qtd = qtdItem; } else { error = true; } if (double.TryParse(item.SubItems[1].Text, out double unitPrice)) { itemSale.UnitPrice = unitPrice; } else { error = true; } itemSale.Product.Name = item.SubItems[2].Text; if (!error) { return(itemSale); } else { MessageBox.Show("Item inválido!"); return(null); } } else { MessageBox.Show("Selecione um item."); return(null); } } catch (Exception) { throw; } }
public void addSaleItemTest() { SaleItems s = new SaleItems(); // TODO: 初始化为适当的值 s.Price = 10; s.SaleId = 1; s.BookId = 1; s.Count = 3; int expected = 1; // TODO: 初始化为适当的值 int actual; actual = SaleService.addSaleItem(s); Assert.AreEqual(expected, actual); // Assert.Inconclusive("验证此测试方法的正确性。"); }
private void OnButtonAddClick(object sender, EventArgs e) { var item = new SaleItems(); var dialog = new FormSaleItemDialog(item, _unitOfWork); DialogResult result = dialog.ShowDialog(); if (result != DialogResult.OK) { return; } _sale.SaleItems.Add(item); UpdateListView(item, ListViewAction.Add, Constant.IndexNone); }
internal void AddItemInternal(SaleItem newItem) { var existingItem = SaleItems.FirstOrDefault(i => i.Product.Id == newItem.Product.Id); if (existingItem != null) { newItem = new SaleItem(newItem.Product, newItem.Quantity + existingItem.Quantity); ReplaceItem(existingItem, newItem); } else { _saleItems.Add(newItem); } UpdateAmounts(); }
public SaleRequestDetailPage(SaleItems saleItem) { InitializeComponent(); mSaleItem = saleItem; lbl_title.Text = mSaleItem.building_name; img_building.Source = mSaleItem.img_url; month_excome.Text = mSaleItem.monthly_balance; int month_balance = 0; bool is_success = int.TryParse(mSaleItem.monthly_balance, out month_balance); if (is_success) { year_excome.Text = (month_balance * 12).ToString(); } current_excome.Text = mSaleItem.income; excome.Text = mSaleItem.excome; }
public List <SaleItems> ListSaleItems(Sales sale) { NpgsqlConnection connection = Database.openConnection(); List <SaleItems> listSaleItems; SaleItems saleItems; Products product; try { string sql = "SELECT precounit, qtd, idproduto, idvenda FROM negocio.itensvenda WHERE idvenda = @idSale"; NpgsqlCommand cmd = new NpgsqlCommand(sql, connection); cmd.Parameters.Add(new NpgsqlParameter("@idSale", sale.Id)); NpgsqlDataReader dataReader = cmd.ExecuteReader(); listSaleItems = new List <SaleItems>(); while (dataReader.Read()) { product = new Products { Id = dataReader.GetInt32(dataReader.GetOrdinal("idproduto")) }; saleItems = new SaleItems { UnitPrice = dataReader.GetDouble(dataReader.GetOrdinal("precounit")), Qtd = dataReader.GetInt32(dataReader.GetOrdinal("qtd")), Product = product }; listSaleItems.Add(saleItems); } cmd.Dispose(); return(listSaleItems); } catch (NpgsqlException npgEx) { throw new Exception("Erro ao listar os itens da venda do banco de dados! " + npgEx.Message); } catch (Exception e) { throw new Exception("Erro ao listar os itens da venda do banco de dados! " + e.Message); } finally { connection.Close(); } }
internal ActionResult AddItemInternal(SaleItem newItem) { var existingItem = SaleItems.FirstOrDefault(i => i.Product.Id == newItem.Product.Id); if (existingItem != null) { newItem = new SaleItem(newItem.Product, newItem.Quantity + existingItem.Quantity); ReplaceItem(existingItem, newItem); } else { _saleItems.Add(newItem); } UpdateAmounts(); return(new ActionResult(isSuccess: true)); }
private void BtnIncreaseProd_Click(object sender, EventArgs e) { try { SaleItems item = GenerateSaleItem(); if (webService.IncreaseQtdSaleItem(item)) { MessageBox.Show("Item incrementado com sucesso!"); } else { MessageBox.Show("Erro na incrementação do item!"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public ActionResult SetItemQuantity(int productId, int newQuantity) { if (IsPaid || IsCancelled) { return(new ActionResult(isSuccess: false, "Cannot change item quantity on paid or cancelled sales")); } var existingItem = SaleItems.FirstOrDefault(i => i.Product.Id == productId); if (existingItem is null) { return(new ActionResult(isSuccess: false, $"ProductId {productId} not found in sale items.")); } ReplaceItem(existingItem, new SaleItem(existingItem.Product, newQuantity)); UpdateAmounts(); return(new ActionResult(isSuccess: true)); }
// SaleItem public bool SaveSaleItem(SaleItems item) { try { SalesDAO salesDAO = new SalesDAO(); SaleItemsDAO itemsDAO = new SaleItemsDAO(); ProductsDAO productsDAO = new ProductsDAO(); UserDAO userDAO = new UserDAO(); Products p; if (item != null) { if (userDAO.CheckLogin(item.Sale.User) == null) { return(false); } if (!salesDAO.CheckUserPermission(item.Sale)) { return(false); } p = productsDAO.SelectProduct(item.Product); if (p == null) { return(false); } if (item.Qtd < 1) { item.Qtd = 1; } if (itemsDAO.ChangeQtdSaleItem(item, item.Qtd) == 0) { item.UnitPrice = p.Price; itemsDAO.InsertSaleItem(item); return(true); } } return(false); } catch (Exception e) { throw new Exception(e.Message); } }
private void BtnSaveItem_Click(object sender, EventArgs e) { try { SaleItems item = GenerateSaleItem(); item.Qtd = 1; if (webService.InsertSaleItem(item)) { MessageBox.Show("Item salvo com sucesso!"); } else { MessageBox.Show("Erro durante o cadastro do item!"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void OnButtonEditClick(object sender, EventArgs e) { if (lvSaleItems.SelectedItems.Count != 1) { MessageBox.Show("Please select one sale item.", Constant.StoreAppName); return; } SaleItems item = (SaleItems)lvSaleItems.SelectedItems[0].Tag; var dialog = new FormSaleItemDialog(item, _unitOfWork); DialogResult result = dialog.ShowDialog(); if (result != DialogResult.OK) { return; } UpdateListView(item, ListViewAction.Update, lvSaleItems.SelectedItems[0].Index); }
private void UpdateListView(SaleItems saleItem, ListViewAction action, int index) { ListViewItem item = new ListViewItem(saleItem.Products.ProductName); // Use InvariantCulture to format the decimal with dot instead of comma. item.SubItems.Add(saleItem.SalePrice.ToString("0.00", System.Globalization.CultureInfo.InvariantCulture)); item.SubItems.Add(saleItem.Amount.ToString()); item.Tag = saleItem; if (action == ListViewAction.Add) { lvSaleItems.Items.Add(item); } if (action == ListViewAction.Update && index > Constant.IndexNone) { lvSaleItems.Items[index] = item; } }
public void Initialize() { AddHandler(System.Windows.Controls.Validation.ErrorEvent, new RoutedEventHandler(OnErrorEvent)); _modelContext = _viewModel.ModelContext; Panel1cboCustomer1.DataContext = _modelContext.customers.OrderBy(s => s.Name).ToList(); //btnDone.CommandBindings.Add(new CommandBinding(ApplicationCommands.Print, BtnDoneExecuted, BtnDoneCanExecute)); var saleItems = new SaleItems(); saleItems.ItemsCollection = _modelContext.items.OrderBy(s => s.Name).ToList(); Panel1.DataContext = saleItems; //List<Items> lst = new List<Items>(); //var connString = "server=127.0.0.1;user id=root;database=MDCafe"; //using (var conn = new MySqlConnection(connString)) //{ // var cmdText = "select * from items"; // using (var command = new MySqlCommand(cmdText,conn)) // { // conn.Open(); // using (var reader = command.ExecuteReader()) // { // while (reader.Read()) // { // lst.Add(new Items() // { // Code = reader.GetString("code"), // Name = reader.GetString("Name"), // Description = reader.GetString("Description"), // currentPrice = reader.GetDecimal("currentPrice"), // Category = reader.GetString("Category") // } // ); // } // } // } //} //this.DataContext = lst; }
public ActionResult AddItem(SaleItem newItem) { if (IsPaid || IsCancelled) { return(new ActionResult(isSuccess: false, "Cannot add items to paid or cancelled sales")); } var existingItem = SaleItems.FirstOrDefault(i => i.Product.Id == newItem.Product.Id); if (existingItem != null) { newItem = new SaleItem(newItem.Product, newItem.Quantity + existingItem.Quantity); ReplaceItem(existingItem, newItem); } else { _saleItems.Add(newItem); } UpdateAmounts(); return(new ActionResult(isSuccess: true)); }
private IEnumerator LoadItems() { string url = "https://gist.githubusercontent.com/sampletext32/e7dfdf2602b59ba798b882be520d9364/raw/1cf374aded0128f8cf2bf7d03b48c960ac9beca9/farm_data.json"; UnityWebRequest webRequest = UnityWebRequest.Get(url); var asyncOperation = webRequest.SendWebRequest(); yield return(asyncOperation); if (webRequest.isNetworkError || webRequest.isHttpError) { Debug.Log(webRequest.error); } else { Debug.Log("Request successful"); var jsonData = webRequest.downloadHandler.text; Debug.Log(jsonData); _saleItems = JsonConvert.DeserializeObject <SaleItems>(jsonData); StartCoroutine(SpawnMenuItems()); } }