public List <UserAskData> ReadUserAskDataWithUserId(int UserId)
{
List <UserAskData> AskDataList = new List <UserAskData>();
SqlConnection con = new SqlConnection(@"Data Source = (local)\SQLEXPRESS; Initial Catalog = SysWal; Integrated Security = True");
SqlCommand myCommand = new SqlCommand("select * from UserAskData where UserId = " + UserId, con);
con.Open();
SqlDataReader myReader = myCommand.ExecuteReader();
while (myReader.Read())
{
UserAskData ask = new UserAskData();
ask.SetAskId((int)myReader["AskId"]);
ask.SetUserId((int)myReader["UserId"]);
ask.Setcash(Convert.ToDouble(myReader["cash"]));
ask.SetFromCurrency(myReader["fromCurrency"].ToString());
ask.SetToCurrency(myReader["toCurrency"].ToString());
// ask.SetResult(Convert.ToDouble(myReader["result"]));
ask.SetFriends((int)myReader["friends"]);
ask.SetControlNo((int)myReader["controlNo"]);
ask.SetAccepted((bool)myReader["accepted"]);
//ask.SetDone((bool)myReader["done"]);
ask.SetResult(0.00);
AskDataList.Add(ask);
}
return(AskDataList);
}
public void SaveUserAskData(UserAskData ask)
{
SqlConnection con = new SqlConnection(@"Data Source=(local)\SQLEXPRESS; Initial Catalog=SysWal;Integrated Security=True");
con.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO UserAskData(AskId, UserId, cash, fromCurrency, toCurrency, friends, controlNo, accepted) values (@AskId, @UserId, @cash, @fromCurrency, @toCurrency, @Friends, @ControlNo, @Accepted)", con);
cmd.Parameters.AddWithValue("@AskId", ask.GetAskId());
cmd.Parameters.AddWithValue("@UserId", ask.GetUserId());
cmd.Parameters.AddWithValue("@cash", ask.Getcash());
cmd.Parameters.AddWithValue("@fromCurrency", ask.GetCurrencyFrom());
cmd.Parameters.AddWithValue("@toCurrency", ask.GetCurrencyTo());
// cmd.Parameters.AddWithValue("@Result", ask.Getresult());
cmd.Parameters.AddWithValue("@Friends", ask.GetFriends());
cmd.Parameters.AddWithValue("@ControlNo", ask.GetControlNo());
cmd.Parameters.AddWithValue("@Accepted", ask.GetAccepted());
// cmd.Parameters.AddWithValue("@Done", ask.GetDone());
cmd.ExecuteNonQuery();
}