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