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