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