public override async Task GrantResourceOwnerCredentials(OAuthGrantResourceOwnerCredentialsContext context) { context.OwinContext.Response.Headers.Add("Access-Control-Allow-Origin", new[] { "*" }); using (PrincipalContext pc = new PrincipalContext(ContextType.Domain, ESPL.AUTHENTICATION.OWINTOKEN.Models.Constants.DomainName)) { //Validate user credentials with AD if (pc.ValidateCredentials(context.UserName, context.Password)) { int authorizedUserID = 0; //Authorize user if site url is provided in Scope of context if (context.Scope != null && !string.IsNullOrEmpty(context.Scope[0])) { //Get User ID of given user from the site if the user is authorized to access site authorizedUserID = AuthorizeUser.GetUserIDFromSPSite(context.UserName, ESPL.AUTHENTICATION.OWINTOKEN.Models.Constants.QualifiedDomainName, context.Scope[0]); //check authorization id. If user id is zero "0" then the given user is not authorized to access the site if (authorizedUserID == 0) { context.SetError("unauthorized_user", "User is not authorized to access site"); return; } } //Get user information from AD UserPrincipal UserInfoFromAD = UserPrincipal.FindByIdentity(pc, context.UserName.ToString()); var identity = new ClaimsIdentity(context.Options.AuthenticationType); identity.AddClaim(new Claim("LoginName", Convert.ToString(context.UserName))); if (UserInfoFromAD.GivenName == null) { identity.AddClaim(new Claim("FirstName", "")); } else { identity.AddClaim(new Claim("FirstName", Convert.ToString(UserInfoFromAD.GivenName))); } if (UserInfoFromAD.MiddleName == null) { identity.AddClaim(new Claim("MiddleName", "")); } else { identity.AddClaim(new Claim("MiddleName", Convert.ToString(UserInfoFromAD.MiddleName))); } if (UserInfoFromAD.Surname == null) { identity.AddClaim(new Claim("LastName", "")); } else { identity.AddClaim(new Claim("LastName", Convert.ToString(UserInfoFromAD.Surname))); } if (UserInfoFromAD.EmailAddress == null) { identity.AddClaim(new Claim("EmailAddress", "")); } else { identity.AddClaim(new Claim("EmailAddress", Convert.ToString(UserInfoFromAD.EmailAddress))); } if (UserInfoFromAD.VoiceTelephoneNumber == null) { identity.AddClaim(new Claim("Telephone", "")); } else { identity.AddClaim(new Claim("Telephone", Convert.ToString(UserInfoFromAD.VoiceTelephoneNumber))); } if (UserInfoFromAD.EmployeeId == null) { identity.AddClaim(new Claim("EmployeeID", "")); } else { identity.AddClaim(new Claim("EmployeeID", Convert.ToString(UserInfoFromAD.EmployeeId))); } identity.AddClaim(new Claim("UserName", Convert.ToString(UserInfoFromAD.Name))); if (authorizedUserID == 0) { identity.AddClaim(new Claim("UserID", "")); } else { identity.AddClaim(new Claim("UserID", Convert.ToString(authorizedUserID))); } identity.AddClaim(new Claim(ClaimTypes.Name, context.UserName)); context.Validated(identity); } else { context.SetError("inactive_user", "User is not valid custom message"); return; } } }
public ActionResult GetData(int?page, int?pageSize, string key, int?sort, string usedState) { try { var objRef = new object[5]; int currentPageIndex = page.HasValue ? page.Value - 1 : 0; if (currentPageIndex < 0) { currentPageIndex = 0; } pageSize = pageSize.HasValue ? 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.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 + " "); } } string sSort = "a.Orders DESC"; if (sort.HasValue) { switch (sort.Value) { case 0: sSort = "a.Name ASC"; ViewBag.SortName = "1"; break; case 1: sSort = "a.Name DESC"; ViewBag.SortName = "2"; break; case 2: ViewBag.SortName = "0"; sSort = "a.Orders ASC"; break; } } else { ViewBag.SortName = "0"; } 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 })); }
private ActionResult ProposalPaymentInternal(string QuoteNo, string AppUserName = null, string CloseWindow = "false") { PaymentModel objPaymentModel = new PaymentModel(); objPaymentModel.QuoteNo = CrossCutting.CrossCutting_EncryptDecrypt.Decrypt(QuoteNo); #region Check user authorization AuthorizeUser authorizeUser = new AuthorizeUser(); if (!string.IsNullOrEmpty(AppUserName)) { authorizeUser.UserName = objPaymentModel.UserName = AppUserName; } else { authorizeUser.UserName = objPaymentModel.UserName = Username; } authorizeUser.QuoteNo = objPaymentModel.QuoteNo; authorizeUser = new AIA.Life.Business.Common.CommonBusiness().CheckAuthorisation(authorizeUser); if (!string.IsNullOrEmpty(authorizeUser.Error.ErrorMessage)) { return(RedirectToAction("AuthorizeError", "Error", new { errorMessage = authorizeUser.Error.ErrorMessage })); } #endregion objPaymentModel.CloseWindow = CloseWindow; TempData["CloseWindow"] = CloseWindow; objPaymentModel = objPaymentBusiness.FetchProposals(objPaymentModel); if (objPaymentModel.lstPaymentItems.Count > 0) { int planID = Convert.ToInt32(objPaymentModel.lstPaymentItems[0].PlanId); var obj = Context.tblMasProductPlans.Where(a => a.PlanId == planID).FirstOrDefault(); if (objPaymentModel.lstPaymentItems[0].PrefferedMode == "12") { switch (obj.PlanCode) { case "SBB": { if (objPaymentModel.lstPaymentItems[0].Premium < 12000) { objPaymentModel.lstPaymentItems[0].Premium = objPaymentModel.lstPaymentItems[0].Premium * 2; } break; } case "SBF": { objPaymentModel.lstPaymentItems[0].Premium = objPaymentModel.lstPaymentItems[0].Premium * 3; break; } case "PPG": { objPaymentModel.lstPaymentItems[0].Premium = objPaymentModel.lstPaymentItems[0].Premium * 3; break; } case "PPH": { if (objPaymentModel.lstPaymentItems[0].Premium < 12000) { objPaymentModel.lstPaymentItems[0].Premium = objPaymentModel.lstPaymentItems[0].Premium * 2; } break; } case "EPB": { if (objPaymentModel.lstPaymentItems[0].Premium < 12000) { objPaymentModel.lstPaymentItems[0].Premium = objPaymentModel.lstPaymentItems[0].Premium * 2; } break; } } } } return(View("~/Views/Payment/ProposalPayment.cshtml", objPaymentModel)); }
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 })); }
public ActionResult Edit(Ex_Exam sysModel) { try { #region Redirect Request int succcess = 0; if (sysModel.Id > 0) { var objTemporary = new SysAdminAction <Ex_Exam>().GetById(sysModel.Id); if (AuthorizeUser.IsAction(Ultity.Constant.Edit) || AuthorizeUser.IsAction(Ultity.Constant.ViewEditAll)) { sysModel.IdGuid = Guid.NewGuid().ToString(); sysModel.CreatedBy = objTemporary.CreatedBy; sysModel.ModifiedDate = DateTime.Now; sysModel.ModifiedBy = WebSecurity.CurrentUserId; sysModel.CreatedDate = objTemporary.CreatedDate; //sysModel.Name = objTemporary.Name; if (!AuthorizeUser.IsHost()) { sysModel.UsedState = objTemporary.UsedState; } succcess = _sysAction.Update(sysModel); } else { succcess = 1; } } else { if (AuthorizeUser.IsAction(Ultity.Constant.Add) || AuthorizeUser.IsAction(Ultity.Constant.ViewEditAll)) { sysModel.IdGuid = Guid.NewGuid().ToString(); sysModel.CreatedBy = WebSecurity.CurrentUserId; sysModel.ModifiedBy = null; sysModel.UsedState = Ultity.Constant.NotAccept; sysModel.CreatedDate = DateTime.Now; sysModel.ModifiedDate = null; succcess = _sysAction.Insert(sysModel); } 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 })); }
public ActionResult Delete(string id) { try { if (!string.IsNullOrEmpty(id)) { if (Request.IsAjaxRequest()) { string sWhere = " Id IN (" + id.Trim() + ") "; string sSet = "UsedState = " + Ultity.Constant.Request_Delete; if (!AuthorizeUser.IsHost()) { new SysAdminAction <SysMenu>().Updates(sSet, sWhere); return(Json(new { status = "success", Message = Ultity.Constant.Change_Delete_Success })); } else { #region Nhieu Id thi se xu ly tunh Id 1. Neu ton tai trong Bang khac thi chi dc Update Status ,Con neu k co thi xoa luon if (id.Contains(",")) { string[] tempId = id.Split(','); foreach (var i in tempId) { var menuLienQuan = new SysGroupMenuAction().List("a.MenuId=" + i, string.Empty, 0, 1); if (menuLienQuan.Count > 0) { return(Json(new { status = "warning", Message = Ultity.Constant.Delete_Success_Err })); } new SysAdminAction <SysMenu>().Deletes(" Id=" + i); } } #endregion Nhieu Id thi se xu ly tunh Id 1. Neu ton tai trong Bang khac thi chi dc Update Status ,Con neu k co thi xoa luon #region Xu ly 1 Id else { var menuLienQuan = new SysGroupMenuAction().List("a.MenuId=" + id, string.Empty, 0, 1); if (menuLienQuan.Count > 0) { return(Json(new { status = "warning", Message = Ultity.Constant.Delete_Success_Err })); } new SysAdminAction <SysMenu>().Deletes(sWhere); } #endregion Xu ly 1 Id return(Json(new { status = "success", Message = Ultity.Constant.Delete_Success })); } //Trigger auto to delete table related } } return(Json(new { status = "fail", Message = Ultity.Constant.Ajax_Fail })); } catch (Exception exception) { return(Json(new { status = "fail", Message = Ultity.Constant.Ajax_Fail })); } }