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