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