/* ----------------------------------------------------- * FUNCTION - DeleteUser * ----------------------------------------------------- * * ------------------------------------------------------ */ public void DeleteUser(Cp_user user) { cpdb.Cp_Users.Remove(( from u in cpdb.Cp_Users where u.Cp_user_id == user.Cp_user_id select u ).FirstOrDefault()); cpdb.SaveChanges(); }
/* ----------------------------------------------------- * FUNCTION - DeleteBank * ----------------------------------------------------- * * ------------------------------------------------------ */ public void DeleteBank(Bank prmBank) { cpdb.Banks.Remove(( from b in cpdb.Banks where b.Bank_id == prmBank.Bank_id select b ).FirstOrDefault()); cpdb.SaveChanges(); }
/* ----------------------------------------------------- * FUNCTION - UpdateAcct_check * ----------------------------------------------------- * * ------------------------------------------------------ */ public Acct_check UpdateAcct_check(Acct_check origCheck, Acct_check newInfoCheck) { origCheck.Account_id = newInfoCheck.Account_id; origCheck.Amount = newInfoCheck.Amount; origCheck.Check_number = newInfoCheck.Check_number; origCheck.Date_written = newInfoCheck.Date_written; origCheck.Date_received = newInfoCheck.Date_received; origCheck.Date_paid = newInfoCheck.Date_paid; origCheck.Amount_paid = newInfoCheck.Amount_paid; cpdb.SaveChanges(); return(SelectAcct_check(origCheck.Acct_check_id)); }
/* ----------------------------------------------------- * FUNCTION -- UpdateAccount * ----------------------------------------------------- * pass in an Account object <prmAcctToUpdate> to update * and an Account object <prmNewAcctInfo> with the new updated info * set all <prmAcctToUpdate>'s info to the <prmNewAcctInfo>'s info * ----------------------------------------------------- */ public Account UpdateAccount(Account acctToUpdate, Account newAcctInfo) { acctToUpdate.First_name = newAcctInfo.First_name; acctToUpdate.Last_name = newAcctInfo.Last_name; acctToUpdate.First_name_2 = newAcctInfo.First_name_2; acctToUpdate.Last_name_2 = newAcctInfo.Last_name_2; acctToUpdate.Bank_id = newAcctInfo.Bank_id; acctToUpdate.Address = newAcctInfo.Address; acctToUpdate.City = newAcctInfo.City; acctToUpdate.State = newAcctInfo.State; acctToUpdate.Country = newAcctInfo.Country; acctToUpdate.Zip_code = newAcctInfo.Zip_code; acctToUpdate.Account_number = newAcctInfo.Account_number; acctToUpdate.Phone_number = newAcctInfo.Phone_number; cpdb.SaveChanges(); return(SelectAccount(acctToUpdate.Account_id)); }
public Client InsertClient(Client client) { Client tstClient = ( from c in cpdb.Clients where c.Client_id == client.Client_id select c ).FirstOrDefault(); Client newClient; if (tstClient == null) { newClient = cpdb.Clients.Add(tstClient); cpdb.SaveChanges(); } else { newClient = tstClient; } return(newClient); }