protected void UpdateAttendance(object sender, EventArgs e) { Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('TAttendance')", true); if (Page.IsValid) { foreach (GridViewRow row in GridView1.Rows) { if (row.RowType == DataControlRowType.DataRow) { CheckBox Status = row.FindControl("Status") as CheckBox; bool attendanceStatus = Status.Checked ? true : false; string pKId = (row.FindControl("pKId") as Label).Text.Trim(); string sttendenceDate = (this.Date.Text.Trim()); DBHandler.DBHandler db = new DBHandler.DBHandler(con); Entities.TAttendance t1 = new Entities.TAttendance() { pKId = pKId, date = sttendenceDate, attendance = attendanceStatus, }; db.InsertTeacherAttendance(t1); AttendanceLabel.Text = "Updated Successfully"; } } } }
public void InsertTeacherAttendance(Entities.TAttendance c1) { using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spInsertTeacherAttendance]")) { s1.AddParameter("@pKId", System.Data.SqlDbType.NVarChar, c1.pKId); s1.AddParameter("@date", System.Data.SqlDbType.Date, c1.date); s1.AddParameter("@attendance ", System.Data.SqlDbType.Bit, c1.attendance); s1.Execute(); } }
protected void UpdateAttendance(object sender, EventArgs e) { Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('TAttendance')", true); if (Page.IsValid) { foreach (GridViewRow row in GridView1.Rows) { if (row.RowType == DataControlRowType.DataRow) { CheckBox Status = row.FindControl("Status") as CheckBox; bool attendanceStatus = Status.Checked ? true : false; string pKId = (row.FindControl("pKId") as Label).Text.Trim(); string sttendenceDate = (this.Date.Text.Trim()); DBHandler.DBHandler db = new DBHandler.DBHandler(con); Entities.TAttendance t1 = new Entities.TAttendance() { pKId = pKId, date = sttendenceDate, attendance = attendanceStatus, }; db.InsertTeacherAttendance(t1); AttendanceLabel.Text = "Updated Successfully"; } } } }