// Загрузка ставки в БД public int LoadBet(Bets bet) { try { comm.CommandText = "INSERT INTO BetsDB VALUES " + "(@IdClien, " + "@Date, " + "@Summ, " + "@Ratio, " + "@Result, " + "@Prise)"; comm.Parameters.AddWithValue("IdClien", bet.IdClient); comm.Parameters.AddWithValue("Date", bet.Date); comm.Parameters.AddWithValue("Summ", bet.Summ); comm.Parameters.AddWithValue("Ratio", bet.Ratio); comm.Parameters.AddWithValue("Result", bet.Result); comm.Parameters.AddWithValue("Prise", bet.Prise); comm.CommandType = CommandType.Text; conn.Open(); return(comm.ExecuteNonQuery()); } catch (Exception) { throw; } finally { if (conn != null) { conn.Close(); } } }
// Запрос ставок из БД public List <Bets> GetBets(string Command_Text) { List <Bets> BetsFromDB = new List <Bets>(); try { comm.CommandText = Command_Text; comm.CommandType = CommandType.Text; conn.Open(); SqlDataReader sqlData = comm.ExecuteReader(); while (sqlData.Read()) { Bets row = new Bets(); row.Id = Convert.ToInt32(sqlData["Id"]); row.IdClient = Convert.ToInt32(sqlData["IdClien"]); row.Date = sqlData["Date"].ToString(); row.Summ = Convert.ToDouble(sqlData["Summ"]); row.Ratio = Convert.ToDouble(sqlData["Ratio"]); row.Result = Convert.ToInt32(sqlData["Result"]); row.Prise = Convert.ToDouble(sqlData["Prise"]); BetsFromDB.Add(row); } return(BetsFromDB); } catch (Exception) { throw; } finally { if (conn != null) { conn.Close(); } } }