private async void saveRecord() { Agents slctdAgent = cmbAgent.SelectedItem as Agents; Area slctdArea = cmbArea.SelectedItem as Area; try { conDB = new ConnectionDB(); MongoClient client = conDB.initializeMongoDB(); var db = client.GetDatabase("DBFH"); DrugstoresSales ds = new DrugstoresSales(); DateTime dte = DateTime.Parse(deliveryDate.Text); ds.DRNo = txtDRNo.Text; ds.DeliveryDate = DateTime.Parse(dte.ToLocalTime().ToShortDateString()); ds.Drugstorename = txtSmallDrugstore.Text; ds.Agent = slctdAgent; ds.Areas = slctdArea; ds.SubArea = cmbSubarea.SelectedValue.ToString(); ds.Payments = lstPayments; ds.Total = Convert.ToDouble(txtTotal.Text); ds.ContactNo = TxtContactNo.Text; ds.ProductsOrdered = lstProductsOrdered; ds.Payments = lstPayments; var collection = db.GetCollection <DrugstoresSales>("DrugstoresSales"); collection.InsertOne(ds); } catch (Exception ex) { await window.ShowMessageAsync("ERROR", "Cause by: " + ex.StackTrace); } }
private void btnEdit_Click(object sender, RoutedEventArgs e) { drugstoreSaleToUpdate = dgvSales.SelectedItem as DrugstoresSales; if (drugstoreSaleToUpdate != null) { dgvSales.IsEnabled = false; btnUpdate.Visibility = Visibility.Visible; btnSave.Visibility = Visibility.Hidden; txtDRNo.Text = drugstoreSaleToUpdate.DRNo; deliveryDate.Text = drugstoreSaleToUpdate.DeliveryDate.ToShortDateString(); txtSmallDrugstore.Text = drugstoreSaleToUpdate.Drugstorename; txtTotal.Text = drugstoreSaleToUpdate.Total.ToString(); lstProductsOrdered = drugstoreSaleToUpdate.ProductsOrdered; lstPayments = drugstoreSaleToUpdate.Payments; TxtContactNo.Text = drugstoreSaleToUpdate.ContactNo; foreach (Area aa in cmbArea.Items) { if (aa.Id.Equals(drugstoreSaleToUpdate.Areas.Id)) { cmbArea.SelectedItem = aa; } } foreach (SubArea sa in cmbSubarea.Items) { if (sa.SubAreaName.Equals(drugstoreSaleToUpdate.SubArea)) { cmbSubarea.SelectedItem = sa; } } foreach (Agents ag in cmbAgent.Items) { if (ag.Id.Equals(drugstoreSaleToUpdate.Agent.Id)) { cmbAgent.SelectedItem = ag; } } } }