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