public int Deposit(CreditCard_Info data)
{
using (SqlConnection con = new SqlConnection(ConnectionString.GetCon()))
{
SqlCommand cmd = new SqlCommand("SP_Deposit", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("User_ID", data.User_ID);
cmd.Parameters.AddWithValue("Credit_Used", data.Credit_Used);
con.Open();
int Data = cmd.ExecuteNonQuery();
return(Data);
}
}
public CreditCard_Info GetBal(int User_ID)
{
CreditCard_Info temp = new CreditCard_Info();
using (SqlConnection con = new SqlConnection(ConnectionString.GetCon()))
{
SqlCommand cmd = new SqlCommand("SP_GetBal", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("User_ID", User_ID);
con.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
temp.Credit_Left = Convert.ToInt32(dr["Credit_Left"]);
temp.Credit_Used = Convert.ToInt32(dr["Credit_Used"]);
temp.Bonus_Point = Convert.ToInt32(dr["Bonus_Point"]);
}
}
}
return(temp);
}
