private void button5_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 updatequery = string.Format("update EMPLOYEES set EMPLOYEENAME= ('{0}'), JOINDATE= ('{1}'), LEAVEDATE= ('{2}'),CONTACTNUMBER= ('{3}'), NIC= ('{4}'), [ADDRESS]= ('{5}'), DESIGNATION= ('{6}'), SALARY= ('{7}'), [STATUS]= ('{8}') where EMPLOYEEID = ('{9}')", textBox4.Text, sdate, date2, maskedTextBox2.Text, maskedTextBox1.Text, textBox1.Text, textBox5.Text, Convert.ToInt32(textBox3.Text), textBox8.Text, Convert.ToInt32(textBox2.Text)); EventMangementSystemClass.Update(updatequery); 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 updatequery = string.Format("delete from DISTRIBUTOR where DISTRIBUTORID = ('{0}')", Convert.ToInt32(Vendoridtextbox.Text)); EventMangementSystemClass.Update(updatequery); 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 comboBox3_SelectedIndexChanged(object sender, EventArgs e) { string SHOW = string.Format("SELECT * FROM dbo.PRODUCTS WHERE PRODUCTNAME = ('{0}')", comboBox3.Text); EventMangementSystemClass.RecordShow(SHOW, dataGridView1); comboBox1.ResetText(); }
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 button4_Click(object sender, EventArgs e) { //try //{ string updatequery = string.Format("UPDATE DISTRIBUTOR SET NAME = ('{0}'), CONTACTNUMBER = ('{1}'),TRADEMARKID = ('{2}'), EMAIL = ('{3}') where DISTRIBUTORID=('{4}')", vendornametextbox.Text, maskedTextBox1.Text, Convert.ToInt32(textBox1.Text), emailtextbox.Text, Convert.ToInt32(Vendoridtextbox.Text)); EventMangementSystemClass.Update(updatequery); var query = string.Format("SELECT * FROM DISTRIBUTOR"); EventMangementSystemClass.RecordShow(query, dataGridView2); Vendoridtextbox.Clear(); vendornametextbox.Clear(); maskedTextBox1.Clear(); emailtextbox.Clear(); comboBox1.SelectedValue = "";; 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); sdate = startdatetimepicker.Value; date2 = lastdatetimepicker.Value; string updatequery = string.Format("delete from CUSTOMER where CUSTOMERID = ('{0}')", Convert.ToInt32(customeridtextbox.Text)); EventMangementSystemClass.Update(updatequery); customernametextbox.Clear(); customeridtextbox.Clear(); maskedTextBox2.Clear(); textBox2.Clear(); maskedTextBox1.Clear(); startdatetimepicker.ResetText(); STATUS.Clear(); lastdatetimepicker.ResetText(); CUSTOMER_INFORMATION_Load(sender, e); dataGridView2.Refresh(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button5_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 updatequery = string.Format("update ASSIGNEDTASKS set TASK= ('{0}'), STARTTIME= ('{1}'), ENDTIME= ('{2}'), REMARKS= ('{3}'), ASSIGNEDDATE= ('{4}'), TASKID= ('{5}'),EMPID= ('{6}') where ASSIGNEDTASKID = ('{6}')", textBox18.Text, sdate, date2, textBox21.Text, D, textBox5.Text, Convert.ToInt32(textBox7.Text), textBox3.Text); EventMangementSystemClass.Update(updatequery); textBox3.Clear(); textBox18.Clear(); textBox7.Clear(); textBox5.Clear(); comboBox1.ResetText(); textBox21.Clear(); dateTimePicker1.ResetText(); dateTimePicker2.ResetText(); dateTimePicker3.ResetText(); TASKS_Load(sender, e); dataGridView1.Refresh(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button4_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 updatequery = string.Format("UPDATE customer SET NAME = ('{0}'), CONTACTNUMBER = ('{1}'), [ADDRESS] = ('{2}'), NIC = ('{3}'), JOINDATE = ('{4}'), [STATUS] = ('{5}'), LEAVEDATE = ('{6}') WHERE CUSTOMERID =('{7}')", customernametextbox.Text, maskedTextBox2.Text, textBox2.Text, maskedTextBox1.Text, sdate, STATUS.Text, date2, Convert.ToInt32(customeridtextbox.Text)); EventMangementSystemClass.Update(updatequery); customernametextbox.Clear(); customeridtextbox.Clear(); maskedTextBox2.Clear(); textBox2.Clear(); maskedTextBox1.Clear(); startdatetimepicker.ResetText(); STATUS.Clear(); lastdatetimepicker.ResetText(); CUSTOMER_INFORMATION_Load(sender, e); dataGridView2.Refresh(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
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); 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 comboBox1_SelectedValueChanged(object sender, EventArgs e) { string SHOW = string.Format("SELECT * FROM dbo.CUSTOMER WHERE NAME = ('{0}')", comboBox1.Text); EventMangementSystemClass.RecordShow(SHOW, dataGridView2); comboBox1.ResetText(); //string SH = string.Format("SELECT * FROM dbo.CUSTOMER"); //EventMangementSystemClass.RecordShow(SH, dataGridView2); }
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 button7_Click(object sender, EventArgs e) { try { string SHOW = string.Format("SELECT * FROM dbo.CUSTOMER"); EventMangementSystemClass.RecordShow(SHOW, dataGridView2); } catch (Exception EX) { MessageBox.Show(EX.Message); } }
private void comboBox3_SelectedValueChanged(object sender, EventArgs e) { try { string SHOW = string.Format("SELECT * FROM PRODUCT"); EventMangementSystemClass.RecordShow(SHOW, dataGridView1); } catch (Exception EX) { MessageBox.Show(EX.Message); } }
private void SearchingCustomerIDtextbox_TextChanged(object sender, EventArgs e) { try { string SHOW = string.Format("SELECT * FROM dbo.DISTRIBUTOR WHERE NAME LIKE ('{0}%')", SearchingCustomerIDtextbox.Text); EventMangementSystemClass.RecordShow(SHOW, dataGridView2); textBox1.Clear(); } catch (Exception EX) { MessageBox.Show(EX.Message); } }
private void button5_Click(object sender, EventArgs e) { try { string SHOW = string.Format("SELECT * FROM dbo.CUSTOMER WHERE NAME LIKE ('{0}%')", textBox1.Text); EventMangementSystemClass.RecordShow(SHOW, dataGridView2); textBox1.Clear(); } catch (Exception EX) { MessageBox.Show(EX.Message); } }
private void VENDOR_INFORMATION_Load(object sender, EventArgs e) { try { string SHOW = string.Format("SELECT DISTRIBUTORID,NAME,dbo.DISTRIBUTOR.CONTACTNUMBER,dbo.DISTRIBUTOR.EMAIL,COMPANYNAME FROM dbo.DISTRIBUTOR INNER JOIN dbo.TRADEMARK ON dbo.TRADEMARK.TRADEMARKID = dbo.DISTRIBUTOR.TRADEMARKID "); EventMangementSystemClass.RecordShow(SHOW, dataGridView2); } catch (Exception EX) { MessageBox.Show(EX.Message); } // TODO: This line of code loads data into the 'seven86settings.TRADEMARK' table. You can move, or remove it, as needed. this.tRADEMARKTableAdapter.Fill(this.seven86settings.TRADEMARK); comboBox1.SelectedValue = "";; }
private void PLACE_ORDER_Load(object sender, EventArgs e) { comboBox1.Text = ""; // TODO: This line of code loads data into the 'seven86DataSet26.DISTRIBUTOR' table. You can move, or remove it, as needed. this.dISTRIBUTORTableAdapter.Fill(this.seven86DataSet26.DISTRIBUTOR); try { string SHOW = string.Format("Select PRODUCTID, PRODUCTNAME, INSTRUCTION, FORMULA as SPECIALITY, QUANTITYINSTOCK, PACKINGID, BATCHID, TRADEMARKID, RETAILPRICE, TRADEPRICE, MARKUP, EXPIRYDATE, MANUFACTUREDATE FROM PRODUCT "); EventMangementSystemClass.RecordShow(SHOW, dataGridView1); } 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 button8_Click(object sender, EventArgs e) { try { string DELETE = string.Format("delete from BATCH where BATCHID= ('{0}')", Convert.ToInt32(BatchIDtextbox.Text)); EventMangementSystemClass.DeleteQuery(DELETE); BatchIDtextbox.Clear(); textBox3.Clear(); dateTimePicker1.ResetText(); COMPANY_BATCH_PACKING_Load(sender, e); dataGridView3.Refresh(); } catch (Exception EX) { MessageBox.Show(EX.Message); } }
private void button2_Click(object sender, EventArgs e) { try { string updatequery = string.Format("update PACKINGTYPE set PACKINGTYPE= ('{0}'),VOLUME= ('{1}') where PACKINGID = ('{2}')", packingnametextBox.Text, packingvolumetextBox.Text, Convert.ToInt32(packingidtextBox.Text)); EventMangementSystemClass.Update(updatequery); packingidtextBox.Clear(); packingnametextBox.Clear(); packingvolumetextBox.Clear(); COMPANY_BATCH_PACKING_Load(sender, e); dataGridView2.Refresh(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button6_Click(object sender, EventArgs e) { try { string deletequery = string.Format("delete from PACKINGTYPE where PACKINGID= ('{0}')", Convert.ToInt32(packingidtextBox.Text)); EventMangementSystemClass.DeleteQuery(deletequery); packingidtextBox.Clear(); packingnametextBox.Clear(); packingvolumetextBox.Clear(); COMPANY_BATCH_PACKING_Load(sender, e); dataGridView2.Refresh(); } 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 button2_Click(object sender, EventArgs e) { try { System.DateTime sdate = default(System.DateTime); sdate = dateTimePicker1.Value; System.DateTime rdate = default(System.DateTime); rdate = dateTimePicker2.Value; var AllRecordQuery = string.Format("Select * from dbo.TAKEORDER inner join dbo.ORDEREDPRODUCTS on dbo.ORDEREDPRODUCTS.ORDERID= dbo.TAKEORDER.ORDERID where ORDERDATE >= ('{0}') and ORDERDATE <=('{1}')", sdate, rdate); dataGridView2.DataSource = EventMangementSystemClass.ReturnTable(AllRecordQuery); dataGridView2.Visible = true; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button7_Click(object sender, EventArgs e) { try { string deletequery = string.Format("delete from TASKS where TASKID= ('{0}')", textBox2.Text); EventMangementSystemClass.DeleteQuery(deletequery); textBox1.Clear(); textBox4.Clear(); textBox2.Clear(); TASKS_Load(sender, e); dataGridView1.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 button8_Click(object sender, EventArgs e) { try { string updatequery = string.Format("update TASKS set DETAILS= ('{0}'), TASKPURPOSE= ('{1}') where TASKID = ('{2}')", textBox1.Text, textBox4.Text, textBox2.Text); EventMangementSystemClass.Update(updatequery); textBox1.Clear(); textBox4.Clear(); textBox2.Clear(); TASKS_Load(sender, e); dataGridView1.Refresh(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button3_Click(object sender, EventArgs e) { try { string deletequery = string.Format("delete from TRADEMARK where COMPANYNAME= ('{0}')", textBox1.Text); EventMangementSystemClass.DeleteQuery(deletequery); 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 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 button4_Click(object sender, EventArgs e) { try { string updatequery = string.Format("update TRADEMARK set COMPANYNAME= ('{0}'), COMPANYADDRESS= ('{1}'), CONTACTNUMBER = ('{2}'), EMAIL = ('{3}') where COMPANYNAME = ('{4}')", textBox1.Text, textBox2.Text, maskedTextBox1.Text, textBox4.Text, textBox1.Text); EventMangementSystemClass.Update(updatequery); textBox1.Clear(); textBox2.Clear(); maskedTextBox1.Clear(); textBox4.Clear(); COMPANY_BATCH_PACKING_Load(sender, e); dataGridView1.Refresh(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }