public string AddAccount(Account a)
{
conn = ConnectionHelp.GetConnection();
conn.Open();
cmd = new SqlCommand("procAccountInsert", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@accountno", a.acno);
cmd.Parameters.AddWithValue("@firstname", a.fname);
cmd.Parameters.AddWithValue("@lastname", a.lname);
cmd.Parameters.AddWithValue("@city", a.city);
cmd.Parameters.AddWithValue("@state", a.state);
cmd.Parameters.AddWithValue("@dateofopening", a.date);
cmd.Parameters.AddWithValue("@amount", a.amount);
cmd.Parameters.AddWithValue("@cheqfacil", a.cheq);
cmd.Parameters.AddWithValue("@accounttype", a.actype);
cmd.Parameters.AddWithValue("@status", a.status);
try
{
cmd.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
conn.Close();
return("Account Added Successfully");
}
public int Generate()
{
conn = ConnectionHelp.GetConnection();
conn.Open();
cmd = new SqlCommand("GenerateAccNo", conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader dr = cmd.ExecuteReader();
dr.Read();
return(Convert.ToInt32(dr["accno"]));
}
public string Close(int a)
{
conn = ConnectionHelp.GetConnection();
conn.Open();
cmd = new SqlCommand("proAccountclose", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@accountno", a);
cmd.ExecuteNonQuery();
conn.Close();
return("account deleted");
}
public string depositaccount(int n, int amount)
{
conn = ConnectionHelp.GetConnection();
conn.Open();
cmd = new SqlCommand("prcAccoundeposit", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@accountno", n);
cmd.Parameters.AddWithValue("@depositamount", amount);
cmd.Parameters.Add(new SqlParameter("@result", SqlDbType.VarChar, 30));
cmd.Parameters["@result"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
string result = cmd.Parameters["@result"].Value.ToString();
return(result);
}
public Account[] ShowAccount()
{
conn = ConnectionHelp.GetConnection();
conn.Open();
cmd = new SqlCommand("procAccountShow", conn);
try
{
cmd.CommandType = CommandType.StoredProcedure;
}
catch (Exception)
{
throw;
}
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader dr = cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(dr);
int c = dt.Rows.Count;
Account[] ar = new Account[c];
Account a = null;
int i = 0;
foreach (DataRow d in dt.Rows)
{
a = new Account();
a.acno = Convert.ToInt32(d["Accountno"]);
a.fname = d["firstname"].ToString();
a.lname = d["lastname"].ToString();
a.city = d["city"].ToString();
a.state = d["state"].ToString();
a.date = d["dateofopening"].ToString();
a.amount = Convert.ToInt32(d["amount"]);
a.cheq = d["cheqfacil"].ToString();
a.actype = d["accounttype"].ToString();
a.status = d["status"].ToString();
ar[i++] = a;
}
conn.Close();
return(ar);
}
public void SearchAccount(int accountno, out string firstname, out string lastname, out string city, out string state, out int amount,
out string cheqfacil, out string accounttype)
{
conn = ConnectionHelp.GetConnection();
conn.Open();
cmd = new SqlCommand("prcSearchAccount1", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@accountno", accountno);
cmd.Parameters.Add(new SqlParameter("@firstname", SqlDbType.VarChar, 30));
cmd.Parameters["@firstname"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new SqlParameter("@lastname", SqlDbType.VarChar, 30));
cmd.Parameters["@lastname"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new SqlParameter("@city", SqlDbType.VarChar, 30));
cmd.Parameters["@city"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new SqlParameter("@state", SqlDbType.VarChar, 30));
cmd.Parameters["@state"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new SqlParameter("@amount", SqlDbType.VarChar, 30));
cmd.Parameters["@amount"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new SqlParameter("@cheqfacil", SqlDbType.VarChar, 30));
cmd.Parameters["@cheqfacil"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new SqlParameter("@accounttype", SqlDbType.VarChar, 30));
cmd.Parameters["@accounttype"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
firstname = cmd.Parameters["@firstname"].Value.ToString();
lastname = cmd.Parameters["@lastname"].Value.ToString();
city = cmd.Parameters["@city"].Value.ToString();
state = cmd.Parameters["@state"].Value.ToString();
amount = Convert.ToInt32(cmd.Parameters["@amount"].Value.ToString());
cheqfacil = cmd.Parameters["@cheqfacil"].Value.ToString();
accounttype = cmd.Parameters["@accounttype"].Value.ToString();
}