private void toolBar_btnCancel_Click(object sender) { PurchaseTenderDB.CancelAllChanges(); purchase_tender purchase_tender_old = (purchase_tender)purchase_tenderDataGrid.SelectedItem; purchase_tender_old.State = EntityState.Unchanged; }
public void Item_Select(object sender, EventArgs e) { purchase_tender purchase_tender = purchase_tenderViewSource.View.CurrentItem as purchase_tender; if (purchase_tender != null) { item item = PurchaseTenderDB.items.Where(x => x.id_item == sbxItem.ItemID).FirstOrDefault(); if (item != null) { //Checks if product exists. if (purchase_tender.purchase_tender_item_detail.Where(x => x.id_item == item.id_item).Count() == 0) { purchase_tender_item purchase_tender_item = new purchase_tender_item(); purchase_tender_item.item = item; purchase_tender_item.id_item = item.id_item; purchase_tender_item.item_description = item.name; purchase_tender_item.quantity = 1; foreach (item_dimension item_dimension in item.item_dimension) { purchase_tender_dimension purchase_tender_dimension = new purchase_tender_dimension(); purchase_tender_dimension.purchase_tender_item = purchase_tender_item; purchase_tender_dimension.id_dimension = item_dimension.id_app_dimension; purchase_tender_dimension.id_measurement = item_dimension.id_measurement; if (PurchaseTenderDB.app_dimension.Where(x => x.id_dimension == item_dimension.id_app_dimension).FirstOrDefault() != null) { purchase_tender_dimension.app_dimension = PurchaseTenderDB.app_dimension.Where(x => x.id_dimension == item_dimension.id_app_dimension).FirstOrDefault(); } purchase_tender_dimension.app_measurement = item_dimension.app_measurement; purchase_tender_dimension.value = item_dimension.value; purchase_tender_item.purchase_tender_dimension.Add(purchase_tender_dimension); } purchase_tender.purchase_tender_item_detail.Add(purchase_tender_item); } else { toolBar.msgWarning("Product Exists"); } } else { if (sbxItem.Text != string.Empty) { purchase_tender_item purchase_tender_item = new purchase_tender_item(); purchase_tender_item.item_description = sbxItem.Text; purchase_tender_item.quantity = 1; purchase_tender.purchase_tender_item_detail.Add(purchase_tender_item); } } purchase_tenderViewSource.View.Refresh(); purchase_tenderpurchase_tender_itemViewSource.View.Refresh(); } }
private void Button_Click(object sender, RoutedEventArgs e) { try { project objProject = project_ViewSource.View.CurrentItem as project; if (objProject != null) { using (db dbTender = new db()) { int idProject = objProject.id_project; purchase_tender purchase_tender = new purchase_tender(); if (idProject > 0) { purchase_tender.id_project = idProject; } purchase_tender.name = txtName.Text; //purchase_tender.code = Convert.ToInt16(txtCode.Text); purchase_tender.comment = txtComment.Text; purchase_tender_contact purchase_tender_contact = new purchase_tender_contact(); purchase_tender_contact.id_contact = Convert.ToInt32(objProject.id_contact); purchase_tender_contact.id_contract = Convert.ToInt32(cbxContract.SelectedValue); purchase_tender_contact.id_condition = Convert.ToInt32(cbxCondition.SelectedValue); purchase_tender_contact.id_currencyfx = Convert.ToInt32(cbxCurrency.SelectedValue); purchase_tender.purchase_tender_contact_detail.Add(purchase_tender_contact); int id = ((project)projectDataGrid.SelectedItem).id_project; // List<project_task> productlist = entity.db.project_task.Where(x => x.id_project == id && x.items.id_item_type != item.item_type.Task && x.selected == true).ToList(); foreach (project_task data in Project_task) { purchase_tender_item purchase_tender_item = new purchase_tender_item(); //purchase_tender_item.id_cost_center = dbTender.app_cost_center.Where(a => a.id_company == _Setting.company_ID && a.is_active == true && a.is_administrative == true).FirstOrDefault().id_cost_center; int idItem = data.items.id_item; purchase_tender_item.id_item = idItem; purchase_tender_item.item_description = dbTender.items.Where(a => a.id_item == idItem).FirstOrDefault().name; purchase_tender_item.quantity = (decimal)data.quantity_est; purchase_tender.purchase_tender_item_detail.Add(purchase_tender_item); } dbTender.purchase_tender.Add(purchase_tender); dbTender.SaveChanges(); //dbTender.Entry(purchase_tender).State = EntityState.Detached; //entity.db.purchase_tender.Attach(purchase_tender); } lblCancel_MouseDown(null, null); } else { MessageBox.Show("Error in getting Project details.", "Cognitivo", MessageBoxButton.OK, MessageBoxImage.Error); } } catch { } }
private void Hyperlink_PreviewMouseUp(object sender, MouseButtonEventArgs e) { purchase_tender purchase_tender = purchase_tenderViewSource.View.CurrentItem as purchase_tender; foreach (purchase_tender_item purchase_tender_item_detail in purchase_tender.purchase_tender_item_detail) { purchase_tender_item_detail.Quantity_Factored = entity.Brillo.ConversionFactor.Factor_Quantity(purchase_tender_item_detail.item, purchase_tender_item_detail.quantity, purchase_tender_item_detail.GetDimensionValue()); purchase_tender_item_detail.RaisePropertyChanged("Quantity_Factored"); } }
private void toolBar_btnNew_Click(object sender) { TenderSetting _pref_PurchaseTender = new TenderSetting(); purchase_tender purchase_tender = new purchase_tender(); purchase_tender.State = EntityState.Added; purchase_tender.IsSelected = true; purchase_tender.trans_date = DateTime.Now.AddDays(_pref_PurchaseTender.TransDate_OffSet); PurchaseTenderDB.Entry(purchase_tender).State = EntityState.Added; purchase_tenderViewSource.View.MoveCurrentToLast(); }
private void toolBar_btnEdit_Click(object sender) { if (purchase_tenderDataGrid.SelectedItem != null) { purchase_tender purchase_tender_old = (purchase_tender)purchase_tenderDataGrid.SelectedItem; purchase_tender_old.IsSelected = true; purchase_tender_old.State = EntityState.Modified; PurchaseTenderDB.Entry(purchase_tender_old).State = EntityState.Modified; } else { toolBar.msgWarning("Please Select an Item"); } }
private void toolBar_btnDelete_Click(object sender) { try { if (MessageBox.Show("Are you sure want to Delete?", "Cognitivo", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes) { purchase_tender purchase_tender = (purchase_tender)purchase_tenderDataGrid.SelectedItem; purchase_tender.is_head = false; purchase_tender.State = EntityState.Deleted; purchase_tender.IsSelected = true; } } catch (Exception ex) { toolBar.msgError(ex); } }
private void UserControl_Loaded(object sender, RoutedEventArgs e) { if (!System.ComponentModel.DesignerProperties.GetIsInDesignMode(this)) { try { CollectionViewSource app_dimensionViewSource = ((CollectionViewSource)(FindResource("app_dimensionViewSource"))); ProjectTaskDB.app_dimension.Where(a => a.id_company == CurrentSession.Id_Company).Load(); app_dimensionViewSource.Source = ProjectTaskDB.app_dimension.Local; CollectionViewSource app_measurementViewSource = ((CollectionViewSource)(FindResource("app_measurementViewSource"))); ProjectTaskDB.app_measurement.Where(a => a.id_company == CurrentSession.Id_Company).Load(); app_measurementViewSource.Source = ProjectTaskDB.app_measurement.Local; cmbtask.ItemsSource = project_taskList; purchase_tender purchase_tender = new purchase_tender(); purchase_tender.status = Status.Documents_General.Pending; purchase_tender.name = project_taskList.FirstOrDefault().project.name; purchase_tender.code = 000; purchase_tender.trans_date = DateTime.Now; foreach (project_task project_task in project_taskList) { if (project_task.project.id_branch != null) { purchase_tender.app_branch = ProjectTaskDB.app_branch.Where(x => x.id_branch == project_task.project.id_branch).FirstOrDefault(); } else { purchase_tender.app_branch = ProjectTaskDB.app_branch.Where(x => x.can_invoice == true && x.can_stock == true).FirstOrDefault(); } if (purchase_tender.purchase_tender_item_detail.Where(x => x.id_item == project_task.id_item).Count() == 0) { purchase_tender.id_project = project_task.id_project; purchase_tender_item purchase_tender_item = new purchase_tender_item(); purchase_tender_item.id_item = project_task.id_item; purchase_tender_item.id_project_task = project_task.id_project_task; purchase_tender_item.item_description = project_task.item_description; purchase_tender_item.quantity = (decimal)project_task.quantity_est; foreach (project_task_dimension project_task_dimension in project_task.project_task_dimension) { purchase_tender_dimension purchase_tender_dimension = new purchase_tender_dimension(); purchase_tender_dimension.id_dimension = project_task_dimension.id_dimension; purchase_tender_dimension.id_measurement = project_task_dimension.id_measurement; purchase_tender_dimension.value = 0; purchase_tender_item.purchase_tender_dimension.Add(purchase_tender_dimension); } purchase_tender.purchase_tender_item_detail.Add(purchase_tender_item); } else { purchase_tender_item purchase_tender_item = purchase_tender.purchase_tender_item_detail.Where(x => x.id_item == project_task.id_item).FirstOrDefault(); purchase_tender_item.quantity = purchase_tender_item.quantity + (decimal)project_task.quantity_est; } } ProjectTaskDB.purchase_tender.Add(purchase_tender); CollectionViewSource purchase_tender_itemViewSource = (CollectionViewSource)this.FindResource("purchase_tender_itemViewSource"); ProjectTaskDB.purchase_tender_item_detail.Load(); purchase_tender_itemViewSource.Source = ProjectTaskDB.purchase_tender_item_detail.Local; if (purchase_tender_itemViewSource != null) { if (purchase_tender_itemViewSource.View != null) { purchase_tender_itemViewSource.View.Filter = i => { purchase_tender_item purchase_tender_item = (purchase_tender_item)i; if (purchase_tender_item.id_purchase_tender_item == 0) { return(true); } else { return(false); } }; } } } catch (Exception ex) { throw ex; } } }
private void btnRequestResource_Click(object sender, EventArgs e) { if (project_taskViewSource.Source != null) { if (tabraw.IsSelected) { List <project_task> productlist = ProjectTaskDB.project_task.ToList(); productlist = productlist.Where(x => x.IsSelected == true).ToList(); if (ProjectTaskDB.project_task.Local.Where(x => x.IsSelected == true).Count() > 0) { PurchaseTender = new cntrl.Curd.PurchaseTender(); crud_modal.Visibility = Visibility.Visible; PurchaseTender.ProjectTaskDB = ProjectTaskDB; PurchaseTender.project_taskList = productlist; crud_modal.Children.Add(PurchaseTender); } else { toolBar.msgWarning("Select a Task"); } } else { project project = ((project)projectViewSource.View.CurrentItem); int id_project = ((project)projectViewSource.View.CurrentItem).id_project; List <project_task> productlist = ProjectTaskDB.project_task.ToList(); productlist = productlist.Where(x => x.IsSelected == true).ToList(); purchase_tender purchase_tender = new purchase_tender(); purchase_tender.status = Status.Documents_General.Pending; purchase_tender.name = project.name; purchase_tender.code = 000; purchase_tender.trans_date = DateTime.Now; foreach (project_task project_task in productlist) { if (project.id_branch != null) { purchase_tender.app_branch = ProjectTaskDB.app_branch.Where(x => x.id_branch == project.id_branch).FirstOrDefault(); } else { purchase_tender.app_branch = ProjectTaskDB.app_branch.Where(x => x.can_invoice == true && x.can_stock == true).FirstOrDefault(); } purchase_tender.id_project = project_task.id_project; purchase_tender_item purchase_tender_item = new purchase_tender_item(); purchase_tender_item.id_item = project_task.id_item; purchase_tender_item.id_project_task = project_task.id_project_task; purchase_tender_item.item_description = project_task.item_description; purchase_tender_item.quantity = (decimal)project_task.quantity_est; foreach (project_task_dimension project_task_dimension in project_task.project_task_dimension) { purchase_tender_dimension purchase_tender_dimension = new purchase_tender_dimension(); purchase_tender_dimension.id_dimension = project_task_dimension.id_dimension; purchase_tender_dimension.id_measurement = project_task_dimension.id_measurement; purchase_tender_dimension.value = project_task_dimension.value; purchase_tender_item.purchase_tender_dimension.Add(purchase_tender_dimension); } purchase_tender.purchase_tender_item_detail.Add(purchase_tender_item); } ProjectTaskDB.purchase_tender.Add(purchase_tender); if (ProjectTaskDB.SaveChanges() > 0) { toolBar.msgSaved(ProjectTaskDB.NumberOfRecords); } } } }
private void set_ContactPref(object sender, RoutedEventArgs e) { if (sbxContact.ContactID > 0) { //Get Contact from SmartBox. contact contact = PurchaseTenderDB.contacts.Where(x => x.id_contact == sbxContact.ContactID).FirstOrDefault(); if (contact == null) { toolBar.msgWarning("Please select Contact"); return; } if (purchase_tenderViewSource.View != null) { purchase_tender purchase_tender = purchase_tenderViewSource.View.CurrentItem as purchase_tender; purchase_tender_contact purchase_tender_contact = new purchase_tender_contact(); if (cbxContract.SelectedItem != null) { purchase_tender_contact.id_contract = (cbxContract.SelectedItem as app_contract).id_contract; purchase_tender_contact.id_condition = (cbxCondition.SelectedItem as app_condition).id_condition; purchase_tender_contact.app_contract = PurchaseTenderDB.app_contract.Where(x => x.id_contract == purchase_tender_contact.id_contract).FirstOrDefault(); purchase_tender_contact.app_condition = PurchaseTenderDB.app_condition.Where(x => x.id_condition == purchase_tender_contact.id_condition).FirstOrDefault();; } else if (contact.app_contract != null) { purchase_tender_contact.id_contract = (int)contact.id_contract; purchase_tender_contact.id_condition = contact.app_contract.id_condition; purchase_tender_contact.app_contract = PurchaseTenderDB.app_contract.Where(x => x.id_contract == purchase_tender_contact.id_contract).FirstOrDefault(); purchase_tender_contact.app_condition = PurchaseTenderDB.app_condition.Where(x => x.id_condition == purchase_tender_contact.id_condition).FirstOrDefault(); } else { toolBar.msgWarning("Please select Contract..."); return; } purchase_tender_contact.contact = contact; purchase_tender_contact.id_contact = contact.id_contact; if (purchase_tender_contact.contact.id_currency == 0 || purchase_tender_contact.contact.id_currency == null) { //Contact does not have Currency, take default currency from Company. if (CurrentSession.CurrencyFX_Default != null) { purchase_tender_contact.id_currencyfx = CurrentSession.CurrencyFX_Default.id_currencyfx; } } else { //Contact has Currency, take FX Rate of Currency. app_currencyfx app_currencyfx = PurchaseTenderDB.app_currencyfx.Where(x => x.app_currency.id_currency == purchase_tender_contact.contact.id_currency && x.is_active).FirstOrDefault(); if (app_currencyfx != null) { purchase_tender_contact.id_currencyfx = app_currencyfx.id_currencyfx; } } if (contact.lead_time != null) { purchase_tender_contact.recieve_date_est = DateTime.Now.AddDays((double)contact.lead_time); } if (purchase_tender != null) { List <purchase_tender_item> listtender = purchase_tender.purchase_tender_item_detail.ToList(); foreach (purchase_tender_item purchase_tender_item in listtender) { if (purchase_tender_contact.id_purchase_tender_contact == 0) { if (purchase_tender_contact.purchase_tender_detail.Where(x => x.purchase_tender_item.id_item == purchase_tender_item.id_item).Count() == 0) { purchase_tender_detail purchase_tender_detail = new purchase_tender_detail(); purchase_tender_detail.id_purchase_tender_item = purchase_tender_item.id_purchase_tender_item; purchase_tender_detail.purchase_tender_item = purchase_tender_item; purchase_tender_detail.quantity = purchase_tender_item.quantity; purchase_tender_detail.unit_cost = 0; purchase_tender_detail.id_vat_group = PurchaseTenderDB.app_vat_group.Where(x => x.is_default).FirstOrDefault().id_vat_group; foreach (purchase_tender_dimension purchase_tender_dimension in purchase_tender_item.purchase_tender_dimension) { purchase_tender_detail_dimension purchase_tender_detail_dimension = new purchase_tender_detail_dimension(); purchase_tender_detail_dimension.purchase_tender_detail = purchase_tender_detail; purchase_tender_detail_dimension.id_dimension = purchase_tender_dimension.id_dimension; purchase_tender_detail_dimension.app_dimension = purchase_tender_dimension.app_dimension; purchase_tender_detail_dimension.id_measurement = purchase_tender_dimension.id_measurement; purchase_tender_detail_dimension.app_measurement = purchase_tender_dimension.app_measurement; purchase_tender_detail_dimension.value = purchase_tender_dimension.value; purchase_tender_detail.purchase_tender_detail_dimension.Add(purchase_tender_detail_dimension); } purchase_tender_contact.purchase_tender_detail.Add(purchase_tender_detail); } else { purchase_tender_detail purchase_tender_detail = purchase_tender_contact.purchase_tender_detail.Where(x => x.purchase_tender_item.id_item == purchase_tender_item.id_item).FirstOrDefault(); purchase_tender_detail.quantity = purchase_tender_detail.quantity + 1; } } else { if (PurchaseTenderDB.purchase_tender_detail.Where(x => x.id_purchase_tender_contact == purchase_tender_contact.id_purchase_tender_contact && x.id_purchase_tender_item == purchase_tender_item.id_purchase_tender_item) == null) { purchase_tender_detail purchase_tender_detail = new purchase_tender_detail(); purchase_tender_detail.id_purchase_tender_item = purchase_tender_item.id_purchase_tender_item; purchase_tender_detail.purchase_tender_item = purchase_tender_item; purchase_tender_detail.quantity = 1; purchase_tender_detail.id_vat_group = PurchaseTenderDB.app_vat_group.Where(x => x.is_default).FirstOrDefault().id_vat_group; purchase_tender_detail.unit_cost = 0; purchase_tender_contact.purchase_tender_detail.Add(purchase_tender_detail); } else { purchase_tender_detail purchase_tender_detail = PurchaseTenderDB.purchase_tender_detail.Where(x => x.id_purchase_tender_contact == purchase_tender_contact.id_purchase_tender_contact && x.id_purchase_tender_item == purchase_tender_item.id_purchase_tender_item).FirstOrDefault(); purchase_tender_detail.quantity = purchase_tender_detail.quantity + 1; } } } } purchase_tender.purchase_tender_contact_detail.Add(purchase_tender_contact); purchase_tenderpurchase_tender_contact_detailViewSource.View.Refresh(); purchase_tenderpurchase_tender_contact_detailViewSource.View.MoveCurrentTo(purchase_tender_contact); } } }