public List <Amt_Withdraw> WithdrawTransaction(int User_ID)
{
List <Amt_Withdraw> Items = new List <Amt_Withdraw>();
using (SqlConnection con = new SqlConnection(ConnectionString.GetCon()))
{
SqlCommand cmd = new SqlCommand("SP_WithdrawTransaction", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("User_ID", User_ID);
con.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
Amt_Withdraw temp = new Amt_Withdraw();
temp.W_ID = Convert.ToInt32(dr["W_ID"]);
temp.User_ID = Convert.ToInt32(dr["User_ID"]);
temp.Date = dr["Date"].ToString();
temp.Amount = Convert.ToInt32(dr["Amount"]);
Items.Add(temp);
}
}
}
return(Items);
}
public int Withdraw(Amt_Withdraw data)
{
using (SqlConnection con = new SqlConnection(ConnectionString.GetCon()))
{
SqlCommand cmd = new SqlCommand("SP_Withdraw", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("User_ID", data.User_ID);
cmd.Parameters.AddWithValue("Amount", data.Amount);
con.Open();
int Data = cmd.ExecuteNonQuery();
return(Data);
}
}
