private void button1_Click(object sender, EventArgs e)
{
try
{
string addquery = string.Format("insert into DISTRIBUTOR (NAME,CONTACTNUMBER,TRADEMARKID,EMAIL)values ('{0}','{1}','{2}','{3}')", vendornametextbox.Text, maskedTextBox1.Text, Convert.ToInt32(textBox1.Text), emailtextbox.Text);
EventMangementSystemClass.Add(addquery);
var query = string.Format("SELECT * FROM DISTRIBUTOR");
EventMangementSystemClass.RecordShow(query, dataGridView2);
Vendoridtextbox.Clear();
vendornametextbox.Clear();
maskedTextBox1.Clear();
emailtextbox.Clear();
comboBox1.Text = "";
textBox1.Clear();
companyaddresstextbox.Clear();
contactnumbertextbox.Clear();
emailaddresstextbox.Clear();
VENDOR_INFORMATION_Load(sender, e);
dataGridView2.Refresh();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button6_Click(object sender, EventArgs e)
{
try
{
System.DateTime sdate = default(System.DateTime);
System.DateTime date2 = default(System.DateTime);
System.DateTime D = default(System.DateTime);
D = dateTimePicker1.Value;
sdate = dateTimePicker2.Value;
date2 = dateTimePicker3.Value;
string addquery = string.Format("insert into ASSIGNEDTASKS (TASK,STARTTIME,ENDTIME,REMARKS,ASSIGNEDDATE,TASKID,EMPID) values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}')", textBox18.Text, sdate, date2, textBox21.Text, D, textBox5.Text, Convert.ToInt32(textBox7.Text));
EventMangementSystemClass.Add(addquery);
textBox3.Clear();
comboBox1.ResetText();
textBox7.Clear();
textBox18.Clear();
textBox5.Clear();
textBox21.Clear();
dateTimePicker1.ResetText();
dateTimePicker2.ResetText();
dateTimePicker3.ResetText();
TASKS_Load(sender, e);
dataGridView4.Refresh();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button6_Click(object sender, EventArgs e)
{
try
{
System.DateTime sdate = default(System.DateTime);
System.DateTime date2 = default(System.DateTime);
sdate = dateTimePicker2.Value;
date2 = dateTimePicker3.Value;
string addquery = string.Format("insert into EMPLOYEES(EMPLOYEENAME,JOINDATE,LEAVEDATE,CONTACTNUMBER,NIC,[ADDRESS],DESIGNATION,SALARY,[STATUS]) values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}')", textBox4.Text, sdate, date2, maskedTextBox2.Text, maskedTextBox1.Text, textBox1.Text, textBox5.Text, Convert.ToInt32(textBox3.Text), textBox8.Text);
EventMangementSystemClass.Add(addquery);
textBox2.Clear();
textBox4.Clear();
textBox3.Clear();
maskedTextBox1.Clear();
textBox5.Clear();
textBox1.Clear();
textBox8.Clear();
maskedTextBox1.ResetText();
dateTimePicker2.ResetText();
dateTimePicker3.ResetText();
ADD_EMPLOYEES_Load(sender, e);
dataGridView1.Refresh();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button2_Click(object sender, EventArgs e)
{
try
{
string addquery = string.Format("insert into dbo.RETURNBYCUSTOMER ( ORDERID,PRODUCTID,CUSTOMERID,RETURNQUANTITY,AMOUNT)values ('{0}','{1}','{2}','{3}','{4}')", Convert.ToInt32(textBox12.Text), Convert.ToInt32(label19.Text), Convert.ToInt32(label20.Text), Convert.ToInt32(textBox4.Text), Convert.ToDouble(textBox5.Text));
EventMangementSystemClass.Add(addquery);
string a = label1.Text;
int v1 = int.Parse(a);
int v2 = Convert.ToInt32(textBox4.Text);
int value = v1 + v2;
string queryUpdate = "Update dbo.PRODUCT set QUANTITYINSTOCK = " + value + " where PRODUCTID ='" + Convert.ToInt32(label20.Text) + "'";
EventMangementSystemClass.Update(queryUpdate);
int S1 = Convert.ToInt32(textBox14.Text);
int S2 = Convert.ToInt32(textBox4.Text);
int SvalueS = S1 - S2;
string queryUpdate2 = "Update dbo.ORDEREDPRODUCTS set QUANTITY = " + SvalueS + " where ORDERID ='" + Convert.ToInt32(textBox12.Text) + "'";
EventMangementSystemClass.Update(queryUpdate2);
textBox4.Clear(); textBox5.Clear(); textBox13.Clear(); textBox14.Clear();
MedicineReplacement_Load(sender, e);
dataGridView1.Refresh();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
//try
//{
// string Query = string.Format("select RETURNID from dbo.RETURNBYCUSTOMER where ORDERID = ('{0}')", textBox12.Text);
// SqlConnection connection = new SqlConnection(EventMangementSystemClass.Path);
// SqlCommand sc = new SqlCommand(Query, connection);
// connection.Open();
// SqlDataReader DR = sc.ExecuteReader();
// if (DR.Read())
// {
// label7.Text = DR.GetValue(0).ToString();
// textBox4.Clear();textBox5.Clear(); textBox13.Clear(); textBox14.Clear();
// }
// connection.Close();
//}
//catch (Exception ex)
//{
// MessageBox.Show(ex.Message);
//}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
System.DateTime sdate = default(System.DateTime);
System.DateTime date2 = default(System.DateTime);
sdate = startdatetimepicker.Value;
date2 = lastdatetimepicker.Value;
string addquery = string.Format("insert into CUSTOMER (NAME,CONTACTNUMBER,[ADDRESS],NIC,JOINDATE,[STATUS],LEAVEDATE)values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}')", customernametextbox.Text, maskedTextBox2.Text, textBox2.Text, maskedTextBox1.Text, sdate, STATUS.Text, date2);
EventMangementSystemClass.Add(addquery);
var query = string.Format("SELECT * FROM CUSTOMER");
EventMangementSystemClass.RecordShow(query, dataGridView2);
CUSTOMER_INFORMATION_Load(sender, e);
dataGridView2.Refresh();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
try
{
//string path = @"Data Source=AAMIR-PC\AMIR;Initial Catalog=Seven86;Integrated Security=True";
string Query = string.Format("select CUSTOMERID from CUSTOMER where NAME = ('{0}')", customernametextbox.Text);
SqlConnection connection = new SqlConnection(EventMangementSystemClass.Path);
SqlCommand sc = new SqlCommand(Query, connection);
connection.Open();
SqlDataReader DR = sc.ExecuteReader();
if (DR.Read())
{
customeridtextbox.Clear();
customeridtextbox.Text = DR.GetValue(0).ToString();
}
connection.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
//try
//{
// string SHOW = string.Format("SELECT * FROM dbo.CUSTOMER");
// EventMangementSystemClass.RecordShow(SHOW, dataGridView2);
//}
//catch (Exception EX)
//{
// MessageBox.Show(EX.Message);
//}
}
private void button5_Click(object sender, EventArgs e)
{
try
{
string addquery = string.Format("insert into PACKINGTYPE(PACKINGTYPE,VOLUME) values ('{0}','{1}')", packingnametextBox.Text, packingvolumetextBox.Text);
EventMangementSystemClass.Add(addquery);
packingidtextBox.Clear();
packingnametextBox.Clear();
packingvolumetextBox.Clear();
COMPANY_BATCH_PACKING_Load(sender, e);
dataGridView2.Refresh();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button9_Click(object sender, EventArgs e)
{
try
{
string addquery = string.Format("insert into TASKS (DETAILS,TASKPURPOSE) values ('{0}','{1}')", textBox1.Text, textBox4.Text);
EventMangementSystemClass.Add(addquery);
textBox1.Clear();
textBox4.Clear();
textBox2.Clear();
TASKS_Load(sender, e);
dataGridView1.Refresh();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
string addquery = string.Format("insert into TRADEMARK(COMPANYNAME,COMPANYADDRESS,CONTACTNUMBER,EMAIL) values ('{0}','{1}','{2}','{3}')", textBox1.Text, textBox2.Text, maskedTextBox1.Text, textBox4.Text);
EventMangementSystemClass.Add(addquery);
textBox1.Clear();
textBox2.Clear();
maskedTextBox1.Clear();
textBox4.Clear();
COMPANY_BATCH_PACKING_Load(sender, e);
dataGridView1.Refresh();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button5_Click(object sender, EventArgs e)
{
try
{
System.DateTime A = default(System.DateTime);
A = dateTimePicker1.Value;
string addquery = string.Format("insert into TAKEORDER (CUSTOMERID,ORDERDATE)values ('{0}','{1}')", Convert.ToInt32(textBox1.Text), A);
EventMangementSystemClass.Add(addquery);
string Query = string.Format("select ORDERID from TAKEORDER order by ORDERID desc");
SqlConnection connection = new SqlConnection(EventMangementSystemClass.Path);
SqlCommand sc = new SqlCommand(Query, connection);
connection.Open();
SqlDataReader DR = sc.ExecuteReader();
if (DR.Read())
{
textBox3.Text = DR.GetValue(0).ToString();
}
connection.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
for (int i = 0; i < ORD_PROD.Rows.Count; i++)
{
string addquery1 = string.Format("insert into ORDEREDPRODUCTS (ORDERID,PRODUCTID,QUANTITY,TOTALAMOUNT,DISCOUNT,GROSSAMOUNT)values ('{0}','{1}','{2}','{3}','{4}','{5}')", Convert.ToInt32(textBox3.Text), ORD_PROD.Rows[i].Cells[7].Value.ToString(), ORD_PROD.Rows[i].Cells[3].Value.ToString(), ORD_PROD.Rows[i].Cells[6].Value.ToString(), ORD_PROD.Rows[i].Cells[5].Value.ToString(), ORD_PROD.Rows[i].Cells[4].Value.ToString());
SqlConnection connection = new SqlConnection(EventMangementSystemClass.Path);
SqlCommand command = new SqlCommand(addquery1, connection);
connection.Open();
var RowEffected = command.ExecuteNonQuery();
if (RowEffected >= ORD_PROD.Rows.Count)
{
MessageBox.Show("Record Save SuccesFully!!!");
}
else if (RowEffected < 1)
{
MessageBox.Show("No Such record Saved Successfully!!!");
}
connection.Close();
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
System.DateTime sdate = default(System.DateTime);
System.DateTime date2 = default(System.DateTime);
sdate = dateTimePicker2.Value;
date2 = dateTimePicker3.Value;
string addquery = string.Format("insert into PRODUCT (PRODUCTNAME,INSTRUCTION,FORMULA,QUANTITYINSTOCK,PACKINGID,BATCHID,TRADEMARKID,RETAILPRICE,TRADEPRICE,MARKUP,MANUFACTUREDATE,EXPIRYDATE)values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}')", textBox2.Text, textBox3.Text, textBox9.Text, Convert.ToInt32(textBox4.Text), Convert.ToInt32(textBox15.Text), Convert.ToInt32(textBox14.Text), Convert.ToInt32(textBox13.Text), Convert.ToDouble(textBox6.Text), Convert.ToDouble(textBox5.Text), Convert.ToInt32(textBox19.Text), sdate, date2);
EventMangementSystemClass.Add(addquery);
textBox1.Clear();
textBox2.Clear();
textBox3.Clear();
textBox4.Clear();
textBox9.Clear();
textBox19.Clear();
textBox13.Clear();
comboBox4.Text = "";
dateTimePicker2.ResetText();
dateTimePicker3.ResetText();
textBox5.Clear();
textBox6.Clear();
comboBox4.Text = "";
textBox18.Clear();
maskedTextBox1.ResetText();
textBox17.Clear();
comboBox1.Text = "";
textBox14.Clear();
dateTimePicker1.ResetText();
comboBox2.Text = "";
textBox15.Clear();
textBox16.Clear();
ADD_NEW_PRODUCTS_Load(sender, e);
dataGridView2.Refresh();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button9_Click(object sender, EventArgs e)
{
try
{
System.DateTime sdate = default(System.DateTime);
sdate = dateTimePicker1.Value;
System.DateTime sdate1 = default(System.DateTime);
sdate1 = dateTimePicker1.Value;
System.DateTime sdate2 = default(System.DateTime);
sdate2 = dateTimePicker1.Value;
string addquery = string.Format("insert into BATCH(BATCHNAME,BATCHDATE) values ('{0}','{1}')", textBox3.Text, sdate);
EventMangementSystemClass.Add(addquery);
BatchIDtextbox.Clear();
textBox3.Clear();
dateTimePicker1.ResetText();
COMPANY_BATCH_PACKING_Load(sender, e);
dataGridView3.Refresh();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button5_Click(object sender, EventArgs e)
{
try
{
string addquery = string.Format("insert into dbo.PAYMENTBYCUSTOMER (CUSTOMERID,ORDERPRODUCTID,BILLAMOUNT,PAIDAMOUNT,BALANCE,STATUS) values ('{0}','{1}','{2}','{3}','{4}','{5}')", Convert.ToInt32(textBox6.Text), Convert.ToInt32(comboBox2.Text), Convert.ToDouble(textBox1.Text), Convert.ToInt32(textBox2.Text), Convert.ToInt32(textBox3.Text), comboBox1.Text);
EventMangementSystemClass.Add(addquery);
textBox6.Clear();
comboBox1.ResetText();
comboBox2.ResetText();
textBox7.Clear();
textBox8.Clear();
textBox1.Clear();
textBox2.Clear();
textBox3.Clear();
string SHOW = string.Format("SELECT * FROM dbo.PAYMENTBYCUSTOMER");
EventMangementSystemClass.RecordShow(SHOW, dataGridView2);
PAYMENT_Load(sender, e);
dataGridView2.Refresh();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}