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