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