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; }