public string withdraw(long acc, int amt)
{
string comment = "withdraw done";
string type = "withdraw";
try
{
Account transactionWithdraw = dbContext.Accounts.Where(var => var.accountNo == acc).Single <Account>();
if (transactionWithdraw.amount >= amt)
{
transactionWithdraw.amount -= amt;
dbContext.SaveChanges();
}
else
{
return("amountNotSufficient");
}
}
catch (Exception exe)
{
return("accountNotFound");
}
TransactionClass obj1 = new TransactionClass();
obj1.insTrans(acc, acc, amt, type, comment);
return("Success");
}
public string deposit(long acc, int amt)
{
string comment = "deposit done";
string type = "deposit";
TransactionClass obj1 = new TransactionClass();
SqlConnection con = new SqlConnection(ConnectionString);
con.Open();
string sql = "checkAcc";
SqlCommand command = new SqlCommand(sql, con);
SqlParameter param1 = new SqlParameter("@acc", acc);
command.Parameters.Add(param1);
command.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(command);
DataSet ds = new DataSet();
da.Fill(ds);
//int res, res1;
if (ds.Tables[0].Rows.Count > 0)
{
string sql3 = "deposit";
SqlCommand command2 = new SqlCommand(sql3, con);
SqlParameter param3 = new SqlParameter("@acc", acc);
command2.Parameters.Add(param3);
SqlParameter param4 = new SqlParameter("@amt", amt);
command2.Parameters.Add(param4);
command2.CommandType = CommandType.StoredProcedure;
command2.ExecuteNonQuery();
}
else
{
con.Close();
return("accountNotFound");
}
obj1.insTrans(acc, acc, amt, type, comment);
return("success");
}
public string deposit(long acc, int amt)
{
string comment = "deposit done";
string type = "deposit";
try
{
Account transactionWithdraw = dbContext.Accounts.Where(var => var.accountNo == acc).Single <Account>();
transactionWithdraw.amount += amt;
dbContext.SaveChanges();
}
catch (Exception exe)
{
return("accountNotFound");
}
TransactionClass obj1 = new TransactionClass();
obj1.insTrans(acc, acc, amt, type, comment);
return("success");
}
public string withdraw(long acc, int amt)
{
string comment = "withdraw done";
string type = "withdraw";
TransactionClass obj1 = new TransactionClass();
SqlConnection con = new SqlConnection(ConnectionString);
con.Open();
string sql = "checkAcc";
SqlCommand command = new SqlCommand(sql, con);
SqlParameter param1 = new SqlParameter("@acc", acc);
command.Parameters.Add(param1);
command.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(command);
DataSet ds = new DataSet();
da.Fill(ds);
int res, res1;
if (ds.Tables[0].Rows.Count > 0)
{
res = (int)ds.Tables[0].Rows[0]["customerId"];
string sql1 = "checkAmo";
SqlCommand command1 = new SqlCommand(sql1, con);
SqlParameter param2 = new SqlParameter("@acc", acc);
command1.Parameters.Add(param2);
command1.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da1 = new SqlDataAdapter(command1);
DataSet ds1 = new DataSet();
da1.Fill(ds1);
if (ds1.Tables[0].Rows.Count > 0)
{
res1 = (int)ds1.Tables[0].Rows[0]["amount"];
if (res1 >= amt)
{
string sql3 = "withdraw";
SqlCommand command2 = new SqlCommand(sql3, con);
SqlParameter param3 = new SqlParameter("@acc", acc);
command2.Parameters.Add(param3);
SqlParameter param4 = new SqlParameter("@amt", amt);
command2.Parameters.Add(param4);
command2.CommandType = CommandType.StoredProcedure;
command2.ExecuteNonQuery();
}
else
{
return("amountNotSufficient");
}
}
}
else
{
return("accountNotFound");
}
obj1.insTrans(acc, acc, amt, type, comment);
return("success");
}