private async Task <String> GetNewReferenceNumber() { string query; DataSet ds; DataRow drow; database_connection dc = new database_connection(); query = $@" select s_prefix + right(('0000000000' + convert(varchar(10),d_last_num + 1)),8) ,d_last_num + 1 from ItemId "; ds = await dc.Connection1Async(query); drow = ds.Tables[0].Rows[0]; string new_transaction_number = drow.ItemArray.GetValue(0).ToString(); string d_new_num = drow.ItemArray.GetValue(1).ToString(); query = $@" UPDATE ItemId SET d_last_num = '{d_new_num}' ,IdItem = '{new_transaction_number}' "; dc.Connection2(query); return(new_transaction_number); }
private async void Button_Search_Click(object sender, RoutedEventArgs e) { dc = new database_connection(); DataSet ds; DataRow drow; string query; query = $@"select Id,Firstname,Lastname,Department from UserLogin where Id like'%{TextBox_Search.Text}%' or Firstname like '%{TextBox_Search.Text}%' or Lastname like '%{TextBox_Search.Text}%'"; ds = await dc.Connection1Async(query); int count; count = ds.Tables[0].Rows.Count; removeText(); if (count == 0) { Loading_User.Visibility = Visibility.Visible; Icon.Kind = MahApps.Metro.IconPacks.PackIconMaterialKind.MagnifyMinusOutline; TextBlock_Message.Text = "Search doesn't exist".ToUpper(); } else { drow = ds.Tables[0].Rows[0]; TextBox_Id.Text = drow.ItemArray.GetValue(0).ToString(); TextBox_FirstName.Text = drow.ItemArray.GetValue(1).ToString(); TextBox_LastName.Text = drow.ItemArray.GetValue(2).ToString(); TextBox_Department.Text = drow.ItemArray.GetValue(3).ToString(); } }
async void refresh() { string query; DataSet ds; DataRow drow; dc = new database_connection(); try { query = $@" select RequestorNo ,ItemDescription ,Quantity ,Unit ,CONVERT(VARCHAR(12), DateIssued, 107) AS [Mon DD, YYYY] ,Convert(VARCHAR(12), Timee, 0 ) as output, 0 as style ,IdOfRequestor ,ItemCode from RequestorVieww where IdOfRequestor ='{userId}' "; Loading_User.Visibility = Visibility.Visible; ds = await dc.Connection1Async(query); Loading_User.Visibility = Visibility.Collapsed; int ctr, total; total = ds.Tables[0].Rows.Count; itemselected_source.Clear(); for (ctr = 0; ctr < total; ctr++) { drow = ds.Tables[0].Rows[ctr]; itemselected_source.Add(new LogBook { RequestNo = 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() , Datee = drow.ItemArray.GetValue(4).ToString() , Timee = drow.ItemArray.GetValue(5).ToString() , ItemCode = drow.ItemArray.GetValue(8).ToString() }); } } catch (Exception ex) { Loading_User.Visibility = Visibility.Visible; Icon.Kind = MahApps.Metro.IconPacks.PackIconMaterialKind.MessageAlert; TextBlock_Message.Text = ex.Message.ToUpper(); } }
private async void TextBox_Search_TextChanged(object sender, TextChangedEventArgs 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}%'"; ds = await dc.Connection1Async(query); 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) { MessageBox.Show(ex.Message); } }
async void refresh() { string query; DataSet ds; DataRow drow; database_connection dc = new database_connection(); int ctr, total; try { query = $@"select Id ,ItemDescription ,Quantity ,Unit ,CONVERT(VARCHAR(12), DateAcquired, 107) AS [Mon DD, YYYY] ,Price ,TotalCost ,Remarks from ItemDetailss"; Loading_User.Visibility = Visibility.Visible; ds = await dc.Connection1Async(query); Loading_User.Visibility = Visibility.Collapsed; 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) { MessageBox.Show(ex.Message); } }
private async void Button_Search_Click(object sender, RoutedEventArgs e) { DataSet ds; DataRow drow; database_connection dc = new database_connection(); string query; requestor_source.Clear(); query = $@"select RequestorNo ,NameOfRequestor, IdOfRequestor ,Department ,ItemCode ,ItemDescription ,Quantity ,Unit ,CONVERT(VARCHAR(12), DateIssued, 107) AS [Mon DD, YYYY] ,Convert(VARCHAR(12), Timee, 0 ) as output, 0 as style from RequestorVieww where RequestorNo like '%{TextBox_Search.Text}%'"; Loading_User.Visibility = Visibility.Visible; ds = await dc.Connection1Async(query); Loading_User.Visibility = Visibility.Collapsed; int ctr, total; total = ds.Tables[0].Rows.Count; for (ctr = 0; ctr < total; ctr++) { drow = ds.Tables[0].Rows[ctr]; requestor_source.Add(new Requestor { RequestorNo = drow.ItemArray.GetValue(0).ToString() , NameOfRequestor = drow.ItemArray.GetValue(1).ToString() , IdOfRequestor = drow.ItemArray.GetValue(2).ToString() , Department = drow.ItemArray.GetValue(3).ToString() , ItemCode = drow.ItemArray.GetValue(4).ToString() , ItemDescription = drow.ItemArray.GetValue(5).ToString() , Quantity = drow.ItemArray.GetValue(6).ToString() , Unit = drow.ItemArray.GetValue(7).ToString() , DateIssued = drow.ItemArray.GetValue(8).ToString() , Time = drow.ItemArray.GetValue(9).ToString() }); } }
private void Button_Create_Click(object sender, RoutedEventArgs e) { dc = new database_connection(); string query; if (status == loginStatus.New) { if (TextBox_Id.Text == "" | TextBox_FirstName.Text == "" | TextBox_LastName.Text == "" | TextBox_Department.Text == "" | PasswordBox_Pass.Password == "" | PasswordBox_ConfirmPass.Password == "") { Loading_User.Visibility = Visibility.Visible; Icon.Kind = MahApps.Metro.IconPacks.PackIconMaterialKind.AccountCheck; TextBlock_Message.Text = "Complete the information".ToUpper(); } else { if (PasswordBox_Pass.Password == PasswordBox_ConfirmPass.Password) { try { query = $@"insert into UserLogin(Id,Firstname,Lastname,Pass,Department) values('{TextBox_Id.Text}' ,'{TextBox_FirstName.Text}' ,'{TextBox_LastName.Text}' ,'{PasswordBox_ConfirmPass.Password}' ,'{TextBox_Department.Text}')"; dc.Connection2(query); Loading_User.Visibility = Visibility.Visible; Icon.Kind = MahApps.Metro.IconPacks.PackIconMaterialKind.ContentSave; TextBlock_Message.Text = "save".ToUpper(); status = loginStatus.create; } 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.AccountMultipleOutline; TextBlock_Message.Text = "Confirm the password correctly".ToUpper(); } } } else { Loading_User.Visibility = Visibility.Visible; Icon.Kind = MahApps.Metro.IconPacks.PackIconMaterialKind.NewBox; TextBlock_Message.Text = "please click the new button".ToUpper(); } }
private void Button_Remove_Click(object sender, RoutedEventArgs e) { dc = new database_connection(); string query; query = $@"Delete from IssuanceInventory where GeneratedId = '{generatedId}' "; dc.Connection2(query); Loading_User.Visibility = Visibility.Visible; Icon.Kind = MahApps.Metro.IconPacks.PackIconMaterialKind.DiskAlert; TextBlock_Message.Text = "Removed Records".ToUpper(); refresh(); }
async void refresh() { dc = new database_connection(); DataSet ds; DataRow drow; string query; begin_source.Clear(); query = $@"Select Monthh, Yearr ,Id ,ItemDescription ,Quantity ,Unit ,Price ,TotalCost ,GeneratedId from IssuanceInventory where Monthh = '{ComboBox_Month.Text}' and Yearr = '{ComboBox_Year.Text}'"; Loading_User.Visibility = Visibility.Visible; ds = await dc.Connection1Async(query); Loading_User.Visibility = Visibility.Collapsed; int ctr, total; total = ds.Tables[0].Rows.Count; for (ctr = 0; ctr < total; ctr++) { drow = ds.Tables[0].Rows[ctr]; begin_source.Add(new Begin { Month = drow.ItemArray.GetValue(0).ToString() , Year = drow.ItemArray.GetValue(1).ToString() , ItemCode = drow.ItemArray.GetValue(2).ToString() , ItemDescription = drow.ItemArray.GetValue(3).ToString() , Quantity = drow.ItemArray.GetValue(4).ToString() , Unit = drow.ItemArray.GetValue(5).ToString() , Price = drow.ItemArray.GetValue(6).ToString() , TotalCost = drow.ItemArray.GetValue(7).ToString() , GeneratedId = drow.ItemArray.GetValue(8).ToString() }); } }
async void enter() { database_connection dc = new database_connection(); DataSet ds; string query; try { query = $@"select Id,Pass from AdminLogin where Id='" + TextBox_IdNo.Text + "'and Pass='******'"; Loading_User.Visibility = Visibility.Visible; ds = await dc.Connection1Async(query); Loading_User.Visibility = Visibility.Hidden; int count; count = ds.Tables[0].Rows.Count; if (count > 0) { MainWindow mw = new MainWindow(); success s = new success(); this.Visibility = Visibility.Hidden; AdminContent ac = new AdminContent(); admin_drawhost ad = new admin_drawhost(); foreach (Window window in Application.Current.Windows) { if (window.GetType() == typeof(MainWindow)) { (window as MainWindow).Rectangle_MainContent.Visibility = Visibility.Hidden; (window as MainWindow).Rectangle_MainWindow.Visibility = Visibility.Hidden; (window as MainWindow).Drawer_HostContent.Content = ad; (window as MainWindow).UserContent.Content = ac; } } } else { Loading_UserInform.Visibility = Visibility.Visible; Icon2.Kind = MahApps.Metro.IconPacks.PackIconMaterialKind.MessageAlert; TextBlock_Message2.Text = "The ID No. and Password you've \n entered doesn't match".ToString(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void Button_Remove_Click(object sender, RoutedEventArgs e) { dc = new database_connection(); string query; query = $@"Delete From UserLogin where Id = '{TextBox_Id.Text}'"; dc.Connection2(query); removeText(); status = loginStatus.Delete; Loading_User.Visibility = Visibility.Visible; Icon.Kind = MahApps.Metro.IconPacks.PackIconMaterialKind.DeleteRestore; TextBlock_Message.Text = "Account Removed".ToUpper(); }
private void Button_Update_Click(object sender, RoutedEventArgs e) { dc = new database_connection(); string query; if (TextBox_Id.Text == "" | TextBox_FirstName.Text == "" | TextBox_LastName.Text == "" | TextBox_Department.Text == "" | PasswordBox_Pass.Password == "" | PasswordBox_ConfirmPass.Password == "") { Loading_User.Visibility = Visibility.Visible; Icon.Kind = MahApps.Metro.IconPacks.PackIconMaterialKind.AccountCheck; TextBlock_Message.Text = "Complete the information".ToUpper(); } else { if (PasswordBox_Pass.Password == PasswordBox_ConfirmPass.Password) { try { query = $@"Update UserLogin set Id = '{TextBox_Id.Text}' ,Firstname = '{TextBox_FirstName.Text}' ,Lastname = '{TextBox_LastName.Text}' ,Department = '{TextBox_Department.Text}' ,Pass = '******' where Id = '{TextBox_Id.Text}'"; dc.Connection2(query); status = loginStatus.Update; Loading_User.Visibility = Visibility.Visible; Icon.Kind = MahApps.Metro.IconPacks.PackIconMaterialKind.DeleteRestore; TextBlock_Message.Text = "Update Account".ToUpper(); } catch { Loading_User.Visibility = Visibility.Visible; Icon.Kind = MahApps.Metro.IconPacks.PackIconMaterialKind.MessageAlert; TextBlock_Message.Text = "Invalid Update".ToUpper(); } } else { Loading_User.Visibility = Visibility.Visible; Icon.Kind = MahApps.Metro.IconPacks.PackIconMaterialKind.AccountMultipleOutline; TextBlock_Message.Text = "Confirm the password correctly".ToUpper(); } } }
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_Delete_Click(object sender, RoutedEventArgs e) { if (status == ReqStatus.select) { database_connection dc = new database_connection(); string query; query = $@"Delete From RequestorVieww where RequestorNo='{RequestorNo } '"; dc.Connection2(query); Loading_User.Visibility = Visibility.Visible; Icon.Kind = MahApps.Metro.IconPacks.PackIconMaterialKind.DeleteRestore; TextBlock_Message.Text = "Deleted Records".ToUpper(); status = ReqStatus.delete; refresh(); } else { Loading_User.Visibility = Visibility.Visible; Icon.Kind = MahApps.Metro.IconPacks.PackIconMaterialKind.Message; TextBlock_Message.Text = "Please Click the Records you want to delete".ToUpper(); } }
private async void Button_Search_Click(object sender, RoutedEventArgs e) { string query; DataSet ds; DataRow drow; dc = new database_connection(); try { query = $@" select RequestorNo ,ItemDescription ,Quantity ,Unit ,CONVERT(VARCHAR(12), DateIssued, 107) AS [Mon DD, YYYY] ,Convert(VARCHAR(12), Timee, 0 ) as output, 0 as style ,ItemCode ,IdOfRequestor from RequestorVieww where (RequestorNo like '%{TextBox_Search.Text}%' or ItemDescription like '%{TextBox_Search.Text}%' or ItemCode like '%{TextBox_Search.Text}%' or DateIssued like '%{TextBox_Search.Text}%') and IdOfRequestor like '%{userId}%' "; Loading_User.Visibility = Visibility.Visible; ds = await dc.Connection1Async(query); Loading_User.Visibility = Visibility.Collapsed; int ctr, total; total = ds.Tables[0].Rows.Count; itemselected_source.Clear(); for (ctr = 0; ctr < total; ctr++) { drow = ds.Tables[0].Rows[ctr]; itemselected_source.Add(new LogBook { RequestNo = 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() , Datee = drow.ItemArray.GetValue(4).ToString() , Timee = drow.ItemArray.GetValue(5).ToString() , ItemCode = drow.ItemArray.GetValue(7).ToString() }); } status = userContent.search; } catch (Exception ex) { Loading_User.Visibility = Visibility.Visible; Icon.Kind = MahApps.Metro.IconPacks.PackIconMaterialKind.MessageAlert; TextBlock_Message.Text = ex.Message.ToUpper(); } }
private async void Button_Save_Click_1(object sender, RoutedEventArgs e) { dc = new database_connection(); string query; if (status == userContent.New) { string requestorNo = await GetNewReferenceNumber(); if (ComboBox_ItemDescription.Text == "" | ComboBox_Quantity.Text == "") { Loading_User.Visibility = Visibility.Visible; Icon.Kind = MahApps.Metro.IconPacks.PackIconMaterialKind.AccountCheck; TextBlock_Message.Text = "Complete the Information".ToUpper(); } else { try { a = SubtractQuantity - int.Parse(ComboBox_Quantity.Text); b = a * price; c = int.Parse(ComboBox_Quantity.Text) * price; query = $@"UPDATE ItemDetailss SET Quantity ='{a}', TotalCost = '{b}' WHERE ItemDescription='{ComboBox_ItemDescription.Text}'"; dc.Connection2(query); query = $@"Insert Into RequestorVieww(RequestorNo, NameOfRequestor, IdOfRequestor, Department, ItemCode, ItemDescription, Quantity, Unit, DateIssued, Timee, Price, TotalCost, Monthh, Yearr ) Values('{requestorNo}','{fullName}' ,'{userId}','{department}' ,'{itemCode}','{ComboBox_ItemDescription.Text}' ,'{ComboBox_Quantity.Text}','{unit}' ,'{date}','{time}' ,'{price}','{c}' ,'{month}','{year}')"; dc.Connection2(query); ComboBox_ItemDescription.Text = ""; ComboBox_Quantity.Text = ""; Loading_User.Visibility = Visibility.Visible; Icon.Kind = MahApps.Metro.IconPacks.PackIconMaterialKind.ContentSave; TextBlock_Message.Text = "Request Saved".ToUpper(); status = userContent.Saved; } catch { Loading_User.Visibility = Visibility.Visible; Icon.Kind = MahApps.Metro.IconPacks.PackIconMaterialKind.CartOff; TextBlock_Message.Text = "Out Of Stock".ToUpper(); } } } else { Loading_User.Visibility = Visibility.Visible; Icon.Kind = MahApps.Metro.IconPacks.PackIconMaterialKind.NewBox; TextBlock_Message.Text = "Please click the new record".ToUpper(); } }
private async void UserControl_Loaded(object sender, RoutedEventArgs e) { database_connection dc = new database_connection(); string query; DataSet ds; DataRow drow; int ctr, total; string mess; string dayBool; try { query = $@"Select Remarks from RemarksMessage Group By Remarks "; Loading_User.Visibility = Visibility.Visible; ds = await dc.Connection1Async(query); Loading_User.Visibility = Visibility.Collapsed; total = ds.Tables[0].Rows.Count; for (ctr = 0; ctr < total; ctr++) { drow = ds.Tables[0].Rows[ctr]; mess = drow.ItemArray.GetValue(0).ToString(); MessageBox.Show(mess); // Loading_User.Visibility = Visibility.Visible; // TextBlock_Message.FontSize = 10; //.Kind = MahApps.Metro.IconPacks.PackIconMaterialKind.MessageAlert; // TextBlock_Message.Text = mess.ToUpper(); } if (dayAlert == "01") { query = $@"Select Id,DayBool From MonthlyAlert where Id = '1'"; ds = await dc.Connection1Async(query); drow = ds.Tables[0].Rows[0]; dayBool = drow.ItemArray.GetValue(1).ToString(); if (dayBool == "T") { if (monthAlert == "01") { query = $@"insert IssuanceInventory(Id,ItemDescription,Unit,Monthh,Yearr,Quantity,Price,TotalCost) select Itemcode,ItemDescription,Unit,Monthh,yearr,sum(Quantity),sum(Price),sum(TotalCost) from RequestorVieww group by Itemcode, ItemDescription,Unit ,Monthh,yearr"; ds = await dc.Connection1Async(query); query = $@"insert EndingInventory(Id,ItemDescription,Unit,Quantity,Price,TotalCost,Monthh,Yearr) select Id,ItemDescription,Unit,Quantity,Price,TotalCost,DATEADD(ms,-2,DATEADD(month, DATEDIFF(month, 0, GETDATE()), 0)),Year(GetDate()) -1 from ItemDetailss "; ds = await dc.Connection1Async(query); query = $@"insert BeginningInventory(Id,ItemDescription,Unit,Quantity,Price,TotalCost,Monthh,Yearr) select Id,ItemDescription,Unit,Quantity,Price,TotalCost,DATENAME(month, GETDATE()),Year(GetDate()) from ItemDetailss "; ds = await dc.Connection1Async(query); query = $@"Update MonthlyAlert Set DayBool = 'F' where Id ='1'"; dc.Connection2(query); MessageBox.Show("Monthly Update"); } if (monthAlert != "01") { query = $@"insert IssuanceInventory(Id,ItemDescription,Unit,Monthh,Yearr,Quantity,Price,TotalCost) select Itemcode,ItemDescription,Unit,Monthh,yearr,sum(Quantity),sum(Price),sum(TotalCost) from RequestorVieww group by Itemcode, ItemDescription,Unit ,Monthh,yearr"; ds = await dc.Connection1Async(query); query = $@"insert EndingInventory(Id,ItemDescription,Unit,Quantity,Price,TotalCost,Monthh,Yearr) select Id,ItemDescription,Unit,Quantity,Price,TotalCost,DATEADD(ms,-2,DATEADD(month, DATEDIFF(month, 0, GETDATE()), 0)),Year(GetDate()) from ItemDetailss "; ds = await dc.Connection1Async(query); query = $@"insert BeginningInventory(Id,ItemDescription,Unit,Quantity,Price,TotalCost,Monthh,Yearr,DateAcquired) select Id,ItemDescription,Unit,Quantity,Price,TotalCost,DATENAME(month, GETDATE()),Year(GetDate()),GetDate() from ItemDetailss "; ds = await dc.Connection1Async(query); query = $@"Update MonthlyAlert Set DayBool = 'F' where Id ='1'"; dc.Connection2(query); MessageBox.Show("Monthly Update"); } } } if (dayAlert != "01") { query = $@"Update MonthlyAlert Set DayBool = 'T' where Id ='1'"; dc.Connection2(query); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
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(); } }
async void enter() { database_connection dc = new database_connection(); DataSet ds; DataRow drow; string query; try { query = $@"select Id,Pass,Firstname,Lastname,Department from UserLogin where Id='" + TextBox_IdNo.Text + "'and Pass='******'"; Loading_User.Visibility = Visibility.Visible; ds = await dc.Connection1Async(query); Loading_User.Visibility = Visibility.Hidden; int count; count = ds.Tables[0].Rows.Count; if (count > 0) { drow = ds.Tables[0].Rows[0]; userId = drow.ItemArray.GetValue(0).ToString(); firstName = drow.ItemArray.GetValue(2).ToString(); lastName = drow.ItemArray.GetValue(3).ToString(); department = drow.ItemArray.GetValue(4).ToString(); fullName = firstName + " " + lastName; MainWindow mw = new MainWindow(); success s = new success(); this.Visibility = Visibility.Hidden; user_content uc = new user_content(); user_drawhost us = new user_drawhost(); foreach (Window window in Application.Current.Windows) { if (window.GetType() == typeof(MainWindow)) { (window as MainWindow).Rectangle_MainContent.Visibility = Visibility.Hidden; (window as MainWindow).Rectangle_MainWindow.Visibility = Visibility.Hidden; (window as MainWindow).Drawer_HostContent.Content = us; (window as MainWindow).UserContent.Content = uc; } } } else { Loading_UserInform.Visibility = Visibility.Visible; Icon2.Kind = MahApps.Metro.IconPacks.PackIconMaterialKind.MessageAlert; TextBlock_Message2.Text = "The ID No. and Password you've \n entered doesn't match".ToString(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
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(); } }