public DataSet.DsPSMS.ST_SUBJECT_MSTDataTable getAllSubjectName(string subjectId, out string msg) { DataSet.DsPSMS.ST_SUBJECT_MSTDataTable result = new DataSet.DsPSMS.ST_SUBJECT_MSTDataTable(); try { db.Open(); result = db.getAllSubjectName(subjectId); if (result != null && result.Rows.Count > 0) { msg = result.Rows.Count + " user found"; } else { result = null; msg = "user not found"; } } catch { msg = "error has occure when insert data"; return(null); } 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); }
private void displaySubjectInGridView() { DataSet.DsPSMS.ST_SUBJECT_MSTDataTable resultDt = service.getAllSubjectData(out msg); if (resultDt != null) { subjectGridView.DataSource = resultDt; subjectGridView.DataBind(); } }
public DataSet.DsPSMS.ST_SUBJECT_MSTDataTable selectAllSubjectData() { string query = "SELECT * FROM ST_SUBJECT_MST ORDER BY 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 DataSet.DsPSMS.ST_TEACHER_GRADERow selectTeacherGradeID(DataSet.DsPSMS.ST_TEACHER_GRADERow dr) //{ // string query = "SELECT * FROM ST_TEACHER_GRADE WHERE TEACHER_ID='" + dr.TEACHER_ID + "'and TEACH_GRADE='" + dr.TEACH_GRADE + "'and TEACH_SUBJECT='" + dr.TEACH_SUBJECT + "'"; // SqlCommand cmd = new SqlCommand(query, conn); // SqlDataAdapter da = new SqlDataAdapter(cmd); // DataSet.DsPSMS.ST_GRADE_SUBJECT_DETAILDataTable dt = new DataSet.DsPSMS.ST_GRADE_SUBJECT_DETAILDataTable(); // da.Fill(dt); // //return single row // return dt[0]; //} public DataSet.DsPSMS.ST_SUBJECT_MSTDataTable getAllSubjectName(String subjectID) { string query = "SELECT * FROM ST_SUBJECT_MST WHERE SUBJECT_ID IN (" + subjectID + ")"; 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 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 void bindThuSubject() { msg = "aaa"; ddlthusublist.Items.Clear(); DataSet.DsPSMS.ST_SUBJECT_MSTDataTable grades = timeService.getAllSubjectData(out msg); ddlthusublist.DataSource = grades; ddlthusublist.DataTextField = "SUBJECT_NAME"; ddlthusublist.DataValueField = "SUBJECT_ID"; ddlthusublist.DataBind(); ddlthusublist.Items.Insert(0, new ListItem("Select Subject", "0")); }
public DataSet.DsPSMS.ST_SUBJECT_MSTRow selectSubjectByid(int id) { //conn.Open(); string query = "SELECT * FROM ST_SUBJECT_MST WHERE SUBJECT_ID=" + 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 single row return(dt[0]); }
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"); } } }
private void displayGradeSubjectData() { DataSet.DsPSMS.ST_GRADE_SUBJECT_DETAILDataTable resultDt = service.getAllGradeSubjectData(out msg); gradeSubjectGridView.DataSource = null; gradeSubjectGridView.DataBind(); if (resultDt != null) { BoundField subjectNameList = new BoundField(); subjectNameList.HeaderText = "Subject"; foreach (DataSet.DsPSMS.ST_GRADE_SUBJECT_DETAILRow row in resultDt.Rows) { string subjectIdList = null; string subjectName = null; if (row.SUBJECT_ID_LIST != null) { subjectIdList = row.SUBJECT_ID_LIST.ToString(); } DataSet.DsPSMS.ST_SUBJECT_MSTDataTable subject = service.getAllSubjectName(subjectIdList, out msg); foreach (DataSet.DsPSMS.ST_SUBJECT_MSTRow subjectRow in subject.Rows) { subjectName += subjectRow.SUBJECT_NAME.ToString(); subjectName += ","; } subjectName = subjectName.Substring(0, subjectName.Length - 1); row.SUBJECT_ID_LIST = subjectName; DataSet.DsPSMS.ST_GRADE_MSTRow grade = new DataSet.DsPSMS.ST_GRADE_MSTDataTable().NewST_GRADE_MSTRow(); grade.GRADE_ID = row.GRADE_ID; DataSet.DsPSMS.ST_GRADE_MSTDataTable result = service.selectGradeByID(grade, out msg); row.GRADE_ID = result.Rows[0]["GRADE_NAME"].ToString(); } gradeSubjectGridView.DataSource = resultDt; gradeSubjectGridView.DataBind(); } }
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 = ""; } }
public DataSet.DsPSMS.ST_SUBJECT_MSTRow getSubjectByid(int id) { DataSet.DsPSMS.ST_SUBJECT_MSTRow resultData = new DataSet.DsPSMS.ST_SUBJECT_MSTDataTable().NewST_SUBJECT_MSTRow(); resultData = timedb.selectSubjectByid(id); return(resultData); }