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 DeleteWish(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;
// this method splits the wishes to seperate collums and makes it possible to delete a specific wish
svc.WishGetList(memberCompanyNo, memberNo);
//define wish to delete
RestEgBoligTest.EgBoligService.Wish wishDelete = new RestEgBoligTest.EgBoligService.Wish();
/**************** FROM DATABASE ****************/
// connectionstring
SqlConnection cn = new SqlConnection(@"Data Source=HAXDMA49; Initial Catalog=Bolig2; Integrated Security=False; User ID=EGBoligWS; Password=zYnc6hvWeytL9AVe; Multipleactiveresultsets=True; App=EntityFramework");
cn.Open();
// SQL for Kontrakt table in Bolig2 database
string sql = "select autonum from [Bolig2].[dbo].[Medlafd] where sel = " + memberCompanyNo + " and medlem = " + memberNo + " and selmin = " + companyNo + " and selmax = " + companyNo + " and afdmin = " + departmentNo + " and afdmax = " + departmentNo + " and rummin = " + rooms + " and rummax = " + rooms + " and lmtype1 = " + type;
SqlCommand cmd = new SqlCommand(sql, cn);
short autoNo = 0;
// get data from Kontrakt table
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
autoNo = Convert.ToInt16(dr["autonum"]);
wishDelete.MemberCompanyNo = memberCompanyNo;
wishDelete.MemberNo = memberNo;
wishDelete.AutoNo = autoNo;
wishDelete.CompanyNo = companyNo;
wishDelete.DepartmentNo = departmentNo;
wishDelete.Room = rooms;
wishDelete.TenancyType = type;
svc.WishDelete(wishDelete);
}
}
cn.Close();
return("Wish deleted!");
}
