protected void UpdateAttendance(object sender, EventArgs e) { foreach (GridViewRow row in GridView2.Rows) { if (row.RowType == DataControlRowType.DataRow) { CheckBox Status = row.FindControl("Status") as CheckBox; bool attendanceStatus = Status.Checked ? true : false; CheckBox Status1 = row.FindControl("Status1") as CheckBox; bool smiles = Status1.Checked ? true : false; string pKId = (row.FindControl("SchoolID") as Label).Text.Trim(); DBHandler.DBHandler db = new DBHandler.DBHandler(con); Entities.Subjects s1 = new Entities.Subjects() { subjectName=DropDownList3.SelectedValue, }; Entities.SAttendance s2 = new Entities.SAttendance() { pKId=pKId, Sdate = TextBox1.Text, attendance=attendanceStatus, smilies=smiles, }; db.InsertStudentAttendance(s2,s1); } } Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('SAttendance')", true); }
protected void UpdateAttendance(object sender, EventArgs e) { foreach (GridViewRow row in GridView2.Rows) { if (row.RowType == DataControlRowType.DataRow) { CheckBox Status = row.FindControl("Status") as CheckBox; bool attendanceStatus = Status.Checked ? true : false; CheckBox Status1 = row.FindControl("Status1") as CheckBox; bool smiles = Status1.Checked ? true : false; string pKId = (row.FindControl("SchoolID") as Label).Text.Trim(); DBHandler.DBHandler db = new DBHandler.DBHandler(con); Entities.Subjects s1 = new Entities.Subjects() { subjectName = DropDownList3.SelectedValue, }; Entities.SAttendance s2 = new Entities.SAttendance() { pKId = pKId, Sdate = TextBox1.Text, attendance = attendanceStatus, smilies = smiles, }; db.InsertStudentAttendance(s2, s1); } } Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('SAttendance')", true); }
public void InsertStudentAttendance(Entities.SAttendance a1, Entities.Subjects c1) { using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spInsertStudentAttendance]")) { s1.AddParameter("@pkid", System.Data.SqlDbType.NVarChar, a1.pKId); s1.AddParameter("@subjectName", System.Data.SqlDbType.NVarChar, c1.subjectName); s1.AddParameter("@Sdate", System.Data.SqlDbType.Date, a1.Sdate); s1.AddParameter("@attendance", System.Data.SqlDbType.Bit, a1.attendance); s1.AddParameter("@smilies", System.Data.SqlDbType.Bit, a1.smilies); s1.Execute(); } }
public DataSet ShowStudentAttendacne(Entities.personalInfo p1, Entities.SAttendance s1, Entities.Subjects s2) { DataSet ds; using (WSqlCommand dbCom = new WSqlCommand(dbconstring, "[dbo].[spShowAttandus]")) { dbCom.AddParameter("@iAm", System.Data.SqlDbType.NVarChar, p1.pKId); dbCom.AddParameter("@subjectName", System.Data.SqlDbType.NVarChar, s2.subjectName); dbCom.AddParameter("@month", System.Data.SqlDbType.NVarChar, s1.Sdate); dbCom.AddOutputParameter("@smilies", System.Data.SqlDbType.Int); dbCom.AddOutputParameter("@sad", System.Data.SqlDbType.Int); dbCom.AddOutputParameter("@presents", System.Data.SqlDbType.Int); dbCom.AddOutputParameter("@absents", System.Data.SqlDbType.Int); ds = new DataSet(); ds = dbCom.Execute(); } return(ds); }
protected void ShowAttendance(object sender, EventArgs e) { DBHandler.DBHandler db = new DBHandler.DBHandler(con); Entities.personalInfo p1 = new Entities.personalInfo() { pKId = Session["School"].ToString(), }; Entities.Subjects s2 = new Entities.Subjects() { subjectName = DropDownList2.SelectedValue, }; Entities.SAttendance s1 = new Entities.SAttendance() { Sdate = DropDownList1.SelectedValue, }; DataSet ds = new DataSet(); ds = db.ShowStudentAttendacne(p1, s1, s2); GridView4.DataSource = ds; GridView4.DataBind(); Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('Attendance')", true); }