public void DeleteGeneralLedgerUsingRepo() { AccountingSystemV2Entities1 db = new AccountingSystemV2Entities1(); GeneralLedgerTbl deleteGL = (from d in db.GeneralLedgerTbls where d.generalLedger == "4802" select d).Single(); db.GeneralLedgerTbls.Remove(deleteGL); db.SaveChanges(); }
public void DeleteTransactionUsingRepo() { AccountingSystemV2Entities1 db = new AccountingSystemV2Entities1(); TransactionTbl deleteTbl = (from d in db.TransactionTbls where d.gl1 == "4801" select d).Single(); db.TransactionTbls.Remove(deleteTbl); db.SaveChanges(); }
public void DeleteProjectUsingRepo() { AccountingSystemV2Entities1 db = new AccountingSystemV2Entities1(); ProjectsTbl deleteProject = (from d in db.ProjectsTbls where d.Project == "1442" select d).Single(); db.ProjectsTbls.Remove(deleteProject); db.SaveChanges(); }
public void DeleteFundUsingRepo() { AccountingSystemV2Entities1 db = new AccountingSystemV2Entities1(); FundTbl deleteFund = (from d in db.FundTbls where d.Fund == "A1R" select d).Single(); db.FundTbls.Remove(deleteFund); db.SaveChanges(); }
public void DeleteCustomerUsingRepo() { AccountingSystemV2Entities1 db = new AccountingSystemV2Entities1(); CustomerTbl deleteCustomer = (from d in db.CustomerTbls where d.firstName == "Patrick" select d).Single(); if (deleteCustomer != null) db.CustomerTbls.Remove(deleteCustomer); db.SaveChanges(); }
//Test transaction for valid GLs and customer public bool validateTransaction(TransactionTbl transaction) { bool valid = true; AccountingSystemV2Entities1 db = new AccountingSystemV2Entities1(); //test GL1 for existence GeneralLedgerTbl foundGL = (from d in db.GeneralLedgerTbls where d.generalLedger == transaction.gl1 select d).Single(); if (foundGL == null) { valid = false; throw new System.ArgumentException("GL " + transaction.gl1 + " not found in GL table."); } //test gl2 foundGL = (from d in db.GeneralLedgerTbls where d.generalLedger == transaction.gl2 select d).Single(); if (foundGL == null) { valid = false; throw new System.ArgumentException("GL " + transaction.gl2 + " not found in GL table."); } //test gl3 foundGL = (from d in db.GeneralLedgerTbls where d.generalLedger == transaction.gl3 select d).Single(); if (foundGL == null) { valid = false; throw new System.ArgumentException("GL " + transaction.gl3 + " not found in GL table."); } //test gl4 foundGL = (from d in db.GeneralLedgerTbls where d.generalLedger == transaction.gl4 select d).Single(); if (foundGL == null) { valid = false; throw new System.ArgumentException("GL " + transaction.gl4 + " not found in GL table."); } //test customer CustomerTbl foundCustomer = (from d in db.CustomerTbls where d.CustomerID == transaction.customer select d).Single(); if (foundCustomer == null) { valid = false; throw new System.ArgumentException("Customer not found in Customer table."); } return valid; }