private void AddWorkerButton_Click(object sender, RoutedEventArgs e)
{
DataBaseClass.DataBase dataBase = new DataBaseClass.DataBase(DataBaseOption.dataBaseOption);
if (CheckFullInfo())
{
bool isExistWorker = dataBase.CheckFullStaff(secondNameTextBox.Text, firstNameTextBox.Text, middleNameTextBox.Text,
staffComboBox.SelectedItem.ToString());
if (isExistWorker)
{
MessageBox.Show("Такой работник уже записан");
}
else
{
dataBase.CreateNewWorker(secondNameTextBox.Text, firstNameTextBox.Text, middleNameTextBox.Text,
staffComboBox.SelectedItem.ToString());
MessageBox.Show("Уcпешно создан");
dataBase.OutputTableStaff(staffTableDataGrid);
}
firstNameTextBox.Clear();
secondNameTextBox.Clear();
middleNameTextBox.Clear();
staffComboBox.SelectedIndex = -1;
}
}
private void AddProductButton_Click(object sender, RoutedEventArgs e)
{
if (CheckFullData())
{
DataBaseClass.DataBase dataBase = new DataBaseClass.DataBase(DataBaseOption.dataBaseOption);
bool isSuccessfulAdd = dataBase.CreateNewTechnic(nameProductTextBox.Text, typeProductTextBox.Text,
priceProductTextBox.Text, nameFabricatorTextBox.Text);
if (isSuccessfulAdd)
{
MessageBox.Show("Товар создан");
dataBase.OutputTableProduct(listProductDataGrid);
nameProductTextBox.Clear();
nameFabricatorTextBox.Clear();
typeProductTextBox.Clear();
priceProductTextBox.Clear();
}
else
{
MessageBox.Show("Такой товар уже существует");
nameProductTextBox.Clear();
nameFabricatorTextBox.Clear();
typeProductTextBox.Clear();
priceProductTextBox.Clear();
}
}
}
public AddProduct()
{
InitializeComponent();
DataBaseClass.DataBase dataBase = new DataBaseClass.DataBase(DataBaseOption.dataBaseOption);
dataBase.OutputTableProduct(listProductDataGrid);
}
public MainWindow()
{
InitializeComponent();
DataBaseClass.DataBase dataBase = new DataBaseClass.DataBase(DataBaseOption.dataBaseOption);
dataBase.OutputTable(salesDataBase);
typeList.SelectedIndex = 0;
}
public AddDiscount()
{
InitializeComponent();
DataBaseClass.DataBase dataBase = new DataBaseClass.DataBase(DataBaseOption.dataBaseOption);
technicComboBox.ItemsSource = dataBase.OutputAllTechnic();
currentDiscountComboBox.ItemsSource = dataBase.OutputAllDiscount();
dataBase.OutputTableDiscount(discountDataGrid);
}
public CreateWorker()
{
InitializeComponent();
DataBaseClass.DataBase dataBase = new DataBaseClass.DataBase(DataBaseOption.dataBaseOption);
dataBase.OutputTableStaff(staffTableDataGrid);
string[] staff = { "Продавец-консультант", "Менеджер", "Кассир" };
staffComboBox.ItemsSource = staff;
}
public addSale(int selectedIndex, DataGrid salesTable)
{
InitializeComponent();
DataBaseClass.DataBase dataBase = new DataBaseClass.DataBase(DataBaseOption.dataBaseOption);
workersListComboBox.ItemsSource = dataBase.GetStaff();
productComboBox.ItemsSource = dataBase.OutputProduct();
this.selectedIndex = selectedIndex;
this.salesTable = salesTable;
}
private void DeleteDiscountButton_Click(object sender, RoutedEventArgs e)
{
if (CheckFullProductDelete())
{
DataBaseClass.DataBase dataBase = new DataBaseClass.DataBase(DataBaseOption.dataBaseOption);
dataBase.DeleteDiscount(currentDiscountComboBox.SelectedItem.ToString());
currentDiscountComboBox.SelectedIndex = -1;
discountDataGrid.Items.Clear();
currentDiscountComboBox.ItemsSource = null;
currentDiscountComboBox.ItemsSource = dataBase.OutputAllDiscount();
dataBase.OutputTableDiscount(discountDataGrid);
MessageBox.Show(" Удаление прошло успешно");
}
}
private void deleteSaleButton_Click(object sender, RoutedEventArgs e)
{
DataBaseClass.DataBase dataBase = new DataBaseClass.DataBase(DataBaseOption.dataBaseOption);
if (CheckFullNumber())
{
if (dataBase.DeleteSale(numberSaleTextBox.Text))
{
MessageBox.Show("Удаление прошло успешно");
dataBase.OutputTable(dataGrid, selectedIndex);
numberSaleTextBox.Clear();
}
else
{
MessageBox.Show("Неверный номер покупки");
numberSaleTextBox.Clear();
}
}
}
private void UpdateSaleButton_Click(object sender, RoutedEventArgs e)
{
DataBaseClass.DataBase dataBase = new DataBaseClass.DataBase(DataBaseOption.dataBaseOption);
if (CheckFullNumber())
{
if (dataBase.UpdateSaleStatus(numberSaleTextBox.Text))
{
MessageBox.Show("Статус изменён");
dataBase.OutputTable(salesTable, selectedIndex);
numberSaleTextBox.Clear();
}
else
{
MessageBox.Show("Невозможно изменить статус");
numberSaleTextBox.Clear();
}
}
}
private void AddDiscountButton_Click(object sender, RoutedEventArgs e)
{
if (CheckFullDiscount())
{
DataBaseClass.DataBase dataBase = new DataBaseClass.DataBase(DataBaseOption.dataBaseOption);
if (dataBase.AddDiscount(technicComboBox.SelectedItem.ToString(), discountTextBox.Text))
{
Tuple <string, int> tuple = new Tuple <string, int>
(technicComboBox.SelectedItem.ToString(), Convert.ToInt32(discountTextBox.Text));
currentDiscountComboBox.SelectedIndex = -1;
discountDataGrid.Items.Clear();
currentDiscountComboBox.ItemsSource = null;
dataBase.OutputTableDiscount(discountDataGrid);
currentDiscountComboBox.ItemsSource = dataBase.OutputAllDiscount();
technicComboBox.SelectedIndex = -1;
discountTextBox.Text = "";
}
else
{
bool isMessageResultAgree = MessageBox.Show
("Скидка на этот товар существует. Изменить существующую скидку?", "Изменнение скидки",
MessageBoxButton.YesNo) == MessageBoxResult.Yes;
if (isMessageResultAgree)
{
dataBase.UpdateDiscount(technicComboBox.SelectedItem.ToString(), discountTextBox.Text);
discountDataGrid.Items.Clear();
dataBase.OutputTableDiscount(discountDataGrid);
}
technicComboBox.SelectedIndex = -1;
discountTextBox.Text = "";
}
}
}
private void DeleteAllDiscountButton_Click(object sender, RoutedEventArgs e)
{
bool isMessageResultAgree = MessageBox.Show
(" Удалить всё?", "Подтверждение операции",
MessageBoxButton.YesNo) == MessageBoxResult.Yes;
if (isMessageResultAgree)
{
DataBaseClass.DataBase dataBase = new DataBaseClass.DataBase(DataBaseOption.dataBaseOption);
dataBase.DeleteDiscount();
currentDiscountComboBox.SelectedIndex = -1;
currentDiscountComboBox.ItemsSource = null;
discountDataGrid.Items.Clear();
currentDiscountComboBox.ItemsSource = dataBase.OutputAllDiscount();
dataBase.OutputTableDiscount(discountDataGrid);
MessageBox.Show(" Удаление прошло успешно");
}
}
private void BackSale_Click(object sender, RoutedEventArgs e)
{
FileClass file = new FileClass();
DataBaseClass.DataBase dataBase = new DataBaseClass.DataBase(DataBaseOption.dataBaseOption);
OpenFileDialog openFile = new OpenFileDialog();
openFile.Title = "Выбрать чек";
openFile.Filter = "Word documents(*.docx)|*.docx";
string saleNumber = string.Empty;
TextFromFile textFromFile = file.GetTextDocWord;
if (openFile.ShowDialog() == true)
{
if (dataBase.IssueRefund(textFromFile(openFile.FileName), ref saleNumber))
{
dataBase.DeleteSale(saleNumber);
MessageBox.Show("Возврат выполнен");
dataBase.OutputTable(salesDataBase, typeList.SelectedIndex);
FileInfo fileInf = new FileInfo(openFile.FileName);
if (fileInf.Exists)
{
fileInf.Delete();
}
}
else
{
MessageBox.Show("Истёк срок");
}
}
}
private void typeList_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
DataBaseClass.DataBase dataBase = new DataBaseClass.DataBase(DataBaseOption.dataBaseOption);
dataBase.OutputTable(salesDataBase, typeList.SelectedIndex);
}
private void addSaleButton_Click(object sender, RoutedEventArgs e)
{
if (deliveryCheckBox.IsChecked == false)
{
if (CheckFullSale())
{
DataBaseClass.DataBase dataBase = new DataBaseClass.DataBase(DataBaseOption.dataBaseOption);
var Tuple = GetWorkerInformation();
dataBase.CreateNewSale(Tuple.Item2, Tuple.Item1, Tuple.Item3, Tuple.Item4,
productComboBox.SelectedItem.ToString());
SaveFileDialog saveFile = new SaveFileDialog();
saveFile.FileName = String.Format("Чек №{0}", dataBase.GetLastSaleNumber());
saveFile.Filter = "DocX document (.docx)|(*.docx)";
MessageBoxResult dialogResult = MessageBox.Show("Сохранить чек?\n(Внимание! Без чека вы не сможете вернуть товар)",
"Сохранение чека", MessageBoxButton.YesNo, MessageBoxImage.Question, MessageBoxResult.Yes);
if (dialogResult == MessageBoxResult.Yes)
{
if (saveFile.ShowDialog() == true)
{
DateTime date = DateTime.Now;
string dateForMySql = date.ToString("yyyy-MM-dd");
string text = String.Format("Номер покупки: {0}\nТовар:\n{1}\nДата покупки: {2}",
dataBase.GetLastSaleNumber(), productComboBox.SelectedItem.ToString(), dateForMySql);
FileClass file = new FileClass();
file.SaveDocWord(saveFile.FileName, text);
}
}
dataBase.OutputTable(salesTable, selectedIndex);
MessageBox.Show("Покупка оформлена");
workersListComboBox.SelectedIndex = -1;
productComboBox.SelectedIndex = -1;
}
}
else
{
// Переменные создаются для того, чтобы подсказки появлись
// сразу и у ComboBox, и у TextBox-ов;
bool checkFullAddress = CheckFullAddress();
bool checkFullSale = CheckFullSale();
if (checkFullAddress && checkFullSale)
{
DataBaseClass.DataBase dataBase = new DataBaseClass.DataBase(DataBaseOption.dataBaseOption);
var tuple = GetWorkerInformation();
dataBase.CreateNewSale(tuple.Item2, tuple.Item1, tuple.Item3, tuple.Item4,
productComboBox.SelectedItem.ToString(), countryTextBox.Text, cityTextBox.Text, streetTextBox.Text);
MessageBoxResult dialogResult = MessageBox.Show("Сохранить чек?\n(Внимание! Без чека вы не сможете вернуть товар)",
"Сохранение чека", MessageBoxButton.YesNo, MessageBoxImage.Question, MessageBoxResult.Yes);
if (dialogResult == MessageBoxResult.Yes)
{
SaveFileDialog saveFile = new SaveFileDialog();
saveFile.FileName = String.Format("Чек №{0}", dataBase.GetLastSaleNumber());
saveFile.Filter = "DocX document (.docx)|(*.docx)";
if (saveFile.ShowDialog() == true)
{
DateTime date = DateTime.Now;
string dateForMySql = date.ToString("yyyy-MM-dd");
string text = String.Format("Номер покупки: {0}\nТовар:\n" +
"{1}\nДата покупки: {2}",
dataBase.GetLastSaleNumber(), productComboBox.SelectedItem.ToString(), dateForMySql);
FileClass file = new FileClass();
file.SaveDocWord(saveFile.FileName, text);
}
}
dataBase.OutputTable(salesTable, selectedIndex);
MessageBox.Show("Покупка оформлена");
workersListComboBox.SelectedIndex = -1;
productComboBox.SelectedIndex = -1;
cityTextBox.Clear();
countryTextBox.Clear();
streetTextBox.Clear();
deliveryCheckBox.IsChecked = false;
}
}
}
