protected void AssignTest(object sender, EventArgs e) { Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('UpcomingTest')", true); if (Page.IsValid) { DBHandler.DBHandler db = new DBHandler.DBHandler(con); Entities.Notes n1 = new Entities.Notes() { teacher = Session["School"].ToString(), date = DateTime.Now.ToShortDateString(), description = TextArea2.Value, noteType = "Quiz", }; Entities.Section s1 = new Entities.Section() { sectionName = DropDownList5.SelectedValue, }; Entities.Class c1 = new Entities.Class() { className = DropDownList4.SelectedValue, }; Entities.Subjects s2 = new Entities.Subjects() { subjectName = DropDownList6.SelectedValue, }; db.AddNotes(n1, s2, s1, c1); TextArea2.Value = " "; } }
protected void AssignHomeWork(object sender, EventArgs e) { Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('AssignHomeWork')", true); if (Page.IsValid) { Stream str = FileUpload1.PostedFile.InputStream; BinaryReader br = new BinaryReader(str); Byte[] size = br.ReadBytes((int)str.Length); DBHandler.DBHandler db = new DBHandler.DBHandler(con); Entities.Notes n1 = new Entities.Notes() { teacher = Session["School"].ToString(), date = DateTime.Now.ToShortDateString(), fileName = Path.GetFileName(FileUpload1.PostedFile.FileName), dataFile = size, description = TextArea1.Value, noteType = "Assignment", }; Entities.Section s1 = new Entities.Section() { sectionName = DropDownList2.SelectedValue, }; Entities.Class c1 = new Entities.Class() { className = DropDownList1.SelectedValue, }; Entities.Subjects s2 = new Entities.Subjects() { subjectName = DropDownList3.SelectedValue, }; db.AddNotes(n1, s2, s1, c1); TextArea1.Value = " "; } }
public DataSet ShowSubNotes(Entities.Notes q1, Entities.personalInfo p1, Entities.Class c1) { DataSet ds; using (WSqlCommand dbCom = new WSqlCommand(dbconstring, "[dbo].[spShowSubNotes]")) { dbCom.AddParameter("@iam", System.Data.SqlDbType.NVarChar, p1.pKId); dbCom.AddParameter("@className", System.Data.SqlDbType.NVarChar, c1.className); dbCom.AddParameter("@noteType", System.Data.SqlDbType.NVarChar, q1.noteType); dbCom.AddParameter("@minDate", System.Data.SqlDbType.Date, q1.date); dbCom.AddParameter("@maxDate", System.Data.SqlDbType.Date, q1.date); ds = new DataSet(); ds = dbCom.Execute(); } return(ds); }
public void AddNotes(Entities.Notes c1, Entities.Subjects s2, Entities.Section s3, Entities.Class c2) { using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spAddNotes]")) { s1.AddParameter("@subjectName", System.Data.SqlDbType.NVarChar, s2.subjectName); s1.AddParameter("@sectionName", System.Data.SqlDbType.NVarChar, s3.sectionName); s1.AddParameter("@className", System.Data.SqlDbType.NVarChar, c2.className); s1.AddParameter("@teacher", System.Data.SqlDbType.NVarChar, c1.teacher); s1.AddParameter("@noteType", System.Data.SqlDbType.NVarChar, c1.noteType); s1.AddParameter("@assignDate", System.Data.SqlDbType.Date, c1.date); s1.AddParameter("@fileName", System.Data.SqlDbType.NVarChar, c1.fileName); s1.AddParameter("@dataFile", System.Data.SqlDbType.VarBinary, c1.dataFile); s1.AddParameter("@description", System.Data.SqlDbType.NVarChar, c1.description); s1.Execute(); } }
public void Quiz() { DBHandler.DBHandler db = new DBHandler.DBHandler(con); Entities.Notes t1 = new Entities.Notes() { noteType = "Quiz", }; Entities.personalInfo p1 = new Entities.personalInfo() { pKId = Session["School"].ToString(), }; Entities.Class c1 = new Entities.Class() { className = "Class 5", }; DataSet ds = new DataSet(); ds = db.ShowSubNotes(t1, p1, c1); GridView3.DataSource = ds; GridView3.DataBind(); }