public ActionResult Edit(Subject subject)
{
var _userSession = Session[ConstantVariable.USER_SESSION] as UserLogin;
if (CheckInputSubject(subject))
{
if (ModelState.IsValid)
{
var _result = new SubjectDAO().Update(subject);
if (_result)
{
var s = new SubjectDAO().GetSubjectById(subject.Id);
SetAlert("Cập nhật thông tin môn học thành công", "success");
new SystemLogDAO().Insert("Cập nhật môn học thành công [" + s.Name + "] [Năm học: " + s.Grade.SchoolYear.NameOfSchoolYear + "]", _userSession.UserName, DateTime.Now.TimeOfDay, DateTime.Now.Date, GetIPAddress.GetLocalIPAddress());
return(Redirect("/admin/subjects/details/" + subject.Id));
}
else
{
SetAlert("Cập nhật thông tin môn học không thành công", "warning");
return(Redirect("/admin/subjects"));
}
}
}
SetGradeViewBag(subject.GradeID);
var _grade = new GradeDAO().GetBySubject(subject);
SetSchoolYearViewBag(_grade.SchoolYearID);
return(View(subject));
}
public ActionResult Create(Subject subject)
{
var _userSession = Session[ConstantVariable.USER_SESSION] as UserLogin;
if (CheckInputSubject(subject))
{
var _subjectDao = new SubjectDAO();
if (ModelState.IsValid)
{
var _result = _subjectDao.Insert(subject);
if (_result > 0)
{
var s = new SubjectDAO().GetSubjectById(_result);
SetAlert("Thêm môn học thành công", "success");
new SystemLogDAO().Insert("Tạo môn học thành công [Môn học: " + s.Name + "] [Năm học: " + s.Grade.SchoolYear.NameOfSchoolYear + "]", _userSession.UserName, DateTime.Now.TimeOfDay, DateTime.Now.Date, GetIPAddress.GetLocalIPAddress());
return(Redirect("/admin/subjects/details/" + _result));
}
else
{
SetAlert("Thêm lớp học không thành công", "warning");
return(RedirectToAction("Index"));
}
}
}
SetSchoolYearViewBag();
SetGradeViewBag();
return(View(subject));
}
// GET: admin/subjects
public ActionResult Index(string searchString, int page = 1, int pageSize = 10)
{
var subjects = new SubjectDAO().GetAllSubjectsPageList(searchString, page, pageSize);
ViewBag.SearchString = searchString;
return(View(subjects));
}
public ActionResult Edit(int SubID)
{
var sub = new SubjectDAO().ShowAllSubID(SubID);
//return View(sub);
return(View(sub));
}
// GET: Admin/Subject
public ActionResult Index()
{
var subDAO = new SubjectDAO();
ViewBag.LisSub = new List <Subject>(subDAO.GetListAll());
return(View());
}
public static DataTable SubjectGetByStore(string name, string code, int?credits, int?hours, int?period, int?status)
{
DataTable dt = new DataTable();
dt = new SubjectDAO().GetByStore(name, code, credits, hours, period, status);
return(dt);
}
public static string GetSubjectSetName(string subjectSetCode)
{
string text2;
try
{
string text = "";
if (subjectSetCode == "")
{
return(text);
}
EntityData subjectSetByCode = SubjectDAO.GetSubjectSetByCode(subjectSetCode);
if (subjectSetByCode.HasRecord())
{
text = subjectSetByCode.GetString("SubjectSetName");
}
subjectSetByCode.Dispose();
text2 = text;
}
catch (Exception exception)
{
throw exception;
}
return(text2);
}
public static DataTable SubjectGetAll()
{
DataTable dt = new DataTable();
dt = new SubjectDAO().GetAll();
return(dt);
}
public static EntityData GetFinanceSubjectSet(DataTable tbRelation)
{
EntityData data2;
try
{
EntityData allSubjectSet = SubjectDAO.GetAllSubjectSet();
allSubjectSet.CurrentTable.Columns.Add("U8Code");
foreach (DataRow row in tbRelation.Rows)
{
string text = ConvertRule.ToString(row["SubjectSetCode"]);
string text2 = ConvertRule.ToString(row["U8Code"]);
DataRow[] rowArray = allSubjectSet.CurrentTable.Select(string.Format("SubjectSetCode='{0}'", text));
if (rowArray.Length > 0)
{
rowArray[0]["U8Code"] = text2;
}
}
data2 = allSubjectSet;
}
catch (Exception exception)
{
throw exception;
}
return(data2);
}
public static bool IsLeafSubjectNode(string subjectCode, string subjectSetCode)
{
bool flag2;
try
{
if (subjectCode == "")
{
throw new ApplicationException("输入空科目编号。");
}
EntityData subjectByCode = SubjectDAO.GetSubjectByCode(subjectCode, subjectSetCode);
if (!subjectByCode.HasRecord())
{
throw new ApplicationException("没有这个科目编号。");
}
int @int = subjectByCode.GetInt("ChildNodesCount");
subjectByCode.Dispose();
bool flag = false;
if (@int == 0)
{
flag = true;
}
flag2 = flag;
}
catch (Exception exception)
{
throw exception;
}
return(flag2);
}
// GET: Teacher/QAndEBankTeacher
//Display List subject teaching
public ActionResult Index()
{
SubjectDAO subjectDAO = new SubjectDAO();
List <Subject> subjects = subjectDAO.GetAllSubjects();
return(View(subjects));
}
protected void Page_Load(object sender, System.EventArgs e)
{
try
{
string unitCode = Request["CorpCode"] + "";
int isSelfAccount = 0;
string subjectSetCode = Request["SubjectSetCode"] + "";
if (subjectSetCode == "" && unitCode != "")
{
subjectSetCode = BLL.SubjectRule.GetUnitSubjectSet(unitCode, ref isSelfAccount);
}
this.txtSubjectSetCode.Value = subjectSetCode;
// this.txtSelfAccount.Value = isSelfAccount.ToString();
// if ( isSelfAccount == 0 )
// {
// this.btnAdd.Visible = false;
// this.btnImport.Visible = false;
// }
Rms.ORMap.EntityData m_SubjectSet = SubjectDAO.GetSubjectSetByCode(this.txtSubjectSetCode.Value);
this.LabelSubjectSetName.Text = m_SubjectSet.GetString("SubjectSetName");
m_SubjectSet.Dispose();
}
catch (Exception ex)
{
ApplicationLog.WriteLog(this.ToString(), ex, "");
}
}
public TeacherSubjectManagement()
{
InitializeComponent();
sdb = new SubjectDAO();
tdb = new TeacherDAO();
flag = "";
check = false;
}
// GET: Admin/Subjects
public ActionResult Index(int page = 1, int pageSize = 10)
{
var dao = new SubjectDAO();
var model = dao.ListAllPaging(page, pageSize);
var subjects = db.Subjects.Include(s => s.Student).Include(s => s.Teacher);
return(View(model));
}
private void button1_Click(object sender, EventArgs e)
{
DataTable dt = SubjectDAO.getMark_Hoang();
DataView dv = new DataView(dt);
dv.RowFilter = "StudentID = " + textBox1.Text;
dataGridView1.AutoGenerateColumns = false;
dataGridView1.DataSource = dv;
}
private void btnSearch_Click(object sender, EventArgs e)
{
DataTable dt = SubjectDAO.getSubject_Hoang();
DataView dv = new DataView(dt);
dv.RowFilter = "[SubjectName] like '%" + txtSearch.Text + "%'";
dataGridView1.AutoGenerateColumns = false;
dataGridView1.DataSource = dv;
}
public ActionResult SaveTest(DECHUAN de)
{
Guid idsub = new SubjectDAO().ShowAllSubIDSingle(de.MaDeChuan).SubjectID;
de.MaMon = idsub;
de.MaDeChuan = -1;
int id = new DeChuanDAO().luuDeChuan(de);
return(Json(id, JsonRequestBehavior.AllowGet));
}
//Lấy danh sách môn học theo lớp đã chọn
//Output: Json
public JsonResult FillSubjects(int?classId)
{
var _subDao = new SubjectDAO();
var subjects = _subDao.GetSubjectByClassID(classId);
if (subjects == null)
{
return(Json(new SelectList(null, "Id", "Name"), JsonRequestBehavior.AllowGet));
}
return(Json(new SelectList(subjects.ToArray(), "Id", "Name"), JsonRequestBehavior.AllowGet));
}
private void SubjectDetailGUI_Load(object sender, EventArgs e)
{
string text = label1.Text;
text += SubjectDAO.getSubjectName_Hoang(subid);
label1.Text = text + " is " + count + " students";
txt1.Text = getTest1(subid);
txt2.Text = getTest2(subid);
txt3.Text = getTest3(subid);
txt4.Text = getFinal(subid);
}
public JsonResult DeleteSubject(Subject subject)
{
if (subject == null)
{
return(Json(new { Message = "Erro", HasError = true }, JsonRequestBehavior.AllowGet));
}
var dao = new SubjectDAO();
var message = dao.deleteSubject(subject);
return(Json(new { Message = message }, JsonRequestBehavior.AllowGet));
}
private void btnUpdate_Click(object sender, EventArgs e)
{
SubjectDAO.updateMark_Hoang(subid, int.Parse(txt1.Text), int.Parse(txt2.Text), int.Parse(txt3.Text), int.Parse(txt4.Text));
btnUpdate.Enabled = false;
DataTable dt = SubjectDAO.getMark_Hoang();
DataView dv = new DataView(dt);
dv.RowFilter = "StudentID = " + textBox1.Text;
dataGridView1.AutoGenerateColumns = false;
dataGridView1.DataSource = dv;
}
public void SetGradeViewBag(Question quiz)
{
var _sub = new SubjectDAO().GetSubjectById(quiz.SubjectsID);
if (_sub == null)
{
ViewBag.GradeID = new SelectList(new GradeDAO().GetAll(), "Id", "GradeName", null);
}
else
{
ViewBag.GradeID = new SelectList(new GradeDAO().GetAll(), "Id", "GradeName", _sub.GradeID);
}
}
//public object GetSubject(string searchValue)
//{
// if (string.IsNullOrWhiteSpace(searchValue))
// {
// return new Response(false, null);
// }
// var list = new SubjectDAO().SearchSubject(searchValue);
// return new Response(true, list);
//}
public object GetSubject(string searchValue, string offset, string number)
{
try
{
long longOffset = long.Parse(offset);
long longNumber = long.Parse(number);
var result = new SubjectDAO().SearchSubject(searchValue, longOffset, longNumber);
return(new Response(true, result));
}
catch (Exception e)
{
return(new Response(false, null, e.Message));
}
}
/// <summary>
///
/// </summary>
/// <param name="idsubject"></param>
/// <returns></returns>
public static Subject GetSujetByID(int idsubject)
{
DataTable dt = SubjectDAO.GetSujetByID(idsubject);
if (dt.Rows.Count == 1)
{
DataRow row = dt.Rows[0];
Subject subject = new Subject(int.Parse(row["ID_SUBJECT"].ToString()), row["SUBJECT_TITLE"].ToString(), row["SUBJECT_DESCRIPTION"].ToString(), DateTime.Parse(row["SUBJECT_DATE"].ToString()), GetUserByID(int.Parse(row["ID_UTILISATEUR"].ToString())), GetRubricByID(int.Parse(row["ID_RUBRIC"].ToString())));
return(subject);
}
return(null);
}
// GET: admin/subjects/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Subject subject = new SubjectDAO().GetSubjectById(id);
if (subject == null)
{
return(HttpNotFound());
}
return(View(subject));
}
public ActionResult Create(QClass sub)
{
bool idclass = false;
if (ModelState.IsValid)
{
var dao = new QClassDAO();
Guid id = new SubjectDAO().GetListAll().Where(i => i.idSub == sub.idQClass).Select(l => l.SubjectID).SingleOrDefault();
sub.SubjectID = id;
sub.ClassID = Guid.NewGuid();
idclass = dao.AddQClass(sub);
}
return Json(idclass, JsonRequestBehavior.AllowGet);
}
public ActionResult SubjectUpdate(string strSubjectID)
{
//Kiểm tra người dùng được sửa
if (LoginDAO.CheckKeyPermission((string)Session["Username"], "PK_QLMH_U") == false)
{
return(RedirectToAction("Login", "Home"));
}
//Lấy config số trang hiển thị trên thanh phân trang
ViewBag.intVisiblePages = Convert.ToInt32(ConfigurationManager.AppSettings["visiblePages"]);
SubjectDTO objSubject = new SubjectDAO().GetSubjectByID(strSubjectID);
return(View(objSubject));
}
/// 有效性检查
/// </summary>
/// <param name="Hint"></param>
/// <returns></returns>
private bool CheckValid(ref string Hint, ref int parentLayer)
{
Hint = "";
parentLayer = 0;
string subjectCode = this.txtSubjectCode.Value;
string subjectSetCode = this.txtSubjectSetCode.Value;
string ruleCode = SubjectRule.GetSubjectSetRuleCode(subjectSetCode);
if (subjectCode == "")
{
Hint = "请输入科目代码";
return(false);
}
if (this.txtSubjectName.Value == "")
{
Hint = "请输入科目名称";
return(false);
}
// if (SubjectRule.IsFitRule(subjectCode,ruleCode)==false)
// {
// Hint = string.Format("科目编号不符合规则“{0}”，请重新输入！", ruleCode);
// return false;
// }
string parentSubjectCode = SubjectRule.GetParentSubjectCode(subjectCode, ruleCode);
if (parentSubjectCode != "")
{
EntityData entityParent = SubjectDAO.GetSubjectByCode(parentSubjectCode, subjectSetCode);
if (!entityParent.HasRecord())
{
Hint = string.Format("该科目编号的上级科目“{0}”不存在，请重新输入！", parentSubjectCode);
return(false);
}
else
{
parentLayer = entityParent.GetInt("Layer");
}
entityParent.Dispose();
}
return(true);
}
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Subject subject = new SubjectDAO().GetSubjectById(id);
if (subject == null)
{
return(HttpNotFound());
}
SetGradeViewBag(subject.GradeID);
SetSchoolYearViewBag(subject.Grade.SchoolYear.Id);
return(View(subject));
}
public ActionResult SearchSubject(string strKeyWord, int intPageIndex = 0)
{
try
{
//Lấy cấu hình số dòng trên trang
//int intPageSize = Convert.ToInt32(ConfigurationManager.AppSettings["RowPerPage"]);
//Lấy config số trang hiển thị trên thanh phân trang
int intVisiblePages = Convert.ToInt32(ConfigurationManager.AppSettings["visiblePages"]);
int intTotalPages = 0;
int intTotalRows = 0;
//Gen HTML
StringBuilder strHTMLSubject = new StringBuilder();
DataTable dtbSubject = new SubjectDAO().SearchSubject(strKeyWord, intPageIndex, intVisiblePages);
if (dtbSubject != null && dtbSubject.Rows.Count > 0)
{
strHTMLSubject = GenHTMLSubject(dtbSubject);
//Lấy tổng số lưởng dòng
intTotalRows = Convert.ToInt32(dtbSubject.Rows[0]["TotalRows"]);
//Lấy tổng số lượng trang
intTotalPages = intTotalRows / intVisiblePages;
//Trường hợp số phần tử không chia hết cho intVisiblePages
if (intTotalRows % intVisiblePages != 0)
{
intTotalPages = intTotalPages + 1;
}
}
else
{
strHTMLSubject.Append("<tr><td colspan='12' class='table-content-null'>Hiện không có nội dung</td></tr>");
}
return(Json(new
{
iserror = false,
content = Convert.ToString(strHTMLSubject),
totalpages = intTotalPages,
totalrows = intTotalRows
}));
}
catch
{
return(Json(new { iserror = true }));
}
}
