private void btnAdd_Click(object sender, EventArgs e) { lblOutput.Text = ""; if (MessageBox.Show("Adding row to the database discards changes\nDo you wish to proceed?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) return; try { //refresh connection to client client = new EFlatsServiceReference.WcfEFlatsServiceClient("WSHttpBinding_IWcfEFlatsService"); int profileScore = client.GetStudentData(tbStudentEmail.Text.Trim()).Score; bool output = client.AddToWishlist(tbStudentEmail.Text.Trim(), Convert.ToInt32(tbFlatId.Text.Trim()), profileScore); if (output) lblOutput.Text = "Application was successfully added"; else lblOutput.Text = "An Error has accured - Unable to add application"; RefreshTable(); } catch(Exception e2) { lblOutput.Text = "Unable to connect to the Database"; } }
private void btnAdd_Click(object sender, EventArgs e) { lblOutput.Text = ""; if (MessageBox.Show("Adding row to the database discards changes\nDo you wish to proceed?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) { return; } try { //refresh connection to client client = new EFlatsServiceReference.WcfEFlatsServiceClient("WSHttpBinding_IWcfEFlatsService"); int profileScore = client.GetStudentData(tbStudentEmail.Text.Trim()).Score; bool output = client.AddToWishlist(tbStudentEmail.Text.Trim(), Convert.ToInt32(tbFlatId.Text.Trim()), profileScore); if (output) { lblOutput.Text = "Application was successfully added"; } else { lblOutput.Text = "An Error has accured - Unable to add application"; } RefreshTable(); } catch (Exception e2) { lblOutput.Text = "Unable to connect to the Database"; } }
private bool AddFlat() { try { //refresh connection to wcf client = new EFlatsServiceReference.WcfEFlatsServiceClient("WSHttpBinding_IWcfEFlatsService"); string result = client.AddFlat(tbLandlordEmail.Text, tbType.Text, tbAddress.Text, tbPostCode.Text, tbCity.Text, Convert.ToDouble(tbRent.Text), Convert.ToDouble(tbDeposit.Text), tbAvailableFrom.Text, tbDescription.Text); if (!result.Trim().Equals("Successfully added.")) return false; GetDataSetToGrid(); return true; } catch(Exception e) { return false; } }
private bool AddFlat() { try { //refresh connection to wcf client = new EFlatsServiceReference.WcfEFlatsServiceClient("WSHttpBinding_IWcfEFlatsService"); string result = client.AddFlat(tbLandlordEmail.Text, tbType.Text, tbAddress.Text, tbPostCode.Text, tbCity.Text, Convert.ToDouble(tbRent.Text), Convert.ToDouble(tbDeposit.Text), tbAvailableFrom.Text, tbDescription.Text); if (!result.Trim().Equals("Successfully added.")) { return(false); } GetDataSetToGrid(); return(true); } catch (Exception e) { return(false); } }
static void Main(string[] args) { EFlatsServiceReference.WcfEFlatsServiceClient client = new EFlatsServiceReference.WcfEFlatsServiceClient(); /* //register (new) Student Test bool registerStudentTest = false; registerStudentTest = client.AddStudent("*****@*****.**", "mypassword", false, false, 0, 0, false, 0, false, DateTime.Now, null, null, null, null, null, null, null); Console.WriteLine("register student | result: " + registerStudentTest.ToString()); //register (same) Student Again and fail Test bool registerStudentFailTest = false; registerStudentFailTest = client.AddStudent("*****@*****.**", "mypassword", false, false, 0, 0, false, 0, false, DateTime.Now, null, null, null, null, null, null, null); Console.WriteLine("register student (fail) | result: " + registerStudentFailTest.ToString()); //register (new landlord with existing student email) Landlord Test bool registerLandlordSTTest = false; registerLandlordSTTest = client.AddLandlord("*****@*****.**", "mypassword", false, DateTime.Now, null, null, null, null, null, null, null); Console.WriteLine("register landlord (fail) | result: " + registerLandlordSTTest.ToString()); //register (new) Landlord Test bool registerLandlordTest = false; registerLandlordTest = client.AddLandlord("*****@*****.**", "mypassword", false, DateTime.Now, null, null, null, null, null, null, null); Console.WriteLine("register landlord | result: " + registerLandlordTest.ToString()); //register (same) Landlord Again and fail Test bool registerLandlordFailTest = false; registerLandlordFailTest = client.AddLandlord("*****@*****.**", "mypassword", false, DateTime.Now, null, null, null, null, null, null, null); Console.WriteLine("register landlord (fail) | result: " + registerLandlordFailTest.ToString()); Console.WriteLine(); //add flat (new) with exisitng landlord email Test bool addFlatTest = false; addFlatTest = client.AddApartment("*****@*****.**", "flat", "address", "zipCode", 2000.0, 6000.0, DateTime.Now, DateTime.Now); Console.WriteLine("add flat | result: " + addFlatTest.ToString()); //add flat (new) with non exisitng landlord email Test bool addFlatNonExistingLandlordTest = false; addFlatNonExistingLandlordTest = client.AddApartment("*****@*****.**", "flat", "address", "zipCode", 2000.0, 6000.0, DateTime.Now, DateTime.Now); Console.WriteLine("add flat (fail) | result: " + addFlatNonExistingLandlordTest.ToString()); //very good catch to set address as PK Console.WriteLine(); //login student with existing account, correct password Test bool loginStudentExistingTest = false; loginStudentExistingTest = client.Login("*****@*****.**", "mypassword"); Console.WriteLine("login student | result: " + loginStudentExistingTest.ToString()); //login student with non existing account, correct password Test bool loginStudentNonExistingTest = false; loginStudentNonExistingTest = client.Login("*****@*****.**", "mypassword"); Console.WriteLine("login student (fail acc) | result: " + loginStudentNonExistingTest.ToString()); //login student with existing account, incorrect password Test bool loginStudentIncorrectPassTest = false; loginStudentIncorrectPassTest = client.Login("*****@*****.**", "mypasswordIncorrect"); Console.WriteLine("login student (fail pass) | result: " + loginStudentIncorrectPassTest.ToString()); //get data from existing user (student) object[] listStudent = new object[18]; client.GetData("*****@*****.**").CopyTo(listStudent, 0); Console.Write("\n\nFetching student data from database: \n"); for (int i = 0; i < listStudent.Length; i++) { Console.Write(listStudent[i] + " ,"); } //userData = initialize...(userData) //get data from existing user (landlord) object[] listLandlord = new object[18]; client.GetData("*****@*****.**").CopyTo(listLandlord, 0); Console.Write("\n\nFetching landlord data from database: \n"); for (int i = 0; i < listLandlord.Length; i++) { Console.Write(listLandlord[i] + " ,"); } //get data from nonexisting user object[] list = new object[18]; client.GetData("*****@*****.**").CopyTo(list, 0); Console.Write("\n\nFetching user data from database: \n"); for (int i = 0; i < list.Length; i++) { Console.Write(list[i] + " ,"); } Console.WriteLine(); Console.WriteLine(); //CHANGE FLAT ID //add to wish list bool AddToWishlist = false; AddToWishlist = client.AddToWishlist(360, "*****@*****.**", 1065); Console.WriteLine("add to wishlist | result: " + AddToWishlist); //add to wishlist existing application bool AddToWishlistExistingApplication = false; AddToWishlistExistingApplication = client.AddToWishlist(360, "*****@*****.**", 1065); Console.WriteLine("add to wishlist (fail APP)| result: " + AddToWishlistExistingApplication); //add to wish list non existing student bool AddToWishlistNonExistingStudent = false; AddToWishlistNonExistingStudent = client.AddToWishlist(5000, "*****@*****.**", 1065); Console.WriteLine("add to wishlist (fail ST) | result: " + AddToWishlistNonExistingStudent); //add to wish list non existing flat bool AddToWishlistNonExistingFlat = false; AddToWishlistNonExistingStudent = client.AddToWishlist(360, "*****@*****.**", 5000); Console.WriteLine("add to wishlist (fail FL) | result: " + AddToWishlistNonExistingFlat); //remove from wish list bool removeFromWishlist = false; removeFromWishlist = client.RemoveFromWishlist(360, 1065); Console.WriteLine("remove from wishlist | result: " + removeFromWishlist); //calculate score (3, 1, 0) int score = 0; score = client.CalculateProfileScore(500, "*****@*****.**"); Console.WriteLine("calculate profile score | result: " + score ); int score = -1; score = client.CalculateApplicationScore(400, "*****@*****.**", 60); Console.WriteLine("Calculate application score() | result: " + score); */ Console.ReadLine(); for(int i = 0; i< 100; i++) { bool registerStudentTest = false; registerStudentTest = client.AddStudent("m"+i, "mypassword", false, false, 0, 0, false, 0, false, DateTime.Now, null, null, null, null, null, null, null); Console.WriteLine("register student | result: " + registerStudentTest.ToString()); } Console.ReadLine(); }