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