public static DialogResult Show(string Text, string btnYes)
{
MsgBox = new CustomMsgBox();
MsgBox.MsgBoxLabel.Text = Text;
MsgBox.Yesbtn.Text = btnYes;
MsgBox.ShowDialog();
return(result);
}
private void button2_Click(object sender, EventArgs e)
{
databaseAccess d1 = new databaseAccess();
string total = "select sum(TotalPrice) from ordereditems where orderID='" + Convert.ToInt32(label8.Text) + "'";
double finalPrice = d1.getValue(total);
string query = "insert into purchaseorders values ('" + Convert.ToInt32(label8.Text) + "','" + label9.Text + "','" + finalPrice + "','" + dateTimePicker1.Text + "')";
d1.InsertData(query);
CustomMsgBox.Show("Your order is succefully processed", "OK");
}
private void Pay1_Click(object sender, EventArgs e)
{
if (label20.Text == "XXXXXX")
{
CustomMsgBox.Show("Your Order Is Not Successfully Processed", "OK");
}
else
{
Bill b1 = new Bill(textBox5.Text, textBox7.Text, richTextBox1.Text, textBox6.Text, label20.Text, label24.Text, label22.Text, 1);
b1.Show();
}
}
private void button4_Click(object sender, EventArgs e)
{
CustomMsgBox.Show(" Completed ", "OK");
textBox6.Text = null;
textBox1.Text = null;
textBox2.Text = null;
richTextBox2.Text = null;
comboBox1.Text = null;
comboBox2.Text = null;
textBox7.Text = null;
label10.Text = "XXXXXXX";
}
private void button4_Click(object sender, EventArgs e)
{
databaseAccess d1 = new databaseAccess();
string query1 = "select count(*) from harasara.supplier where SupID='" + textBox6.Text + "'";
if (0 == d1.getValue(query1))
{
string query = "insert into harasara.supplier (SupID,supplierName,contactNumber,Address,Bank,AccountNumber) values ('" + textBox6.Text + "','" + textBox1.Text + "','" + textBox2.Text + "','" + richTextBox2.Text + "','" + comboBox2.Text + "','" + textBox7.Text + "')";
d1.InsertData(query);
CustomMsgBox.Show("Added New Supplier ", "OK");
}
}
public int getValue(string query)
{
con.Open();
try
{
cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = query;
int x = Convert.ToInt32(cmd.ExecuteScalar());
con.Close();
return(x);
}
catch (Exception ex)
{
CustomMsgBox.Show(ex.Message, "OK");
con.Close();
return(0);
}
}
public string getString(string query)
{
con.Open();
try
{
cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = query;
string x = cmd.ExecuteScalar().ToString();
con.Close();
return(x);
}
catch (Exception ex)
{
string charc = " ";
CustomMsgBox.Show(ex.Message, "OK");
con.Close();
return(charc);
}
}
private void PayB_Click(object sender, EventArgs e)
{
if (label7.Text == "SupplierID")
{
databaseAccess d2 = new databaseAccess();
string pID = "PU" + invoiceBill.Text + label2.Text;
if (pType == "Cash")
{
string query = "insert into purchasepayments values('" + pID + "','" + label8.Text + "','" + DateTime.Now.Date.ToString("yyyy-MM-dd") + ",,'" + pType + "','" + label2.Text + "','" + label1.Text + "','" + emailBill.Text + "')";
d2.InsertData(query);
}
else if (pType == "Credit")
{
string query = "insert into purchasepayments values('" + pID + "','" + label8.Text + "','" + DateTime.Now.Date.ToString("yyyy-MM-dd") + ",,'" + pType + "','" + label2.Text + "','" + label1.Text + "','" + emailBill.Text + "')";
d2.InsertData(query);
}
}
else
{
databaseAccess d1 = new databaseAccess();
string pID = "SL" + invoiceBill.Text + label2.Text;
if (pType == "Cash")
{
string query = "insert into harasara.payments(PaymentID,customerID,date,type,CardNumber,orderID,Price) values('" + pID + "','" + label8.Text + "','" + DateTime.Now.Date.ToString("yyyy-MM-dd") + "','" + pType + "','" + textBox1.Text + "','" + label2.Text + "','" + Convert.ToDouble(label1.Text) + "') ";
d1.InsertData(query);
}
else if (pType == "Credit")
{
string query = "insert into harasara.payments(PaymentID,customerID,date,type,CardNumber,orderID,Price) values('" + pID + "','" + label8.Text + "','" + DateTime.Now.Date.ToString("yyyy-MM-dd") + "','" + pType + "','" + textBox1.Text + "','" + label2.Text + "','" + Convert.ToDouble(label1.Text) + "') ";
d1.InsertData(query);
}
string dlQuery = "Delete from harasara.slorders where orderID='" + label2.Text + "'";
d1.deleterow(dlQuery);
CustomMsgBox.Show("Payment was successfull", "OK");
}
}
public void contactNumberValidation(string text, Label label)
{
try
{
Regex rx = new Regex(@"^(\+[0-9]{9})$");
bool x = rx.IsMatch(text);
if (x == true)
{
label.Text = " ";
}
else
{
label.ForeColor = Color.Red;
label.Text = " Invalid Contact Number ";
}
}
catch (Exception ex)
{
CustomMsgBox.Show(ex.Message, "OK");
}
}
//Insert new Customer Details in to database
public void getCustomerDetails()
{
//con.Open();
try {
string customer = textBox5.Text;
string number = textBox7.Text;
string email = textBox6.Text;
string address = richTextBox1.Text;
cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "insert into harasara.customer (customerName,contactNumber,Address,Email) values('" + customer + "','" + number + "','" + address + "','" + email + "')";
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
CustomMsgBox.Show(ex.Message, "OK");
}
//con.Close();
}