public bool updateSubject(DataSet.DsPSMS.ST_SUBJECT_MSTRow dr, out string msg) { bool isOk = false; if (dr == null) { msg = "data is empty "; return(false); } try { db.Open(); int result = db.updateSubject(dr); msg = "update complete"; } catch { msg = "error has occure when update data"; return(false); } finally { db.Close(); } return(isOk); }
public int deleteSubject(DataSet.DsPSMS.ST_SUBJECT_MSTRow dr, out string msg) { int result; try { if (dr == null) { msg = "data is empty"; return(0); } else { db.Open(); result = db.deleteSubject(dr); msg = "grade deleted"; } } catch { msg = "error has occure when delete data"; return(0); } finally { db.Close(); } return(result); }
public DataSet.DsPSMS.ST_SUBJECT_MSTDataTable selectSubjectByID(DataSet.DsPSMS.ST_SUBJECT_MSTRow subject, out string msg) { DataSet.DsPSMS.ST_SUBJECT_MSTDataTable result = new DataSet.DsPSMS.ST_SUBJECT_MSTDataTable(); if (subject == null) { msg = "data is empty "; return(result); } try { db.Open(); if (subject.SUBJECT_ID != null) { result = db.selectSubjectByID(subject); } } catch { msg = "error has occure when insert data"; return(result); } finally { db.Close(); } msg = "exist user"; return(result); }
public bool saveSubject(DataSet.DsPSMS.ST_SUBJECT_MSTRow dr, out string msg) { bool isOk = false; if (dr == null) { msg = "data is empty "; return(false); } try { db.Open(); int result = db.insertSubject(dr); msg = "insert complete"; } catch { msg = "duplicate id cannot be inserted"; return(false); } finally { db.Close(); } return(isOk); }
public void DisplayTimeDetail(string id) { DataSet.DsPSMS.ST_TIMETABLE_DETAILDataTable resultDt = timeService.getAllTimeDetailData(id, out msg); if (resultDt != null) { foreach (DataSet.DsPSMS.ST_TIMETABLE_DETAILRow row in resultDt.Rows) { int subjectId; string subvalue = null; if (row.MONDAY != null) { subjectId = int.Parse(row.MONDAY); DataSet.DsPSMS.ST_SUBJECT_MSTRow subject = timeService.getSubjectByid(subjectId); subvalue = subject.SUBJECT_NAME; row.MONDAY = subvalue; } if (row.TUESDAY != null) { subjectId = int.Parse(row.TUESDAY); DataSet.DsPSMS.ST_SUBJECT_MSTRow subject = timeService.getSubjectByid(subjectId); subvalue = subject.SUBJECT_NAME; row.TUESDAY = subvalue; } if (row.WEDNESDAY != null) { subjectId = int.Parse(row.WEDNESDAY); DataSet.DsPSMS.ST_SUBJECT_MSTRow subject = timeService.getSubjectByid(subjectId); subvalue = subject.SUBJECT_NAME; row.WEDNESDAY = subvalue; } if (row.THURSDAY != null) { subjectId = int.Parse(row.THURSDAY); DataSet.DsPSMS.ST_SUBJECT_MSTRow subject = timeService.getSubjectByid(subjectId); subvalue = subject.SUBJECT_NAME; row.THURSDAY = subvalue; } if (row.FRIDAY != null) { subjectId = int.Parse(row.FRIDAY); DataSet.DsPSMS.ST_SUBJECT_MSTRow subject = timeService.getSubjectByid(subjectId); subvalue = subject.SUBJECT_NAME; row.FRIDAY = subvalue; } } gvtimedetail.DataSource = resultDt; gvtimedetail.DataBind(); } }
public DataSet.DsPSMS.ST_SUBJECT_MSTDataTable selectSubjectByID(DataSet.DsPSMS.ST_SUBJECT_MSTRow dr) { string query = "SELECT * FROM ST_SUBJECT_MST where SUBJECT_ID= '" + dr.SUBJECT_ID + "'"; SqlCommand cmd = new SqlCommand(query, conn); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet.DsPSMS.ST_SUBJECT_MSTDataTable dt = new DataSet.DsPSMS.ST_SUBJECT_MSTDataTable(); da.Fill(dt); return(dt); }
public int deleteSubject(DataSet.DsPSMS.ST_SUBJECT_MSTRow dr) { int result; string query = "UPDATE ST_SUBJECT_MST SET DEL_FLG = 1 WHERE "; query += " SUBJECT_ID = " + "'" + dr.SUBJECT_ID + "' AND"; query += " SUBJECT_NAME = " + "'" + dr.SUBJECT_NAME + "'"; SqlCommand cmd = new SqlCommand(query, conn); result = cmd.ExecuteNonQuery(); return(result); }
public int updateSubject(DataSet.DsPSMS.ST_SUBJECT_MSTRow dr) { int result; string query = "UPDATE ST_SUBJECT_MST SET "; if (dr.SUBJECT_NAME != null) { query += " SUBJECT_NAME ='" + dr.SUBJECT_NAME + "'"; } query += " WHERE SUBJECT_ID=" + dr.SUBJECT_ID; SqlCommand cmd = new SqlCommand(query, conn); result = cmd.ExecuteNonQuery(); return(result); }
public int insertSubject(DataSet.DsPSMS.ST_SUBJECT_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_SUBJECT_MST (EDU_YEAR, SUBJECT_ID, SUBJECT_NAME, CRT_DT_TM, CRT_USER_ID, DEL_FLG) VALUES (" + currentYear + ",'" + dr.SUBJECT_ID + "','" + dr.SUBJECT_NAME + "','" + currentDate + "', 1, 0)"; SqlCommand cmd = new SqlCommand(query, conn); result = cmd.ExecuteNonQuery(); return(result); }
protected void btnUpdateSubject_Click(object sender, EventArgs e) { LinkButton btn = (LinkButton)(sender); string editSubjectId = btn.CommandName; subjectId.Text = editSubjectId; subjectId.Enabled = false; subjectRow = new DataSet.DsPSMS.ST_SUBJECT_MSTDataTable().NewST_SUBJECT_MSTRow(); if (editSubjectId != null) { subjectRow.SUBJECT_ID = editSubjectId; } DataSet.DsPSMS.ST_SUBJECT_MSTDataTable subjectData = service.selectSubjectByID(subjectRow, out msg); subjectName.Text = subjectData.Rows[0]["SUBJECT_NAME"].ToString(); subjectAdd.Text = "Update"; subjectDelete.Enabled = false; subjectShowAll.Enabled = false; }
protected void btnDeleteSubject_Click(object sender, EventArgs e) { subjectRow = new DataSet.DsPSMS.ST_SUBJECT_MSTDataTable().NewST_SUBJECT_MSTRow(); msg = ""; if (!checkValidationForSubject()) { subjectRow.SUBJECT_ID = subjectId.Text; subjectRow.SUBJECT_NAME = subjectName.Text; DataSet.DsPSMS.ST_SUBJECT_MSTDataTable subjectData = service.selectSubjectByID(subjectRow, out msg); if (subjectData != null && subjectData.Rows.Count > 0) { service.deleteSubject(subjectRow, out msg); displaySubjectData(); } else { ModelState.AddModelError(string.Empty, "Data doesn't exist"); } } }
protected void btnAddSubject_Click(object sender, EventArgs e) { subjectRow = new DataSet.DsPSMS.ST_SUBJECT_MSTDataTable().NewST_SUBJECT_MSTRow(); if (!checkValidationForSubject()) { if (subjectAdd.Text.Equals("Add")) { msg = ""; subjectRow.SUBJECT_ID = subjectId.Text; subjectRow.SUBJECT_NAME = subjectName.Text; DataSet.DsPSMS.ST_SUBJECT_MSTDataTable subjectData = service.selectSubjectByID(subjectRow, out msg); if (subjectData != null && subjectData.Rows.Count > 0) { ModelState.AddModelError(string.Empty, "Data already exists"); } else { service.saveSubject(subjectRow, out msg); } } else if (subjectAdd.Text.Equals("Update")) { subjectRow.SUBJECT_NAME = subjectName.Text; subjectRow.SUBJECT_ID = subjectId.Text; service.updateSubject(subjectRow, out msg); subjectAdd.Text = "Add"; subjectId.Enabled = true; subjectDelete.Enabled = true; subjectShowAll.Enabled = true; } displaySubjectData(); displaySubjectInGridView(); subjectId.Text = ""; subjectName.Text = ""; } }
protected void DisplayTimetable(string timeHedId) { DataSet.DsPSMS.ST_TIMETABLE_DETAILDataTable resultDt = timeService.getAllTimeDetailData(timeHedId, out msg); if (resultDt != null) { gvStuTimetable.Visible = true; lblNodata.Visible = false; foreach (DataSet.DsPSMS.ST_TIMETABLE_DETAILRow row in resultDt.Rows) { int subjectId; string subvalue = null; if (row.MONDAY != null) { subjectId = int.Parse(row.MONDAY); DataSet.DsPSMS.ST_SUBJECT_MSTRow subject = timeService.getSubjectByid(subjectId); subvalue = subject.SUBJECT_NAME; row.MONDAY = subvalue; } if (row.TUESDAY != null) { subjectId = int.Parse(row.TUESDAY); DataSet.DsPSMS.ST_SUBJECT_MSTRow subject = timeService.getSubjectByid(subjectId); subvalue = subject.SUBJECT_NAME; row.TUESDAY = subvalue; } if (row.WEDNESDAY != null) { subjectId = int.Parse(row.WEDNESDAY); DataSet.DsPSMS.ST_SUBJECT_MSTRow subject = timeService.getSubjectByid(subjectId); subvalue = subject.SUBJECT_NAME; row.WEDNESDAY = subvalue; } if (row.THURSDAY != null) { subjectId = int.Parse(row.THURSDAY); DataSet.DsPSMS.ST_SUBJECT_MSTRow subject = timeService.getSubjectByid(subjectId); subvalue = subject.SUBJECT_NAME; row.THURSDAY = subvalue; } if (row.FRIDAY != null) { subjectId = int.Parse(row.FRIDAY); DataSet.DsPSMS.ST_SUBJECT_MSTRow subject = timeService.getSubjectByid(subjectId); subvalue = subject.SUBJECT_NAME; row.FRIDAY = subvalue; } } gvStuTimetable.DataSource = resultDt; gvStuTimetable.DataBind(); } else { Panelteacher.Visible = false; gvStuTimetable.Visible = false; lblNodata.Visible = true; lblNodata.Text = "There is no data "; } }