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