public bool Deletestaff(int staffid) { DatabaseDeleteQuery deletestaff = new DatabaseDeleteQuery("staff", "staffid= " + staffid); DatabaseDeleteQuery delAssm = new DatabaseDeleteQuery("markingassign", "staffid='" + staffid + "'"); delAssm.RunQuery(); return(deletestaff.RunQuery()); }
public bool Deletestud(int studid) { DatabaseDeleteQuery deletestud = new DatabaseDeleteQuery("student", "studid= " + studid); deletestud.RunQuery(); DatabaseDeleteQuery delAssm = new DatabaseDeleteQuery("markingassign", "studid='" + studid + "'"); delAssm.RunQuery(); return(true); }
public bool Updatestud(int studid, student s) { student studentInitial = Getstudbystudid(studid); if (studentInitial.mschemeassigned != s.mschemeassigned) { DatabaseDeleteQuery del = new DatabaseDeleteQuery("markingassign", "studid = '" + studid + "' AND mschemeid = '" + studentInitial.mschemeassigned + "'"); del.RunQuery(); } DatabaseUpdateQuery updatestud = new DatabaseUpdateQuery("student", "studid= '" + studid + "'"); updatestud.AddData("name", s.name); updatestud.AddData("dip", s.dip); updatestud.AddData("matricno", s.matricno); updatestud.AddData("mschemeassigned", s.mschemeassigned); return(updatestud.RunQuery()); }
public static Boolean deleteBooking(int bookingid) { DatabaseDeleteQuery r = new DatabaseDeleteQuery("Booking","bookingid="+bookingid); return r.RunQuery(); }
public bool Deleteassignment(int assignid) { DatabaseDeleteQuery deleteassignment = new DatabaseDeleteQuery("markingassign", "assignid=" + assignid); return(deleteassignment.RunQuery()); }
public bool ProcessNewAssignment(newAssignment assignment) { for (int x = 0; x < assignment.assignedStaff.Count; x++) { DatabaseRetriveQuery countofstaff = new DatabaseRetriveQuery("markingassign"); countofstaff.AddRestriction("studid", "=", assignment.studentId.ToString()); countofstaff.AddRestriction("staffid", "=", assignment.assignedStaff[x].staffId.ToString()); countofstaff.AddRestriction("mschemeid", "=", assignment.markingschemeId.ToString()); int count = countofstaff.NumRows(); if (count == 0) { DatabaseInsertQuery insertAssessment = new DatabaseInsertQuery("markingassign"); insertAssessment.AddData("studid", assignment.studentId.ToString()); insertAssessment.AddData("staffid", assignment.assignedStaff[x].staffId.ToString()); insertAssessment.AddData("mschemeid", assignment.markingschemeId.ToString()); insertAssessment.AddData("componentid", assignment.assignedStaff[x].componentsAssigned); insertAssessment.RunQuery(); } else { DatabaseUpdateQuery updateAssessment = new DatabaseUpdateQuery("markingassign", "studid = '" + assignment.studentId + "' AND staffid = '" + assignment.assignedStaff[x].staffId + "' AND mschemeid = '" + assignment.markingschemeId + "'"); updateAssessment.AddData("componentid", assignment.assignedStaff[x].componentsAssigned); updateAssessment.AddData("assessmsub", ""); updateAssessment.RunQuery(); } } DatabaseRetriveQuery listOfStaffAssigned = new DatabaseRetriveQuery("markingassign"); listOfStaffAssigned.AddRestriction("studid", "=", assignment.studentId.ToString()); listOfStaffAssigned.AddRestriction("mschemeid", "=", assignment.markingschemeId.ToString()); SqlDataReader dr = listOfStaffAssigned.RunQuery(); List <newAssignmentAssignedStaff> listOfStaffAssignedNow = new List <newAssignmentAssignedStaff>(); while (dr.Read()) { newAssignmentAssignedStaff tmp = new newAssignmentAssignedStaff(); tmp.staffId = (int)dr["staffid"]; tmp.componentsAssigned = (string)dr["componentid"]; listOfStaffAssignedNow.Add(tmp); } for (int x = 0; x < listOfStaffAssignedNow.Count; x++) { bool found = false; for (int y = 0; y < assignment.assignedStaff.Count; y++) { if (listOfStaffAssignedNow[x].staffId == assignment.assignedStaff[y].staffId) { found = true; break; } } if (!found) { DatabaseDeleteQuery deleteAssignment = new DatabaseDeleteQuery("markingassign", "studid = '" + assignment.studentId + "' AND staffid = '" + listOfStaffAssignedNow[x].staffId + "'"); deleteAssignment.RunQuery(); } } return(true); }
public bool Deletemarks(int mschemeid) { DatabaseDeleteQuery deletemarks = new DatabaseDeleteQuery("markingscheme", "mschemeid=" + mschemeid); return(deletemarks.RunQuery()); }