private string getPassWord(string userName) { EntUserPassword objentuserPass = new EntUserPassword(); UserPassword objUserPassword = new UserPassword(); objentuserPass = objUserPassword.getUserPassword(userName); string Password = objentuserPass.Password; return(Password); }
public EntUserPassword getUserPassword(string userName) { SqlParameter[] param = new SqlParameter[] { new SqlParameter("@UserName", userName) }; userInformation = new EntUserPassword(); if (objConnection.Connection.State == ConnectionState.Closed) { objConnection.Connection.Open(); } reader = objConnection.ExecuteDataSetQuery(clsConstant.SP_GET_PASSWORD_BY_USERNAME, CommandType.StoredProcedure, param); if (reader.Tables[0] != null && reader.Tables[0].Rows.Count > 0) { //------------------------ userInformation.Password = reader.Tables[0].Rows[0][0].ToString(); //userInformation.isUserActive = bool.Parse(reader.Tables[0].Rows[0][1].ToString()); } return(userInformation); }