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); }