protected void btnUpdate_Click(object sender, EventArgs e)
{
for (int i = 0; i < gridViewAttendance.Rows.Count; i++)
{
int resultDt = 0;
DataSet.DsPSMS.ST_ATTENDANCE_DATARow row = new DataSet.DsPSMS.ST_ATTENDANCE_DATADataTable().NewST_ATTENDANCE_DATARow();
row.EDU_YEAR = Convert.ToInt16(eduYearList.Text);
row.STUDENT_ID = gridViewAttendance.Rows[i].Cells[0].Text;
row.ATTENDANCE_DATE = attendDate.Text;
CheckBox chkAM = (CheckBox)gridViewAttendance.Rows[i].FindControl("AM");
if (chkAM != null && chkAM.Checked == false)
{
row.MORNING = "0";
}
else
{
row.MORNING = "1";
}
CheckBox chkPM = (CheckBox)gridViewAttendance.Rows[i].FindControl("PM");
if (chkPM != null && chkPM.Checked == false)
{
row.EVENING = "0";
}
else
{
row.EVENING = "1";
}
resultDt = attService.updateAttendanceRecord(row, out msg);
showAllButton();
}
}
public DataSet.DsPSMS.ST_ATTENDANCE_DATADataTable selectAttendanceByDate(DataSet.DsPSMS.ST_ATTENDANCE_DATARow dr)
{
if (dr == null)
{
return(null);
}
string query = "SELECT * FROM ST_ATTENDANCE_DATA ";
string where = "";
if (dr.STUDENT_ID != null)
{
where += " STUDENT_ID = '" + dr.STUDENT_ID + "'";
}
if (dr.ATTENDANCE_DATE != null)
{
if (where.Length > 0)
{
where += " AND ATTENDANCE_DATE= '" + dr.ATTENDANCE_DATE.ToString() + "'";
}
}
if (where.Length > 0)
{
query += " WHERE " + where;
}
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet.DsPSMS.ST_ATTENDANCE_DATADataTable dt = new DataSet.DsPSMS.ST_ATTENDANCE_DATADataTable();
da.Fill(dt);
return(dt);
}
public DataSet.DsPSMS.ST_ATTENDANCE_DATADataTable getAttendanceByDate(DataSet.DsPSMS.ST_ATTENDANCE_DATARow dr)
{
if (dr == null)
{
return(null);
}
try
{
db.Open();
DataSet.DsPSMS.ST_ATTENDANCE_DATADataTable dt = db.selectAttendanceByDate(dr);
if (dt != null && (dt.Rows.Count > 0))
{
return(dt);
}
else
{
return(null);
}
}
catch
{
return(null);
}
finally
{
db.Close();
}
}
public DataSet.DsPSMS.ST_ATTENDANCE_DATADataTable selectAttendanceList(DataSet.DsPSMS.ST_ATTENDANCE_DATARow dr)
{
DataSet.DsPSMS.ST_ATTENDANCE_DATADataTable result = new DataSet.DsPSMS.ST_ATTENDANCE_DATADataTable();
try
{
db.Open();
result = db.selectAttendanceList(dr);
}
catch
{
return(null);
}
finally
{
db.Close();
}
return(result);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
if (checkAldyRecord())
{
ModelState.AddModelError(string.Empty, "Already Record! Choose another date");
}
else
{
studentRow = new DataSet.DsPSMS.ST_STUDENT_DATADataTable().NewST_STUDENT_DATARow();
studentRow.EDU_YEAR = Convert.ToInt16(eduYearList.Text);
studentRow.GRADE_ID = gradeList.Text;
studentRow.ROOM_ID = roomList.Text;
for (int i = 0; i < gridViewAttendance.Rows.Count; i++)
{
int resultDt = 0;
DataSet.DsPSMS.ST_ATTENDANCE_DATARow row = new DataSet.DsPSMS.ST_ATTENDANCE_DATADataTable().NewST_ATTENDANCE_DATARow();
row.STUDENT_ID = gridViewAttendance.Rows[i].Cells[0].Text;
row.EDU_YEAR = Convert.ToInt16(eduYearList.Text);
row.ATTENDANCE_DATE = attendDate.Text;
CheckBox chkAM = (CheckBox)gridViewAttendance.Rows[i].FindControl("AM");
if (chkAM != null && chkAM.Checked == false)
{
row.MORNING = "0";
}
else
{
row.MORNING = "1";
}
CheckBox chkPM = (CheckBox)gridViewAttendance.Rows[i].FindControl("PM");
if (chkPM != null && chkPM.Checked == false)
{
row.EVENING = "0";
}
else
{
row.EVENING = "1";
}
resultDt = attService.saveAttendanceRecord(row, out msg);
}
}
showAllButton();
}
private bool checkAldyRecord()
{
bool alreadyExist = false;
for (int i = 0; i < gridViewAttendance.Rows.Count; i++)
{
DataSet.DsPSMS.ST_ATTENDANCE_DATADataTable result = new DataSet.DsPSMS.ST_ATTENDANCE_DATADataTable();
DataSet.DsPSMS.ST_ATTENDANCE_DATARow drr = result.NewST_ATTENDANCE_DATARow();
drr.STUDENT_ID = gridViewAttendance.Rows[i].Cells[0].Text;
drr.ATTENDANCE_DATE = attendDate.Text;
result = attService.getAttendanceByDate(drr);
if (result != null && result.Rows.Count > 0)
{
alreadyExist = true;
}
else
{
alreadyExist = false;
}
}
return(alreadyExist);
}
public DataSet.DsPSMS.ST_ATTENDANCE_DATADataTable selectAttendanceList(DataSet.DsPSMS.ST_ATTENDANCE_DATARow dr)
{
string query = "SELECT * FROM ST_ATTENDANCE_DATA WHERE STUDENT_ID IN (" + dr.STUDENT_ID + ")";
if (dr.ATTENDANCE_DATE.Substring(0, 2) != "00")
{
query += " AND DAY(ATTENDANCE_DATE) LIKE " + dr.ATTENDANCE_DATE.Substring(0, 2);
}
if (dr.ATTENDANCE_DATE.Substring(3, 2) != "00")
{
query += " AND MONTH(ATTENDANCE_DATE) LIKE " + dr.ATTENDANCE_DATE.Substring(3, 2);
}
if (dr.ATTENDANCE_DATE.Substring(6, 4) != "0000")
{
query += " AND YEAR(ATTENDANCE_DATE) LIKE " + dr.ATTENDANCE_DATE.Substring(6, 4);
}
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet.DsPSMS.ST_ATTENDANCE_DATADataTable dt = new DataSet.DsPSMS.ST_ATTENDANCE_DATADataTable();
da.Fill(dt);
return(dt);
}
protected void btnSearch_Click(object sender, EventArgs e)
{
if (!checkValidation())
{
gridViewAttendance.DataSource = null;
gridViewAttendance.DataBind();
studentRow = new DataSet.DsPSMS.ST_STUDENT_DATADataTable().NewST_STUDENT_DATARow();
studentRow.EDU_YEAR = Convert.ToInt16(eduYearList.Text);
studentRow.GRADE_ID = gradeList.Text;
studentRow.ROOM_ID = roomList.Text;
studentRow.ROLL_NO = "";
studentRow.STUDENT_NAME = "";
if (attendDate.Text.Trim().Length == 0)
{
DataSet.DsPSMS.ST_STUDENT_DATADataTable resultDt = attService.selectStudentData(studentRow, out msg);
if (resultDt == null || resultDt.Count == 0)
{
ModelState.AddModelError(string.Empty, "Data doesn't found");
gridViewAttendance.DataSource = null;
gridViewAttendance.DataBind();
}
else
{
gridViewAttendance.DataSource = resultDt;
gridViewAttendance.DataBind();
}
}
else
{
DataSet.DsPSMS.ST_ATTENDANCE_DATARow adr = new DataSet.DsPSMS.ST_ATTENDANCE_DATADataTable().NewST_ATTENDANCE_DATARow();
adr.ATTENDANCE_DATE = attendDate.Text;
DataSet.DsPSMS.ATTENDANCE_RESULTDataTable resultDt = attService.selectAttendanceData(studentRow, adr, out msg);
if (resultDt.Count != 0)
{
gridViewAttendance.DataSource = resultDt;
gridViewAttendance.DataBind();
for (int i = 0; i < resultDt.Count; i++)
{
Label date = (Label)gridViewAttendance.Rows[i].FindControl("Date");
date.Text = resultDt.Rows[i]["ATTENDANCE_DATE"].ToString();
CheckBox chkAM = (CheckBox)gridViewAttendance.Rows[i].FindControl("AM");
chkAM.Checked = false;
if (Convert.ToInt16(resultDt.Rows[i]["MORNING"]) == 1)
{
chkAM.Checked = true;
}
else
{
chkAM.Checked = false;
}
CheckBox chkPM = (CheckBox)gridViewAttendance.Rows[i].FindControl("PM");
chkPM.Checked = false;
if (Convert.ToInt16(resultDt.Rows[i]["EVENING"]) == 1)
{
chkPM.Checked = true;
}
else
{
chkPM.Checked = false;
}
}
}
}
showAllButton();
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
if (!checkValidation())
{
studentRow = new DataSet.DsPSMS.ST_STUDENT_DATADataTable().NewST_STUDENT_DATARow();
stdResult = new DataSet.DsPSMS.ST_STUDENT_DATADataTable();
studentRow.GRADE_ID = ddlGrade.Text;
studentRow.ROOM_ID = ddlClass.Text;
studentRow.STUDENT_NAME = txtName.Text;
stdResult = attService.selectStudentId(studentRow);
attRow = new DataSet.DsPSMS.ST_ATTENDANCE_DATADataTable().NewST_ATTENDANCE_DATARow();
attResult = new DataSet.DsPSMS.ST_ATTENDANCE_DATADataTable();
if (ddlDay.SelectedIndex != 0)
{
attRow.ATTENDANCE_DATE = ddlDay.Text + "/";
}
else
{
attRow.ATTENDANCE_DATE = "00/";
}
if (ddlMonth.SelectedIndex != 0)
{
attRow.ATTENDANCE_DATE += ddlMonth.Text + "/";
}
else
{
attRow.ATTENDANCE_DATE += "00/";
}
if (ddlYear.SelectedIndex != 0)
{
attRow.ATTENDANCE_DATE += ddlYear.Text;
}
else
{
attRow.ATTENDANCE_DATE += "0000";
}
if (stdResult.Count > 0)
{
if (stdResult.Count == 1)
{
attRow.STUDENT_ID = stdResult.Rows[0]["STUDENT_ID"].ToString();
}
else
{
attRow.STUDENT_ID = "";
for (int i = 0; i < stdResult.Count; i++)
{
attRow.STUDENT_ID += stdResult.Rows[i]["STUDENT_ID"] + ",";
}
attRow.STUDENT_ID = attRow.STUDENT_ID.Substring(0, attRow.STUDENT_ID.Length - 1);
}
attResult = attService.selectAttendanceList(attRow);
}
if (attResult.Count == 0)
{
ModelState.AddModelError(string.Empty, "Data does not exist!");
}
gvAttendanceList.DataSource = attResult;
gvAttendanceList.DataBind();
}
}
