private void SubmitEdits_Click(object sender, RoutedEventArgs e) { if (!string.IsNullOrWhiteSpace(EditName.Text) && !string.IsNullOrWhiteSpace(EditDescription.Text) && !string.IsNullOrWhiteSpace(EditPrice.Text) && !string.IsNullOrWhiteSpace(EditQuantity.Text)) { try { connection.Open(); MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "update items set ITEM_NAME=@ItemName,ITEM_PRICE=@ItemPrice,ITEM_DESCRIPTION=@ItemDescription,ITEM_QUANTATY=@ItemQuantity where ITEM_ID=@ItemId"; cmd.Parameters.AddWithValue("@ItemName", EditName.Text); cmd.Parameters.AddWithValue("@ItemPrice", EditPrice.Text); cmd.Parameters.AddWithValue("@ItemDescription", EditDescription.Text); cmd.Parameters.AddWithValue("@ItemQuantity", EditQuantity.Text); cmd.Parameters.AddWithValue("@ItemId", EditId.Text); cmd.Connection = connection; cmd.ExecuteNonQuery(); MySqlCommand Com = new MySqlCommand("Select * from items ", connection); MySqlDataAdapter adp = new MySqlDataAdapter(Com); DataSet ds = new DataSet(); adp.Fill(ds, "LoadDataBinding"); EditDataGrid.DataContext = ds; } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { connection.Close(); MessageBox.Show("Successfully updated", "Success"); EditName.Clear(); EditDescription.Clear(); EditPrice.Clear(); EditQuantity.Clear(); EditId.Clear(); } } else { MessageBox.Show("Cannot Edit Empty Row ", "ERROR"); } }
private void DeleteEdits_Click(object sender, RoutedEventArgs e) { if (!string.IsNullOrWhiteSpace(EditName.Text) && !string.IsNullOrWhiteSpace(EditDescription.Text) && !string.IsNullOrWhiteSpace(EditPrice.Text) && !string.IsNullOrWhiteSpace(EditQuantity.Text)) { MessageBoxResult choice = MessageBox.Show("delete selected item ?", "confirmation", MessageBoxButton.YesNo); if (choice == MessageBoxResult.Yes) { try { connection.Open(); MySqlCommand cmd = new MySqlCommand("delete from items where ITEM_ID='" + int.Parse(EditId.Text) + "'", connection); cmd.ExecuteNonQuery(); MySqlCommand Com = new MySqlCommand("Select * from items ", connection); MySqlDataAdapter adp = new MySqlDataAdapter(Com); DataSet ds = new DataSet(); adp.Fill(ds, "LoadDataBinding"); EditDataGrid.DataContext = ds; } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { connection.Close(); EditId.Clear(); EditName.Clear(); EditQuantity.Clear(); EditPrice.Clear(); EditDescription.Clear(); MessageBox.Show("item deleted", "confirmed"); } } } else { MessageBox.Show("Select a row to delete", "ERROR"); } }
//Edit a Property internal void EditProperty() { Global.ExcelLib.PopulateInCollection(Config.PropertyManagementResource.ExcelPath, "Property"); //Explicit Wait Thread.Sleep(1000); //Click on Owners tab Owners.Click(); //Click Properties option Properties.Click(); // Explicit Wait Thread.Sleep(1000); // Click on the menu menulink.Click(); // Explicit Wait Thread.Sleep(1000); //Click on Edit Button EditBtn.Click(); Thread.Sleep(500); //Modify Property Name EditPropertyName.Clear(); EditPropertyName.SendKeys(Global.ExcelLib.ReadData(2, "PropertyName_Modified")); EditDescription.Clear(); EditDescription.SendKeys(Global.ExcelLib.ReadData(2, "Description_Modified")); Thread.Sleep(1000); EditCar.SendKeys(Global.ExcelLib.ReadData(2, "Car_Modified")); Thread.Sleep(1000); // Approach 1 to upload file ChooseFilesbtn.SendKeys(@"C:\Users\Shahabuddin\Desktop\Rumana\house1_image.png"); Thread.Sleep(1000); /* * //File Upload Approach2: AutoIt- Handles windows that do not belong to browser * FileUploadbtn.Click(); * AutoItX3 AutoIt = new AutoItX3(); * AutoIt.ControlFocus("Open", "", "Edit1"); * Thread.Sleep(2000); * AutoIt.ControlSetText("Open", "", "Edit1", @"C:\Users\Shahabuddin\Desktop\Rumana\Afraz.jpg"); * Thread.Sleep(1000); * AutoIt.ControlClick("Open", "", "Button1"); */ EditSaveBtn.Click(); //Verification //Click on Owners tab Owners.Click(); //Click Properties option Properties.Click(); string msg2 = Global.GlobalDefinition.driver.FindElement(By.XPath("//*[@id='main-content']/section/div[1]/div/div[3]/div/div[1]/div[2]/div[1]/div[1]/a/h3")).Text; string Actmsg2 = Global.ExcelLib.ReadData(2, "EditPropertyVerification"); Thread.Sleep(2000); if (msg2 == Actmsg2) { Thread.Sleep(200); Global.Base.test.Log(LogStatus.Pass, "Test Passed, Record has been updated successfully"); Global.SaveScreenShotClass.SaveScreenshot(Global.GlobalDefinition.driver, "PropertyListEdited"); } else { Thread.Sleep(200); Global.Base.test.Log(LogStatus.Pass, "Test Failed, Record has not updated"); } }