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