private void refreshLocations() { currentPerson.Locations = ComplexQueryHelper.GetLocationsForPerson(currentPerson.Email); available = BusinessLayer.Classes.Location.Select().Except(currentPerson.Locations).ToList(); dgvAvailable.DataSource = new AggregatedPropertyBindingList <Location>(available); dgvUsed.DataSource = new AggregatedPropertyBindingList <Location>(currentPerson.Locations); }
private void btnSaveLists_Click(object sender, EventArgs e) { List <Product> itemsToAdd = location.Products.Except(oldCopy.Products).ToList(); List <Product> itemsToDelete = oldCopy.Products.Except(location.Products).ToList(); ComplexQueryHelper.UpdateProductsForLocation(location, itemsToAdd, itemsToDelete); }
private void btnSaveConfig_Click(object sender, EventArgs e) { var diff = component.Configurations.Except(oldCopy.Configurations); ComplexQueryHelper.AddConfigurationsForComponent(component, diff.ToList()); MessageBox.Show("Component configuration updated", "Modification status"); }
private void refetchComponents() { product.Components = ComplexQueryHelper.GetComponentsForProduct(product); dgvUsedComponents.DataSource = new AggregatedPropertyBindingList <Comp>(product.Components); availableComponents = getAvailableComponents(product.Components, Comp.Select()); dgvAvailableComponents.DataSource = new AggregatedPropertyBindingList <Comp>(availableComponents); }
private void dgvProducts_CellClick(object sender, DataGridViewCellEventArgs e) { //Ensure that the click was not on the title cells if (e.RowIndex > -1) { string id = (sender as DataGridView).Rows[e.RowIndex].Cells["Id"].Value.ToString(); Product clickedItem = products.Find(p => p.Id == id); if (clickedItem != null) { frmProductDetails frm = new frmProductDetails(ref location, ref clickedItem); Utils.ShowForm(this, frm, dgvProducts, () => { if (location == null) { products = Product.Select(); } else { products = ComplexQueryHelper.GetProductsForLocation(location); } dgvProducts.DataSource = products; }); } } }
public frmTask() { InitializeComponent(); CenterToScreen(); tasks = ComplexQueryHelper.GetCompleteTaskDetails(); createColumnHeadings(); bindDataGridView(); }
private void btnSaveUsed_Click(object sender, EventArgs e) { List <ProductCategory> newItems = contractType.ProductCategories.Except(oldCopy.ProductCategories).ToList(); List <ProductCategory> deletedItems = oldCopy.ProductCategories.Except(contractType.ProductCategories).ToList(); ComplexQueryHelper.UpdateProductCategoriesForContractType(contractType, newItems, deletedItems); MessageBox.Show("Product Categories updated"); }
public frmSchedule() { InitializeComponent(); CenterToScreen(); createDataGridViewColumns(); employees = ComplexQueryHelper.GetAllTechnicians(); bindFields(); }
private void btnSaveLists_Click(object sender, EventArgs e) { List <Location> itemsToAdd = currentPerson.Locations.Except(oldCopy.Locations).ToList(); List <Location> itemsToDelete = oldCopy.Locations.Except(currentPerson.Locations).ToList(); ComplexQueryHelper.UpdateLocationsForPerson(currentPerson, itemsToAdd, itemsToDelete); MessageBox.Show("Locations Updated", "Modification status", MessageBoxButtons.OK, MessageBoxIcon.Information); }
private void button9_Click(object sender, EventArgs e) { List <Comp> itemsToAdd = product.Components.Except(oldCopy.Components).ToList(); List <Comp> itemsToDelete = oldCopy.Components.Except(product.Components).ToList(); ComplexQueryHelper.UpdateComponentsForProduct(product, itemsToAdd, itemsToDelete); MessageBox.Show("Product Component composition updated", "Modification status"); }
private void button1_Click(object sender, EventArgs e) { IEnumerable <string> brokenRules; string msg = "Invalid input. Please check the Error box"; bool isValid = false; if (newCity) { City c = new City(0, cmbCity.Text); if (c.IsUnique() && c.Validate(out brokenRules)) { c.Insert(); location.Street.City = c; location.Street.FK_CityID = c.Id; } } if (newStreet) { Street s = new Street(0, cmbStreet.Text, txtAreaCode.Text, location.Street.City); s.FK_CityID = location.Street.City.Id; if (s.IsUnique() && s.Validate(out brokenRules)) { s.Insert(); location.Street = s; location.FK_StreetID = s.Id; } } if (location.Validate(out brokenRules)) { isValid = true; if (insert) { //Insert a new location for a person only if the person object has been set if (person != null) { ComplexQueryHelper.InsertLocationForPerson(ref person, location); } else { location.Insert(); } msg = "Location Inserted"; } else { location.Update(); msg = "Location Updated"; } edit = insert = false; toggleControlsEnable(false); } lstError.DataSource = brokenRules.ToList(); MessageBox.Show(msg, "Modification Status", MessageBoxButtons.OK, isValid ? MessageBoxIcon.Information : MessageBoxIcon.Error); }
private void btnManageProducts_Click(object sender, EventArgs e) { List <Product> products = ComplexQueryHelper.GetProductsForLocation(location); frmProduct frm = new frmProduct(); frm.FormClosed += (s, eventArgs) => { Show(); }; frm.Show(); Hide(); }
private void initialise(Schedule schedule, bool insert) { InitializeComponent(); CenterToScreen(); nudCost.Maximum = decimal.MaxValue; nudCost.Minimum = decimal.MinValue; createDataGridColumns(); this.insert = insert; this.schedule = schedule; schedule.DeepCopyInto(ref oldCopy); employees = ComplexQueryHelper.GetAllTechnicians(); tasks = StoredProcedureHelper.GetUnassginedTasksWithContracts(); //If a task has already been assigned and the task is in view mode, add the task to the list of available tasks if (schedule.FK_TaskId != "" && !insert) { tasks.Add(new TaskWithContract("", schedule.Task)); } bindFields(schedule); setFieldsEnable(insert); }
private void btnLogin_Click(object sender, EventArgs e) { if (txtEmail.Text == "" || txtPassword.Text == "") { MessageBox.Show("The email and password fields may not be empy", "Input error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { Employee result = ComplexQueryHelper.ValidLogin(txtEmail.Text, txtPassword.Text); if (result != null) { frmMenu frm = new frmMenu(result); frm.Show(); frm.FormClosed += (s, events) => Show(); Hide(); } else { MessageBox.Show("Invalid credentials", "Invalid login", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void updateLocationsTable() { locations = ComplexQueryHelper.GetLocationsForPerson(lstClients.Text); dgvLocation.DataSource = new AggregatedPropertyBindingList <Location>(locations); }