public DataSet.DsPSMS.ST_GRADE_MSTDataTable selectGradeByID(DataSet.DsPSMS.ST_GRADE_MSTRow dr, out string msg) { msg = null; DataSet.DsPSMS.ST_GRADE_MSTDataTable selectedGrade = new DataSet.DsPSMS.ST_GRADE_MSTDataTable(); if (dr == null) { msg = "data is empty "; return(selectedGrade); } try { db.Open(); if (dr.GRADE_ID != null) { selectedGrade = db.selectGradeByID(dr); } } catch { msg = "error has occure when insert data"; return(selectedGrade); } finally { db.Close(); } return(selectedGrade); }
public bool saveGrade(DataSet.DsPSMS.ST_GRADE_MSTRow dr, out string msg) { bool isOk = false; if (dr == null) { msg = "data is empty "; return(false); } try { db.Open(); int result = db.insertGrade(dr); msg = "insert complete"; } catch { msg = "error occurs when inserting data to ST_GRADE_MST table"; return(false); } finally { db.Close(); } return(isOk); }
public bool updateGrade(DataSet.DsPSMS.ST_GRADE_MSTRow dr, out string msg) { bool isOk = false; if (dr == null) { msg = "data is empty "; return(false); } try { db.Open(); int result = db.updateGrade(dr); msg = "update complete"; } catch { msg = "error has occure when update data"; return(false); } finally { db.Close(); } return(isOk); }
public int deleteGrade(DataSet.DsPSMS.ST_GRADE_MSTRow dr, out string msg) { int result; try { if (dr == null) { msg = "data is empty"; return(0); } else { db.Open(); result = db.deleteGrade(dr); msg = "grade deleted"; } } catch { msg = "error has occure when delete data"; return(0); } finally { db.Close(); } return(result); }
private void DisplayDatabydate(string date) { DataSet.DsPSMS.ST_TIMETABLEDataTable resultDt = timeService.getTimetableBydate(date); if (resultDt != null) { resultDt.Columns.Remove(resultDt.Columns["EDU_YEAR"]); resultDt.Columns.Remove(resultDt.Columns["CRT_DT_TM"]); resultDt.Columns.Remove(resultDt.Columns["CRT_USER_ID"]); resultDt.Columns.Remove(resultDt.Columns["UPD_DT_TM"]); resultDt.Columns.Remove(resultDt.Columns["UPD_USER_ID"]); resultDt.Columns.Remove(resultDt.Columns["DEL_FLG"]); resultDt.Columns.Remove(resultDt.Columns["TEACHER_ID"]); foreach (DataSet.DsPSMS.ST_TIMETABLERow row in resultDt.Rows) { int gradeId; string gradevalue = null; if (row.GRADE_ID != null) { gradeId = int.Parse(row.GRADE_ID); DataSet.DsPSMS.ST_GRADE_MSTRow grade = timeService.getGradeByid(gradeId); gradevalue = grade.GRADE_NAME; row.GRADE_ID = gradevalue; } } gvresultlist.DataSource = resultDt; gvresultlist.DataBind(); gvresultlist.HeaderRow.Cells[0].Text = "NO"; gvresultlist.HeaderRow.Cells[1].Text = "GRADE"; } }
public DataSet.DsPSMS.ST_GRADE_MSTDataTable selectGradeByID(DataSet.DsPSMS.ST_GRADE_MSTRow dr) { string query = "SELECT * FROM ST_GRADE_MST where GRADE_ID= '" + dr.GRADE_ID + "'"; SqlCommand cmd = new SqlCommand(query, conn); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet.DsPSMS.ST_GRADE_MSTDataTable dt = new DataSet.DsPSMS.ST_GRADE_MSTDataTable(); da.Fill(dt); return(dt); }
public int deleteGrade(DataSet.DsPSMS.ST_GRADE_MSTRow dr) { int result; string query = "UPDATE ST_GRADE_MST SET DEL_FLG = 1 WHERE "; query += " GRADE_ID = " + "'" + dr.GRADE_ID + "' AND"; query += " GRADE_NAME = " + "'" + dr.GRADE_NAME + "'"; SqlCommand cmd = new SqlCommand(query, conn); result = cmd.ExecuteNonQuery(); return(result); }
public int updateGrade(DataSet.DsPSMS.ST_GRADE_MSTRow dr) { int result; string query = "UPDATE ST_GRADE_MST SET "; if (dr.GRADE_NAME != null) { query += " GRADE_NAME ='" + dr.GRADE_NAME + "'"; } query += " WHERE GRADE_ID=" + dr.GRADE_ID; SqlCommand cmd = new SqlCommand(query, conn); result = cmd.ExecuteNonQuery(); return(result); }
private void DisplayData() { DataSet.DsPSMS.ST_TIMETABLEDataTable resultDt = timeService.getAllTimeTableData(out msg); if (resultDt != null) { // MessageBox.Show(msg); resultDt.Columns.Remove(resultDt.Columns["CRT_DT_TM"]); resultDt.Columns.Remove(resultDt.Columns["CRT_USER_ID"]); resultDt.Columns.Remove(resultDt.Columns["UPD_DT_TM"]); resultDt.Columns.Remove(resultDt.Columns["UPD_USER_ID"]); resultDt.Columns.Remove(resultDt.Columns["DEL_FLG"]); foreach (DataSet.DsPSMS.ST_TIMETABLERow row in resultDt.Rows) { int gradeId; string gradevalue = null; int teacherId; string teachervalue = null; if (row.GRADE_ID != null) { gradeId = int.Parse(row.GRADE_ID); DataSet.DsPSMS.ST_GRADE_MSTRow grade = timeService.getGradeByid(gradeId); gradevalue = grade.GRADE_NAME; row.GRADE_ID = gradevalue; } if (row.TEACHER_ID != null) { teacherId = int.Parse(row.TEACHER_ID); DataSet.DsPSMS.ST_TEACHER_DATARow teacher = timeService.getTeacherByid(teacherId); teachervalue = teacher.TEACHER_NAME; row.TEACHER_ID = teachervalue; } } dvtimetable.DataSource = resultDt; dvtimetable.DataBind(); dvtimetable.HeaderRow.Cells[1].Text = "Year"; dvtimetable.HeaderRow.Cells[2].Text = "ID"; dvtimetable.HeaderRow.Cells[3].Text = "GRADE"; dvtimetable.HeaderRow.Cells[4].Text = "TEACHER"; } }
public int insertGrade(DataSet.DsPSMS.ST_GRADE_MSTRow dr) { int result; if (dr == null) { return(-1); } int currentYear = DateTime.Now.Year; DateTime date = DateTime.Now.Date; String currentDate = date.ToString().Substring(0, 19); string query = "INSERT INTO ST_GRADE_MST (EDU_YEAR, GRADE_ID, GRADE_NAME, CRT_DT_TM, CRT_USER_ID, DEL_FLG) VALUES (" + currentYear + "," + dr.GRADE_ID + ",'" + dr.GRADE_NAME + "','" + currentDate + "', 1, 0)"; SqlCommand cmd = new SqlCommand(query, conn); result = cmd.ExecuteNonQuery(); return(result); }
public void DisplayRoomTeacher() { DataSet.DsPSMS.ST_TIMETABLE_HEDDataTable resultDt = timeService.getAllTimetableHedData(out msg); if (resultDt != null) { foreach (DataSet.DsPSMS.ST_TIMETABLE_HEDRow row in resultDt.Rows) { int gradeId; string gradevalue = null; int teacherId; string teachervalue = null; if (row.GRADE_ID != null) { gradeId = int.Parse(row.GRADE_ID); DataSet.DsPSMS.ST_GRADE_MSTRow grade = timeService.getGradeByid(gradeId); gradevalue = grade.GRADE_NAME; row.GRADE_ID = gradevalue; } if (row.ROOM_TEACHER_ID != null) { teacherId = int.Parse(row.ROOM_TEACHER_ID); DataSet.DsPSMS.ST_TEACHER_DATARow teacher = timeService.getTeacherByid(teacherId); teachervalue = teacher.TEACHER_NAME; row.ROOM_TEACHER_ID = teachervalue; } if (row.ROOM_ID != null) { int roomId = int.Parse(row.ROOM_ID); DataSet.DsPSMS.ST_ROOM_MSTRow room = timeService.getClassByid(roomId); string roomvalue = room.ROOM_NAME; row.ROOM_ID = roomvalue; } } gvRoomTeacher.DataSource = resultDt; gvRoomTeacher.DataBind(); } }
protected void btnUpdate_Click(object sender, EventArgs e) { LinkButton btn = (LinkButton)(sender); string editGradeId = btn.CommandName; gradeId.Text = editGradeId; gradeId.Enabled = false; gradeRow = new DataSet.DsPSMS.ST_GRADE_MSTDataTable().NewST_GRADE_MSTRow(); if (editGradeId != null) { gradeRow.GRADE_ID = editGradeId; } DataSet.DsPSMS.ST_GRADE_MSTDataTable gradeData = service.selectGradeByID(gradeRow, out msg); gradeName.Text = gradeData.Rows[0]["GRADE_NAME"].ToString(); btnAdd.Text = "Update"; btnDelete.Enabled = false; btnShowAll.Enabled = false; }
protected void btnDelete_Click(object sender, EventArgs e) { gradeRow = new DataSet.DsPSMS.ST_GRADE_MSTDataTable().NewST_GRADE_MSTRow(); msg = ""; if (!checkValidationForGrade()) { gradeRow.GRADE_ID = gradeId.Text; gradeRow.GRADE_NAME = gradeName.Text; DataSet.DsPSMS.ST_GRADE_MSTDataTable resultDt = service.selectGradeByID(gradeRow, out msg); if (resultDt != null && resultDt.Rows.Count > 0) { service.deleteGrade(gradeRow, out msg); displayGradeData(); } else { ModelState.AddModelError(string.Empty, "Data doesn't exist"); } } }
protected void btnAdd_Click(object sender, EventArgs e) { gradeRow = new DataSet.DsPSMS.ST_GRADE_MSTDataTable().NewST_GRADE_MSTRow(); if (!checkValidationForGrade()) { if (btnAdd.Text.Equals("Add")) { msg = ""; gradeRow.GRADE_ID = gradeId.Text; gradeRow.GRADE_NAME = gradeName.Text; DataSet.DsPSMS.ST_GRADE_MSTDataTable gradeData = service.selectGradeByID(gradeRow, out msg); if (gradeData != null && gradeData.Rows.Count > 0) { ModelState.AddModelError(string.Empty, "Data already exists"); } else { service.saveGrade(gradeRow, out msg); } } else if (btnAdd.Text.Equals("Update")) { gradeRow.GRADE_NAME = gradeName.Text; gradeRow.GRADE_ID = gradeId.Text; service.updateGrade(gradeRow, out msg); btnAdd.Text = "Add"; gradeId.Enabled = true; btnDelete.Enabled = true; btnShowAll.Enabled = true; } displayGradeData(); FillGradeListCombo(); gradeId.Text = ""; gradeName.Text = ""; } }