private IBet MakeBetObject(IBetDTO dto) { var info = dto.GetBetSpecificInfo(); IBet output = null; if (info.TryGetValue("Color", out object temp)) { if (temp != null) { int color = (int)temp; output = new ColorBet((IPocketColor)color) { Id = dto.Id, Stake = dto.Stake, }; } } else if (info.TryGetValue("FirstNumber", out object temp3) && info.TryGetValue("SecondNumber", out object temp4)) { if (temp3 != null && temp4 != null) { int firstNumber = (int)temp3; int secondNumber = (int)temp4; output = new NeighbourBet((IPocketNumber)firstNumber, (IPocketNumber)secondNumber) { Id = dto.Id, Stake = dto.Stake, }; } } else if (info.TryGetValue("Number", out object temp5)) { if (temp5 != null) { int number = (int)temp; output = new SingleNumberBet((IPocketNumber)number) { Id = dto.Id, Stake = dto.Stake, }; } } else if (info.TryGetValue("IsEven", out object temp2)) { if (temp2 != null) { bool isEven = (bool)temp; output = new EvenUnevenBet(isEven) { Id = dto.Id, Stake = dto.Stake, }; } } return(output); }
private IBet MakeBetObject(IBetDTO bet) { var info = bet.GetBetSpecificInfo(); IBet output = null; if (info.TryGetValue("Color", out object tempcolor)) { int color = (int)tempcolor; output = new ColorBet((IPocketColor)color) { Id = bet.Id, Stake = bet.Stake, }; } else if (info.TryGetValue("IsEven", out object tempEven)) { bool isEven = (bool)tempEven; output = new EvenUnevenBet(isEven) { Id = bet.Id, Stake = bet.Stake, }; } else if (info.TryGetValue("FirstNumber", out object first) && info.TryGetValue("SecondNumber", out object second)) { int firstNumber = (int)first; int secondNumber = (int)second; output = new NeighbourBet((IPocketNumber)firstNumber, (IPocketNumber)secondNumber) { Id = bet.Id, Stake = bet.Stake, }; } else if (info.TryGetValue("Number", out object tempNumber)) { int number = (int)tempNumber; output = new SingleNumberBet((IPocketNumber)number) { Id = bet.Id, Stake = bet.Stake, }; } return(output); }
public bool Save(IBetDTO dto) { var values = dto.GetBetSpecificInfo(); List <string> propNames = new List <string>(); List <object> propValues = new List <object>(); foreach (var v in values) { if (v.Key != "Type") { propNames.Add(v.Key); propValues.Add(v.Value); } } string sql = SQLStringBuilder(propNames); try { using (MySqlConnection conn = new MySqlConnection(_connection)) { conn.Open(); using (MySqlCommand cmd = new MySqlCommand(sql, conn)) { for (int i = 0; i < propNames.Count; i++) { string propName = propNames[i]; var parameter = cmd.CreateParameter(); parameter.ParameterName = "@" + propName; parameter.Value = propValues[i]; cmd.Parameters.Add(parameter); } if (cmd.ExecuteNonQuery() > 0) { return(true); } return(false); } } } catch (MySqlException ex) { throw new Exception(ex.Message, ex); } }