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