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());
}
