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 DeleteCommandBinding_Executed(object sender, ExecutedRoutedEventArgs e) { try { DataGrid dg = (DataGrid)e.Source; MessageBoxResult result = MessageBox.Show("Are you sure want to Delete?", "Delete", MessageBoxButton.YesNo, MessageBoxImage.Question); if (result == MessageBoxResult.Yes) { if (dg.Name == "purchase_tender_contact_detailDataGrid") { purchase_tender_contact_detailDataGrid.CancelEdit(); purchase_tender_contact purchase_tender_contact = e.Parameter as entity.purchase_tender_contact; if (purchase_tender_contact != null) { PurchaseTenderDB.purchase_tender_contact_detail.Remove(purchase_tender_contact); purchase_tenderpurchase_tender_contact_detailViewSource.View.Refresh(); } else { toolBar.msgWarning("Please Contact Admin."); } } else if (dg.Name == "purchase_tender_itemDataGrid") { purchase_tender_itemDataGrid.CancelEdit(); PurchaseTenderDB.purchase_tender_item_detail.Remove(e.Parameter as purchase_tender_item); purchase_tenderpurchase_tender_itemViewSource.View.Refresh(); } else { //DeleteDetailGridRow purchase_tender_item_detailDataGrid.CancelEdit(); PurchaseTenderDB.purchase_tender_detail.Remove(e.Parameter as purchase_tender_detail); purchase_tenderpurchase_tender_item_detailViewSource.View.Refresh(); } } } catch (Exception ex) { toolBar.msgError(ex); } }
private void EditCommand_Executed(object sender, System.Windows.Input.ExecutedRoutedEventArgs e) { purchase_tender_contact purchase_tender_contact = (purchase_tender_contact)e.Parameter; entity.Brillo.Document.Start.Automatic(e.Parameter as purchase_tender_contact, purchase_tender_contact.purchase_tender.app_document_range); }
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); } } }