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