// POST api/values
public int Post(memberget value)
{
var connection = new SqlConnection(connectionString);
connection.Open();
var sqlCommand = new SqlCommand($"insert into members (name,position,tag) values ('{value.lastname}','{value.position}','{value.tag}'); select scope_identity()", connection);
var createdid = sqlCommand.ExecuteScalar();
sqlCommand.CommandText = $"insert into contacts (mail,skype,memberID) values ('{value.mail}','{value.skype}',{Convert.ToInt32(createdid)})";
sqlCommand.ExecuteNonQuery();
connection.Close();
return(Convert.ToInt32(createdid));
}
// PUT api/values/5
public int Put(int id, memberget value)
{
var connection = new SqlConnection(connectionString);
connection.Open();
var oldMember = getmemberbyid(id);
var elemforuploads = new member();
var elemforcont = new contacts();
elemforuploads.ID = oldMember.ID;
if (string.IsNullOrEmpty(value.lastname))
{
elemforuploads.name = oldMember.name;
}
else
{
elemforuploads.name = value.lastname;
}
if (string.IsNullOrEmpty(value.tag))
{
elemforuploads.tag = oldMember.tag;
}
else
{
elemforuploads.tag = value.tag;
}
if (string.IsNullOrEmpty(value.position))
{
elemforuploads.position = oldMember.position;
}
else
{
elemforuploads.position = value.position;
}
elemforuploads.contacts = elemforcont;
if (string.IsNullOrEmpty(value.mail))
{
elemforcont.mail = oldMember.contacts.mail;
}
else
{
elemforcont.mail = value.mail;
}
if (string.IsNullOrEmpty(value.skype))
{
elemforcont.skype = oldMember.contacts.skype;
}
else
{
elemforcont.skype = value.skype;
}
var sqlcommand = new SqlCommand($"update members set name = '{elemforuploads.name}', position = '{elemforuploads.position}', tag = '{elemforuploads.tag}' where ID = {elemforuploads.ID}", connection);
sqlcommand.ExecuteNonQuery();
sqlcommand.CommandText = $"update contacts set mail = '{elemforcont.mail}', skype = '{elemforcont.skype}' where memberID = {id}";
sqlcommand.ExecuteNonQuery();
connection.Close();
return(elemforuploads.ID);
}