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