// 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 DataGrid_ItemDetails_SelectionChanged(object sender, SelectionChangedEventArgs e) { if (DataGrid_ItemDetailss.SelectedItem == null) { return; } var selectedDetails = DataGrid_ItemDetailss.SelectedItem as ItemDetailss; TextBox_TransactionId.Text = selectedDetails.TransactionId; TextBox_ItemDescription.Text = selectedDetails.ItemDescription; TextBox_Quantity.Text = Convert.ToString(selectedDetails.ItemQuantity); TextBox_Unit.Text = selectedDetails.ItemUnit; date = selectedDetails.DateAcquired; remarks = selectedDetails.Remarks; TextBox_Price.Text = Convert.ToString(selectedDetails.Price); TextBox_TotalCost.Text = Convert.ToString(selectedDetails.TotalCost); status = statusAdminContent.select; }
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 Button_Clear_Click(object sender, RoutedEventArgs e) { string query; if (status == statusAdminContent.select) { try { query = $@"Update ItemDetailss Set Remarks = '' Where Id = '{TextBox_TransactionId.Text}'"; dc.Connection2(query); query = $@"Delete from RemarksMessage where Id = '{TextBox_TransactionId.Text}' "; dc.Connection2(query); status = statusAdminContent.clear; Loading_User.Visibility = Visibility.Visible; Icon.Kind = MahApps.Metro.IconPacks.PackIconMaterialKind.FormatClear; TextBlock_Message.Text = "Cleared Remarks".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 clear".ToUpper(); } }
private void Button_Update_Click(object sender, RoutedEventArgs e) { dc = new database_connection(); string query; int a; string datee = DateTime.Now.ToString("MM/dd/yyyy"); if (status == statusAdminContent.select) { try { query = $@"Insert Into BeginningInventory([Id] ,[ItemDescription] ,[Quantity] ,[Unit] ,[Price] ,[TotalCost] ,[Monthh] ,[Yearr] ,[DateAcquired]) values ('{TextBox_TransactionId.Text}' ,'{TextBox_ItemDescription.Text}' ,'{TextBox_Quantity.Text}' ,'{TextBox_Unit.Text}' ,'{TextBox_Price.Text}' ,'{TextBox_TotalCost.Text}' ,'{month}' ,'{year}' ,'{datee}')"; dc.Connection2(query); a = int.Parse(TextBox_Quantity.Text) * int.Parse(TextBox_Price.Text); TextBox_TotalCost.Text = a.ToString(); query = $@"Update ItemDetailss Set ItemDescription ='{TextBox_ItemDescription.Text}' ,Quantity = '{TextBox_Quantity.Text}' ,Unit = '{TextBox_Unit.Text}' ,DateAcquired = '{date}' ,Price = '{TextBox_Price.Text}' ,TotalCost = '{TextBox_TotalCost.Text}' ,Remarks = '' Where Id = '{TextBox_TransactionId.Text}'"; dc.Connection2(query); status = statusAdminContent.Update; Loading_User.Visibility = Visibility.Visible; Icon.Kind = MahApps.Metro.IconPacks.PackIconMaterialKind.Update; TextBlock_Message.Text = "Update".ToUpper(); } catch (Exception ex) { Loading_User.Visibility = Visibility.Visible; Icon.Kind = MahApps.Metro.IconPacks.PackIconMaterialKind.MessageAlert; TextBlock_Message.Text = ex.Message.ToUpper(); refresh(); } } else { Loading_User.Visibility = Visibility.Visible; Icon.Kind = MahApps.Metro.IconPacks.PackIconMaterialKind.MessageAlert; TextBlock_Message.Text = "Please Click the Records you want to update".ToUpper(); } }
private async void Button_Save_Click(object sender, RoutedEventArgs e) { DataSet ds; try { if (status == statusAdminContent.Add) { if (TextBox_ItemDescription.Text == "" | TextBox_Quantity.Text == "" | TextBox_Unit.Text == "" | TextBox_Price.Text == "" | int.Parse(TextBox_Price.Text) <= 0 | int.Parse(TextBox_Quantity.Text) <= 0) { Loading_User.Visibility = Visibility.Visible; Icon.Kind = MahApps.Metro.IconPacks.PackIconMaterialKind.AccountCheck; TextBlock_Message.Text = "Complete the Information".ToUpper(); } else { Loading_User.Visibility = Visibility.Visible; Icon.Kind = MahApps.Metro.IconPacks.PackIconMaterialKind.ContentSave; TextBlock_Message.Text = "saved records".ToUpper(); string query; dc = new database_connection(); string s_new_number = await GetNewReferenceNumber(); query = $@" insert into ItemDetailss (Id,ItemDescription ,Quantity ,Unit ,DateAcquired ,Price ,TotalCost ) values('{s_new_number}' ,'{TextBox_ItemDescription.Text}' ,'{TextBox_Quantity.Text}' ,'{TextBox_Unit.Text}' ,'{date}' ,'{TextBox_Price.Text}' ,'{TextBox_TotalCost.Text}' )"; ds = await dc.Connection1Async(query); query = $@"Insert into BeginningInventory (Monthh ,Yearr ,Id ,ItemDescription ,Quantity ,Unit ,Price ,TotalCost ,DateAcquired ) Values ('{month}' ,'{year}' ,'{s_new_number}' ,'{TextBox_ItemDescription.Text}' ,'{TextBox_Quantity.Text}' ,'{TextBox_Unit.Text}' ,'{TextBox_Price.Text}' ,'{TextBox_TotalCost.Text}' ,'{date}') "; dc.Connection2(query); TextBox_TransactionId.Text = s_new_number; status = statusAdminContent.Save; } } else { Loading_User.Visibility = Visibility.Visible; Icon.Kind = MahApps.Metro.IconPacks.PackIconMaterialKind.NewBox; TextBlock_Message.Text = "Please click new button".ToUpper(); } } catch (Exception ex) { Loading_User.Visibility = Visibility.Visible; Icon.Kind = MahApps.Metro.IconPacks.PackIconMaterialKind.Alert; TextBlock_Message.Text = ex.Message.ToUpper(); } }