public AuthorizationAuto AutoLogin(string iDuser) { var connectionString = GetDatabaseConnection(ConnectionName); AuthorizationAuto data = new AuthorizationAuto(); using (var conn = new SqlConnection(connectionString)) using (var command = new SqlCommand("AutoLogin", conn) { CommandType = CommandType.StoredProcedure }) { command.Parameters.AddWithValue("@ID", Convert.ToInt32(iDuser)); conn.Open(); SqlDataReader reader = command.ExecuteReader(); int id = -1; string name = ""; while (reader.Read()) { id = reader.GetInt32(0); name = reader.GetString(1); } conn.Close(); data.UserName = name; data.UserId = id; } return(data); }
public AuthorizationAuto AutoLogin(string iDuser) { var connectionString = GetDatabaseConnection(ConnectionName); AuthorizationAuto data = new AuthorizationAuto(); using (var conn = new SqlConnection(connectionString)) using (var command = new SqlCommand("AutoLogin", conn) { CommandType = CommandType.StoredProcedure }) { command.Parameters.AddWithValue("@ID", Convert.ToInt32(iDuser)); conn.Open(); SqlDataReader reader = command.ExecuteReader(); int id = -1; string name = ""; while (reader.Read()) { id = reader.GetInt32(0); name = reader.GetString(1); } conn.Close(); data.UserName = name; data.UserId = id; } return data; }