private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
Important.ProdName = dataGridView1.CurrentRow.Cells[0].Value.ToString();
this.labelProdName.Text = Important.ProdName;
this.textBoxQuan.TabIndex = 0;
this.textBoxQuan.Text = "0";
string Query = "select Price from Product where ProdName = '" +
Important.ProdName + "'";
try
{
SqlCommand sel = new SqlCommand(Query, Important.conex);
Cost = Convert.ToDouble(sel.ExecuteScalar().ToString());
AmountMoney = Convert.ToInt32(textBoxQuan.Text) * Math.Round(Cost, 2);
}
catch (Exception ex)
{
Important.message = ex.GetType().ToString();
DialogMessageP dial = new DialogMessageP();
dial.ShowDialog();
this.textBoxQuan.Text = "";
}
labelPrice.Text = AmountMoney.ToString() + '$';
}
private void buttonDelete_Click(object sender, EventArgs e)
{
string Delete;
string Select;
if (this.richTextBoxSQLCondition.Text == "")
{
Delete = "delete from Product";
DialogConfirmationP conf = new DialogConfirmationP();
Important.message = "Doriti sa stergeti toate datele din tabel?";
conf.label1.Text = Important.message;
conf.ShowDialog();
}
else
{
Delete = "delete from Product where " + this.richTextBoxSQLCondition.Text;
DialogConfirmationP conf = new DialogConfirmationP();
Important.message = "Doriti sa stergeti aceste date din tabel?";
conf.label1.Text = Important.message;
conf.ShowDialog();
}
if (Important.confirm == true)
{
try
{
SqlCommand del = new SqlCommand(Delete, Important.conex);
del.ExecuteNonQuery();
}
catch (Exception ex)
{
Important.message = ex.GetType().ToString();
DialogMessageP dial = new DialogMessageP();
dial.ShowDialog();
}
}
Select = "select * from Product";
SqlCommand sel = new SqlCommand(Select, Important.conex);
SqlDataAdapter da = new SqlDataAdapter(sel);
DataSet ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
this.textBox1.Text = "";
this.textBox2.Text = "";
this.textBox3.Text = "";
this.textBox4.Text = "";
this.textBox5.Text = "";
this.textBox6.Text = "";
this.textBox7.Text = "";
this.textBox8.Text = "";
this.textBox9.Text = "";
this.textBox10.Text = "";
this.richTextBoxSQLCondition.Text = "";
}
private void buttonDisplay_Click(object sender, EventArgs e)
{
String Querry;
if (this.richTextBoxSQLCondition.Text == "")
{
Querry = "select * from Sale";
try
{
if (dataGridView1.Rows.Count == 0)
{
SqlCommand prt = new SqlCommand(Querry, Important.conex);
SqlDataAdapter da = new SqlDataAdapter(prt);
DataSet ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
}
else
{
dataGridView1.DataSource = null;
dataGridView1.Refresh();
}
}
catch (Exception ex)
{
Important.message = ex.GetType().ToString();
DialogMessageP dial = new DialogMessageP();
dial.ShowDialog();
}
}
else
{
Querry = "select * from Sale where " + this.richTextBoxSQLCondition.Text;
try
{
SqlCommand prt = new SqlCommand(Querry, Important.conex);
SqlDataAdapter da = new SqlDataAdapter(prt);
DataSet ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
}
catch (Exception ex)
{
Important.message = ex.GetType().ToString();
DialogMessageP dial = new DialogMessageP();
dial.ShowDialog();
}
}
}
private void textBoxQuan_TextChanged(object sender, EventArgs e)
{
string Query = "select Quantity from Product where ProdName = '" +
Important.ProdName + "'";
SqlCommand SQLprodQuan = new SqlCommand(Query, Important.conex);
try
{
int prodQuan = Convert.ToInt32(SQLprodQuan.ExecuteScalar().ToString());
if (Convert.ToInt32(this.textBoxQuan.Text) <= prodQuan)
{
Query = "select Price from Product where ProdName = '" +
Important.ProdName + "'";
string text;
try
{
SqlCommand sel = new SqlCommand(Query, Important.conex);
Cost = Convert.ToDouble(sel.ExecuteScalar().ToString());
text = this.textBoxQuan.Text;
if (text == "")
text = "0";
AmountMoney = Convert.ToInt32(text) * Math.Round(Cost, 2);
}
catch (Exception ex)
{
Important.message = ex.GetType().ToString();
DialogMessageP dial = new DialogMessageP();
dial.ShowDialog();
this.textBoxQuan.Text = "";
}
labelPrice.Text = AmountMoney.ToString() + '$';
}
else
{
DialogMessageP dial = new DialogMessageP();
Important.message = "Cantitatea selectata depaseste \ncantitatea disponibila pe stock";
dial.ShowDialog();
this.textBoxQuan.Text = "0";
}
}
catch
{
}
}
private void buttonInsert_Click(object sender, EventArgs e)
{
string Insert;
string Select;
Insert = "insert into Product values('"
+ this.textBox1.Text + "', '" + this.textBox2.Text + "', '"
+ this.textBox3.Text + "', '" + this.textBox4.Text + "', '"
+ this.textBox5.Text + "', '" + this.textBox6.Text + "', '"
+ this.textBox7.Text + "', '" + this.textBox8.Text + "', '"
+ this.textBox9.Text + "', '" + this.textBox10.Text + "'); ";
try
{
SqlCommand ins = new SqlCommand(Insert, Important.conex);
ins.ExecuteNonQuery();
}
catch (Exception ex)
{
Important.message = ex.GetType().ToString();
DialogMessageP dial = new DialogMessageP();
dial.ShowDialog();
}
Select = "select * from Product";
SqlCommand sel = new SqlCommand(Select, Important.conex);
SqlDataAdapter da = new SqlDataAdapter(sel);
DataSet ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
this.textBox1.Text = "";
this.textBox2.Text = "";
this.textBox3.Text = "";
this.textBox4.Text = "";
this.textBox5.Text = "";
this.textBox6.Text = "";
this.textBox7.Text = "";
this.textBox8.Text = "";
this.textBox9.Text = "";
this.textBox10.Text = "";
this.richTextBoxSQLCondition.Text = "";
}
private void buttonBuy_Click(object sender, EventArgs e)
{
DialogMessageP dial = new DialogMessageP();
DialogConfirmationP conf = new DialogConfirmationP();
string Query = "Select Charge from _User where Username = '******';";
try
{
if (Convert.ToInt32(this.textBoxQuan.Text) < 1)
{
Important.message = "Selecteaza cantitatea dorita de produse!";
dial.ShowDialog();
}
else
{
SqlCommand money = new SqlCommand(Query, Important.conex);
double charge = Convert.ToDouble(money.ExecuteScalar().ToString());
if (charge < AmountMoney)
{
Important.message = "Nu aveti bani suficienti!";
dial.ShowDialog();
}
else
{
Important.message = "Sunteti siguri ca doriti sa cumparati acest produs?";
conf.ShowDialog();
if (Important.confirm == true)
{
BuyProductTransaction();
Important.message = "Va multumim pentru ca ati cumparat acest produs!";
dial.ShowDialog();
}
}
}
}
catch { }
}
private void buttonUpdate_Click(object sender, EventArgs e)
{
string Update;
string Select;
string Check;
try
{
Check = "select ProdName from Product where " + this.richTextBoxSQLCondition.Text + ";";
SqlCommand comCheck1 = new SqlCommand(Check, Important.conex);
if (this.textBox1.Text == "")
{
this.textBox1.Text = comCheck1.ExecuteScalar().ToString();
}
Check = "select Type from Product where " + this.richTextBoxSQLCondition.Text + ";";
SqlCommand comCheck2 = new SqlCommand(Check, Important.conex);
if (this.textBox2.Text == "")
{
this.textBox2.Text = comCheck2.ExecuteScalar().ToString();
}
Check = "select Origin from Product where " + this.richTextBoxSQLCondition.Text + ";";
SqlCommand comCheck3 = new SqlCommand(Check, Important.conex);
if (this.textBox3.Text == "")
{
this.textBox3.Text = comCheck3.ExecuteScalar().ToString();
}
Check = "select Mass from Product where " + this.richTextBoxSQLCondition.Text + ";";
SqlCommand comCheck4 = new SqlCommand(Check, Important.conex);
if (this.textBox4.Text == "")
{
this.textBox4.Text = comCheck4.ExecuteScalar().ToString();
}
Check = "select Length from Product where " + this.richTextBoxSQLCondition.Text + ";";
SqlCommand comCheck5 = new SqlCommand(Check, Important.conex);
if (this.textBox5.Text == "")
{
this.textBox5.Text = comCheck5.ExecuteScalar().ToString();
}
Check = "select Caliber from Product where " + this.richTextBoxSQLCondition.Text + ";";
SqlCommand comCheck6 = new SqlCommand(Check, Important.conex);
if (this.textBox6.Text == "")
{
this.textBox6.Text = comCheck6.ExecuteScalar().ToString();
}
Check = "select Diameter from Product where " + this.richTextBoxSQLCondition.Text + ";";
SqlCommand comCheck7 = new SqlCommand(Check, Important.conex);
if (this.textBox7.Text == "")
{
this.textBox7.Text = comCheck7.ExecuteScalar().ToString();
}
Check = "select Filling from Product where " + this.richTextBoxSQLCondition.Text + ";";
SqlCommand comCheck8 = new SqlCommand(Check, Important.conex);
if (this.textBox8.Text == "")
{
this.textBox8.Text = comCheck8.ExecuteScalar().ToString();
}
Check = "select Quantity from Product where " + this.richTextBoxSQLCondition.Text + ";";
SqlCommand comCheck9 = new SqlCommand(Check, Important.conex);
if (this.textBox9.Text == "")
{
this.textBox9.Text = comCheck9.ExecuteScalar().ToString();
}
Check = "select Price from Product where " + this.richTextBoxSQLCondition.Text + ";";
SqlCommand comCheck10 = new SqlCommand(Check, Important.conex);
if (this.textBox10.Text == "")
{
this.textBox10.Text = comCheck10.ExecuteScalar().ToString();
}
Update = "update Product set ProdName = '" + this.textBox1.Text + "', Type = '"
+ this.textBox2.Text + "', Origin = '" + this.textBox3.Text + "', Mass = '"
+ this.textBox4.Text + "', Length = '" + this.textBox5.Text + "', Caliber = '"
+ this.textBox6.Text + "', Diameter = '" + this.textBox7.Text + "', Filling = '"
+ this.textBox8.Text + "', Quantity = '" + this.textBox9.Text + "', Price = '"
+ this.textBox10.Text + "' where " + this.richTextBoxSQLCondition.Text + ";";
SqlCommand upd = new SqlCommand(Update, Important.conex);
upd.ExecuteNonQuery();
}
catch (Exception ex)
{
Important.message = ex.GetType().ToString();
DialogMessageP dial = new DialogMessageP();
dial.ShowDialog();
}
Select = "select * from Product";
SqlCommand sel = new SqlCommand(Select, Important.conex);
SqlDataAdapter da = new SqlDataAdapter(sel);
DataSet ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
this.textBox1.Text = "";
this.textBox2.Text = "";
this.textBox3.Text = "";
this.textBox4.Text = "";
this.textBox5.Text = "";
this.textBox6.Text = "";
this.textBox7.Text = "";
this.textBox8.Text = "";
this.textBox9.Text = "";
this.textBox10.Text = "";
this.richTextBoxSQLCondition.Text = "";
}
private void button4_Click(object sender, EventArgs e)
{
string Update;
string Select;
string Check;
try
{
Check = "select FullName from _User where " + this.richTextBox1.Text + ";";
SqlCommand comCheck1 = new SqlCommand(Check, Important.conex);
if (this.textBox1.Text == "")
{
this.textBox1.Text = comCheck1.ExecuteScalar().ToString();
}
Check = "select Username from _User where " + this.richTextBox1.Text + ";";
SqlCommand comCheck2 = new SqlCommand(Check, Important.conex);
if (this.textBox2.Text == "")
{
this.textBox2.Text = comCheck2.ExecuteScalar().ToString();
}
Check = "select Email from _User where " + this.richTextBox1.Text + ";";
SqlCommand comCheck3 = new SqlCommand(Check, Important.conex);
if (this.textBox3.Text == "")
{
this.textBox3.Text = comCheck3.ExecuteScalar().ToString();
}
Check = "select Password from _User where " + this.richTextBox1.Text + ";";
SqlCommand comCheck4 = new SqlCommand(Check, Important.conex);
if (this.textBox4.Text == "")
{
this.textBox4.Text = comCheck4.ExecuteScalar().ToString();
}
Check = "select UserType from _User where " + this.richTextBox1.Text + ";";
SqlCommand comCheck5 = new SqlCommand(Check, Important.conex);
if (this.textBox5.Text == "")
{
this.textBox5.Text = comCheck5.ExecuteScalar().ToString();
}
Check = "select Charge from _User where " + this.richTextBox1.Text + ";";
SqlCommand comCheck6 = new SqlCommand(Check, Important.conex);
if (this.textBox6.Text == "")
{
this.textBox6.Text = comCheck6.ExecuteScalar().ToString();
}
Update = "update _User set FullName = '" + this.textBox1.Text + "', Username = '******', Email = '" + this.textBox3.Text + "', Password = '******', UserType = '" + this.textBox5.Text + "', Charge = " + Convert.ToDouble(this.textBox6.Text)
+ " where " + this.richTextBox1.Text + ";";
SqlCommand upd = new SqlCommand(Update, Important.conex);
upd.ExecuteNonQuery();
}
catch (Exception ex)
{
Important.message = ex.GetType().ToString();
DialogMessageP dial = new DialogMessageP();
dial.ShowDialog();
}
Select = "select * from _User";
SqlCommand sel = new SqlCommand(Select, Important.conex);
SqlDataAdapter da = new SqlDataAdapter(sel);
DataSet ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
this.textBox1.Text = "";
this.textBox6.Text = "";
this.textBox2.Text = "";
this.textBox3.Text = "";
this.textBox4.Text = "";
this.textBox5.Text = "";
this.richTextBox1.Text = "";
}
