// GET api/values
public IEnumerable <member> Get()
{
List <member> sqlLst = new List <member>();
var connection = new SqlConnection(connectionString);
connection.Open();
var sqlCommand = new SqlCommand("select * from members join contacts on members.ID = contacts.memberID", connection);
var reader = sqlCommand.ExecuteReader();
while (reader.Read())
{
var name = reader.GetValue(0).ToString();
var position = reader.GetValue(1).ToString();
var tag = reader.GetValue(2).ToString();
var photo = reader.GetValue(4).ToString();
var ID = Convert.ToInt32(reader.GetValue(3));
var mail = reader.GetValue(5).ToString();
var skype = reader.GetValue(6).ToString();
var member = new member
{
name = name,
position = position,
tag = tag,
photo = photo,
ID = ID,
contacts = new contacts
{
mail = mail,
skype = skype
}
};
sqlLst.Add(member);
}
connection.Close();
return(sqlLst);
}
// 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);
}
