public DataSet.DsPSMS.ST_GRADE_SUBJECT_DETAILDataTable selectGradeSubjectByID(DataSet.DsPSMS.ST_GRADE_SUBJECT_DETAILRow dr, out string msg)
{
msg = null;
DataSet.DsPSMS.ST_GRADE_SUBJECT_DETAILDataTable selectedUser = new DataSet.DsPSMS.ST_GRADE_SUBJECT_DETAILDataTable();
if (dr == null)
{
msg = "data is empty ";
return(selectedUser);
}
try
{
db.Open();
if (dr.ID != null)
{
selectedUser = db.selectGradeSubjectByID(dr);
}
msg = "complete";
}
catch
{
msg = "error has occure when insert data";
return(selectedUser);
}
finally
{
db.Close();
}
return(selectedUser);
}
public DataSet.DsPSMS.ST_GRADE_SUBJECT_DETAILDataTable getAllGradeSubjectData(out string msg)
{
DataSet.DsPSMS.ST_GRADE_SUBJECT_DETAILDataTable result = new DataSet.DsPSMS.ST_GRADE_SUBJECT_DETAILDataTable();
try
{
db.Open();
result = db.getAllGradeSubjectData();
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_GRADE_SUBJECT_DETAILDataTable getAllGradeSubjectData()
{
string query = "SELECT * FROM ST_GRADE_SUBJECT_DETAIL WHERE DEL_FLG = 0";
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(dt);
}
public DataSet.DsPSMS.ST_GRADE_SUBJECT_DETAILDataTable selectGradeSubjectByID(DataSet.DsPSMS.ST_GRADE_SUBJECT_DETAILRow dr)
{
string query = "SELECT * FROM ST_GRADE_SUBJECT_DETAIL where ID= '" + dr.ID + "'";
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(dt);
}
public DataSet.DsPSMS.ST_GRADE_SUBJECT_DETAILRow selectGradeSubjectBygradeId(int id)
{
string query = "SELECT * FROM ST_GRADE_SUBJECT_DETAIL WHERE GRADE_ID=" + id;
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]);
}
protected void btnAddGradeSubject_Click(object sender, EventArgs e)
{
gradeSubjectRow = new DataSet.DsPSMS.ST_GRADE_SUBJECT_DETAILDataTable().NewST_GRADE_SUBJECT_DETAILRow();
if (!checkValidationForGradeSubject())
{
if (gradeSubjectAdd.Text.Equals("Add"))
{
msg = "";
gradeSubjectRow.ID = gradeSubjectId.Text;
gradeSubjectRow.GRADE_ID = gradeList.Text;
string subjectId = getSubjectIdList();
DataSet.DsPSMS.ST_GRADE_SUBJECT_DETAILDataTable resultDt = service.selectGradeSubjectByID(gradeSubjectRow, out msg);
if (resultDt != null && resultDt.Rows.Count > 0)
{
service.saveGradeSubject(gradeSubjectRow, subjectId, out msg);
}
else
{
ModelState.AddModelError(string.Empty, "Data already exists");
}
}
else if (gradeSubjectAdd.Text.Equals("Update"))
{
gradeSubjectRow.ID = gradeSubjectId.Text;
gradeSubjectRow.GRADE_ID = gradeList.Text;
gradeSubjectRow.SUBJECT_ID_LIST = getSubjectIdList();
service.updateGradeSubject(gradeSubjectRow, out msg);
gradeSubjectAdd.Text = "Add";
gradeSubjectId.Enabled = true;
gradeSubjectDelete.Enabled = true;
gradeSubjectShowAll.Enabled = true;
}
displayGradeSubjectData();
gradeSubjectId.Text = "";
gradeList.SelectedIndex = 0;
foreach (GridViewRow row in subjectGridView.Rows)
{
CheckBox chk = (CheckBox)row.FindControl("selectedSubject");
if (chk != null && chk.Checked)
{
chk.Checked = false;
}
}
}
}
protected void btnUpdateGradeSubject_Click(object sender, EventArgs e)
{
LinkButton btn = (LinkButton)(sender);
string editId = btn.CommandName;
gradeSubjectId.Text = editId;
gradeSubjectId.Enabled = false;
gradeSubjectRow = new DataSet.DsPSMS.ST_GRADE_SUBJECT_DETAILDataTable().NewST_GRADE_SUBJECT_DETAILRow();
if (editId != null)
{
gradeSubjectRow.ID = editId;
}
DataSet.DsPSMS.ST_GRADE_SUBJECT_DETAILDataTable subjectGradeData = service.selectGradeSubjectByID(gradeSubjectRow, out msg);
gradeSubjectAdd.Text = "Update";
gradeSubjectDelete.Enabled = false;
gradeSubjectShowAll.Enabled = false;
}
protected void btnDeleteGradeSubject_Click(object sender, EventArgs e)
{
gradeSubjectRow = new DataSet.DsPSMS.ST_GRADE_SUBJECT_DETAILDataTable().NewST_GRADE_SUBJECT_DETAILRow();
msg = "";
if (!checkValidationForGradeSubject())
{
gradeSubjectRow.ID = gradeSubjectId.Text;
gradeSubjectRow.GRADE_ID = gradeList.Text;
DataSet.DsPSMS.ST_GRADE_SUBJECT_DETAILDataTable resultDt = service.selectGradeSubjectByID(gradeSubjectRow, out msg);
if (resultDt != null && resultDt.Rows.Count > 0)
{
service.deleteGradeSubject(gradeSubjectRow, out msg);
displayGradeSubjectData();
}
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();
}
}
public DataSet.DsPSMS.ST_GRADE_SUBJECT_DETAILRow getGradeSubjectBygradeid(int id)
{
DataSet.DsPSMS.ST_GRADE_SUBJECT_DETAILRow resultData = new DataSet.DsPSMS.ST_GRADE_SUBJECT_DETAILDataTable().NewST_GRADE_SUBJECT_DETAILRow();
resultData = timedb.selectGradeSubjectBygradeId(id);
return(resultData);
}
