public ActionResult GetClassExam(int userId) { var lstClass = new SysAdminAction <Cms_Class>().List("a.CreatedBy=" + userId, "a.CreatedDate desc", 0, 100); var lstExam = new SysAdminAction <Ex_Exam>().List("a.CreatedBy=" + userId, "a.CreatedDate desc", 0, 100); return(Json(new { status = THelper.Ajax_Return.Ok, lstClass = lstClass, lstExam = lstExam })); }
public ActionResult GetChuong(string key, int id) { try { string sWhere = (AuthorizeUser.IsHost() || AuthorizeUser.IsAction(Ultity.Constant.ViewEditAll)) ? " 1=1 " : " a.CreatedBy =" + WebSecurity.CurrentUserId; sWhere += " and a.ParentId=" + id; sWhere += " and a.Section like '%" + key + "%'"; string sSort = "a.Orders DESC"; var modelList = new SysAdminAction <Ex_Question>().List(sWhere, sSort, 0, 100); //Check after deleted last item in page . Redirect page close have value smaller if (Request.IsAjaxRequest()) { return(Json(new { status = "success", Message = Ultity.Constant.Ajax_Success, Data = modelList })); } } catch (Exception exception) { Ultity.TFunction.WriteToLog(exception); return(Json(new { status = "fail", Message = Ultity.Constant.Ajax_Fail })); } return(Json(new { status = "fail", Message = Ultity.Constant.Ajax_Fail })); }
public ActionResult Edit(Ex_Question sysModel) { try { #region Redirect Request int succcess = 0; if (sysModel.Id > 0) { var objTemporary = new SysAdminAction <Ex_Question>().GetById(sysModel.Id); if (AuthorizeUser.IsAction(Ultity.Constant.Edit) || AuthorizeUser.IsAction(Ultity.Constant.ViewEditAll)) { sysModel.CreatedBy = objTemporary.CreatedBy; sysModel.ModifiedDate = DateTime.Now; sysModel.ModifiedBy = WebSecurity.CurrentUserId; sysModel.CreatedDate = objTemporary.CreatedDate; sysModel.UsedState = objTemporary.UsedState; //sysModel.Name = objTemporary.Name; succcess = _sysAction.Update(sysModel); } else { succcess = 1; } } else { if (AuthorizeUser.IsAction(Ultity.Constant.Add) || AuthorizeUser.IsAction(Ultity.Constant.ViewEditAll)) { sysModel.CreatedBy = WebSecurity.CurrentUserId; sysModel.ModifiedBy = null; sysModel.CreatedDate = DateTime.Now; sysModel.ModifiedDate = null; sysModel.UsedState = Ultity.Constant.NotActive; succcess = _sysAction.Insert(sysModel); } else { succcess = 1; } } if (succcess > 0) { return(Json(new { status = "success", Message = Ultity.Constant.Ajax_Success, Data = succcess })); } return(Json(new { status = "fail", Message = Ultity.Constant.Ajax_Fail })); #endregion Redirect Request } catch (Exception exception) { Ultity.TFunction.WriteToLog(exception); } return(Json(new { status = "fail", Message = Ultity.Constant.Ajax_Fail })); }
// GET: Admin/ReportClass public ActionResult Index() { bool checkRole = AuthorizeUser.IsHost() || AuthorizeUser.IsAction(Ultity.Constant.ViewEditAll); var lstUser = new List <SysUser>(); var lstUserTeacher = new SysGroupAction().GetUserInGroup(20, string.Empty); if (checkRole) { var admin = new SysAdminAction <SysUser>().GetById(Ultity.Constant.userIdAdmin); lstUser.Add(new SysUser() { UserId = admin.UserId, UserName = admin.UserName }); lstUserTeacher.ForEach(x => { lstUser.Add(new SysUser() { UserId = x.UserId, UserName = x.UserName }); }); } else { var user = new SysAdminAction <SysUser>().GetById(WebSecurity.CurrentUserId); lstUser.Add(new SysUser() { UserId = user.UserId, UserName = user.UserName }); } var lstClass = new List <Cms_Class>(); var lstExam = new List <Ex_Exam>(); if (checkRole) { lstClass = new SysAdminAction <Cms_Class>().List("", "a.CreatedDate desc", 0, 100); lstExam = new SysAdminAction <Ex_Exam>().List("", "a.CreatedDate desc", 0, 100); } else { lstClass = new SysAdminAction <Cms_Class>().List("a.CreatedBy=" + WebSecurity.CurrentUserId, "a.CreatedDate desc", 0, 100); lstExam = new SysAdminAction <Ex_Exam>().List("a.CreatedBy=" + WebSecurity.CurrentUserId, "a.CreatedDate desc", 0, 100); } ViewBag.LstClass = lstClass; ViewBag.LstExam = lstExam; ViewBag.StartDate = DateTime.Now.ToString("dd/MM/yyy 00:00"); ViewBag.EndDate = DateTime.Now.ToString("dd/MM/yyy 23:59"); ViewBag.ListUser = lstUser; ViewBag.Host = checkRole; return(View()); }
public ActionResult GetQuestion(int cauHoi) { try { if (cauHoi > 0) { var question = new SysAdminAction <Ex_Question>().GetById(cauHoi); var subQuestion = new List <Ex_SubQuestion>(); var answerObjectJson = new List <AnswerObjectJson>(); if (question.Id > 0) { subQuestion = new SysAdminAction <Ex_SubQuestion>().List("a.QuestionId=" + question.Id, "a.Orders asc", 0, 100); if (subQuestion.Count > 0) { for (int i = 0; i < subQuestion.Count; i++) { var model = new AnswerObjectJson(); model.Id = subQuestion[i].Id; model.QuestionId = subQuestion[i].QuestionId; model.SubQuestionName = subQuestion[i].SubQuestionName; var listAnswer = new List <Ex_Answer>(); var answer = new SysAdminAction <Ex_Answer>().List("a.SubQuestionId=" + subQuestion[i].Id, "a.Orders asc", 0, 100); if (answer.Count > 0) { for (int j = 0; j < answer.Count; j++) { var sAnswer = new Ex_Answer(); sAnswer.Answer = answer[j].Answer; sAnswer.CorrectAnswer = answer[j].CorrectAnswer; sAnswer.Id = answer[j].Id; listAnswer.Add(sAnswer); } } model.ListOfAnswer = listAnswer; answerObjectJson.Add(model); } } return(Json(new { status = "success", Message = Ultity.Constant.Ajax_Success, Question = question, SubQuestion = answerObjectJson })); } return(Json(new { status = "waring", Message = Ultity.Constant.Ajax_Success })); } return(Json(new { status = "fail", Message = Ultity.Constant.Ajax_Fail })); } catch (Exception exception) { Ultity.TFunction.WriteToLog(exception); return(Json(new { status = "fail", Message = Ultity.Constant.Ajax_Fail })); } }
public ActionResult PheDuyetRutTien(string ids) { if (AuthorizeUser.IsHost()) { var model = new SysAdminAction <Cms_HistoryPayment>().GetByGuidId(ids); new SysAdminAction <SysUser>().Updates("BCoin=BCoin-" + model.BCoin, "UserId=" + model.FromUser); new SysAdminAction <Cms_HistoryPayment>().Updates("Summary=N'" + Ultity.Constant.RutTien + "' , IsActive=1", "IdGuid='" + ids + "'"); #region Gửi mail thông báo giao dịch thành công var modelEmail = new SysUserAction().GetById(model.FromUser); Models.THelper.SendMail(modelEmail.Email, modelEmail.FullName, String.Format("{0:0,0}", model.BCoin), "Rút tiền"); #endregion } return(Json(new { status = "success", Message = Ultity.Constant.Ajax_Success })); }
public ActionResult Index() { ViewBag.Host = AuthorizeUser.IsHost() || AuthorizeUser.IsAction(Ultity.Constant.ViewEditAll); ViewBag.Edit = AuthorizeUser.IsAction(Ultity.Constant.Edit); var model = new CmsIntroduce(); var list = new SysAdminAction <CmsIntroduce>().List(string.Empty, string.Empty, 0, 1); if (list.Count > 0) { model = list[0]; } return(View(model)); }
public ActionResult Index() { ViewBag.Host = AuthorizeUser.IsHost() || AuthorizeUser.IsAction(Ultity.Constant.ViewEditAll); ViewBag.Add = AuthorizeUser.IsAction(Ultity.Constant.Add); ViewBag.Edit = AuthorizeUser.IsAction(Ultity.Constant.Edit); ViewBag.Delete = AuthorizeUser.IsAction(Ultity.Constant.Delete); if (ViewBag.Host) { ViewBag.UsedStateAdd = Ultity.TFunction.GetUsedStateSelected(Ultity.Constant.Active); } else { ViewBag.UsedStateAdd = Ultity.TFunction.GetAllUsedStateSelectedNotAdmin(Ultity.Constant.Active); } ViewBag.UsedState = Ultity.TFunction.GetAllUsedStateSelected(Ultity.Constant.All); #region Danh sách môn học var lstSubeject = new SysAdminAction <Ex_Subject>().List("a.UsedState=1", "a.Orders desc", 0, 100); var itemsListSearch = new List <SelectListItem>(); var itemsListEdit = new List <SelectListItem>(); var selectListItemAll = new SelectListItem { Text = "Tất cả", Value = "", Selected = true }; itemsListSearch.Add(selectListItemAll); if (lstSubeject != null) { for (int i = 0; i < lstSubeject.Count; i++) { SelectListItem obj = new SelectListItem(); obj.Selected = false; obj.Value = lstSubeject[i].Id.ToString(); obj.Text = lstSubeject[i].Name; itemsListSearch.Add(obj); itemsListEdit.Add(obj); } } ViewBag.ListSearch = itemsListSearch; ViewBag.EditSearch = itemsListEdit; ViewBag.Grade = new SysAdminAction <Ex_CategoryValue>().List("a.CatCode='KHOI'", "a.Orders desc", 0, 100); ViewBag.Level = new SysAdminAction <Ex_CategoryValue>().List("a.CatCode='DK'", "a.Orders desc", 0, 100); #endregion return(View()); }
public ActionResult GetById(int?id) { var objTemporary = new Ex_Category(); try { int editId = id.HasValue ? id.Value : 0; if (editId > 0) { objTemporary = new SysAdminAction <Ex_Category>().GetById(editId); } return(Json(new { status = "success", Message = Ultity.Constant.Ajax_Success, Data = objTemporary })); } catch (Exception exception) { Ultity.TFunction.WriteToLog(exception); return(Json(new { status = "fail", Message = Ultity.Constant.Ajax_Fail })); } }
public ActionResult GetData(string fromDate, string toDate, int userId, bool notAccept) { DateTime dtFrom, dtTo; #region +Validate if (string.IsNullOrEmpty(fromDate) || string.IsNullOrEmpty(toDate)) { return(Json(new { status = THelper.Ajax_Return.ErrSystem })); } try { dtFrom = DateTime.ParseExact(fromDate, "dd/MM/yyyy HH:mm", null); dtTo = DateTime.ParseExact(toDate, "dd/MM/yyyy HH:mm", null); } catch (Exception e) { return(Json(new { status = THelper.Ajax_Return.ErrSystem })); } #endregion #region Handler if (AuthorizeUser.IsHost() || AuthorizeUser.IsAction(Ultity.Constant.ViewEditAll)) { var lst = new SysAdminAction <Cms_HistoryPayment>().HistoryPayment(dtFrom, dtTo, userId); if (notAccept) { lst = lst.Where(x => x.IsActive == false).ToList(); } return(Json(new { status = THelper.Ajax_Return.Ok, value = lst })); } else { var lst = new SysAdminAction <Cms_HistoryPayment>().HistoryPayment(dtFrom, dtTo, WebSecurity.CurrentUserId); if (notAccept) { lst = lst.Where(x => x.IsActive == false).ToList(); } return(Json(new { status = THelper.Ajax_Return.Ok, value = lst })); } #endregion }
public ActionResult Index() { ViewBag.Host = AuthorizeUser.IsHost() || AuthorizeUser.IsAction(Ultity.Constant.ViewEditAll); ViewBag.Add = AuthorizeUser.IsAction(Ultity.Constant.Add); ViewBag.Edit = AuthorizeUser.IsAction(Ultity.Constant.Edit); ViewBag.Delete = AuthorizeUser.IsAction(Ultity.Constant.Delete); ViewBag.UsedStateAdd = Ultity.TFunction.GetUsedStateSelected(Ultity.Constant.Active); ViewBag.UsedState = Ultity.TFunction.GetAllUsedStateSelected(Ultity.Constant.All); #region Danh sách các lớp học string sWhere = (AuthorizeUser.IsHost() || AuthorizeUser.IsAction(Ultity.Constant.ViewEditAll)) ? " 1=1 " : " a.CreatedBy =" + WebSecurity.CurrentUserId; var lstClass = new SysAdminAction <Cms_Class>().List(sWhere, "a.CreatedDate desc", 0, 100); var itemsListSearch = new List <SelectListItem>(); var itemsListAdd = new List <SelectListItem>(); var selectListItem1 = new SelectListItem { Text = Ultity.Constant.VideoString, Value = Ultity.Constant.Video.ToString(), Selected = false }; var selectListItemAll = new SelectListItem { Text = "Tất cả", Value = "0", Selected = true }; itemsListSearch.Add(selectListItemAll); foreach (var item in lstClass) { SelectListItem obj = new SelectListItem(); obj.Value = item.Id.ToString(); obj.Text = item.Name; obj.Selected = false; itemsListSearch.Add(obj); itemsListAdd.Add(obj); } ViewBag.ListClass = itemsListSearch; ViewBag.ListClassAdd = itemsListAdd; #endregion return(View()); }
public ActionResult GetDataCategory(string key, int type) { try { string sWhere = (AuthorizeUser.IsHost() || AuthorizeUser.IsAction(Ultity.Constant.ViewEditAll)) ? " 1=1 " : " a.CreatedBy =" + WebSecurity.CurrentUserId; if (!string.IsNullOrEmpty(key)) { key = key.Trim(); ViewBag.Search = key; sWhere += "and ( a.Name like N'%" + key + "%' or dbo.ConvertToNoSigned(a.Name) like dbo.ConvertToNoSigned(N'%" + key + "%')) "; } string sSort = "a.Orders DESC"; if (type == 1) //Category { var modelList = new SysAdminAction <Ex_Category>().List(sWhere, sSort, 0, 100); //Check after deleted last item in page . Redirect page close have value smaller if (Request.IsAjaxRequest()) { return(Json(new { status = "success", Message = Ultity.Constant.Ajax_Success, Data = modelList })); } } else//CategoryValue { var modelList = new SysAdminAction <Ex_CategoryValue>().List(sWhere, sSort, 0, 100); //Check after deleted last item in page . Redirect page close have value smaller if (Request.IsAjaxRequest()) { return(Json(new { status = "success", Message = Ultity.Constant.Ajax_Success, Data = modelList })); } } } catch (Exception exception) { Ultity.TFunction.WriteToLog(exception); return(Json(new { status = "fail", Message = Ultity.Constant.Ajax_Fail })); } return(Json(new { status = "fail", Message = Ultity.Constant.Ajax_Fail })); }
public ActionResult GetInfoData(int type, string grade, string examId, string subjectId) { try { switch (type) { case 1: //lấy môn học theo khối { var objTemporary = new Ex_SubjectAction().GetSubjectByGrade(grade); return(Json(new { status = "success", Message = Ultity.Constant.Ajax_Success, Data = objTemporary })); } case 2: //Lấy đề thi theo môn và khối { var objTemporary = new SysAdminAction <Ex_Exam>().List("a.SubjectId=" + subjectId + " and a.Grade='" + grade.Trim() + "'", "a.Orders desc", 0, 100); return(Json(new { status = "success", Message = Ultity.Constant.Ajax_Success, Data = objTemporary })); } case 3: //Lấy chương theo đề thi { var objTemporary = new SysAdminAction <Ex_ExamConfig>().List("a.ExamCode='" + examId + "'", "a.Orders desc", 0, 100); return(Json(new { status = "success", Message = Ultity.Constant.Ajax_Success, Data = objTemporary })); } default: //break; { return(Json(new { status = "err", Message = Ultity.Constant.Ajax_Fail })); } } } catch (Exception exception) { Ultity.TFunction.WriteToLog(exception); return(Json(new { status = "fail", Message = Ultity.Constant.Ajax_Fail })); } }
public ActionResult Payment(int userId, int type, int money) { string sWhere = "1=1"; var modelUser = new SysUserAction().GetById(userId); if (AuthorizeUser.IsHost()) { if (type == 1) { new SysAdminAction <SysUser>().Updates("BCoin=BCoin+" + money, "UserId=" + userId); #region +Thêm vào lịch sử giao dịch new SysAdminAction <Cms_HistoryPayment>().Payment(new Cms_HistoryPayment { IdGuid = Guid.NewGuid().ToString(), FromUser = Ultity.Constant.userIdAdmin, Code = string.Empty, ToUser = userId, BCoin = money, Summary = Ultity.Constant.NapTien, CreatedDate = DateTime.Now, IsShow = true, IsActive = true, }); #endregion } else { if (modelUser.BCoin < money) { return(Json(new { status = "money", Message = Ultity.Constant.Ajax_Fail })); } new SysAdminAction <SysUser>().Updates("BCoin=BCoin-" + money, "UserId=" + userId); #region +Thêm vào lịch sử giao dịch new SysAdminAction <Cms_HistoryPayment>().Payment(new Cms_HistoryPayment { IdGuid = Guid.NewGuid().ToString(), FromUser = Ultity.Constant.userIdAdmin, Code = string.Empty, ToUser = userId, BCoin = money, Summary = Ultity.Constant.AdminRutTien, CreatedDate = DateTime.Now, IsShow = true, IsActive = true, }); #endregion } #region Gửi mail thông báo giao dịch thành công var model = new SysUserAction().GetById(userId); if (type == 1) { Models.THelper.SendMail(model.Email, model.FullName, String.Format("{0:0,0}", money), "Nạp tiền"); } else { Models.THelper.SendMail(model.Email, model.FullName, String.Format("{0:0,0}", money), "Rút tiền"); } #endregion } else { if (WebSecurity.CurrentUserId > 0 && type == -1) { if (modelUser.BCoin < money) { return(Json(new { status = "money", Message = Ultity.Constant.Ajax_Fail })); } #region +Thêm vào lịch sử giao dịch var modelHis = new Cms_HistoryPayment { IdGuid = Guid.NewGuid().ToString(), FromUser = WebSecurity.CurrentUserId, Code = string.Empty, ToUser = WebSecurity.CurrentUserId, BCoin = money, Summary = Ultity.Constant.DeXuatRutTien, CreatedDate = DateTime.Now, IsShow = false, IsActive = false, }; new SysAdminAction <Cms_HistoryPayment>().Payment(modelHis); #endregion #region Gửi thông báo cho Giáo viên và Admin var lstUserInClass = new List <Cms_HistoryPayment>(); lstUserInClass.Add(modelHis); lstUserInClass.ForEach(x => { x.CreatedDateStr = Convert.ToDateTime(x.CreatedDate).ToString("dd/MM/yyy HH:mm"); x.FromUserStr = modelUser.FullName; }); IHubContext contextall = GlobalHost.ConnectionManager.GetHubContext <NotificationHub>(); NotificationHub hub = new NotificationHub(); //Gửi cho Admin var userAd = new SysAdminAction <SysUser>().GetById((Convert.ToInt32(Ultity.Constant.userIdAdmin))); UserHubModels userAdmin = hub.GetUser(userAd.UserName); if (userAdmin != null) { List <string> connectIds = userAdmin.ConnectionIds.ToList <string>(); connectIds.ForEach(x => { contextall.Clients.Client(x).recieveNotificationFirstTime(lstUserInClass); }); } #endregion } } return(Json(new { status = "success", Message = Ultity.Constant.Ajax_Success })); }
public ActionResult GetData(string fromDate, string toDate, int userId, bool chkKhoaHoc, bool chkDeThi, string ddlClass, string ddlExam) { DateTime dtFrom, dtTo; var lstResult = new List <ReportClassModel>(); #region +Validate if (string.IsNullOrEmpty(fromDate) || string.IsNullOrEmpty(toDate)) { return(Json(new { status = THelper.Ajax_Return.ErrSystem })); } try { dtFrom = DateTime.ParseExact(fromDate, "dd/MM/yyyy HH:mm", null); dtTo = DateTime.ParseExact(toDate, "dd/MM/yyyy HH:mm", null); } catch (Exception e) { return(Json(new { status = THelper.Ajax_Return.ErrSystem })); } #endregion #region +Handler if (chkKhoaHoc) { string sWhere = "1=1 and a.CreatedDate>='" + dtFrom.ToString("MM/dd/yyy HH:mm") + "' and a.CreatedDate <='" + dtTo.ToString("MM/dd/yyy HH:mm") + "'"; sWhere = (userId == 0 && AuthorizeUser.IsHost()) ? sWhere: (sWhere + "and a.CreatedBy=" + (userId == 0 ? WebSecurity.CurrentUserId : userId) + ""); sWhere = (ddlClass == "0") ? sWhere : (sWhere + "and a.IdGuid='" + ddlClass + "'"); string sql = "Select a.*,(select count(*) from Cms_ClassStudent where ClassGuid=a.IdGuid)as TongHS from Cms_Class a "; sql += " where " + sWhere; var lst = SqlHelper.ExecuteList <Cms_Class>(SqlConnection, CommandType.Text, sql); lst.ForEach(x => { lstResult.Add(new ReportClassModel { Time = Convert.ToDateTime(x.CreatedDate), Loai = "Khóa học", Ten = x.Name, SoLuong = x.TongHS }); }); } if (chkDeThi) { string sWhere = "1=1 and a.CreatedDate>='" + dtFrom.ToString("MM/dd/yyy HH:mm") + "' and a.CreatedDate <='" + dtTo.ToString("MM/dd/yyy HH:mm") + "'"; sWhere = (userId == 0 && AuthorizeUser.IsHost()) ? sWhere : (sWhere + "and a.CreatedBy=" + (userId == 0?WebSecurity.CurrentUserId:userId) + ""); sWhere = (ddlExam == "0") ? sWhere : (sWhere + "and a.IdGuid='" + ddlExam + "'"); var lst = new SysAdminAction <Ex_Exam>().List(sWhere, "a.CreatedDate desc", 0, 100); lst.ForEach(x => { lstResult.Add(new ReportClassModel { Time = Convert.ToDateTime(x.CreatedDate), Loai = "Đề thi", Ten = x.Name, SoLuong = x.TotalStudent }); }); } #endregion return(Json(new { status = THelper.Ajax_Return.Ok, value = lstResult })); }