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 ";
}
}
