public MainWindow()
{
InitializeComponent();
DataBaseClass.DataBase dataBase = new DataBaseClass.DataBase(DataBaseOption.dataBaseOption);
dataBase.OutputTable(salesDataBase);
typeList.SelectedIndex = 0;
}
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 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;
}
}
}
