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