private void Button_Kill_Click(object sender, EventArgs e)
{
KillProcess();
FetchAllProcesses();
AddContentToListBox();
TextBox_Search.Clear();
}
private void TextBox_Search_GotFocus(object sender, RoutedEventArgs e)
{
if (TextBox_Search.Text == "Search File")
{
TextBox_Search.Clear();
}
}
private void Search(object sender, MouseButtonEventArgs e)
{
TextBox_Search.Visibility = Visibility.Visible;
search_image.Visibility = Visibility.Hidden;
TextBox_Search.Text = "";
TextBox_Search.Focus();
}
// private async void Button_Search_Click(object sender, RoutedEventArgs e)
// {
// string query;
// DataSet ds;
// DataRow drow;
// database_connection dc = new database_connection();
// try
// {
// query = $@"select Id,
//ItemDescription
//,Quantity
//,Unit
//,CONVERT(VARCHAR(12), DateAcquired, 107) AS [Mon DD, YYYY]
//,Price
//,TotalCost
//,Remarks
//from ItemDetailss
//where Id like '%{TextBox_Search.Text}%' or ItemDescription like '%{TextBox_Search.Text}%' or Unit like '%{TextBox_Search.Text}%' or DateAcquired like '%{TextBox_Search.Text}%'";
// Loading_User.Visibility = Visibility.Visible;
// ds = await dc.Connection1Async(query);
// Loading_User.Visibility = Visibility.Collapsed;
// int count;
// count = ds.Tables[0].Rows.Count;
// if (count == 0)
// {
// Loading_User.Visibility = Visibility.Visible;
// Icon.Kind = MahApps.Metro.IconPacks.PackIconMaterialKind.AlertCircleOutline;
// TextBlock_Message.Text = "Search does not exists".ToUpper();
// TextBox_TransactionId.Clear();
// TextBox_ItemDescription.Clear();
// TextBox_Quantity.Clear();
// TextBox_Unit.Clear();
// TextBox_Price.Clear();
// TextBox_TotalCost.Clear();
// refresh();
// }
// else
// {
// drow = ds.Tables[0].Rows[0];
// TextBox_TransactionId.Text = drow.ItemArray.GetValue(0).ToString();
// TextBox_ItemDescription.Text = drow.ItemArray.GetValue(1).ToString();
// TextBox_Quantity.Text = drow.ItemArray.GetValue(2).ToString();
// TextBox_Unit.Text = drow.ItemArray.GetValue(3).ToString();
// date = drow.ItemArray.GetValue(4).ToString();
// TextBox_Price.Text = drow.ItemArray.GetValue(5).ToString();
// TextBox_TotalCost.Text = drow.ItemArray.GetValue(6).ToString();
// }
// int ctr, total;
// total = ds.Tables[0].Rows.Count;
// itemdetailss.Clear();
// for (ctr = 0; ctr < total; ctr++)
// {
// drow = ds.Tables[0].Rows[ctr];
// itemdetailss.Add(new ItemDetailss
// {
// TransactionId = drow.ItemArray.GetValue(0).ToString()
// ,
// ItemDescription = drow.ItemArray.GetValue(1).ToString()
// ,
// ItemQuantity = int.Parse(drow.ItemArray.GetValue(2).ToString())
// ,
// ItemUnit = drow.ItemArray.GetValue(3).ToString()
// ,
// DateAcquired = drow.ItemArray.GetValue(4).ToString()
// ,
// Price = double.Parse(drow.ItemArray.GetValue(5).ToString())
// ,
// TotalCost = double.Parse(drow.ItemArray.GetValue(6).ToString())
// ,
// Remarks = drow.ItemArray.GetValue(7).ToString()
// });
// }
// }
// catch (Exception ex)
// {
// Loading_User.Visibility = Visibility.Visible;
// Icon.Kind = MahApps.Metro.IconPacks.PackIconMaterialKind.MessageAlert;
// TextBlock_Message.Text = ex.Message.ToUpper();
// }
// }
private void Button_Add_Click(object sender, RoutedEventArgs e)
{
TextBox_TransactionId.Clear();
TextBox_ItemDescription.Clear();
TextBox_Price.Clear();
TextBox_Quantity.Clear();
TextBox_Search.Clear();
TextBox_Unit.Clear();
TextBox_TotalCost.Clear();
status = statusAdminContent.Add;
}
private void Button_Add_Click_1(object sender, RoutedEventArgs e)
{
ComboBox_Quantity.Text = "";
TextBox_Search.Clear();
ComboBox_ItemDescription.Text = "";
ComboBox_Quantity.Items.Clear();
itemselected_source.Clear();
status = userContent.New;
refresh();
}
private void ComboBox_DropDownClosed(object sender, EventArgs e)
{
TextBox_Search.TextChanged -= TextBox_Search_TextChanged;
selectedPerson = (Person)ComboBox.SelectedItem;
if (selectedPerson != null)
{
if (PersonSelected != null)
{
PersonSelected(selectedPerson);
}
int age = DateTime.Now.Subtract(selectedPerson.DateOfBirth.GetValueOrDefault()).Days / 360;
TextBox_Search.Text = $"{selectedPerson.Name} {selectedPerson.LastName}".Trim();
}
TextBox_Search.TextChanged += TextBox_Search_TextChanged;
TextBox_Search.Focus();
}
private void TextBox_Search_TextChanged(object sender, TextChangedEventArgs e)
{
var searchWords = TextBox_Search.Text.Split(' ').ToList();
List <Person> filteredPeople = new List <Person>(people);
foreach (var word in searchWords)
{
filteredPeople = filteredPeople.Where(p => $"{p.Name} {p.LastName}".ToLower().Contains(word.ToLower())).ToList();
}
if (e.Changes.ElementAt(0).AddedLength > 0)
{
}
ComboBox.IsDropDownOpen = true;
ComboBox.ItemsSource = filteredPeople;
TextBox_Search.Focus();
}
private void Button_Delete_Click(object sender, RoutedEventArgs e)
{
dc = new database_connection();
if (status == statusAdminContent.select)
{
string query;
try
{
query = $@"Delete from ItemDetailss Where Id='{ TextBox_TransactionId.Text} ' ";
dc.Connection2(query);
query = $@"Delete from RemarksMessage where Id='{TextBox_TransactionId.Text}'";
dc.Connection2(query);
TextBox_TransactionId.Clear();
TextBox_ItemDescription.Clear();
TextBox_Price.Clear();
TextBox_Quantity.Clear();
TextBox_Search.Clear();
TextBox_Unit.Clear();
TextBox_TotalCost.Clear();
status = statusAdminContent.delete;
Loading_User.Visibility = Visibility.Visible;
Icon.Kind = MahApps.Metro.IconPacks.PackIconMaterialKind.DeleteRestore;
TextBlock_Message.Text = "deleted Records".ToUpper();
}
catch (Exception ex)
{
Loading_User.Visibility = Visibility.Visible;
Icon.Kind = MahApps.Metro.IconPacks.PackIconMaterialKind.MessageAlert;
TextBlock_Message.Text = ex.Message.ToUpper();
}
}
else
{
Loading_User.Visibility = Visibility.Visible;
Icon.Kind = MahApps.Metro.IconPacks.PackIconMaterialKind.MessageAlert;
TextBlock_Message.Text = "Please Click the Records you want to delete".ToUpper();
}
}
private void SearchDialog_Load(object sender, EventArgs e)
{
TextBox_Search.Focus();
}
private void ComboBox_DropDownOpened(object sender, EventArgs e)
{
TextBox_Search.Focus();
}
