public void RefreshSalesTeam()
{
using (var context = new WarehouseContext())
{
var salesmans =
from sales_team in context.SalesTeam
orderby sales_team.Name
select sales_team;
Debug.WriteLine("Found sales mans: " + salesmans.Count().ToString());
Salesman.Items.Clear();
foreach (var salesman in salesmans)
{
Salesman.Items.Add(salesman.Name);
}
}
}
public Salesman GetSalesman(WarehouseContext context)
{
if (Salesman.SelectedItem != null)
{
Debug.WriteLine("Selected sales man ID: " + Salesman.SelectedItem);
var name = Salesman.SelectedItem;
var salesman =
from sales_team in context.SalesTeam
where sales_team.Name == name
select sales_team;
if (salesman.Count() == 0)
{
Debug.WriteLine("No salesman found for name: " + name);
return(null);
}
Debug.WriteLine("Found sales man ID: " + salesman.First().Id.ToString());
return(salesman.First());
}
return(null);
}
private void Sale_Click(object sender, EventArgs e)
{
if (ProductList.SelectedItems.Count > 0)
{
var quantity = 0;
if (!Int32.TryParse(SaleQuantity.Text, out quantity))
{
MessageBox.Show("Incorrect Quantity value. Not a number.", "Sale Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
if (quantity <= 0)
{
MessageBox.Show("Incorrect Quantity value. Non positive numebr.", "Sale Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
var item = ProductList.SelectedItems[ProductList.SelectedItems.Count - 1];
var item_id = Int32.Parse(item.SubItems[0].Text);
Debug.WriteLine("Sale of product ID: " + item_id.ToString());
using (var context = new WarehouseContext())
{
var salesman = GetSalesman(context);
if (salesman == null)
{
MessageBox.Show("Please select salesman first.", "Sale Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
var product_to_sale =
from product in context.Products
where product.Id == item_id
select product;
if (product_to_sale.First().AvailableQuantity < quantity)
{
MessageBox.Show("Incorrect Quantity value. Not enough available items left.", "Sale Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
var sale_item = new Sale {
Product = product_to_sale.First(), Quantity = quantity, Salesman = salesman, Date = DateTime.Now
};
context.Sales.Add(sale_item);
product_to_sale.First().AvailableQuantity = product_to_sale.First().AvailableQuantity - quantity;
context.SaveChanges();
}
SaleProductName.Text = "";
SaleQuantity.Text = "";
RefreshSales();
RefreshProducts();
}
else
{
Debug.WriteLine("No product selected");
MessageBox.Show("You must select product.", "Sale Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
}
private void SyncButton_Click(object sender, EventArgs e)
{
using (var context = new WarehouseContext())
{
var sales =
from sale in context.Sales
orderby sale.Id descending
select sale;
foreach (var sale in sales)
{
this.saleTableAdapter.Insert(sale.Product.WarehouseId, sale.Salesman.WarehouseId, sale.Date, sale.Quantity);
context.Sales.Remove(sale);
}
context.SaveChanges();
var products = from product in context.Products select product;
foreach (var product in products)
{
context.Products.Remove(product);
}
context.SaveChanges();
foreach (var product in this.productsSaledProducedAvailableTableAdapter.GetData())
{
Debug.WriteLine(product.ToString());
var localProduct = new Product
{
Name = product.Name,
Price = product.Price,
Description = product.Description,
AvailableQuantity = product.QAvailable,
WarehouseId = product.Id
};
context.Products.Add(localProduct);
}
context.SaveChanges();
var salesmans = from salseman in context.SalesTeam select salseman;
foreach (var salesman in salesmans)
{
context.SalesTeam.Remove(salesman);
}
context.SaveChanges();
foreach (var salesman in this.salesmanTableAdapter.GetData())
{
var localSalesman = new Salesman
{
Name = salesman.Name,
WarehouseId = salesman.Id
};
context.SalesTeam.Add(localSalesman);
}
context.SaveChanges();
}
RefreshSales();
RefreshProducts();
RefreshSalesTeam();
}
public void RefreshSales()
{
using (var context = new WarehouseContext())
{
var selected_salesman = GetSalesman(context);
if (selected_salesman == null)
{
SaleHistory.Items.Clear();
return;
}
Debug.WriteLine("Sales listing obtained");
var sales =
from sale in context.Sales
join product in context.Products on sale.Product.Id equals product.Id
where sale.Salesman.Id == selected_salesman.Id
orderby sale.Id descending
select new
{
Id = sale.Id,
Name = product.Name,
Quantity = sale.Quantity,
Date = sale.Date
};
Debug.WriteLine("Sale history listing obtained");
Debug.WriteLine("Found sales: " + sales.Count().ToString());
SaleHistory.Items.Clear();
foreach (var sale in sales)
{
Debug.WriteLine(sale.Name);
var item = new ListViewItem();
item.Name = "Sale";
item.Tag = sale.Id;
item.Text = sale.Id.ToString();
var subItem = new ListViewItem.ListViewSubItem(item, "Name");
subItem.Name = "Name";
subItem.Text = sale.Name;
item.SubItems.Add(subItem);
subItem = new ListViewItem.ListViewSubItem(item, "Quantity");
subItem.Name = "Quantity";
subItem.Text = sale.Quantity.ToString();
item.SubItems.Add(subItem);
subItem = new ListViewItem.ListViewSubItem(item, "Date");
subItem.Name = "Date";
subItem.Text = sale.Date.ToString();
item.SubItems.Add(subItem);
SaleHistory.Items.Add(item);
}
Debug.WriteLine("Sale listing updated");
}
}