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