/// <summary> /// Returns /// </summary> /// <returns></returns> public int assignedHours() { DataTable dt = DatabaseQuery.DBQuery(String.Format("select * from demos where DemoID = {0}", ID)); hours = dt.Rows.Count; return(hours); }
/// <summary> /// removes demo from database /// </summary> public void removeFromDB() { // Remove demo from all tables DatabaseQuery.DBInsert(String.Format(@"delete from enrolled where demoID = {0}; delete from previouslyDemoed where demoID = {0}; delete from preferredPaper where demoID = {0} delete from demoTimeTable where demoID = {0}", ID)); DatabaseQuery.DBInsert(String.Format("delete from Demos where DemoID = {0}; delete from demonstrator where studentID='{0}'", ID)); }
/// <summary> /// Updates demos attributes to database /// </summary> public void updateDB() { DatabaseQuery.DBInsert(String.Format(@" update DEMONSTRATOR SET name='{0}', lastName='{1}', phoneNo='{2}', gender='{3}', username='******', summerAddr='{5}', major='{6}', degree='{7}', studyYear={8}, email='{9}', lastYear={10}, age={11} where studentID = '{12}'", firstName, familyName, phone, gender, username, summer, major, degree, year, email, last.Equals("1") ? 1 : 0, age, ID)); // add enrolled, prefered and experience papers by removing old and inserting new DatabaseQuery.DBInsert(String.Format("delete from enrolled where demoID={0}", ID)); foreach (String s in enrolled) { // prevents empty lines if (s != "") { DatabaseQuery.DBInsert(String.Format("insert into enrolled(paperCode, demoID) Values('{0}', {1})", s, ID)); } } DatabaseQuery.DBInsert(String.Format("delete from preferredPaper where demoID={0}", ID)); foreach (String s in prefer) { // prevents empty lines if (s != "") { DatabaseQuery.DBInsert(String.Format("insert into preferredPaper Values('{0}', {1})", s, ID)); } } DatabaseQuery.DBInsert(String.Format("delete from previouslyDemoed where demoID={0}", ID)); foreach (String s in experience) { // prevents empty lines if (s != "") { DatabaseQuery.DBInsert(String.Format("insert into previouslyDemoed Values('{0}', {1})", s, ID)); } } DatabaseQuery.DBInsert(String.Format("delete from demoTimeTable where demoID = {0}", ID)); foreach (Tuple <String, String> t in mapBoolToTime(freeTime)) { DatabaseQuery.DBInsert(String.Format("insert into demoTimeTable Values('{0}','{1}', {2})", t.Item1, t.Item2, ID)); } // set non free demo time slots //for (int i = 0; i < freeTime.GetLength(0); i++) //{ // for (int j = 0; j < freeTime.GetLength(1); j++) // { // if (freeTime[i, j]) // DatabaseQuery.DBInsert(String.Format("insert into demoTimeTable Values({0},{1})", ID, intToDay(i), j)); //////////////////////////////////////////////////////////////////////////////// CHANGE i TO MON, TUE etc. j to 1000, 1100, 1200 etc // } //} }
protected void updatePaperToDB(String code, String title, bool[,] times) { //Console.WriteLine(String.Format("delete from lab where code='{0}'; delete from paper where code='{0}'", code)); //DatabaseQuery.DBInsert(String.Format("delete from lab where paper='{0}'; delete from paper where code='{0}'", paper.Code)); // will remove assigned demos that are associated to a paper DatabaseQuery.DBInsert(String.Format(@"delete from Demos where LabID in ( select LabID from demos d, lab l where l.paper = '{0}' and d.labID = l.id);delete from lab where paper='{0}';delete from paper where code='{0}';", paper.Code)); addPaperToDB(code, title, times); this.mainForm.ListBoxPapers_Refresh(); }
/// <summary> /// add paper to database. /// </summary> /// <param name="title">paper title e.g. infomation discovery</param> /// <param name="code">paper code e.g. COMP103</param> /// <param name="times">2D bool array where true indicates time</param> protected void addPaperToDB(String code, String title, bool[,] times) { if (code != "") { // add paper DatabaseQuery.DBInsert("insert into paper Values('" + code + "', '" + title + "')"); // add time for paper foreach (Tuple <String, String> t in this.mainForm.mapBoolToTime(times)) { DatabaseQuery.DBInsert(String.Format("insert into lab Values('{0}','{1}', {2}, 'R.G.07')", code, t.Item1, t.Item2)); } } else { MessageBox.Show("Paper must have a paper code"); } }
/// <summary> /// Add demo to database /// </summary> public void addToDB() { DatabaseQuery.DBInsert(String.Format("INSERT INTO DEMONSTRATOR(studentID, name) VALUES('{0}', '{1}')", ID, firstName)); updateDB(); }