private void AddButton_Click(object sender, RoutedEventArgs e)
{
var newProduct = new AddProductWindow();
if (newProduct.ShowDialog() == true)
{
var product = new Product()
{
ID = IDGenerator.createID("P"),
Name = newProduct.P_Name,
CategoryID = newProduct.P_CategoryID,
Price = newProduct.P_Price,
Weight = newProduct.P_Weight,
isDeleted = false,
Picture = newProduct.P_Picture,
};
MainWindow.db.Products.Add(product);
MainWindow.db.SaveChanges();
productDataGrid.ItemsSource = MainWindow.db.Products.ToList();
}
}
private void ImportButton_Click(object sender, RoutedEventArgs e)
{
var screen = new OpenFileDialog();
screen.Filter = "Excel files|*.xls;*.xlsx";
if (screen.ShowDialog() == true)
{
var workbook = new Workbook(screen.FileName);
//Invoice sheet
var sheet = workbook.Worksheets[0];
var col = "A";
var row = 2;
var cell = sheet.Cells[$"{col}{row}"];
while (cell.Value != null)
{
var id = sheet.Cells[$"A{row}"].StringValue;
var newid = IDGenerator.createID("I");
var customerid = sheet.Cells[$"B{row}"].StringValue;
bool exists = MainWindow.db.Customers.ToList().Any(cus => cus.ID == customerid);
if (exists != true)
{
string message = "The customer with ID \"" + customerid + "\" in invoice #" + id + " does not exist.\nDo you want to add a new customer? You can skip importing this invoice by clicking \"No\".";
if (MessageBox.Show(message, "Warning", MessageBoxButton.YesNo, MessageBoxImage.Warning) == MessageBoxResult.Yes)
{
var newCustomer = new AddCustomerWindow();
if (newCustomer.ShowDialog() == true)
{
if (!string.IsNullOrWhiteSpace(newCustomer.C_Name) && !string.IsNullOrWhiteSpace(newCustomer.C_Telephone) && !string.IsNullOrWhiteSpace(newCustomer.C_Address))
{
var customer = new Customer()
{
ID = customerid,
Name = newCustomer.C_Name,
Telephone = newCustomer.C_Telephone,
Address = newCustomer.C_Address,
isDeleted = false,
};
MainWindow.db.Customers.Add(customer);
MainWindow.db.SaveChanges();
CustomerControl.customer_notification.CustomerChange = true;
var date = sheet.Cells[$"C{row}"].DateTimeValue;
var total = sheet.Cells[$"D{row}"].DoubleValue;
var status = sheet.Cells[$"E{row}"].StringValue;
var newInvoice = new Invoice()
{
ID = newid,
CustomerID = customerid,
Date = date,
Total = total,
Status = status,
isDeleted = false,
};
MainWindow.db.Invoices.Add(newInvoice);
MainWindow.db.SaveChanges();
//Invoice detail sheet
var sheetd = workbook.Worksheets[1];
var cold = "A";
var rowd = 2;
var celld = sheetd.Cells[$"{cold}{rowd}"];
while (celld.Value != null)
{
var invoiceid = sheetd.Cells[$"A{rowd}"].StringValue;
if (invoiceid == id)
{
var productid = sheetd.Cells[$"B{rowd}"].StringValue;
bool existsproduct = MainWindow.db.Products.ToList().Any(cus => cus.ID == productid);
if (existsproduct != true)
{
string messaged = "The product with ID \"" + productid + "\" in invoice #" + id + " does not exist.\nDo you want to add a new product? You can skip importing this product by clicking \"No\".";
if (MessageBox.Show(messaged, "Warning", MessageBoxButton.YesNo, MessageBoxImage.Warning) == MessageBoxResult.Yes)
{
var newProduct = new AddProductWindow();
if (newProduct.ShowDialog() == true)
{
if (!string.IsNullOrWhiteSpace(newProduct.P_Name) && !string.IsNullOrWhiteSpace(newProduct.P_CategoryID) && newProduct.P_Price > 0 && newProduct.P_Weight > 0)
{
var product = new Product()
{
ID = productid,
Name = newProduct.P_Name,
CategoryID = newProduct.P_CategoryID,
Price = newProduct.P_Price,
Weight = newProduct.P_Weight,
isDeleted = false,
Picture = newProduct.P_Picture,
};
MainWindow.db.Products.Add(product);
MainWindow.db.SaveChanges();
//maybe notify changed here?
var weight = sheetd.Cells[$"C{rowd}"].DoubleValue;
var unitprice = sheetd.Cells[$"D{rowd}"].DoubleValue;
var amount = sheetd.Cells[$"E{rowd}"].DoubleValue;
var newInvoiceDetail = new InvoiceDetail()
{
InvoiceID = newid,
ProductID = productid,
Weight = weight,
UnitPrice = unitprice,
Amount = amount,
isDeleted = false,
};
MainWindow.db.InvoiceDetails.Add(newInvoiceDetail);
MainWindow.db.SaveChanges();
}
}
}
}
else
{
var weight = sheetd.Cells[$"C{rowd}"].DoubleValue;
var unitprice = sheetd.Cells[$"D{rowd}"].DoubleValue;
var amount = sheetd.Cells[$"E{rowd}"].DoubleValue;
var newInvoiceDetail = new InvoiceDetail()
{
InvoiceID = newid,
ProductID = productid,
Weight = weight,
UnitPrice = unitprice,
Amount = amount,
isDeleted = false,
};
MainWindow.db.InvoiceDetails.Add(newInvoiceDetail);
MainWindow.db.SaveChanges();
}
}
rowd++;
celld = sheetd.Cells[$"{cold}{rowd}"];
}
}
}
}
}
else
{
var date = sheet.Cells[$"C{row}"].DateTimeValue;
var total = sheet.Cells[$"D{row}"].DoubleValue;
var status = sheet.Cells[$"E{row}"].StringValue;
var newInvoice = new Invoice()
{
ID = newid,
CustomerID = customerid,
Date = date,
Total = total,
Status = status,
isDeleted = false,
};
MainWindow.db.Invoices.Add(newInvoice);
MainWindow.db.SaveChanges();
//Invoice detail sheet
var sheetd = workbook.Worksheets[1];
var cold = "A";
var rowd = 2;
var celld = sheetd.Cells[$"{cold}{rowd}"];
while (celld.Value != null)
{
var invoiceid = sheetd.Cells[$"A{rowd}"].StringValue;
if (invoiceid == id)
{
var productid = sheetd.Cells[$"B{rowd}"].StringValue;
bool existsproduct = MainWindow.db.Products.ToList().Any(cus => cus.ID == productid);
if (existsproduct != true)
{
string messaged = "The product with ID \"" + productid + "\" in invoice #" + id + " does not exist.\nDo you want to add a new product? You can skip importing this product by clicking \"No\".";
if (MessageBox.Show(messaged, "Warning", MessageBoxButton.YesNo, MessageBoxImage.Warning) == MessageBoxResult.Yes)
{
var newProduct = new AddProductWindow();
if (newProduct.ShowDialog() == true)
{
if (!string.IsNullOrWhiteSpace(newProduct.P_Name) && !string.IsNullOrWhiteSpace(newProduct.P_CategoryID) && newProduct.P_Price > 0 && newProduct.P_Weight > 0)
{
var product = new Product()
{
ID = productid,
Name = newProduct.P_Name,
CategoryID = newProduct.P_CategoryID,
Price = newProduct.P_Price,
Weight = newProduct.P_Weight,
isDeleted = false,
Picture = newProduct.P_Picture,
};
MainWindow.db.Products.Add(product);
MainWindow.db.SaveChanges();
//maybe notify changed here?
var weight = sheetd.Cells[$"C{rowd}"].DoubleValue;
var unitprice = sheetd.Cells[$"D{rowd}"].DoubleValue;
var amount = sheetd.Cells[$"E{rowd}"].DoubleValue;
var newInvoiceDetail = new InvoiceDetail()
{
InvoiceID = newid,
ProductID = productid,
Weight = weight,
UnitPrice = unitprice,
Amount = amount,
isDeleted = false,
};
MainWindow.db.InvoiceDetails.Add(newInvoiceDetail);
MainWindow.db.SaveChanges();
}
}
}
}
else
{
var weight = sheetd.Cells[$"C{rowd}"].DoubleValue;
var unitprice = sheetd.Cells[$"D{rowd}"].DoubleValue;
var amount = sheetd.Cells[$"E{rowd}"].DoubleValue;
var newInvoiceDetail = new InvoiceDetail()
{
InvoiceID = newid,
ProductID = productid,
Weight = weight,
UnitPrice = unitprice,
Amount = amount,
isDeleted = false,
};
MainWindow.db.InvoiceDetails.Add(newInvoiceDetail);
MainWindow.db.SaveChanges();
}
}
rowd++;
celld = sheetd.Cells[$"{cold}{rowd}"];
}
}
row++;
cell = sheet.Cells[$"{col}{row}"];
}
MessageBox.Show("Import completed!", "Message");
invoiceDataGrid.ItemsSource = MainWindow.db.Invoices.ToList();
}
}