// GET: api/ItemArtist
public List <ItemArtist> Get()
{
List <ItemArtist> pomList = new List <ItemArtist>();
using (var conn = new NpgsqlConnection("Host = localhost; Port = 5555; Username = db_201617z_va_proekt_invoke_mk_owner; Password = invoke_finki; Database = db_201617z_va_proekt_invoke_mk"))
{
conn.Open();
using (var cmd = new NpgsqlCommand())
{
cmd.Connection = conn;
cmd.CommandText = "SELECT * from invoke.itemartist";
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
ItemArtist artist = new ItemArtist();
artist.UserID = reader.GetInt64(0);
artist.UserName = reader.GetString(1);
artist.ItemArtisName = reader.GetString(2);
artist.ItemArtisSurName = reader.GetString(3);
pomList.Add(artist);
}
}
}
}
return(pomList);
}
// POST: api/Register
// POST: api/Users
public IHttpActionResult Post(ItemArtist user)
{
using (var conn = new NpgsqlConnection("Host = localhost; Port = 5555; Username = db_201617z_va_proekt_invoke_mk_owner; Password = invoke_finki; Database = db_201617z_va_proekt_invoke_mk"))
{
conn.Open();
using (var cmd = new NpgsqlCommand())
{
cmd.Connection = conn;
// Insert some data
/* *Igor*
* if we want to include userid..
* cmd.CommandText = "INSERT INTO invoke.users " +
* "(userid,username,userspassword,usersemail,userscountry,usersgender) " +
* $"VALUES('user.UserID = *','{user.UserName}','{user.Password}','{user.Email}','{user.Country}','{user.Gender}');";
* because we have nextval('users_usersid_seq'::regclass) in DataBase we dont need to include
* userid the DB know that he need to add the sequence
*/
cmd.CommandText = "INSERT INTO invoke.users " +
"(username,userspassword,usersemail,userscountry,usersgender) " +
$"VALUES('{user.UserName}','{user.Password}','{user.Email}','{user.Country}','{user.Gender}');";
cmd.ExecuteNonQuery();
//cmd.CommandText = "SELECT * from users where users.usersid = 6 ";
// cmd.CommandText = "SELECT users.usersid from users where users.username = '******'; ";
cmd.CommandText = $"SELECT * FROM invoke.users where users.username = '******'";
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
user.UserID = reader.GetInt64(0);
}
}
if (user.ItemArtisName == "asd123")
{
cmd.CommandText = "INSERT INTO invoke.costomers " +
"(usersid,costomersusername) " +
$"VALUES({user.UserID},'{user.UserName}');";
cmd.ExecuteNonQuery();
}
else
{
cmd.CommandText = "INSERT INTO invoke.itemartist " +
"(usersid,itemartistusername,itemartistname,itemartistsurname) " +
$"VALUES({user.UserID},'{user.UserName}','{user.ItemArtisName}','{user.ItemArtisSurName}') ";
cmd.ExecuteNonQuery();
}
}
return(Ok("Added user"));
}
}
