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