public void Add(string bankName, string bankAccountNo, string accountHolderName)
{
BankAccountDatasource sds = new BankAccountDatasource();
WCSA_Entity_Classes.BankAccount ba = new WCSA_Entity_Classes.BankAccount(bankName, bankAccountNo, accountHolderName);
sds.AddToList(ba);
}
public List <WCSA_Entity_Classes.BankAccount> GetAll()
{
string query = "SELECT BankName,AccountNo,AccountHolderName FROM BANKACCOUNT";
SqlDataReader reader = DataAccess.GetData(query);
WCSA_Entity_Classes.BankAccount ba = null;
List <WCSA_Entity_Classes.BankAccount> bankAccoountList = new List <WCSA_Entity_Classes.BankAccount>();
while (reader.Read())
{
ba = new WCSA_Entity_Classes.BankAccount();
ba.BankName = reader["BankName"].ToString();
ba.BankAccountNo = reader["AccountNo"].ToString();
ba.BankAccountName = reader["AccountHolderName"].ToString();
bankAccoountList.Add(ba);
}
return(bankAccoountList);
}
public int Add(WCSA_Entity_Classes.BankAccount ba)
{
string query = string.Format("INSERT INTO BANKACCOUNT (BankName,AccountNo,AccountHolderName) VALUES('{0}', '{1}', '{2}')", ba.BankName, ba.BankAccountNo, ba.BankAccountName);
return(DataAccess.ExecuteQuery(query));
}