static public string CubeName(int id) { string cubename = ""; Helpers.ETLHelpers.Debug("Trying to get cubename by chain: " + DdDReportState.currentChain); var chainConnString = DdDReportState.ChainConnectionString(DdDReportState.currentChain); Helpers.ETLHelpers.Debug("Got the chain connectionString: " + chainConnString); using (SqlConnection connection = new SqlConnection(DdDReportState.ChainConnectionString(DdDReportState.currentChain))) { connection.Open(); using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = connection; cmd.CommandText = String.Format("SELECT cubeName FROM ddd.dbo.Users2 WHERE id = {0}", id); Helpers.ETLHelpers.Debug("SQL to fire: " + cmd.CommandText); using (SqlDataReader reader = cmd.ExecuteReader()) { if (reader.Read()) { cubename = reader.GetString(0); } } } } return(Helpers.ETLHelpers.RemoveSpecialChars(cubename)); }
static public bool FirstLogin(int id) { bool isFirstLogin = true; using (SqlConnection connection = new SqlConnection(DdDReportState.ChainConnectionString(DdDReportState.currentChain))) { connection.Open(); using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = connection; cmd.CommandText = String.Format("SELECT * from ddd.dbo.DdDreportActiveUsers WHERE id = {0}", id); using (SqlDataReader reader = cmd.ExecuteReader()) { if (reader.Read()) { isFirstLogin = false; } } if (isFirstLogin) { var cube = ""; var username = ""; cmd.CommandText = String.Format("SELECT username,cubeName FROM ddd.dbo.Users2 WHERE id = {0}", id); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { username = reader.GetString(0); cube = reader.GetString(1); } } cmd.CommandText = String.Format("INSERT INTO ddd.dbo.DdDreportActiveUsers values ({0},'{1}','{2}',CURRENT_TIMESTAMP)", id, username, cube); cmd.ExecuteNonQuery(); } } } return(isFirstLogin); }
public static string Currency(int id) { string currency = ""; using (SqlConnection connection = new SqlConnection(DdDReportState.ChainConnectionString(DdDReportState.currentChain))) { connection.Open(); using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = connection; cmd.CommandText = String.Format("SELECT currency FROM ddd.dbo.Users2 where id={0}", id); using (SqlDataReader reader = cmd.ExecuteReader()) { if (reader.Read()) { currency = reader.GetString(0); } } } } return(currency); }
static public string Email(int id) { string email = ""; using (SqlConnection connection = new SqlConnection(DdDReportState.ChainConnectionString(DdDReportState.currentChain))) { connection.Open(); using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = connection; cmd.CommandText = String.Format("SELECT email FROM ddd.dbo.Users2 WHERE id = {0}", id); using (SqlDataReader reader = cmd.ExecuteReader()) { if (reader.Read()) { email = reader.GetString(0); } } } } return(email); }