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
{
}
}
}
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");
}
}
}
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();
}
}