public Accounting()
{
this.StartPosition = FormStartPosition.CenterScreen;
mysqlConn = new customerDbConn();
mysqlConn.connect();
InitializeComponent();
if (mysqlConn.connOpen() == true)
{
dataGridView1.DataSource = mysqlConn.qry("SELECT * FROM `orderdetails`").Tables[0];
dataGridView2.DataSource = mysqlConn.qry("SELECT * FROM `products`").Tables[0];
}
mysqlConn.connClose();
}
public Ticket()
{
this.StartPosition = FormStartPosition.CenterScreen;
InitializeComponent();
mysqlConn = new customerDbConn();
mysqlConn.connect();
if (mysqlConn.connOpen() == true)
{
dataGridView1.DataSource = mysqlConn.qry("SELECT * FROM `poll_main`").Tables[0];
dataGridView2.DataSource = mysqlConn.qry("SELECT * FROM `poll_options`").Tables[0];
dataGridView3.DataSource = mysqlConn.qry("SELECT * FROM `poll_votes`").Tables[0];
}
mysqlConn.connClose();
}
public Profit()
{
this.StartPosition = FormStartPosition.CenterScreen;
mysqlConn = new customerDbConn();
mysqlConn.connect();
InitializeComponent();
if (mysqlConn.connOpen() == true)
{
dataGridView1.DataSource = mysqlConn.qry("SELECT * FROM `sales`").Tables[0];
dataGridView2.DataSource = mysqlConn.qry("SELECT * FROM `orderdetails`").Tables[0];
dataGridView3.DataSource = mysqlConn.qry("SELECT * FROM `tblCustomer`").Tables[0];
dataGridView4.DataSource = mysqlConn.qry("SELECT * FROM `products`").Tables[0];
itemsSold.Text = "0";
}
mysqlConn.connClose();
}
public CRM()
{
this.StartPosition = FormStartPosition.CenterScreen;
InitializeComponent();
mysqlConn = new customerDbConn();
mysqlConn.connect();
if (mysqlConn.connOpen() == true)
{
dataGridView1.DataSource = mysqlConn.qry("SELECT * FROM `tblCustomer`").Tables[0];
}
mysqlConn.connClose();
}
private void Add_Click(object sender, EventArgs e)
{
string errorMsg;
if (!ValidFirstName(FirstName.Text, out errorMsg))
{
// Cancel the event and select the text to be corrected by the user.
// Set the ErrorProvider error with the text to display.
Alert.Show(errorMsg);
}
if (!ValidLastName(LastName.Text, out errorMsg))
{
// Cancel the event and select the text to be corrected by the user.
// Set the ErrorProvider error with the text to display.
Alert.Show(errorMsg);
}
else if (!ValidEmailAddress(Email.Text, out errorMsg))
{
// Set the ErrorProvider error with the text to display.
Alert.Show(errorMsg);
}
else
{
if (mysqlConn.connOpen() == true)
{
var Name = LastName.Text + " " + FirstName.Text;
mysqlConn.insertCustomer(Name, FirstName.Text, LastName.Text, TelNum.Text, address.Text, city.Text, Email.Text, country.Text);
dataGridView1.DataSource = mysqlConn.qry("SELECT * FROM `tblCustomer`").Tables[0];
Name = "";
}
}
}
