private void RefreshData()
{
var DBContext = new SimpleWarehousContext();
var result = (from order in DBContext.Orders
join address in DBContext.Adresses
on order.OrderAddressId equals address.AddressId
join company in DBContext.Companies
on order.CompanyId equals company.CompanyId
join status in DBContext.OrderStatus
on order.OrderStatusId equals status.OrderStatusId
join user in DBContext.Users
on order.UserId equals user.UserId
select new
{
order.OrderId,
order.Subotal,
order.AdditionalInformations,
user.UserId,
company.CompanyName,
address.Street,
address.StreetNumber,
address.City,
address.Zipcode,
status.StatusName
}).ToList();
var Orders = DBContext.Orders.ToList();
OrdersGridView.DataSource = result;
OrdersGridView.Columns[0].Visible = false;
//OrdersGridView.Columns[3].Visible = false;
//OrdersGridView.Columns[4].Visible = false;
//OrdersGridView.Columns[5].Visible = false;
//OrdersGridView.Columns[6].Visible = false;
}
private void PopulateIdList()
{
var DBContext = new SimpleWarehousContext();
var users = DBContext.Users.ToList();
UserID.DataSource = users;
var companies = DBContext.Companies.ToList();
CompanyID.DataSource = companies;
var statuses = DBContext.OrderStatus.ToList();
StatusID.DataSource = statuses;
UserID.DisplayMember = "UserId";
UserID.ValueMember = "UserId";
CompanyID.DisplayMember = "CompanyName";
CompanyID.ValueMember = "CompanyId";
StatusID.DisplayMember = "StatusName";
StatusID.ValueMember = "OrderStatusId";
}
private void RefreshData()
{
var DBContext = new SimpleWarehousContext();
var products = DBContext.Produts.ToList();
var result = (from product in DBContext.Produts
join category in DBContext.Categories
on product.CategoryId equals category.CategoryId
select new
{
product.DisplayName,
product.Price,
product.Description,
category.Name
}).ToList();
productsGridView.DataSource = result;
productsGridView.Columns[3].HeaderText = "Category";
productsGridView.Columns[0].HeaderText = "ProductName";
//productsGridView.DataSource = products;
//productsGridView.Columns[0].Visible = false;
//productsGridView.Columns[4].Visible = false;
//var stringlist = new List<String>(); // LISTA STRING DO WYKORZYSTANIA NP W LISTBOXACH
//foreach (var item in products)
//{
// stringlist.Add(item.ProductId + " " + item.DisplayName);
//}
}
private void RefreshData()
{
var DBContext = new SimpleWarehousContext();
var result = (from customer in DBContext.Users
join address in DBContext.Adresses
on customer.AddressId equals address.AddressId
join companyRole in DBContext.CompanyRole
on customer.CompanyRoleId equals companyRole.CompanyRoleId
select new
{
customer.Name,
customer.Surename,
customer.Email,
customer.Phone,
address.Street,
address.StreetNumber,
address.City,
address.Zipcode,
companyRole.RoleName
}).ToList();
CustomerGridView.DataSource = result;
//var Users = DBContext.Users.ToList();
//CustomerGridView.DataSource = Users;
//CustomerGridView.Columns[0].Visible = false;
//CustomerGridView.Columns[6].Visible = false;
//CustomerGridView.Columns[7].Visible = false;
}
private void RefreshData()
{
var DBContext = new SimpleWarehousContext();
var result = (from warehouse in DBContext.Warehouses
join address in DBContext.Adresses
on warehouse.AddressId equals address.AddressId
join company in DBContext.Companies
on warehouse.CompanyId equals company.CompanyId
select new
{
warehouse.WarehouseName,
address.Street,
address.StreetNumber,
address.City,
address.Zipcode,
company.CompanyName
}).ToList();
warehousesGridView.DataSource = result;
//var Warehouses = DBContext.Warehouses.ToList();
//warehousesGridView.DataSource = Warehouses;
//warehousesGridView.Columns[0].Visible = false;
//warehousesGridView.Columns[2].Visible = false;
//warehousesGridView.Columns[3].Visible = false;
}
private void RefreshData()
{
var DBContext = new SimpleWarehousContext();
var Addresses = DBContext.Adresses.ToList();
AddressGridView.DataSource = Addresses;
AddressGridView.Columns[0].Visible = false;
}
private void RefreshData()
{
var DBContext = new SimpleWarehousContext();
var products = DBContext.Produts.ToList();
productsGridView.DataSource = products;
productsGridView.Columns[0].Visible = false;
productsGridView.Columns[4].Visible = false;
}
private void PopulateIdList()
{
var DBContext = new SimpleWarehousContext();
var companies = DBContext.Companies.ToList();
WarehousesAddCompany.DataSource = companies;
WarehousesAddCompany.DisplayMember = "CompanyName";
WarehousesAddCompany.ValueMember = "CompanyId";
}
private void PopulateIdList()
{
var DBContext = new SimpleWarehousContext();
var categories = DBContext.Categories.ToList();
ProductsAddCat.DataSource = categories;
ProductsAddCat.DisplayMember = "Name";
ProductsAddCat.ValueMember = "CategoryId";
}
private void AddCategoryButton_Click(object sender, EventArgs e)
{
var DBContext = new SimpleWarehousContext();
var temp = new Category {
Name = textBox1.Text
};
DBContext.Categories.Add(temp);
DBContext.SaveChanges();
RefreshData();
}
private void AddButton_Click(object sender, EventArgs e)
{
var DBContext = new SimpleWarehousContext();
Address temp = new Address {
Street = StreetBox.Text, StreetNumber = (int)NumberBox.Value, City = CityBox.Text, Zipcode = ZipBox.Text
};
MessageBox.Show("Dodawanie klienta " + (int)NumberBox.Value + " " + StreetBox.Text);
DBContext.Adresses.Add(temp);
DBContext.SaveChanges();
RefreshData();
}
private void ProductsAdd_Click(object sender, EventArgs e)
{
var DBContext = new SimpleWarehousContext();
Category tempCat = (Category)ProductsAddCat.SelectedItem;
Product temp = new Product {
DisplayName = ProductsAddName.Text, Price = (double)ProductsAddPrice.Value, Description = ProductsAddDesc.Text, CategoryId = tempCat.CategoryId
};
MessageBox.Show("Dodawanie produktu " + ProductsAddName.Text);
DBContext.Produts.Add(temp);
DBContext.SaveChanges();
RefreshData();
}
private void AddButton_Click(object sender, EventArgs e)
{
var DBContext = new SimpleWarehousContext();
CompanyRole tempRole = (CompanyRole)CompanyRoleId.SelectedItem;
User temp = new User {
Name = NameBox.Text, Surename = SurnameBox.Text, Phone = PhoneBox.Text, Email = EmailBox.Text, AddressId = AdId, CompanyRoleId = tempRole.CompanyRoleId
};
MessageBox.Show("Dodawanie klienta " + NameBox.Text);
DBContext.Users.Add(temp);
DBContext.SaveChanges();
RefreshData();
}
private void WarehousesAdd_Click(object sender, EventArgs e)
{
var DBContext = new SimpleWarehousContext();
Company tempComp = (Company)WarehousesAddCompany.SelectedItem;
Warehous temp = new Warehous {
WarehouseName = WarehousesAddName.Text, AddressId = AdId, CompanyId = tempComp.CompanyId
};
MessageBox.Show("Dodawanie magazynu " + WarehousesAddName.Text);
DBContext.Warehouses.Add(temp);
DBContext.SaveChanges();
RefreshData();
}
private void ProductsDelete_Click(object sender, EventArgs e)
{
var DBContext = new SimpleWarehousContext();
Product temp = new Product();
foreach (DataGridViewRow row in productsGridView.SelectedRows)
{
MessageBox.Show("USUWANIE: Index " + row.Index.ToString() + " ID: " + row.Cells[0].Value.ToString());
temp.ProductId = (int)row.Cells[0].Value;
DBContext.Produts.Remove(temp);
DBContext.SaveChanges();
}
RefreshData();
}
private void RefreshData()
{
var DBContext = new SimpleWarehousContext();
var categories = DBContext.Categories.ToList();
categoriesGridView.DataSource = categories;
categoriesGridView.Columns[0].Visible = false;
categoriesGridView.Columns[2].Visible = false;
//var stringlist= new List<String>(); // LISTA STRING
//foreach (var item in categories)
//{
// stringlist.Add(item.CategoryId + " " + item.Name);
//}
}
private void DeleteCategoryButton_Click(object sender, EventArgs e)
{
var DBContext = new SimpleWarehousContext();
Category temp = new Category();
foreach (DataGridViewRow row in categoriesGridView.SelectedRows)
{
MessageBox.Show("USUWANIE: Index " + row.Index.ToString() + " ID: " + row.Cells[0].Value.ToString());
temp.CategoryId = (int)row.Cells[0].Value;
DBContext.Categories.Remove(temp);
DBContext.SaveChanges();
}
RefreshData();
}
private void AddButton_Click(object sender, EventArgs e)
{
var DBContext = new SimpleWarehousContext();
User tempUser = (User)UserID.SelectedItem;
Company tempComp = (Company)CompanyID.SelectedItem;
OrderStatus tempStat = (OrderStatus)StatusID.SelectedItem;
Order temp = new Order {
Subotal = SubtotalBox.Value, AdditionalInformations = InfoBox.Text, OrderAddressId = AdId, UserId = tempUser.UserId, CompanyId = tempComp.CompanyId, OrderStatusId = tempStat.OrderStatusId
};
MessageBox.Show("Dodawanie Zamowinia ");
DBContext.Orders.Add(temp);
DBContext.SaveChanges();
RefreshData();
}
private void PopulateIdList()
{
var DBContext = new SimpleWarehousContext();
var roles = DBContext.CompanyRole.ToList();
CompanyRoleId.DataSource = roles;
CompanyRoleId.DisplayMember = "RoleName";
CompanyRoleId.ValueMember = "CompanyRoleId";
CompanyRole temp = new CompanyRole();
temp.CompanyRoleId = -1;
temp.RoleName = "Brak";
CompanyRoleId.SelectedItem = temp;
}
public GenericRepository(SimpleWarehousContext simpleWarehousContext)
{
this.simpleWarehousContext = simpleWarehousContext;
}
public CategoryService(IGenericRepository <Category> genericRepository, SimpleWarehousContext simpleWarehousContext)
{
_genericRepository = genericRepository;
_simpleWarehousContext = simpleWarehousContext;
}