public bool ValidateUser(string connectionString, string username, string password) { DataTable dt = null; bool _ret = false; try { SqlParameter[] parameters = { new SqlParameter("@username", username), new SqlParameter("@password", Utility.Tools.Encrypt(password)), SqlAccessor.SqlParameterBuilder("@returnValue", SqlDbType.Int, ParameterDirection.Output) }; dt = SqlAccessor.ExecuteDataSet(connectionString, SqlAccessor.SqlCommandBuilder(new SqlCommand(PL_VALIDATEUSER_SP), parameters), CommandType.StoredProcedure, "").Tables[0]; if (Convert.ToInt32(dt.Rows[0][0]) != 0) { _ret = true; } } catch (Exception exc) { //ErrorLog.Log(APLU_NAME, "GetAll():" + exc.Message); } return(_ret); }
public DataTable GetTrdpCode(string connectionString, string username) { DataTable dt = null; try { SqlParameter[] parameters = { new SqlParameter("@username", username), SqlAccessor.SqlParameterBuilder("@returnValue", SqlDbType.Int, ParameterDirection.Output) }; dt = SqlAccessor.ExecuteDataSet(connectionString, SqlAccessor.SqlCommandBuilder(new SqlCommand(PL_GETTRDPCODE_SP), parameters), CommandType.StoredProcedure, "").Tables[0]; } catch (Exception exc) { //ErrorLog.Log(APLU_NAME, "GetAll():" + exc.Message); } return(dt); }
public void ProcessLog(string connectionString, string processSource, bool isSuccess, string description, string technicalError) { DataTable dt = null; try { SqlParameter[] parameters = { new SqlParameter("@prlgProcessSource", processSource), new SqlParameter("@prlgIsSuccess", isSuccess), new SqlParameter("@prlgDescription", description), new SqlParameter("@prlgTechnicalErrDesc", technicalError), SqlAccessor.SqlParameterBuilder("@returnValue", SqlDbType.Int, ParameterDirection.Output) }; dt = SqlAccessor.ExecuteDataSet(connectionString, SqlAccessor.SqlCommandBuilder(new SqlCommand(PL_PROCESSLOG_SP), parameters), CommandType.StoredProcedure, "").Tables[0]; } catch (Exception exc) { //ErrorLog.Log(APLU_NAME, "GetAll():" + exc.Message); } }