public IActionResult GetFromTableFixed(string table) { string sqlTableName; switch (table) { case "u": sqlTableName = "users"; break; case "s": sqlTableName = "shop_items"; break; default: throw new HttpRequestException($"Neteisingas lentelės pavadinimas: {table}"); } using var db = new DbContextMSSQL(); var con = db.Connection; var sql = $"SELECT * FROM " + sqlTableName; var cmd = new SqlCommand(sql, con); var dataReader = cmd.ExecuteReader(); var results = new LinkedList <Dictionary <string, string> >(); while (dataReader.Read()) { var dict = new Dictionary <string, string>(); results.AddLast(dict); for (int i = 0; i < dataReader.FieldCount; i++) { dict.Add(dataReader.GetName(i), dataReader.GetString(i)); } } return(Ok(results)); }
public IActionResult GetFromTable(string tableName) { using var db = new DbContextMSSQL(); var con = db.Connection; var sql = $"SELECT * FROM " + tableName; var cmd = new SqlCommand(sql, con); var dataReader = cmd.ExecuteReader(); var results = new LinkedList <Dictionary <string, string> >(); while (dataReader.Read()) { var dict = new Dictionary <string, string>(); results.AddLast(dict); for (int i = 0; i < dataReader.FieldCount; i++) { dict.Add(dataReader.GetName(i), dataReader.GetString(i)); } } return(Ok(results)); }
public IActionResult Get(string userId) { using var db = new DbContextMSSQL(); var con = db.Connection; var sql = $"SELECT * FROM users WHERE user_id = {userId}"; var cmd = new SqlCommand(sql, con); var dataReader = cmd.ExecuteReader(); var results = new LinkedList <User>(); while (dataReader.Read()) { results.AddLast(new User { UserId = dataReader.GetInt32(0), Username = dataReader.GetString(1), Email = dataReader.GetString(2), Password = dataReader.GetString(3), Balance = dataReader.GetInt32(4) }); } return(Ok(results)); }