public DataSet.DsPSMS.ST_GRADE_MSTDataTable getAllGradeData(out string msg)
{
DataSet.DsPSMS.ST_GRADE_MSTDataTable result = new DataSet.DsPSMS.ST_GRADE_MSTDataTable();
try
{
db.Open();
result = db.selectAllGradeData();
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_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 void bindGrade()
{
msg = "aaa";
DataSet.DsPSMS.ST_GRADE_MSTDataTable grades = timeService.getAllGradeData(out msg);
ddltimegradelist.DataSource = grades;
ddltimegradelist.DataTextField = "GRADE_NAME";
ddltimegradelist.DataValueField = "GRADE_ID";
ddltimegradelist.DataBind();
}
//select grade data
public DataSet.DsPSMS.ST_GRADE_MSTDataTable selectAllGrade()
{
string query = "SELECT * FROM ST_GRADE_MST";
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 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);
}
private void displayGradeData()
{
DataSet.DsPSMS.ST_GRADE_MSTDataTable resultDt = service.getAllGradeData(out msg);
gridViewGrade.DataSource = null;
gridViewGrade.DataBind();
if (resultDt != null)
{
gridViewGrade.DataSource = resultDt;
gridViewGrade.DataBind();
}
}
public void bindGrade()
{
msg = "aaa";
ddlstugradelist.Items.Clear();
DataSet.DsPSMS.ST_GRADE_MSTDataTable grades = timeService.getAllGradeData(out msg);
ddlstugradelist.DataSource = grades;
ddlstugradelist.DataTextField = "GRADE_NAME";
ddlstugradelist.DataValueField = "GRADE_ID";
ddlstugradelist.DataBind();
ddlstugradelist.Items.Insert(0, new ListItem("Select Grade", "0"));
}
public DataSet.DsPSMS.ST_GRADE_MSTRow selectGradeByid(int id)
{
//conn.Open();
string query = "SELECT * FROM ST_GRADE_MST WHERE GRADE_ID=" + 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 single row
return(dt[0]);
}
protected void getGrade()
{
gradeList.Items.Clear();
DataSet.DsPSMS.ST_GRADE_MSTDataTable gradeResult = gradeService.getAllGradeData(out msg);
if (gradeResult != null)
{
gradeList.DataSource = gradeResult.OrderBy(item => item.GRADE_ID);
gradeList.DataTextField = "GRADE_NAME";
gradeList.DataValueField = "GRADE_ID";
gradeList.DataBind();
gradeList.Items.Insert(0, "Select Grade");
}
}
void FillGradeListCombo()
{
gradeList.Items.Clear();
DataSet.DsPSMS.ST_GRADE_MSTDataTable resultDt = service.getAllGradeData(out msg);
if (resultDt != null)
{
gradeList.DataSource = resultDt;
gradeList.DataTextField = "GRADE_NAME";
gradeList.DataValueField = "GRADE_ID";
gradeList.DataBind();
gradeList.Items.Insert(0, "Select Grade");
}
}
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");
}
}
}
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 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 = "";
}
}
public DataSet.DsPSMS.ST_GRADE_MSTRow getGradeByid(int id)
{
DataSet.DsPSMS.ST_GRADE_MSTRow resultData = new DataSet.DsPSMS.ST_GRADE_MSTDataTable().NewST_GRADE_MSTRow();
resultData = timedb.selectGradeByid(id);
return(resultData);
}
