private void showAll() {
//if (!ddlYear.SelectedValue.ToString().Equals("--กรุณาเลือก--") && !ddlSemester.SelectedValue.ToString().Equals("--กรุณาเลือก--"))
//{
Entity.CurriculumInfo sub = new Entity.CurriculumInfo();
sub.ShowPlan_YearUpdate = ddlYearMod.SelectedValue.ToString();
sub.ShowPlan_Year = ddlYear.SelectedValue.ToString();
sub.ShowPlan_Semester = ddlSemester.SelectedValue.ToString();
this.Session["subject"] = BLL.Curriculum.LoadAllShowManagePlanEducate(sub);
bind(0);
// }
}
protected void btnSearch_Click(object sender, EventArgs e)
{
Entity.CurriculumInfo subject = new Entity.CurriculumInfo();
//subject.Curri_Year = ddlYear.SelectedValue.ToString();
subject.ShowPlan_Year = ddlCourses.SelectedValue.ToString();
subject.ShowPlan_Semester = ddlSemester.SelectedValue.ToString();
subject.StructSub_Code = txtCodeSubject.Text.ToString();
subject.StructSub_NameTha = txtSubNameThai.Text.ToString();
this.Session["subject"] = BLL.Curriculum.LoadAllShowManagePlanEducate(subject);
bind(0);
}
protected void btnSearch_Click(object sender, EventArgs e)
{
Entity.CurriculumInfo subject = new Entity.CurriculumInfo();
subject.ShowPlan_Semester = ddlterm.SelectedValue.ToString();
subject.StructSub_Code = txtcode.Text.ToString();
subject.StructSub_NameEn = txtNameEn.Text.ToString();
subject.StructSub_NameTha = txtNameThai.Text.ToString();
subject.ShowPlan_YearUpdate = ddlYear.SelectedValue.ToString();
subject.ShowPlan_Year = ddlclassYear.SelectedValue.ToString();
dttt= BLL.Curriculum.selectShowMainDetailTeach(subject);
this.Session["subject"] = dttt;
bind(0);
}
protected void btnSearch_Click(object sender, EventArgs e)
{
Entity.CurriculumInfo subject = new Entity.CurriculumInfo();
subject.Curri_Course = ddlCourses.SelectedValue.ToString();
subject.Curri_Group = ddlGroup.SelectedValue.ToString();
subject.StructSub_Code = txtcode.Text.ToString();
subject.StructSub_NameEn = txtNameEn.Text.ToString();
subject.StructSub_NameTha = txtNameThai.Text.ToString();
subject.Curri_Year = ddlYear.SelectedValue.ToString();
this.Session["subject"] = BLL.Curriculum.LoadAll(subject);
bind(0);
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (checkTxtNull())
{
if (BLL.Curriculum.checkSubjectCode(txtCode.Text.ToString()))
{
Entity.CurriculumInfo subject = new Entity.CurriculumInfo();
subject.Curri_Year = ddlYear.SelectedValue.ToString();
subject.Curri_Course = ddlCourses.SelectedValue.ToString();
subject.Curri_Group = ddlGroup.SelectedValue.ToString();
subject.StructSub_Code = txtCode.Text.ToString();
subject.StructSub_NameEn = TxtNameEn.Text.ToString();
subject.StructSub_NameTha = txtNameThai.Text.ToString();
subject.StructSub_Detail = txtArea.Text.ToString();
subject.StructSub_Credit = txtCredit.Text.ToString();
if (txtCode.Text.Substring(0, 1).Equals("x"))
{
bool insertSubject = BLL.Curriculum.insertSubject(subject);
if (insertSubject)
{
ShowMessageWeb("บันทึกข้อมูลหลักสูตรเรียบร้อย");
clearValue();
}
else
{
ShowMessageWeb("บันทึกข้อมูลหลักสูตรล้มเหลว");
}
}
}
else
{
ShowMessageWeb("รหัสรายวิชานี้ถูกใช้แล้ว กรุณาเปลี่ยนรหัสใหม่");
}
}
else
{
ShowMessageWeb("กรุณากรอกข้อมูลให้ครบ ! ");
}
}
private void loadShowSubject()
{
Entity.CurriculumInfo subject = new Entity.CurriculumInfo();
subject = BLL.Curriculum.selectLoadShowSubject(txtCode.Text);
txtNameThai.Text = subject.StructSub_NameTha.ToString();
TxtNameEn.Text = subject.StructSub_NameEn.ToString();
txtCredit.Text = subject.StructSub_Credit.ToString();
// editor.Content = subject.StructSub_Detail.ToString();
txtyear.Text = subject.Curri_Year.ToString();
txtcour.Text = subject.Curri_Course.ToString();
txtGroup.Text = subject.Curri_Group.ToString();
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (checkTxtNull())
{
Entity.CurriculumInfo subject = new Entity.CurriculumInfo();
//subject.Curri_Year = ddlYear.SelectedValue.ToString();
//subject.Curri_Course = ddlCourses.SelectedValue.ToString();
//subject.Curri_Group = ddlGroup.SelectedValue.ToString();
subject.StructSub_Code = txtCode.Text.ToString();
subject.StructSub_NameEn = TxtNameEn.Text.ToString();
subject.StructSub_NameTha = txtNameThai.Text.ToString();
subject.StructSub_Detail = txtArea.Text.ToString();
subject.StructSub_Credit = txtCredit.Text.ToString();
//subject.StructSub_CodePass = TxtCodePass.Text.ToString();
bool insertSubject = BLL.Curriculum.updateSubject(subject);
if (insertSubject)
{
ShowMessageWeb("บันทึกข้อมูลหลักสูตรเรียบร้อย");
//clearValue();
}
else
{
ShowMessageWeb("บันทึกข้อมูลหลักสูตรล้มเหลว");
}
}
else
{
ShowMessageWeb("กรุณากรอกข้อมูลให้ครบ ! ");
}
}
public static Entity.CurriculumInfo selectLoadShowSubject(string code)
{
try
{
string sql = "SELECT * FROM StructSubject Where StructSub_Code=@code";
string Addvalue = "@code";
string value = code;
Entity.CurriculumInfo sub = new Entity.CurriculumInfo();
ClassConnectDB conn=new ClassConnectDB();
SqlDataReader read = conn.SelectWhereSqlDataReader(sql,Addvalue,value);
if (read.Read()) {
sub.StructSub_Code = read["StructSub_Code"].ToString();
sub.StructSub_NameTha=read["StructSub_NameTha"].ToString();
sub.StructSub_NameEn=read["StructSub_NameEn"].ToString();
sub.StructSub_Detail=read["StructSub_Detail"].ToString();
sub.StructSub_Credit = read["StructSub_Credit"].ToString();
// sub.Curri_Year = read["Curri_Id"].ToString();
}
string sqlCurri = "SELECT * FROM Curriculum Where Curri_Id=@curid";
string addCurri = "@curid";
string valueCurri = read["Curri_Id"].ToString();
SqlDataReader readCurri = conn.SelectWhereSqlDataReader(sqlCurri,addCurri,valueCurri);
if (readCurri.Read()) {
sub.Curri_Year = readCurri["Curri_Year"].ToString();
sub.Curri_Course = readCurri["Curri_Course"].ToString();
sub.Curri_Group = readCurri["Curri_Group"].ToString();
}
return sub;
}
catch (Exception)
{
return null;
}
}
