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);
}
}