private void button1_Click(object sender, EventArgs e) { String EMAIL = UEmail.Text; if (!qdb.CheckUser(EMAIL)) { String NAME = UName.Text; String ADDRESS = UAddress.Text; String MOBILE = UMobile.Text; String GENDER = " "; if (UMale.Checked) { GENDER = "Male"; } if (UFemale.Checked) { GENDER = "Female"; } if (qdb.CreateUser(EMAIL, NAME, MOBILE, ADDRESS, GENDER)) { MessageBox.Show("User Created"); this.Dispose(); } else { MessageBox.Show("There is some problem in creating user"); } } else { MessageBox.Show("User already Exist"); } }
private void button5_Click(object sender, EventArgs e) { int user = pb.CheckUserExist(BName.Text, BMobile.Text); if (BName.Text != "" || BMobile.Text != "") { if (user > 0) { if (pb.CreateSell(DateTime.Now.ToString(), user, Convert.ToInt32(label10.Text), Convert.ToInt32(label7.Text), pb.ID)) { int b = 0; int sid = pb.GetMaxID("Sell"); //String name; int qty, price, pid; foreach (DataGridViewRow p in dataGridView3.Rows) { // name= dataGridView3.Rows[b].Cells["PName"].Value.ToString(); qty = Convert.ToInt32(dataGridView3.Rows[b].Cells["PQty"].Value.ToString()); price = Convert.ToInt32(dataGridView3.Rows[b].Cells["PPrice"].Value.ToString()); //total=Convert.ToInt32(dataGridView3.Rows[b].Cells["Total"].Value.ToString()); pid = Convert.ToInt32(dataGridView3.Rows[b].Cells["pid"].Value.ToString()); if (pb.CreateSellProduct(sid, pid, qty, price)) { } else { MessageBox.Show("there is an erroe " + b); } b++; } Bill bi = new Bill(b, BName.Text, (Convert.ToInt32(label7.Text)), sid); bi.Show(); BName.Text = ""; BMobile.Text = ""; textBox5.Text = "0"; textBox4.Text = "0"; dataGridView3.Rows.Clear(); dataGridView3.Refresh(); label7.Text = "0"; minus.Text = "( 0 - 0 )"; } } else { //String ot= "none"; if (pb.CreateUser(" ", BName.Text, BMobile.Text, " ", " ")) { user = pb.CheckUserExist(BName.Text, BMobile.Text); if (user > 0) { if (pb.CreateSell(DateTime.Now.ToString(), user, Convert.ToInt32(label10.Text), Convert.ToInt32(label7.Text), pb.ID)) { int b = 0; int sid = pb.GetMaxID("Sell"); //String name; int qty, price, pid; foreach (DataGridViewRow p in dataGridView3.Rows) { // name= dataGridView3.Rows[b].Cells["PName"].Value.ToString(); qty = Convert.ToInt32(dataGridView3.Rows[b].Cells["PQty"].Value.ToString()); price = Convert.ToInt32(dataGridView3.Rows[b].Cells["PPrice"].Value.ToString()); //total=Convert.ToInt32(dataGridView3.Rows[b].Cells["Total"].Value.ToString()); pid = Convert.ToInt32(dataGridView3.Rows[b].Cells["pid"].Value.ToString()); if (pb.CreateSellProduct(sid, pid, qty, price)) { } else { MessageBox.Show("SellProduct insert Erroe " + b); } b++; } Bill bi = new Bill(b + 1, BName.Text, (Convert.ToInt32(label7.Text)), sid); bi.Show(); BName.Text = ""; BMobile.Text = ""; textBox5.Text = "0"; textBox4.Text = "0"; dataGridView3.Rows.Clear(); dataGridView3.Refresh(); label7.Text = "0"; minus.Text = "( 0 - 0 )"; } } } } } }