public bool updateGradeSubject(DataSet.DsPSMS.ST_GRADE_SUBJECT_DETAILRow dr, out string msg)
{
bool isOk = false;
if (dr == null)
{
msg = "data is empty ";
return(false);
}
try
{
db.Open();
int result = db.updateGradeSubject(dr);
msg = "update complete";
}
catch
{
msg = "error has occure when update data";
return(false);
}
finally
{
db.Close();
}
return(isOk);
}
public int deleteGradeSubject(DataSet.DsPSMS.ST_GRADE_SUBJECT_DETAILRow dr, out string msg)
{
int result;
try
{
if (dr == null)
{
msg = "data is empty";
return(0);
}
else
{
db.Open();
result = db.deleteGradeSubject(dr);
msg = "grade deleted";
}
}
catch
{
msg = "error has occure when delete data";
return(0);
}
finally
{
db.Close();
}
return(result);
}
public bool saveGradeSubject(DataSet.DsPSMS.ST_GRADE_SUBJECT_DETAILRow dr, string subjectIdList, out string msg)
{
bool isOk = false;
if (dr == null)
{
msg = "data is empty ";
return(false);
}
try
{
db.Open();
int result = db.insertGradeSubjectDetail(dr, subjectIdList);
msg = "insert complete";
}
catch
{
msg = "duplicate id cannot be inserted";
return(false);
}
finally
{
db.Close();
}
return(isOk);
}
public int deleteGradeSubject(DataSet.DsPSMS.ST_GRADE_SUBJECT_DETAILRow dr)
{
int result;
string query = "UPDATE ST_GRADE_SUBJECT_DETAIL SET DEL_FLG = 1 WHERE ";
query += " ID = " + "'" + dr.ID + "' AND";
query += " GRADE_ID = " + "'" + dr.GRADE_ID + "'";
SqlCommand cmd = new SqlCommand(query, conn);
result = cmd.ExecuteNonQuery();
return(result);
}
public int insertGradeSubjectDetail(DataSet.DsPSMS.ST_GRADE_SUBJECT_DETAILRow dr, string sub)
{
int result;
int currentYear = DateTime.Now.Year;
DateTime date = DateTime.Now.Date;
String currentDate = date.ToString().Substring(0, 19);
string query = "INSERT INTO ST_GRADE_SUBJECT_DETAIL (EDU_YEAR, ID, GRADE_ID, SUBJECT_ID_LIST, CRT_DT_TM, CRT_USER_ID, DEL_FLG) VALUES (" + currentYear + "," + dr.ID + ",'" + dr.GRADE_ID + "','" + sub + "','" + currentDate + "', 1, 0)";
SqlCommand cmd = new SqlCommand(query, conn);
result = cmd.ExecuteNonQuery();
return(result);
}
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;
}
public int updateGradeSubject(DataSet.DsPSMS.ST_GRADE_SUBJECT_DETAILRow dr)
{
int result;
string query = "UPDATE ST_GRADE_SUBJECT_DETAIL SET ";
if (dr.GRADE_ID != null)
{
query += " GRADE_ID ='" + dr.GRADE_ID + "'";
}
if (dr.SUBJECT_ID_LIST != null)
{
query += ", SUBJECT_ID_LIST ='" + dr.SUBJECT_ID_LIST + "'";
}
query += " WHERE ID=" + dr.ID;
SqlCommand cmd = new SqlCommand(query, conn);
result = cmd.ExecuteNonQuery();
return(result);
}
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");
}
}
}
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 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);
}