private void calculations() { _bttn_newTrade.Enabled = false; MySqlDataReader Reader = null; float cost = 0; try { //mysql connection String connectionString = "server=127.0.0.1;uid=root;pwd=root;database=db_sm;"; MySqlConnection connection = new MySqlConnection(connectionString); connection.Open(); MySqlCommand cmd = connection.CreateCommand(); cmd.CommandText = "SELECT * FROM PRODUCT_MART WHERE BARCODE = " + _tb_barcode.Text; Reader = cmd.ExecuteReader(); while (Reader.Read()) { if (Reader["TYPE"].ToString() == "BİRİM") { ListViewItem lw = new ListViewItem(Reader["NAME"].ToString()); kiloScreen ks = new kiloScreen(); var result = ks.ShowDialog(); if (result == DialogResult.OK) { lw.SubItems.Add(ks.okValue); } cost = float.Parse(Reader["COST"].ToString()) * float.Parse(ks.okValue); lw.SubItems.Add(cost.ToString()); _lw_trade.Items.Add(lw); } else { //add item to listbox ListViewItem lw = new ListViewItem(Reader["NAME"].ToString()); lw.SubItems.Add("1"); cost = float.Parse(Reader["COST"].ToString()); lw.SubItems.Add(cost.ToString()); _lw_trade.Items.Add(lw); } } _tb_barcode.Text = ""; sum += cost; _tb_tradeResult.Text = sum.ToString() + " TL"; Reader.Close(); connection.Close(); } catch (Exception ex) { traceLogger logger = new traceLogger(); logger.enterRecord(ex.ToString()); } }
private void _bttn_record_Click(object sender, EventArgs e) { bool ifData = false; try { //mysql connection String connectionString = "server=127.0.0.1;uid=root;pwd=root;database=db_sm;"; MySqlConnection connection = new MySqlConnection(connectionString); connection.Open(); //mysql query execute MySqlCommand cmd = connection.CreateCommand(); cmd.CommandText = "SELECT * FROM PRODUCT_MART WHERE BARCODE = " + _tb_barcode.Text; MySqlDataReader Reader = cmd.ExecuteReader(); while (Reader.Read()) { if (Reader["NAME"].ToString() != "") { ifData = true; break; } } if (ifData) { MessageBox.Show(Reader["BARCODE"].ToString() + " BARKODLU ÜRÜNÜNÜZ " + Reader["NAME"].ToString() + " OLARAK KAYDI MEVCUTTUR.", "HATALI GİRİŞ", MessageBoxButtons.OK, MessageBoxIcon.Error); Reader.Close(); } else { Reader.Close(); cmd.CommandText = "INSERT INTO PRODUCT_MART VALUES(?name,?type,?cost,?barcode)"; cmd.Parameters.Add("?name", MySqlDbType.VarChar).Value = _tb_name.Text.ToUpper(); cmd.Parameters.Add("?type", MySqlDbType.VarChar).Value = _tb_type.Text.ToUpper(); cmd.Parameters.Add("?cost", MySqlDbType.Float).Value = float.Parse(_tb_cost.Text); cmd.Parameters.Add("?barcode", MySqlDbType.UInt64).Value = long.Parse(_tb_barcode.Text); cmd.ExecuteNonQuery(); MessageBox.Show(_tb_name.Text.ToUpper() + " ÜRÜNÜNÜZ " + _tb_type.Text.ToUpper() + " KATEGORİSİNDE " + _tb_cost.Text.ToUpper() + " ÜCRETİYLE KAYDEDİLMİŞTİR.", "KAYIT", MessageBoxButtons.OK, MessageBoxIcon.Information); } //messagebox //empty related records _tb_name.Text = ""; _tb_type.Text = ""; _tb_cost.Text = ""; _tb_barcode.Text = ""; connection.Close(); } catch (Exception ex) { traceLogger logger = new traceLogger(); logger.enterRecord(ex.ToString()); } }
private void button1_Click(object sender, EventArgs e) { string query = ""; int prodNameCheck = 0, typeCheck = 0; try { //datatable DataTable dt = new DataTable(); String connectionString = "server=127.0.0.1;uid=root;pwd=root;database=db_sm;"; MySqlConnection connection = new MySqlConnection(connectionString); connection.Open(); //mysql query execute MySqlCommand cmd = connection.CreateCommand(); query = "SELECT * FROM PRODUCT_MART WHERE "; if (_tb_productName.Text != "") { query += "NAME LIKE UPPER('%" + _tb_productName.Text + "%')"; prodNameCheck = 1; } if (_tb_type.Text != "") { if (prodNameCheck == 1) { query += " AND "; } query += "TYPE LIKE UPPER('%" + _tb_type.Text + "%')"; typeCheck = 1; } if (_tb_barcode.Text != "") { if (prodNameCheck == 1 || typeCheck == 1) { query += " AND "; } query += "BARCODE = " + _tb_barcode.Text; } cmd.CommandText = query; MySqlDataAdapter mySqlDataAdapter = new MySqlDataAdapter(cmd.CommandText, connection); mySqlDataAdapter.Fill(dt); dataGridView1.DataSource = dt; connection.Close(); } catch (Exception ex) { traceLogger logger = new traceLogger(); logger.enterRecord(ex.ToString()); } }
private void _bttn_erase_Click(object sender, EventArgs e) { string query = ""; int prodNameCheck = 0, typeCheck = 0; try { //datatable DataTable dt = new DataTable(); String connectionString = "server=127.0.0.1;uid=root;pwd=root;database=db_sm;"; MySqlConnection connection = new MySqlConnection(connectionString); connection.Open(); //mysql query execute MySqlCommand cmd = connection.CreateCommand(); query = "DELETE FROM PRODUCT_MART WHERE "; if (_tb_productName.Text != "") { query += "NAME LIKE UPPER('%" + _tb_productName.Text + "%')"; prodNameCheck = 1; } if (_tb_type.Text != "") { if (prodNameCheck == 1) { query += " AND "; } query += "TYPE LIKE UPPER('%" + _tb_type.Text + "%')"; typeCheck = 1; } if (_tb_barcode.Text != "") { if (prodNameCheck == 1 || typeCheck == 1) { query += " AND "; } query += "BARCODE = " + _tb_barcode.Text; } cmd.CommandText = query; cmd.ExecuteNonQuery(); connection.Close(); MessageBox.Show(_tb_barcode.Text + " BARKODLU ÜRÜNÜNÜZ SİLİNMİŞTİR."); overview_Load(sender, e); } catch (Exception ex) { traceLogger logger = new traceLogger(); logger.enterRecord(ex.ToString()); } }
private void button1_Click(object sender, EventArgs e) { try { barcodeReadWindow brw = new barcodeReadWindow(); var result = brw.ShowDialog(); if (result == DialogResult.OK) { _tb_barcode.Text = brw.okValue; } } catch (Exception ex) { traceLogger logger = new traceLogger(); logger.enterRecord(ex.ToString()); } }
private void button1_Click(object sender, EventArgs e) { int maximum = _lw_trade.SelectedItems.Count; try { for (int i = 0; i < maximum; i++) { sum -= float.Parse(_lw_trade.SelectedItems[0].SubItems[2].Text); _lw_trade.SelectedItems[0].Remove(); _tb_tradeResult.Text = sum.ToString() + " TL"; _tb_barcode.Focus(); } }catch (Exception ex) { traceLogger logger = new traceLogger(); logger.enterRecord(ex.ToString()); } }
private void button2_Click(object sender, EventArgs e) { try { String connectionString = "server=127.0.0.1;uid=root;pwd=root;database=db_sm;"; MySqlConnection connection = new MySqlConnection(connectionString); connection.Open(); //mysql query execute MySqlCommand cmd = connection.CreateCommand(); cmd.CommandText = "UPDATE PRODUCT_MART SET COST = ?cost WHERE BARCODE = " + _tb_updateBarcode.Text; cmd.Parameters.Add("?cost", MySqlDbType.Float).Value = _tb_updatePrice.Text; cmd.ExecuteNonQuery(); MessageBox.Show(_tb_updateBarcode.Text + " BARKOD NUMARALI ÜRÜNÜNÜZÜN (ADET/KG) FİYATI : " + _tb_updatePrice.Text + " TL OLARAK GÜNCELLENMİŞTİR"); overview_Load(sender, e); } catch (Exception ex) { traceLogger logger = new traceLogger(); logger.enterRecord(ex.ToString()); } }
private void overview_Load(object sender, EventArgs e) { try { //datatable DataTable dt = new DataTable(); String connectionString = "server=127.0.0.1;uid=root;pwd=root;database=db_sm;"; MySqlConnection connection = new MySqlConnection(connectionString); connection.Open(); //mysql query execute MySqlCommand cmd = connection.CreateCommand(); cmd.CommandText = "SELECT * FROM PRODUCT_MART"; MySqlDataAdapter mySqlDataAdapter = new MySqlDataAdapter(cmd.CommandText, connection); mySqlDataAdapter.Fill(dt); dataGridView1.DataSource = dt; connection.Close(); } catch (Exception ex) { traceLogger logger = new traceLogger(); logger.enterRecord(ex.ToString()); } }