void Update() { switch (((ComboBoxItem)_type.SelectedItem).Content.ToString()) { case "По наименованию": table.ItemsSource = DBQueries.GetProductsATT(att).Where(x => x.count > 0).Where(x => x.title.Contains(_find.Text)); break; case "По действующему веществу": table.ItemsSource = DBQueries.GetProductsATT(att).Where(x => x.count > 0).Where(x => x.active.Contains(_find.Text)); break; case "По форме выпуска": table.ItemsSource = DBQueries.GetProductsATT(att).Where(x => x.count > 0).Where(x => x.form.Contains(_find.Text)); break; case "По типу медикамента": table.ItemsSource = DBQueries.GetProductsATT(att).Where(x => x.count > 0).Where(x => x.type.Contains(_find.Text)); break; case "По производителю": table.ItemsSource = DBQueries.GetProductsATT(att).Where(x => x.count > 0).Where(x => x.creator.Contains(_find.Text)); break; default: break; } }
public void AddClick(object sender, EventArgs e) { pop_up_medium pop_up = new pop_up_medium(); pop_up.SetParentForm(memory.GetTaskbarForm()); if (pop_up.GetChoosen()) { if (main.CB_type.SelectedIndex == 0) { Asset asset = new Asset(); asset.Name = main.TF_asset_name.Text; asset.ValueTypeId = 1; asset.StringValue = main.TF_asset_text.Text; asset.Description = main.TF_asset_description.Text; DBQueries.AddNewAsset(asset, AssetType.Text); } else { Asset asset = new Asset(); asset.Name = main.TF_asset_name.Text; asset.ValueTypeId = 4; asset.CredentialUsername = main.TF_asset_text.Text; asset.CredentialPassword = AesCryptography.Pasword.Encrypt(main.TF_asset_password.Text); asset.Description = main.TF_asset_description.Text; DBQueries.AddNewAsset(asset, AssetType.Credential); } new set_panel_changer(memory.GetPanelChanger(), new Assets_Panel().MainPanel); } }
private void search_Box_TextChanged(object sender, EventArgs e) { dbQ = new DBQueries(); ds = new DataSet(); ds = dbQ.SELECT_FROM_TABLE("SELECT Title, Author, Price, Year FROM BookData WHERE Title LIKE '%" + search_Box.Text + "%'"); dataGridView1.AutoGenerateColumns = true; dataGridView1.DataSource = ds.Tables[0]; // dataset DataGridViewColumn column = dataGridView1.Columns[0]; column.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; column.FillWeight = 40; DataGridViewColumn column1 = dataGridView1.Columns[1]; column1.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; column1.FillWeight = 20; DataGridViewColumn column2 = dataGridView1.Columns[2]; column2.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; column2.FillWeight = 10; DataGridViewColumn column3 = dataGridView1.Columns[3]; column3.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; column3.FillWeight = 10; this.dataGridView1.Columns["Price"].DefaultCellStyle.Format = "c"; }
public void TestMethodQuestion2() { String Question = "Testing question input"; try { DBQueries dbQ = new DBQueries(); bool result; bool expectedResult = true; List <object> newstore = new List <object>( new object[] { Question, "chawl113" } ); result = dbQ.INSERT_INTO_TABLE("Questions", newstore); dbQ.DELETE_FROM_TABLE("Delete from Questions Where AskedBy ='chawl113'"); Assert.AreEqual(expectedResult, result); } catch (ArgumentOutOfRangeException ae) { Assert.AreEqual("Question parameter cannot be null or empty.", ae.Message); } }
private void LibHome_Load(object sender, EventArgs e) { bookOrder = new BookOrder(); dbQ = new DBQueries(); ds = new DataSet(); ds = dbQ.SELECT_FROM_TABLE("SELECT Title, Author, Price, Year FROM BookData"); dataGridView1.AutoGenerateColumns = true; dataGridView1.DataSource = ds.Tables[0]; // dataset DataGridViewColumn column = dataGridView1.Columns[0]; column.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; column.FillWeight = 40; DataGridViewColumn column1 = dataGridView1.Columns[1]; column1.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; column1.FillWeight = 20; DataGridViewColumn column2 = dataGridView1.Columns[2]; column2.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; column2.FillWeight = 10; DataGridViewColumn column3 = dataGridView1.Columns[3]; column3.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; column3.FillWeight = 10; this.dataGridView1.Columns["Price"].DefaultCellStyle.Format = "c"; }
private void addMovie_Click(object sender, RoutedEventArgs e) { DBConnect dbcon = new DBConnect(); SqlConnection con = dbcon.Connect(); try { if (con.State == ConnectionState.Closed) { con.Open(); int recordscheck = DBQueries.CheckExistingMovie(con, txt1.Text); if (recordscheck == 0) { DBQueries.AddNewMovie(con, txt1.Text, txt2.Text, txt3.Text, txt4.Text, txt5.Text, txt6.Text); MessageBox.Show("Movie added successfully."); } else { MessageBox.Show("Movie already in the database!"); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { con.Close(); } }
/// <summary> /// Methods used in VM /// </summary> /// // login user // check if provided login exists in db private void LoginUser() { if (Login != null && Password != null) { LoginStatus status = DBQueries.CheckUserExists(Login, Password); switch (status) { case (LoginStatus.Correct): Window Main = new MainWindow(); Application.Current.Windows[0].Close(); Main.Show(); break; case (LoginStatus.NoSuchUser): MessageBox.Show("Incorrect login or password!"); Password = ""; break; } } else { MessageBox.Show("Provide login and password!"); } }
private void btnSubmit_Click(object sender, RoutedEventArgs e) { DBConnect dbcon = new DBConnect(); SqlConnection con = dbcon.Connect(); try { if (con.State == ConnectionState.Closed) { con.Open(); int usercheck = DBQueries.UserLogIn(con, txtUsername.Text, txtPassword.Password); if (usercheck == 1) { MainWindow dashboard = new MainWindow(txtUsername.Text); dashboard.Show(); this.Close(); } else { MessageBox.Show("Username or password is incorrect."); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { con.Close(); } }
private void loginButton_Click(object sender, RoutedEventArgs e) { LoginDialog dlg = new LoginDialog(); dlg.Owner = this; dlg.ShowDialog(); // Process data entered by user if dialog box is accepted if (dlg.DialogResult == true) { if (userData.LogIn(dlg.nameTextBox.Text, dlg.passwordTextBox.Password) == true) { this.logoutButton.Visibility = Visibility.Visible; this.loginButton.Visibility = Visibility.Collapsed; this.statusTextBlock.Text = "You are logged in. Welcome " + userData.FullName; DBQueries dbQ = new DBQueries(); DataSet ds = new DataSet(); String s1 = "Select Manager from UserData Where UserID ='" + userData.UserID + "'"; ds = dbQ.SELECT_FROM_TABLE(s1); Manager = bool.Parse(ds.Tables[0].Rows[0]["Manager"].ToString()); if (Manager) { this.AdminPanelbutton.Visibility = Visibility.Visible; this.AskButton.Visibility = Visibility.Collapsed; } } else { this.statusTextBlock.Text = "Your login failed. Please try again."; } } }
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { DBQueries dbQ = new DBQueries(); DataSet ds = new DataSet(); int selectedComboItem = comboBox1.SelectedIndex + 1; ds = dbQ.SELECT_FROM_TABLE("SELECT Title, Author, Price, Year FROM BookData WHERE CategoryID = '" + selectedComboItem + "'"); dataGridView1.AutoGenerateColumns = true; dataGridView1.DataSource = ds.Tables[0]; // dataset DataGridViewColumn column = dataGridView1.Columns[0]; column.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; column.FillWeight = 40; DataGridViewColumn column1 = dataGridView1.Columns[1]; column1.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; column1.FillWeight = 20; DataGridViewColumn column2 = dataGridView1.Columns[2]; column2.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; column2.FillWeight = 10; DataGridViewColumn column3 = dataGridView1.Columns[3]; column3.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; column3.FillWeight = 10; this.dataGridView1.Columns["Price"].DefaultCellStyle.Format = "c"; }
void attach_model_data() { foreach (var item in DBQueries.QueueItems(id)) { queue_list.Height = queue_list.Height + new queue_item_list2().main_panel.Height; } int count = 0; foreach (var item in DBQueries.QueueItems(id)) { queue_item_list2 queueListItem = new queue_item_list2(); queueListItem.set_data( item.ID, item.StatusID, item.Reference, item.Priority, item.CreationTime.ToString(), item.StartTime.ToString(), item.EndTime.ToString() ); Panel panel = queueListItem.main_panel; panel.Location = new Point(0, panel.Height * count); queue_list.Controls.Add(panel); new size_listener(queue_list, panel, panel.Height, 0); count++; } }
// Use this for initialization void Start() { input_username = GameObject.Find("userName"); input_password = GameObject.Find("userPassword"); query = this.GetComponent <DBQueries>(); session = new Session(); }
private void BookMenu_Load(object sender, EventArgs e) { // TODO: This line of code loads data into the 'booksAgile6DB17DataSet1.Category' table. You can move, or remove it, as needed. this.categoryTableAdapter.Fill(this.booksAgile6DB17DataSet1.Category); bookOrder = new BookOrder(); dbQ = new DBQueries(); ds = new DataSet(); ds = dbQ.SELECT_FROM_TABLE("SELECT Title, Author, Price, Year FROM BookData"); dataGridView1.AutoGenerateColumns = true; dataGridView1.DataSource = ds.Tables[0]; // dataset DataGridViewColumn column = dataGridView1.Columns[0]; column.Width = 800; DataGridViewColumn column1 = dataGridView1.Columns[1]; column1.Width = 357; DataGridViewColumn column2 = dataGridView1.Columns[2]; column2.Width = 150; DataGridViewColumn column3 = dataGridView1.Columns[3]; column3.Width = 150; this.dataGridView1.Columns["Price"].DefaultCellStyle.Format = "c"; }
public void TestMethodTitle() { DBQueries dbQ = new DBQueries(); DataSet ds = new DataSet(); Boolean expectedInsert = false; int isbn = 1234445552; int category = 1; string title = ""; string author = "John Steinbeck"; double price = 12.80; int supplier = 1; int year = 2014; int edition = 2; string publisher = "Wiley"; string description = "Lots of Mice, Not many men"; try { List <object> bookstore = new List <object>( new object[] { isbn, category, title, author, price, supplier, year, edition, publisher, description } ); bool actualInsert = dbQ.INSERT_INTO_TABLE("BookData_Insert", bookstore); Assert.AreEqual(expectedInsert, actualInsert); } catch { Assert.Fail("Exception should've been thrown"); } }
private void btnSignin_Click(object sender, RoutedEventArgs e) { DBConnect dbcon = new DBConnect(); SqlConnection con = dbcon.Connect(); try { if (con.State == ConnectionState.Closed) { con.Open(); int usercheck = DBQueries.CheckExistingUser(con, txtUsername.Text); if (usercheck == 0) { DBQueries.RegisterNewUser(con, txtUsername.Text, txtPassword.Password); MessageBox.Show("You can now log in!"); loginScreen logScreen = new loginScreen(); logScreen.Show(); this.Close(); } else { MessageBox.Show("Login already taken!"); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { con.Close(); } }
public void attach_model_data() { int schedCount = DBQueries.getAllSchedule().Count; int count = 0; panel_schedule_list.Controls.Clear(); foreach (var item in DBQueries.getAllSchedule()) { schedule_list schedule_list = new schedule_list(); schedule_list.set_data( item.id, item.schedule_name, item.robot_name, item.schedule_day, item.schedule_day, item.should_enable, this ); if (count == schedCount - 1) { schedule_list.panel_bottom_border.Visible = true; } Panel panel = schedule_list.main_panel; panel.Width = panel_schedule_list.Width; panel.Location = new Point(0, panel.Height * count); panel_schedule_list.Controls.Add(panel); new size_listener(this.panel_schedule_list, panel, panel.Height, 0); panel_schedule_list.Height = panel_schedule_list.Height + panel.Height; count++; } }
void attach_model_data() { int count = 0; foreach (var item in DBQueries.getAllAssets()) { String image_path; if (item.ValueTypeId.Equals(1)) { image_path = memory.GetAssetsPath() + "\\Image\\folder.png"; } else { image_path = memory.GetAssetsPath() + "\\Image\\lock.png"; } assets_list_ui asset_ui = new assets_list_ui(); asset_ui.set_data( item.ID, item.Name, item.Description, item.StringValue, "", image_path, this, item.ValueTypeId.ToString() ); Panel panel = asset_ui.main_panel; panel.Location = new Point(0, panel.Height * count); list_panel.Controls.Add(panel); new size_listener(list_panel, panel, panel.Height, 0); list_panel.Height = list_panel.Height + panel.Height; count++; } }
public Sell() { InitializeComponent(); table.Items.Clear(); product = DBQueries.GetProductATT(MainWindow.att, MainWindow.product.id); table.Items.Add(product); count.Text = MainWindow.product.sell.ToString(); }
void DirEnum_FileFound(object sender, FileFoundEventArgs e) { FileCount++; workerThread.ReportProgress(1, e.fileInfo); string MD5Hash = Kavitesh.Hashing.MD5Hash.GetMD5HashFromFile(e.fileInfo.FullName); DBQueries.CreateFileEntry(_dbEngine, e.fileInfo, MD5Hash); }
public MainWindow() { sellList = new List <ProductATT>(); InitializeComponent(); _person.Text = DBQueries.GetPerson(person); title_date.Text = "Остатки на " + DateTime.Now.ToLongDateString(); table.ItemsSource = DBQueries.GetProductsATT(att).Where(x => x.count > 0); }
public void FillArityDropDownList(int dbID) { var lst = DBQueries.GetDBArityExists(dbID); comboArity.DataSource = lst; comboArity.ValueMember = "Key"; comboArity.DisplayMember = "Value"; }
public ActionResult DeactivatePDOPharmacist(int id) { DBQueries queryObj = new DBQueries(); string sqlQuery = string.Format(queryObj.sqlDeactivatePDOPharmacist, id, getUserId()); var result = dbCommon.ExcecuteNonQuery(sqlQuery, "PDO"); return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult UpdateResendInvNotif(InvNotifications ResendNotifications) { DBCommon commObj = new DBCommon(); DBQueries dbQueries = new DBQueries(); string query = string.Format(dbQueries.sqlUpdateResendInvoiceNotif, ResendNotifications.PharmacyCode, ResendNotifications.FacilityCode, ResendNotifications.Email, getUserId()); int result = commObj.GetNumwithQuery("UpdateResend", query, getUserId()); return(Json(result, JsonRequestBehavior.AllowGet)); }
public Cheque() { InitializeComponent(); cheque = History.cheque; table.ItemsSource = DBQueries.GetSales(cheque.id); number.Text = $"Чек #{cheque.id}"; total.Text = $"ИТОГО {cheque.sum}"; person.Text = $"Кассир: {cheque.person}"; date.Text = $"Дата: {cheque.date.ToShortDateString()} {cheque.date.ToShortTimeString()}"; }
public ContentResult Get() { db.Connect(); string json = db.ExecuteQuery(DBQueries.GetAllUsers()); var result = new ContentResult() { Content = json, ContentType = "application/json" }; return(result); }
private void Window_Loaded(object sender, EventArgs e) { DataSet ds = new DataSet(); DBQueries dbQ = new DBQueries(); ds = dbQ.SELECT_FROM_TABLE("SELECT * FROM Questions"); ReviewsDataGrid.ItemsSource = ds.Tables[0].DefaultView; ReviewsDataGrid.Columns[0].Width = 50; ReviewsDataGrid.Columns[1].Width = 295; ReviewsDataGrid.Columns[2].Width = 100; }
public void TestMethodAdd() { DBQueries dbQ = new DBQueries(); DataSet ds = new DataSet(); int expectedISBN = 1234445559; int expectedCategoryID = 1; string expectedTitle = "Of Mice and Men"; string expectedAuthor = "John Steinbeck"; double expectedPrice = 12.80; int expectedSupplierID = 1; int expectedYear = 2014; int expectedEdition = 2; string expectedPublisher = "Wiley"; string expectedDescription = "Lots of Mice, Not many men"; List <object> bookstore = new List <object>( new object[] { expectedISBN, expectedCategoryID, expectedTitle, expectedAuthor, expectedPrice, expectedSupplierID, expectedYear, expectedEdition, expectedPublisher, expectedDescription } ); Boolean expectedInsert = true; Boolean expectedDelete = true; Boolean actualInsert = dbQ.INSERT_INTO_TABLE("BookData", bookstore); //Insert method for database Assert.AreEqual(expectedInsert, actualInsert); ds = dbQ.SELECT_FROM_TABLE("SELECT * FROM BookData WHERE ISBN = '" + expectedISBN + "'"); int actualISBN = Int32.Parse(ds.Tables[0].Rows[0]["ISBN"].ToString()); int actualCategoryID = Int32.Parse(ds.Tables[0].Rows[0]["CategoryID"].ToString()); string actualTitle = ds.Tables[0].Rows[0]["Title"].ToString(); string actualAuthor = ds.Tables[0].Rows[0]["Author"].ToString(); double actualPrice = Double.Parse(ds.Tables[0].Rows[0]["Price"].ToString()); int actualSupplierID = Int32.Parse(ds.Tables[0].Rows[0]["SupplierId"].ToString()); int actualYear = Int32.Parse(ds.Tables[0].Rows[0]["Year"].ToString()); int actualEdition = Int32.Parse(ds.Tables[0].Rows[0]["Edition"].ToString()); string actualPublisher = ds.Tables[0].Rows[0]["Publisher"].ToString(); string actualDescription = ds.Tables[0].Rows[0]["Description"].ToString(); Assert.AreEqual(expectedISBN, actualISBN); Assert.AreEqual(expectedCategoryID, actualCategoryID); Assert.AreEqual(expectedTitle, actualTitle); Assert.AreEqual(expectedAuthor, actualAuthor); Assert.AreEqual(expectedPrice, actualPrice); Assert.AreEqual(expectedSupplierID, actualSupplierID); Assert.AreEqual(expectedYear, actualYear); Assert.AreEqual(expectedEdition, actualEdition); Assert.AreEqual(expectedPublisher, actualPublisher); Assert.AreEqual(expectedDescription, actualDescription); Boolean actualDelete = dbQ.DELETE_FROM_TABLE("DELETE FROM BookData WHERE ISBN = '" + expectedISBN + "'"); Assert.AreEqual(expectedDelete, actualDelete); }
// save equipment instance to database // provide feedback to VM // true - successfuly saved equipment // false - equipment already in exists in DB public bool SaveToDatabase() { if (!CheckIfExistsInDatabase()) { DBQueries.EquipmentSaveToDatabase(this); return(true); } else { return(false); } }
private void addReviewButton_Click(object sender, RoutedEventArgs e) { var dlg = new ReviewItem(Isbn); DALReviewItem reviewItem = new DALReviewItem(); dlg.isbnTextBox.Text = Isbn; dlg.titleTextBox.Text = Title; //dlg.Owner = this; DBQueries dbQ = new DBQueries(); DataSet ds = new DataSet(); String s1 = "select t1.OrderID, t1.UserID from Orders " + "t1 INNER JOIN OrderItem t2 ON t1.OrderID = t2.OrderID Where t2.ISBN = '" + Isbn + "' And t1.UserID = '" + UserID + "'"; // ds = dbQ.SELECT_FROM_TABLE("SELECT * FROM BookData WHERE Title = '" + // dataGridView1.SelectedCells[0].Value.ToString() + "'"); ds = dbQ.SELECT_FROM_TABLE(s1); if (ds.Tables[0].Rows.Count > 0) { var orderID = ds.Tables[0].Rows[0]["OrderID"].ToString(); //MessageBox.Show("fetched orderID is" + orderID); //var title = ds.Tables[0].Rows[0]["Title"].ToString(); dlg.orderNoTextBox.Text = orderID; dlg.ShowDialog(); if (dlg.DialogResult == true) { if (reviewItem.Review(Isbn, int.Parse(orderID), int.Parse(dlg.ratingsbutton.Text), dlg.commentsTextBox.Text)) { MessageBox.Show("Your Review Has been submitted."); } else { MessageBox.Show("Your Review could not be added, if you have already reviewed a book you cannot leave another review"); } } } else { MessageBox.Show("You need to purchase a book to be able to review it."); } }
private void Invoices_MouseDoubleClick(object sender, MouseButtonEventArgs e) { invoice = ((InvoiceATT)(ItemsControl.ContainerFromElement((DataGrid)sender, e.OriginalSource as DependencyObject) as DataGridRow).Item); _table.ItemsSource = DBQueries.GetRecords(invoice.id); if (invoice.taken == "Нет") { submit.IsEnabled = true; } else { submit.IsEnabled = false; } }