public ArrayList Getallmarks()
{
DatabaseRetriveQuery retrieveallmarks = new DatabaseRetriveQuery("markingscheme");
SqlDataReader dr = retrieveallmarks.RunQuery();
ArrayList result = new ArrayList();
while (dr.Read())
{
markingscheme ms = new markingscheme();
ms.mschemeid = (int)dr["mschemeid"];
ms.name = (string)dr["name"];
DatabaseRetriveQuery staffRet = new DatabaseRetriveQuery("staff");
staffRet.AddRestriction("staffid", "=", dr["createdby"].ToString());
SqlDataReader sdr = staffRet.RunQuery();
if (sdr.Read())
{
ms.createdby = (string)sdr["name"];
}
ms.mscheme = (string)dr["mscheme"];
result.Add(ms);
}
return(result);
}
public bool Updatemarks(int mschemeid, markingscheme ms)
{
DatabaseUpdateQuery updatemarks = new DatabaseUpdateQuery("markingscheme", "mschemeid= '" + mschemeid + "'");
updatemarks.AddData("createdby", ms.createdby);
updatemarks.AddData("mscheme", ms.mscheme);
return(updatemarks.RunQuery());
}
public bool Addmarks(markingscheme m)
{
DatabaseInsertQuery newmarks = new DatabaseInsertQuery("markingscheme");
newmarks.AddData("name", m.name);
newmarks.AddData("createdby", m.createdby);
newmarks.AddData("mscheme", m.mscheme);
return(newmarks.RunQuery());
}
/*public String Getstudbystudid(int studid)
* {
* DatabaseRetriveQuery retrievestud = new DatabaseRetriveQuery("student");
*
* retrievestud.AddRestriction("studid", "=", studid.ToString());
*
* SqlDataReader dr = retrievestud.RunQuery();
*
* String result = "";
*
* while (dr.Read())
* {
* student s = new student();
* s.studid = (int)dr["studid"];
* s.name = (string)dr["name"];
* s.dip = (string)dr["dip"];
* s.matricno = (string)dr["matricno"];
* result = ("studid: " +Convert.ToString(s.studid)+",name: "+ s.name+",dip: " +s.dip+",matricno: " + s.matricno +",");
* }
*
* return result;
* }*/
/*public ArrayList Getallstud()
* {
* DatabaseRetriveQuery retrievestud = new DatabaseRetriveQuery("student");
*
* SqlDataReader dr = retrievestud.RunQuery();
*
* ArrayList result = new ArrayList();
*
* while (dr.Read())
* {
* student s = new student();
* s.studid = (int)dr["studid"];
* s.name = (string)dr["name"];
* s.dip = (string)dr["dip"];
* s.matricno = (string)dr["matricno"];
* s.mschemeassigned = (string)dr["mschemeassigned"];
* result.Add(s);
* }
*
* return result;
* }*/
public ArrayList Getallstud()
{
/*DatabaseRetriveQuery retrievestud = new DatabaseRetriveQuery("student");
*
* retrievestud.AddOpend("ORDER BY mschemeassigned DESC");
*
* SqlDataReader dr = retrievestud.RunQuery();
*
* ArrayList result = new ArrayList();
*
* while (dr.Read())
* {
* student s = new student();
* s.studid = (int)dr["studid"];
* s.name = (string)dr["name"];
* s.dip = (string)dr["dip"];
* s.matricno = (string)dr["matricno"];
* s.mschemeassigned = (string)dr["mschemeassigned"];
* result.Add(s);
* }*/
ArrayList markingSchemes = (new markingschemedbmanager()).Getallmarks();
ArrayList studentsByMarkingScheme = new ArrayList();
for (int x = 0; x < markingSchemes.Count; x++)
{
markingscheme currentms = (markingscheme)markingSchemes[x];
ArrayList listOfStudentsInMarkingScheme = new ArrayList();
DatabaseRetriveQuery stuRet = new DatabaseRetriveQuery("student");
stuRet.AddRestriction("mschemeassigned", "=", currentms.mschemeid.ToString());
SqlDataReader dr = stuRet.RunQuery();
ArrayList result = new ArrayList();
while (dr.Read())
{
student s = new student();
s.studid = (int)dr["studid"];
s.name = (string)dr["name"];
s.dip = (string)dr["dip"];
s.matricno = (string)dr["matricno"];
s.mschemeassigned = (string)dr["mschemeassigned"].ToString();
result.Add(s);
}
studentsByMarkingScheme.Add(new { markingScheme = currentms, students = result });
}
return(studentsByMarkingScheme);
}
public ArrayList Getmarksbymarkingid(int mschemeid)
{
DatabaseRetriveQuery retrievemarks = new DatabaseRetriveQuery("markingscheme");
retrievemarks.AddRestriction("mschemeid", "=", mschemeid.ToString());
SqlDataReader dr = retrievemarks.RunQuery();
ArrayList result = new ArrayList();
while (dr.Read())
{
markingscheme ms = new markingscheme();
ms.mschemeid = (int)dr["mschemeid"];
ms.createdby = (string)dr["createdby"];
ms.mscheme = (string)dr["mscheme"];
result.Add(ms);
}
return(result);
}
