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