/// <summary> /// Danh sách tất cả các SoccerBetSetting /// </summary> /// <returns>List</returns> public List<clsSoccerBetSetting> getAll() { try { List<clsSoccerBetSetting> objList = new List<clsSoccerBetSetting>(); SqlCommand com = new SqlCommand("iBet_tblSoccerBetSetting_Gets", conn.GetConn()); com.CommandType = System.Data.CommandType.StoredProcedure; conn.OpenConn(); SqlDataReader dr = com.ExecuteReader(); while (dr.Read()) { clsSoccerBetSetting obj = new clsSoccerBetSetting(); if (dr["ID"] != DBNull.Value) { obj.Id = Convert.ToInt32(dr["ID"]); } if (dr["AccID"] != DBNull.Value) { obj.AccId = Convert.ToInt64(dr["AccID"]); } if (dr["Minbet"] != DBNull.Value) { obj.Minbet = Convert.ToDecimal(dr["Minbet"]); } if (dr["Maxbet"] != DBNull.Value) { obj.Maxbet = Convert.ToDecimal(dr["Maxbet"]); } if (dr["MaxPerMath"] != DBNull.Value) { obj.MaxPerMath = Convert.ToDecimal(dr["MaxPerMath"]); } objList.Add(obj); } return objList; } catch (Exception) { throw; } finally { conn.CloseConn(); } }
/// <summary> /// Trả về một đối tượng soccerBetSetting theo id /// </summary> /// <param name="id">ID của SoccerBetSetting muốn tìm</param> /// <returns>Đối tượng SoccerBetSetting</returns> public clsSoccerBetSetting getById(int id) { try { clsSoccerBetSetting obj = new clsSoccerBetSetting(); SqlCommand com = new SqlCommand("iBet_tblSoccerBetSetting_Get", conn.GetConn()); com.CommandType = System.Data.CommandType.StoredProcedure; com.Parameters.AddWithValue("@Id", id); conn.OpenConn(); SqlDataReader dr = com.ExecuteReader(); if (dr.Read()) { if (dr["ID"] != DBNull.Value) { obj.Id = Convert.ToInt32(dr["ID"]); } if (dr["AccID"] != DBNull.Value) { obj.AccId = Convert.ToInt64(dr["AccID"]); } if (dr["Minbet"] != DBNull.Value) { obj.Minbet = Convert.ToDecimal(dr["Minbet"]); } if (dr["Maxbet"] != DBNull.Value) { obj.Maxbet = Convert.ToDecimal(dr["Maxbet"]); } if (dr["MaxPerMath"] != DBNull.Value) { obj.MaxPerMath = Convert.ToDecimal(dr["MaxPerMath"]); } } return obj; } catch (Exception) { throw; } finally { conn.CloseConn(); } }