public string UpdateJob(string equipment, string employeeID, string jobNumber) { DBhandler db = new DBhandler(); //TODO : Handle Department table string dbresult = db.SingleInsertUpdate("UPDATE Equipment_Scrum SET Status = 'End' WHERE([Equipment No_] = '" + equipment + "')"); if (dbresult == "1") { dbresult = db.SingleInsertUpdate("UPDATE WorkInProgress SET [Date End] = '" + DateTime.Now.ToString("yyyy-MM-dd") + "' WHERE(Job = '" + jobNumber + "')"); if (dbresult == "1") { dbresult = db.SingleInsertUpdate("UPDATE Time_Employee SET Time_End = '" + DateTime.Now.ToString("HH:mm:ss") + "' WHERE(ID_employee = '" + employeeID + "')"); } } return(dbresult); }
private void button1_Click(object sender, EventArgs e) { if (textBox1.Text.Length == 0) { MessageBox.Show("Enter message tiltle"); } else { if (msg.Text.Length == 0) { MessageBox.Show("Enter Message body"); } else { DBhandler v = new DBhandler(); v.Ins_Up_Del("insert into messages(title,message) values('" + textBox1.Text.ToString() + "','" + msg.Text.ToString() + "')"); MessageBox.Show("Message insrted succesfully"); } } }
public string InsertJob(string equipment, string employeeID, string jobNumber, string itemNumber, string coreNumber, string coreTotal, string phase) { DBhandler db = new DBhandler(); string dbresult = db.SingleInsertUpdate("INSERT INTO ScrumTable(Job, Item, CoreTotal, ToDo, Doing, Done)VALUES('" + jobNumber + "','" + itemNumber + "'," + coreTotal + ",0,0,0)"); if (dbresult == "1") { //TODO : Handle Department table dbresult = db.SingleInsertUpdate("INSERT INTO Equipment_Scrum([Equipment No_], Job, Item, Core, CoreTotal, Phases, Status) VALUES('" + equipment + "', '" + jobNumber + "', '" + itemNumber + "', " + coreNumber + ", " + coreTotal + ", '" + phase + "', 'Start')"); if (dbresult == "1") { dbresult = db.SingleInsertUpdate("INSERT INTO WorkInProgress(No_, Job, Item, [Customer No_], [Customer Description], [Core Description], Core, CoreTotal, Location, Operation, [Badge Start], [Date Start], [Badge End], [Date End], [No Operator], [Weight for Unit kg], [Thickness mm], [Static mm], [Column 1 Measure mm], [Central Measure mm], [Column 2 Measure mm], [Actual Phases],[Department Code])VALUES('','" + jobNumber + "','" + itemNumber + "','','',''," + coreNumber + "," + coreTotal + ",'','','','" + DateTime.Now.ToString("yyyy-MM-dd") + "','','',0,0,0,0,0,0,0,'','')"); if (dbresult == "1") { dbresult = db.SingleInsertUpdate("INSERT INTO Time_Employee(PK_Time_Employee, FK_WorkInProgress_No_, ID_employee, Time_Start, Time_End)VALUES('','','" + employeeID + "','" + DateTime.Now.ToString("HH:mm:ss") + "','')"); } } } return(dbresult); }