Exemple #1
0
        private void deleteDataNPV(NetPresValue npv)
        {
            using (NpvDataContext context = new NpvDataContext())
            {
                // find a city to update
                IQueryable<NetPresValue> npvQuery = from n in context.Npv where n.Name == npv.Name select n;
                NetPresValue npvToDelete = new NetPresValue();

                npvToDelete = npvQuery.FirstOrDefault();

                //hapus data yang diseleksi

                try
                {
                    context.Npv.DeleteOnSubmit(npvQuery.FirstOrDefault());

                    // save changes to the database
                    context.SubmitChanges();
                }
                catch
                {

                }
            }
        }
Exemple #2
0
        private void insertData(Product p)
        {
            using (NpvDataContext context = new NpvDataContext())
            {
                if (p != null)
                {
                    NetPresValue npv = new NetPresValue();
                    npv.InitialCost = p.InitialCost;
                    npv.Name = p.Name;
                    npv.AnnualProfit = p.AnnualProfit;
                    npv.Marr = p.Marr;
                    npv.LifetimeProject = p.LifetimeProject;
                    npv.Npv = p.Npv;
                    npv.Status = p.Status;
                    npv.Irr = p.Irr;
                    try
                    {

                        context.Npv.InsertOnSubmit(npv);
                        context.SubmitChanges();
                        this.targetSaved.ItemsSource = (List<NetPresValue>)this.GetNpv();
                    }
                    catch
                    {
                        MessageBox.Show("P : " + p.Name + " NPV : " + npv.Name);
                        if (!context.DatabaseExists())
                        {
                            context.CreateDatabase();
                        }
                    }

                }
                else
                {
                    MessageBox.Show("NOTHING");
                }

            }
        }
Exemple #3
0
 private void Delete_Tap(object sender, System.Windows.Input.GestureEventArgs e)
 {
     if (MessageBox.Show("Are you sure?", "Delete this plan?", MessageBoxButton.OKCancel) == MessageBoxResult.OK)
     {
        NetPresValue n = new NetPresValue();
         n = (NetPresValue)targetSaved.SelectedItem;
         this.deleteDataNPV(n);
         this.targetSaved.ItemsSource = (List<NetPresValue>)this.GetNpv();
     }
 }