public IEnumerable <Member> Get()
{
List <Member> memberList = new List <Member>();
RestEgBoligTest.EgBoligService.Service10540Client svc = new RestEgBoligTest.EgBoligService.Service10540Client();
for (int i = 0; i < 10; i++)
{
Member member = new Member();
RestEgBoligTest.EgBoligService.Member memberFromService = svc.MemberGet(1, i + 1);
member.MemberCompanyNo = memberFromService.MemberCompanyNo;
member.MemberNo = memberFromService.MemberNo;
member.Name = memberFromService.Name;
member.Address = memberFromService.Address;
member.PostalCodeCity = memberFromService.PostalCodeCity;
member.Country = memberFromService.Country;
member.CprNo = memberFromService.CprNo;
member.Email = memberFromService.Email;
member.HomePhone = memberFromService.HomePhone;
member.MobilePhone = memberFromService.MobilePhone;
member.Children = memberFromService.Children;
memberList.Add(member);
}
return(memberList);
}
public string AddWish(string cprNo, short companyNo, short departmentNo, byte rooms, short?type)
{
/**************** FROM WEB SERVICE ****************/
string cprNoFormatted = cprNo.Insert(6, "0");
RestEgBoligTest.EgBoligService.Service10540Client svc = new RestEgBoligTest.EgBoligService.Service10540Client();
RestEgBoligTest.EgBoligService.Member[] memberFromService = svc.MemberGetListByCprNo(cprNoFormatted, false);
short memberCompanyNo = memberFromService[0].MemberCompanyNo;
decimal memberNo = memberFromService[0].MemberNo;
// to get autoNo
RestEgBoligTest.EgBoligService.Member member = svc.MemberGet(memberCompanyNo, memberNo);
// define wish
RestEgBoligTest.EgBoligService.Wish wish = new RestEgBoligTest.EgBoligService.Wish();
wish.MemberCompanyNo = memberCompanyNo;
wish.MemberNo = memberNo;
wish.AutoNo = member.AutoNo;
wish.CompanyNo = companyNo;
wish.DepartmentNo = departmentNo;
wish.FloorMax = 99;
wish.FloorMin = -1;
wish.Room = rooms;
wish.SqmMax = 9999;
wish.SqmMin = 0;
wish.TenancyType = type;
// add wish
svc.WishAdd(wish, null);
return("Wish added");
}
public string UpdateMember(string cprNo, string country, string postalCodeCity, string address, string email, string homePhone, string mobilePhone, short children, [FromBody] string comment)
{
/**************** FROM WEB SERVICE ****************/
string cprNoFormatted = cprNo.Insert(6, "0");
RestEgBoligTest.EgBoligService.Service10540Client svc = new RestEgBoligTest.EgBoligService.Service10540Client();
RestEgBoligTest.EgBoligService.Member[] memberFromService = svc.MemberGetListByCprNo(cprNoFormatted, false);
short memberCompanyNo = memberFromService[0].MemberCompanyNo;
decimal memberNo = memberFromService[0].MemberNo;
int interessentNo = memberFromService[0].InteressentNo;
decimal autoNo = memberFromService[0].AutoNo;
string type = memberFromService[0].Type;
/**************** FROM DATABASE ****************/
// connectionstring
SqlConnection connection = new SqlConnection(@"Data Source=HAXDMA49; Initial Catalog=Bolig2; Integrated Security=False; User ID=EGBoligWS; Password=zYnc6hvWeytL9AVe; Multipleactiveresultsets=True; App=EntityFramework");
connection.Open();
// SQL for Kontrakt table in Bolig2 database - Update comment
string sqlSetComment = "update Top(1) [Bolig2].[dbo].[Medlem] set krittext = '" + comment + "' where sel = " + memberCompanyNo + " and medlem = " + memberNo;
SqlCommand cmd = new SqlCommand(sqlSetComment, connection);
// execute command
cmd.ExecuteReader();
connection.Close();
//define member to update
RestEgBoligTest.EgBoligService.Member memberUpdate = new RestEgBoligTest.EgBoligService.Member();
memberUpdate.MemberCompanyNo = memberCompanyNo;
memberUpdate.MemberNo = memberNo;
memberUpdate.InteressentNo = interessentNo;
memberUpdate.AutoNo = autoNo;
memberUpdate.Type = type;
memberUpdate.Country = country;
memberUpdate.PostalCodeCity = postalCodeCity;
memberUpdate.Address = address;
memberUpdate.Email = email;
memberUpdate.HomePhone = homePhone;
memberUpdate.MobilePhone = mobilePhone;
memberUpdate.Children = children;
// comment
// Update member in service
svc.MemberUpdate(memberUpdate);
return("Member " + memberUpdate.Name + " updated!");
}
