public UserPaswordHistoryBO GetCurrentPaswordDetails(DBEgine dbEngine,int userID) { UserPaswordHistoryBO hs = null; try { SqlParameter[] parms = new SqlParameter[1]; SqlParameter p1 = new SqlParameter(); p1.ParameterName = "@UserID"; p1.SqlDbType = SqlDbType.Int; p1.Direction = ParameterDirection.Input; p1.Value = userID; parms[0] = p1; DataTable dtHistry = dbEngine.ExecuteDataTable("UserManagement.UM_GetCurrentPasswordDetails", parms); if (dtHistry.Rows.Count > 0) { foreach (DataRow r in dtHistry.Rows) { hs = new UserPaswordHistoryBO(); if (r.Table.Columns.Contains("UserPaswordHistoryID")) if (r["UserPaswordHistoryID"] != DBNull.Value) hs.UserPaswordHistoryID = (int)r["UserPaswordHistoryID"]; if (r.Table.Columns.Contains("UserID")) if (r["UserID"] != DBNull.Value) hs.UserID = (int)r["UserID"]; if (r.Table.Columns.Contains("Password")) if (r["Password"] != DBNull.Value) hs.Password = r["Password"].ToString(); if (r.Table.Columns.Contains("CreatedBy")) if (r["CreatedBy"] != DBNull.Value) hs.CreatedBy = (int)r["CreatedBy"]; if (r.Table.Columns.Contains("CreatedDate")) if (r["CreatedDate"] != DBNull.Value) hs.CreatedDate = DateTime.Parse(r["CreatedDate"].ToString()); if (r.Table.Columns.Contains("DayProcessID")) if (r["DayProcessID"] != DBNull.Value) hs.DayProcessID = r["DayProcessID"].ToString(); if (r.Table.Columns.Contains("IsCurrent")) if (r["IsCurrent"] != DBNull.Value) hs.IsCurrent = (bool)r["IsCurrent"]; } } return hs; } catch { throw; } }
public int SaveUserPaswordHistory(DBEgine dbEngine, UserPaswordHistoryBO upHistry) { int ID = -1; try { SqlParameter[] arrSqlParam = GetFDUpLiftmentParameters(upHistry); dbEngine.ExecNonQueryStoredProc("UserManagement.UM_SaveUserPasswordHistory", arrSqlParam); } catch { throw; } return ID; }
private SqlParameter[] GetFDUpLiftmentParameters(UserPaswordHistoryBO upHistry) { SqlParameter[] arrSqlParam = new SqlParameter[3]; SqlParameter param_UserID = new SqlParameter(); param_UserID.ParameterName = "@UserID"; param_UserID.SqlDbType = SqlDbType.Int; param_UserID.Value = upHistry.UserID; arrSqlParam[0] = param_UserID; SqlParameter param_Password = new SqlParameter(); param_Password.ParameterName = "@Password"; param_Password.SqlDbType = SqlDbType.NVarChar; param_Password.Value = upHistry.Password; arrSqlParam[1] = param_Password; SqlParameter param_CreatedBy = new SqlParameter(); param_CreatedBy.ParameterName = "@CreatedBy"; param_CreatedBy.SqlDbType = SqlDbType.Int; param_CreatedBy.Value = upHistry.CreatedBy; arrSqlParam[2] = param_CreatedBy; return arrSqlParam; }
public bool ChangePasswordByUserId(int userId, string userPassword, int createdBy) { bool isChange = false; DBEgine dbEgine = new DBEgine(); SqlTransaction trnx = null; try { dbEgine.DBOpen(trnx); SqlParameter[] parms = new SqlParameter[2]; SqlParameter p1 = new SqlParameter(); p1.ParameterName = "UserId"; p1.SqlDbType = SqlDbType.Int; p1.Direction = ParameterDirection.Input; p1.Value = userId; parms[0] = p1; SqlParameter p2 = new SqlParameter(); p2.ParameterName = "password"; p2.SqlDbType = SqlDbType.NVarChar; p2.Size = 500; p2.Direction = ParameterDirection.Input; p2.Value = userPassword; parms[1] = p2; dbEgine.ExecNonQueryStoredProc("UserManagement.UM_changePasswordByUserId", parms); isChange = true; UserPaswordHistoryBO histry = new UserPaswordHistoryBO(); histry.UserID = userId; histry.Password = userPassword; histry.CreatedBy = createdBy; new UserPaswordHistoryDAL().SaveUserPaswordHistory(dbEgine, histry); dbEgine.DBTransAction.Commit(); } catch { throw; } finally { dbEgine.DBClose(); } return isChange; }