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
{
}
}
}
public IList<NetPresValue> GetNpv()
{
IList<NetPresValue> npvList = null;
using (NpvDataContext context = new NpvDataContext())
{
try
{
IQueryable<NetPresValue> query = from n in context.Npv select n;
npvList = query.ToList();
}
catch
{
}
}
return npvList;
}
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");
}
}
}
