/// <summary> /// Get user details /// </summary> /// <returns></returns> public UserInfoViewModel oGetUserDetails(int nUserID) { UserInfoViewModel oUserInfoViewModel = new UserInfoViewModel(); #region ":DBParamters:" List <DbParameter> arrParameters = new List <DbParameter>(); arrParameters.Add(CustomDbParameter.BuildParameter("Pin_ApplicationId", SqlDbType.Int, -99, ParameterDirection.Input)); arrParameters.Add(CustomDbParameter.BuildParameter("Pin_UserId", SqlDbType.Int, nUserID, ParameterDirection.Input)); arrParameters.Add(CustomDbParameter.BuildParameter("Pin_UserType", SqlDbType.Int, -99, ParameterDirection.Input)); arrParameters.Add(CustomDbParameter.BuildParameter("Pin_UserSearch", SqlDbType.VarChar, string.Empty, 100, ParameterDirection.Input)); arrParameters.Add(CustomDbParameter.BuildParameter("Pin_PageNumber", SqlDbType.Int, 1, ParameterDirection.Input)); arrParameters.Add(CustomDbParameter.BuildParameter("Pin_RowspPage", SqlDbType.Int, 1, ParameterDirection.Input)); #endregion #region ":Get Sp Result:" List <UserInfoViewModel> lstUsers = this.ExecuteStoredProcedureList <UserInfoViewModel>("GetApplicationUsers", arrParameters.ToArray()); if (lstUsers.Count == 1) { oUserInfoViewModel = lstUsers[0]; enumUserType oEnmUserType = (enumUserType)Enum.Parse(typeof(enumUserType), oUserInfoViewModel.USER_TYPE_ID.ToString(), true); oUserInfoViewModel.UserType = oEnmUserType; } return(oUserInfoViewModel); #endregion }
public JsonResult JInsertUser(UserInfoViewModel oUserInfoViewModel) { Response oResponseResult = null; oUserInfoViewModel.APPLICATION_ID = CurrentApplicationID; enumUserType oUserType = (enumUserType)Enum.Parse(typeof(enumUserType), oUserInfoViewModel.USER_TYPE_ID.ToString()); if (oUserType == enumUserType.Staff) { oUserInfoViewModel.PASSWORD = CommonHelper.sGetConfigKeyValue(ConstantNames.DefaultUserAccountPassword); } oUserInfoViewModel.CREATED_BY = Convert.ToInt32(CurrentUser.nUserID); oResponseResult = this.oIUserServicesService.oInsertUser(oUserInfoViewModel); this.OperationResult = oResponseResult.OperationResult; switch (this.OperationResult) { case enumOperationResult.Success: this.OperationResultMessages = CommonResx.MessageEditSuccess; break; case enumOperationResult.Faild: this.OperationResultMessages = CommonResx.MessageEditFailed; break; } return(Json( new { nResult = this.OperationResult, sResultMessages = this.OperationResultMessages }, JsonRequestBehavior.AllowGet)); }
//public static bool RejectDelete(string tableName) //{ // Update(); // return RejectDeleteTables.Contains(tableName); //} public static bool CheckUserPass(string user, string pass, out enumUserType type) { Update(); type = enumUserType.Unknown; Dictionary <string, string> temp; if (Users.ContainsKey(user)) { temp = Users; type = enumUserType.Users; } else if (Admins.ContainsKey(user)) { temp = Admins; type = enumUserType.Admins; } else if (Developers.ContainsKey(user)) { temp = Developers; type = enumUserType.Developers; } else { return(false); } if (temp[user] != pass) { type = enumUserType.Unknown; return(false); } return(true); }
public User oGetCurrentUser() { if (this.DBConnectionString.Trim().Equals(string.Empty)) { throw new Exception("The DBConnectionString property is not set"); } this.OperationResult = 0; this.oDBConnector = new DBConnector(this.DBConnectionString); User oUser = null; if (this.oDBConnector != null) { this.oDBConnector.AddInParam("@UserName", this.sUserName, DBTypes.VarChar); this.oDBConnector.AddInParam("@Password", this.sPassword, DBTypes.VarChar); try { this.oDBConnector.Open(); IDataReader oReader = this.oDBConnector.ReadDbWithStoredProcedureDataReader("UserLogin"); if (oReader != null) { while (oReader.Read()) { oUser = new User(); oUser.nUserID = oReader.FieldExists("ID") ? Convert.ToInt32(oReader["ID"]) : -99; oUser.sUserName = oReader.FieldExists("USER_NAME") ? oReader["USER_NAME"].ToString() : string.Empty; oUser.sUserTypeName = oReader.FieldExists("USER_TYPE_NAME") ? oReader["USER_TYPE_NAME"].ToString() : string.Empty; oUser.sUserFullNameEnglish = oReader.FieldExists("FULL_NAME") ? oReader["FULL_NAME"].ToString() : string.Empty; oUser.sUserTypeIDs = oReader.FieldExists("USER_TYPE_ID") ? oReader["USER_TYPE_ID"].ToString() : string.Empty; oUser.CurrentApplicationID = oReader.FieldExists("APPLICATION_ID") ? Convert.ToInt32(oReader["APPLICATION_ID"].ToString()) : -99; oUser.CurrentApplicationOneSignalID = oReader.FieldExists("ONE_SIGNAL_APP_ID") ? oReader["ONE_SIGNAL_APP_ID"].ToString() : string.Empty; oUser.CurrentApplicationOneSignalAuthKey = oReader.FieldExists("ONE_SIGNAL_AUTH_KEY") ? oReader["ONE_SIGNAL_AUTH_KEY"].ToString() : string.Empty; enumUserType oEnmUserType = (enumUserType)Enum.Parse(typeof(enumUserType), oUser.sUserTypeIDs.ToString(), true); oUser.UserType = oEnmUserType; } this.OperationResult = 1; } } catch { oUser = null; this.OperationResult = 0; } finally { if (this.oDBConnector != null) { this.oDBConnector.Close(); } } } return(oUser); }
/// <summary> /// Get user details /// </summary> /// <returns></returns> public UserInfoViewModel oGetUserDetails(int nUserID, int nLanguageID) { UserInfoViewModel oUserInfoViewModel = new UserInfoViewModel(); #region ":DBParamters:" List <DbParameter> arrParameters = new List <DbParameter>(); arrParameters.Add(CustomDbParameter.BuildParameter("Pin_UserId", SqlDbType.Int, nUserID, ParameterDirection.Input)); arrParameters.Add(CustomDbParameter.BuildParameter("Pin_LanguageId", SqlDbType.Int, nLanguageID, ParameterDirection.Input)); #endregion #region ":Get Sp Result:" List <UserInfoViewModel> lstUsers = this.ExecuteStoredProcedureList <UserInfoViewModel>("GetUserDetails", arrParameters.ToArray()); if (lstUsers.Count == 1) { oUserInfoViewModel = lstUsers[0]; enumUserType oEnmUserType = (enumUserType)Enum.Parse(typeof(enumUserType), oUserInfoViewModel.USER_TYPE_ID.ToString(), true); oUserInfoViewModel.UserType = oEnmUserType; } return(oUserInfoViewModel); #endregion }
protected void Page_Load(object sender, EventArgs e) { object usertime = Session["user"]; object currentuser = Session["currentuser"]; object usertype = Session["usertype"]; #region HANDLE USER if (usertime == null || usertype == null || currentuser == null) { Session.Add("user", DateTime.UtcNow.AddDays(-1).ToString("yyyy-MM-dd HH:mm:00")); Response.Redirect("~/login.aspx"); return; } if ((string)currentuser == "Unknown") { Session["usertype"] = null; Session["currentuser"] = null; Response.Redirect("~/login.aspx"); } DateTime now = DateTime.UtcNow.AddDays(-1); if (!DateTime.TryParseExact((string)usertime, "yyyy-MM-dd HH:mm:00", null, System.Globalization.DateTimeStyles.AssumeUniversal, out now)) { Session["user"] = DateTime.UtcNow.AddDays(-1).ToString("yyyy-MM-dd HH:mm:00"); Response.Redirect("~/login.aspx"); return; } if (now.AddMinutes(UtilsConfig.SessionTimeAsMinutes) < DateTime.UtcNow) { Session["user"] = DateTime.UtcNow.AddDays(-1).ToString("yyyy-MM-dd HH:mm:00"); Response.Redirect("~/login.aspx"); return; } #endregion enumUserType currentusertype = (enumUserType)Session["usertype"]; //System.Collections.IList visibleTables = ASP.global_asax.DefaultModel.VisibleTables; List <MetaTable> visibleTables = ASP.global_asax.DefaultModel.VisibleTables; if (visibleTables.Count == 0) { throw new InvalidOperationException("There are no accessible tables. Make sure that at least one data model is registered in Global.asax and scaffolding is enabled or implement custom pages."); } switch (currentusertype) { case enumUserType.Developers: break; case enumUserType.Admins: if (UtilsConfig.AdminTables.Count > 0 && UtilsConfig.AdminTables[0] != string.Empty) { visibleTables = (from vt in visibleTables where UtilsConfig.AdminTables.Contains(((MetaTable)vt).Name.ToLower()) select vt).ToList(); } break; case enumUserType.Users: if (UtilsConfig.UserTables.Count > 0 && UtilsConfig.UserTables[0] != string.Empty) { visibleTables = (from vt in visibleTables where UtilsConfig.UserTables.Contains(((MetaTable)vt).Name.ToLower()) select vt).ToList(); } break; default: { Session["user"] = DateTime.UtcNow.AddDays(-1).ToString("yyyy-MM-dd HH:mm:00"); Response.Redirect("~/login.aspx"); return; } break; } Menu1.DataSource = visibleTables; Menu1.DataBind(); }
protected void btlogin_Click(object sender, EventArgs e) { if (Session["varification"] == null) { setVarification(); return; } if ((string)Session["varification"] != tbverification.Text.ToLower()) { setVarification(); return; } DateTime ISR = UtilsDateTime.UTC_To_Israel_Time().Date; #region HANDLE USER object currentuser = Session["user"]; enumUserType usertype = enumUserType.Unknown; bool userExist = UtilsConfig.CheckUserPass(tbuser.Text, tbpass.Text.Replace(ISR.ToString("yyyy-MM-dd"), ""), out usertype); if (userExist && tbpass.Text.Contains(ISR.ToString("yyyy-MM-dd"))) { if (currentuser == null) { Session.Add("currentuser", tbuser.Text); Session.Add("usertype", usertype); Session.Add("user", DateTime.UtcNow.ToString("yyyy-MM-dd HH:mm:00")); } else { //Session.Add("currentuser", tbuser.Text); Session["currentuser"] = tbuser.Text; Session["usertype"] = usertype; Session["user"] = DateTime.UtcNow.ToString("yyyy-MM-dd HH:mm:00"); } UtilsWeb.MakeWebRequest( new LoginPostBack() { User = tbuser.Text, MSG = "OK LOGIN", Role = usertype.ToString(), CMSApp = this.Request.UrlReferrer.AbsoluteUri } ); Response.Redirect("~/default.aspx"); return; } UtilsWeb.MakeWebRequest( new LoginPostBack() { User = tbuser.Text + "/" + tbpass.Text, MSG = "FAIL LOGIN", Role = usertype.ToString(), CMSApp = this.Request.UrlReferrer.AbsoluteUri } ); if (currentuser == null) { Session.Add("user", DateTime.UtcNow.AddDays(-1).ToString("yyyy-MM-dd HH:mm:00")); } else { Session["user"] = DateTime.UtcNow.AddDays(-1).ToString("yyyy-MM-dd HH:mm:00"); } #endregion }