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 GetChuong(string key, string code)
{
try
{
string sWhere = (AuthorizeUser.IsHost() || AuthorizeUser.IsAction(Ultity.Constant.ViewEditAll)) ? " WHERE 1=1 " : " WHERE a.CreatedBy =" + WebSecurity.CurrentUserId;
sWhere += " and a.Section like '%" + key + "%'";
sWhere += " and a.ExamCode = '" + code.Trim() + "'";
string sSort = " ORDER BY a.Orders DESC";
var modelList = new Ex_ExamConfigAction().GetExamConfig(sWhere, sSort);
//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 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.Accept = AuthorizeUser.IsAction(Ultity.Constant.Accept);
ViewBag.UsedStateAdd = Ultity.TFunction.GetUsedStateSelected(Ultity.Constant.Active);
//ViewBag.TypeList = new SysAdminAction<Cms_ClassVideo>().List("a.UsedState=1 and a.Type=" + Ultity.Constant.Video, "a.Orders asc", 0, 100);
string[] str = { Constant.UsedState_Delete, Constant.UsedState_NotActive };
var itemsList = new List <SelectListItem>();
for (int i = -1; i < str.Length - 1; i++)
{
bool isSelected = false;
if (i == Constant.NotActive)
{
isSelected = true;
}
var selectListItem = new SelectListItem {
Text = str[i + 1], Value = CommonHelper.Convert.ConvertToString(i), Selected = isSelected
};
itemsList.Add(selectListItem);
}
ViewBag.UsedState = itemsList;
ViewBag.Grade = new SysAdminAction <Ex_CategoryValue>().List("a.CatCode='KHOI'", "a.Orders desc", 0, 100);
return(View());
}
public ActionResult GetData(int?page, int?pageSize, string key, string grade, int subjectId, string exam, int sectionId)
{
try
{
var objRef = new object[5];
int currentPageIndex = page.HasValue ? page.Value - 1 : 0;
if (currentPageIndex < 0)
{
currentPageIndex = 0;
}
pageSize = rowInPage;
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.QuestionContent like N'%" + key + "%' or dbo.ConvertToNoSigned(a.QuestionContent) like dbo.ConvertToNoSigned(N'%" + key + "%')) ";
}
if (!string.IsNullOrEmpty(grade))
{
sWhere += " and a.Grade ='" + grade.Trim() + "'";
}
if (subjectId > 0)
{
sWhere += " and a.SubjectId =" + subjectId + "";
}
if (!string.IsNullOrEmpty(exam))
{
sWhere += " and a.ExamId ='" + exam.Trim() + "'";
}
if (sectionId > 0)
{
sWhere += " and a.SectionId =" + sectionId + "";
}
string sSort = "a.CreatedDate DESC";
objRef[0] = sWhere;
objRef[1] = sSort;
objRef[2] = currentPageIndex;
objRef[3] = pageSize;
objRef[4] = 0;
var modelList = _sysAction.List(ref objRef);
int totalRow = CommonHelper.Convert.ConvertToInt32(objRef[4]);
//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, TotalPage = totalRow, CurrentPage = currentPageIndex, PageSize = pageSize }));
}
}
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 }));
}
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);
return(View());
}
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);
//ViewBag.TypeList = new SysAdminAction<Cms_ClassVideo>().List("a.UsedState=1 and a.Type=" + Ultity.Constant.Video, "a.Orders asc", 0, 100);
return(View());
}
public ActionResult Edit(SysGroup sysModel)
{
try
{
#region Redirect Request
int succcess;
if (sysModel.Id > 0)
{
var objTemporary = _sysAction.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;
succcess = _sysAction.Update(sysModel.Id, sysModel.Name, sysModel.Summary, CommonHelper.Convert.ConvertToInt32(sysModel.UsedState), CommonHelper.Convert.ConvertToDateTime(sysModel.CreatedDate), CommonHelper.Convert.ConvertToInt32(sysModel.CreatedBy), sysModel.ModifiedDate, sysModel.ModifiedBy);
}
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;
succcess = _sysAction.Insert(sysModel.Name, sysModel.Summary, CommonHelper.Convert.ConvertToInt32(sysModel.UsedState), CommonHelper.Convert.ConvertToDateTime(sysModel.CreatedDate), CommonHelper.Convert.ConvertToInt32(sysModel.CreatedBy), sysModel.ModifiedDate, sysModel.ModifiedBy);
}
else
{
succcess = 1;
}
}
if (succcess > 0)
{
return(Json(new { status = "success", Message = Ultity.Constant.Ajax_Success }));
}
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 GetData(int?page, int?pageSize, string key, int?sort, string usedState, string subjectId)
{
try
{
var objRef = new object[5];
int currentPageIndex = page.HasValue ? page.Value - 1 : 0;
if (currentPageIndex < 0)
{
currentPageIndex = 0;
}
pageSize = 100;
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 + "%')) ";
}
if (!string.IsNullOrEmpty(usedState))
{
if (!usedState.Equals(Ultity.Constant.All.ToString()))
{
ViewBag.UsedState = Ultity.TFunction.GetAllUsedStateSelected(CommonHelper.Convert.ConvertToInt32(usedState));
sWhere = string.IsNullOrEmpty(sWhere) ? " a.UsedState=" + usedState + "" : (sWhere + " AND a.UsedState=" + usedState + " ");
}
}
if (!string.IsNullOrEmpty(subjectId))
{
sWhere = string.IsNullOrEmpty(sWhere) ? " a.SubjectId=" + subjectId + "" : (sWhere + " AND a.SubjectId=" + subjectId + " ");
}
string sSort = "a.CreatedDate DESC";
objRef[0] = sWhere;
objRef[1] = sSort;
objRef[2] = currentPageIndex;
objRef[3] = pageSize;
objRef[4] = 0;
var modelList = _sysAction.List(ref objRef);
int totalRow = CommonHelper.Convert.ConvertToInt32(objRef[4]);
//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, TotalPage = totalRow, CurrentPage = currentPageIndex, PageSize = pageSize }));
}
}
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 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(int?cauhoi)
{
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);
ViewBag.Grade = new SysAdminAction <Ex_CategoryValue>().List("a.CatCode='KHOI'", "", 0, 100);
ViewBag.DoKho = new SysAdminAction <Ex_CategoryValue>().List("a.CatCode='DK'", "", 0, 100);
return(View());
}
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 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(int?cauhoi)
{
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);
ViewBag.Grade = new SysAdminAction <Ex_CategoryValue>().List("a.CatCode='KHOI'", "", 0, 100);
ViewBag.DoKho = new SysAdminAction <Ex_CategoryValue>().List("a.CatCode='DK'", "", 0, 100);
var radom = new Random();
var currentDate = DateTime.Now;
//ViewBag.MaCauHoi = string.IsNullOrEmpty(cauhoi) ? code : cauhoi;
return(View());
}
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);
var objRef = new object[5];
string sSort = "a.CreatedDate DESC";
objRef[0] = "";
objRef[1] = sSort;
objRef[2] = 0;
objRef[3] = 100;
objRef[4] = 0;
var modelList = _sysGroupAction.List(ref objRef);
ViewBag.ListGroup = modelList;
return(View());
}
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 Edit(SysUser sysModel)
{
try
{
int id = CommonHelper.Convert.ConvertToInt32(sysModel.Id);
int isSuc = 0;
if (sysModel.Id == 0)
{
sysModel.UserName = sysModel.UserName.Trim();
sysModel.FullName = string.IsNullOrEmpty(sysModel.FullName) ? string.Empty : sysModel.FullName.Trim();
if (!WebSecurity.UserExists(sysModel.UserName))
{
try
{
//Create User Membership
if (AuthorizeUser.IsAction(Ultity.Constant.Add) || AuthorizeUser.IsAction(Ultity.Constant.ViewEditAll))
{
WebSecurity.CreateUserAndAccount(sysModel.UserName.Trim(), sysModel.Password.Trim());
//Get UserByName
int userId = WebSecurity.GetUserId(sysModel.UserName);
if (userId > 0)
{
//Create CoreSys User
try
{
var model = new SysUser();
model.Id = userId;
model.UserId = userId;
model.CreatedBy = WebSecurity.CurrentUserId;
model.FullName = sysModel.FullName.Trim();
model.UserName = sysModel.UserName.Trim();
model.Email = sysModel.Email;
model.Phone = sysModel.Phone;
model.Host = sysModel.Host;
model.Gender = sysModel.Gender;
model.BCoin = 0;
model.UsedState = sysModel.UsedState;
model.CreatedDate = DateTime.Now;
isSuc = _sysAction.Insert(model);
}
catch (Exception exception)
{
((SimpleMembershipProvider)Membership.Provider).DeleteUser(sysModel.UserName.Trim(), true);
new SysAdminAction <SysUser>().Deletes("UserId=" + userId);
}
}
}
else
{
isSuc = 1;
}
}
catch (Exception exception)
{
Ultity.TFunction.WriteToLog(exception);
return(Json(new { status = "error", Message = "Đã tồn tại Username này trong hệ thống !" }));
}
}
else
{
//return
return(Json(new { status = "exits", Message = "Đã tồn tại Username này trong hệ thống !" }));
}
}
else
{
//Get User By Id
SysUser item = _sysAction.GetById(sysModel.Id);
if (item != null)
{
if (AuthorizeUser.IsAction(Ultity.Constant.Edit) || AuthorizeUser.IsAction(Ultity.Constant.ViewEditAll))
{
item.ModifiedBy = WebSecurity.CurrentUserId;
item.FullName = sysModel.FullName.Trim();
item.UserName = sysModel.UserName.Trim();
item.Email = sysModel.Email;
item.Phone = sysModel.Phone;
item.Host = sysModel.Host;
item.BCoin = sysModel.BCoin;
item.Gender = sysModel.Gender;
item.ImageUrl = sysModel.ImageUrl;
item.UsedState = sysModel.UsedState;
item.ModifiedDate = DateTime.Now;
item.CreatedDate = DateTime.Now;
isSuc = _sysAction.Update(item);
}
else
{
isSuc = 1;
}
}
}
return(Json(new { status = "success", Message = Ultity.Constant.Ajax_Fail }));
}
catch (Exception exception)
{
Ultity.TFunction.WriteToLog(exception);
return(Json(new { status = "fail", Message = Ultity.Constant.Ajax_Fail }));
}
}
public ActionResult AddTeacher(SysUser sysModel)
{
if (sysModel.Id == 0)
{
sysModel.UserName = sysModel.UserName.Trim();
sysModel.FullName = string.IsNullOrEmpty(sysModel.FullName) ? string.Empty : sysModel.FullName.Trim();
if (!WebSecurity.UserExists(sysModel.UserName))
{
try
{
//Create User Membership
if (AuthorizeUser.IsAction(Ultity.Constant.Add) || AuthorizeUser.IsAction(Ultity.Constant.ViewEditAll))
{
WebSecurity.CreateUserAndAccount(sysModel.UserName.Trim(), sysModel.Password.Trim());
//Get UserByName
int userId = WebSecurity.GetUserId(sysModel.UserName);
if (userId > 0)
{
//Create CoreSys User
try
{
#region + Thêm vào bảng SysUser
var model = new SysUser();
model.Id = userId;
model.UserId = userId;
model.CreatedBy = WebSecurity.CurrentUserId;
model.FullName = sysModel.FullName.Trim();
model.UserName = sysModel.UserName.Trim();
model.Email = sysModel.Email;
model.ImageUrl = sysModel.ImageUrl;
model.Phone = sysModel.Phone;
model.Summary = sysModel.Summary;
model.Host = sysModel.Host;
model.Gender = sysModel.Gender;
model.BCoin = 0;
model.UsedState = sysModel.UsedState;
model.CreatedDate = DateTime.Now;
_sysAction.Insert(model);
#endregion
#region +Thêm vào nhóm Giáo viên
var sysGroupUser = new SysGroupUser();
sysGroupUser.CreatedBy = WebSecurity.CurrentUserId;
sysGroupUser.CreatedDate = DateTime.Now;
sysGroupUser.GroupId = 20;
sysGroupUser.Orders = 2;
sysGroupUser.UserId = userId;
sysGroupUser.UsedState = Ultity.Constant.Active;
new SysGroupUserAction().Add(sysGroupUser);
#endregion
}
catch (Exception exception)
{
((SimpleMembershipProvider)Membership.Provider).DeleteUser(sysModel.UserName.Trim(), true);
new SysAdminAction <SysUser>().Deletes("UserId=" + userId);
}
}
return(Json(new { status = "success" }));
}
return(Json(new { status = "error", Message = "Đã tồn tại Username này trong hệ thống !" }));
}
catch (Exception exception)
{
Ultity.TFunction.WriteToLog(exception);
return(Json(new { status = "error", Message = "Đã tồn tại Username này trong hệ thống !" }));
}
}
else
{
return(Json(new { status = "exits", Message = "Đã tồn tại Username này trong hệ thống !" }));
}
}
else
{
//Get User By Id
SysUser item = _sysAction.GetById(sysModel.Id);
if (item != null)
{
if (!string.IsNullOrEmpty(sysModel.Password))
{
var token = WebSecurity.GeneratePasswordResetToken(sysModel.UserName);
// link directed to an action with form to capture password
WebSecurity.ResetPassword(token, sysModel.Password);
}
if (AuthorizeUser.IsAction(Ultity.Constant.Edit) || AuthorizeUser.IsAction(Ultity.Constant.ViewEditAll))
{
item.ModifiedBy = WebSecurity.CurrentUserId;
item.FullName = sysModel.FullName.Trim();
item.Email = sysModel.Email;
item.Phone = sysModel.Phone;
item.Host = sysModel.Host;
item.BCoin = sysModel.BCoin;
item.Gender = sysModel.Gender;
item.Summary = sysModel.Summary;
item.ImageUrl = sysModel.ImageUrl;
item.UsedState = sysModel.UsedState;
item.ModifiedDate = DateTime.Now;
item.CreatedDate = DateTime.Now;
_sysAction.Update(item);
}
}
}
return(Json(new { status = "success", Message = Ultity.Constant.Ajax_Fail }));
}
