public clsUserCommission getById(int id)
{
try
{
clsUserCommission obj = new clsUserCommission();
SqlCommand com = new SqlCommand("iBet_tblUserCommission_Get", conn.GetConn());
com.CommandType = System.Data.CommandType.StoredProcedure;
com.Parameters.AddWithValue("@Id", id);
conn.OpenConn();
SqlDataReader dr = com.ExecuteReader();
while (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["CommA"] != DBNull.Value)
{
obj.CommA = Convert.ToDecimal(dr["CommA"]);
}
if (dr["CommB"] != DBNull.Value)
{
obj.CommB = Convert.ToDecimal(dr["CommB"]);
}
if (dr["CommC"] != DBNull.Value)
{
obj.CommC = Convert.ToDecimal(dr["CommC"]);
}
if (dr["CommD"] != DBNull.Value)
{
obj.CommD = Convert.ToDecimal(dr["CommD"]);
}
if (dr["Comm1x2"] != DBNull.Value)
{
obj.Comm1x2 = Convert.ToDecimal(dr["Comm1x2"]);
}
if (dr["CommOther"] != DBNull.Value)
{
obj.CommOther = Convert.ToDecimal(dr["CommOther"]);
}
if (dr["CreateBy"] != DBNull.Value)
{
obj.CreateBy = Convert.ToInt64(dr["CreateBy"]);
}
if (dr["CreateDate"] != DBNull.Value)
{
obj.CreateDate = Convert.ToDateTime(dr["CreateDate"]);
}
if (dr["ModifyBy"] != DBNull.Value)
{
obj.ModifyBy = Convert.ToInt64(dr["ModifyBy"]);
}
if (dr["ModifyDate"] != DBNull.Value)
{
obj.ModifyDate = Convert.ToDateTime(dr["ModifyDate"]);
}
}
return(obj);
}
catch (Exception)
{
throw;
}
finally
{
conn.CloseConn();
}
}
/// <summary>
/// Danh sách tất cả các tblSoccerDeadBall
/// </summary>
/// <returns>List</returns>
public List<clsUserCommission> getAll()
{
try
{
List<clsUserCommission> objList = new List<clsUserCommission>();
SqlCommand com = new SqlCommand("iBet_tblUserCommission_Gets", conn.GetConn());
com.CommandType = System.Data.CommandType.StoredProcedure;
conn.OpenConn();
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
clsUserCommission obj = new clsUserCommission();
if (dr["ID"] != DBNull.Value)
{
obj.Id = Convert.ToInt32(dr["ID"]);
}
if (dr["AccID"] != DBNull.Value)
{
obj.AccId = Convert.ToInt64(dr["AccID"]);
}
if (dr["CommA"] != DBNull.Value)
{
obj.CommA = Convert.ToDecimal(dr["CommA"]);
}
if (dr["CommB"] != DBNull.Value)
{
obj.CommB = Convert.ToDecimal(dr["CommB"]);
}
if (dr["CommC"] != DBNull.Value)
{
obj.CommC = Convert.ToDecimal(dr["CommC"]);
}
if (dr["CommD"] != DBNull.Value)
{
obj.CommD = Convert.ToDecimal(dr["CommD"]);
}
if (dr["Comm1x2"] != DBNull.Value)
{
obj.Comm1x2 = Convert.ToDecimal(dr["Comm1x2"]);
}
if (dr["CommOther"] != DBNull.Value)
{
obj.CommOther = Convert.ToDecimal(dr["CommOther"]);
}
if (dr["CreateBy"] != DBNull.Value)
{
obj.CreateBy = Convert.ToInt64(dr["CreateBy"]);
}
if (dr["CreateDate"] != DBNull.Value)
{
obj.CreateDate = Convert.ToDateTime(dr["CreateDate"]);
}
if (dr["ModifyBy"] != DBNull.Value)
{
obj.ModifyBy = Convert.ToInt64(dr["ModifyBy"]);
}
if (dr["ModifyDate"] != DBNull.Value)
{
obj.ModifyDate = Convert.ToDateTime(dr["ModifyDate"]);
}
objList.Add(obj);
}
return objList;
}
catch (Exception)
{
throw;
}
finally
{
conn.CloseConn();
}
}
/// <summary>
/// Danh sách tất cả các tblSoccerDeadBall
/// </summary>
/// <returns>List</returns>
public List <clsUserCommission> getAll()
{
try
{
List <clsUserCommission> objList = new List <clsUserCommission>();
SqlCommand com = new SqlCommand("iBet_tblUserCommission_Gets", conn.GetConn());
com.CommandType = System.Data.CommandType.StoredProcedure;
conn.OpenConn();
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
clsUserCommission obj = new clsUserCommission();
if (dr["ID"] != DBNull.Value)
{
obj.Id = Convert.ToInt32(dr["ID"]);
}
if (dr["AccID"] != DBNull.Value)
{
obj.AccId = Convert.ToInt64(dr["AccID"]);
}
if (dr["CommA"] != DBNull.Value)
{
obj.CommA = Convert.ToDecimal(dr["CommA"]);
}
if (dr["CommB"] != DBNull.Value)
{
obj.CommB = Convert.ToDecimal(dr["CommB"]);
}
if (dr["CommC"] != DBNull.Value)
{
obj.CommC = Convert.ToDecimal(dr["CommC"]);
}
if (dr["CommD"] != DBNull.Value)
{
obj.CommD = Convert.ToDecimal(dr["CommD"]);
}
if (dr["Comm1x2"] != DBNull.Value)
{
obj.Comm1x2 = Convert.ToDecimal(dr["Comm1x2"]);
}
if (dr["CommOther"] != DBNull.Value)
{
obj.CommOther = Convert.ToDecimal(dr["CommOther"]);
}
if (dr["CreateBy"] != DBNull.Value)
{
obj.CreateBy = Convert.ToInt64(dr["CreateBy"]);
}
if (dr["CreateDate"] != DBNull.Value)
{
obj.CreateDate = Convert.ToDateTime(dr["CreateDate"]);
}
if (dr["ModifyBy"] != DBNull.Value)
{
obj.ModifyBy = Convert.ToInt64(dr["ModifyBy"]);
}
if (dr["ModifyDate"] != DBNull.Value)
{
obj.ModifyDate = Convert.ToDateTime(dr["ModifyDate"]);
}
objList.Add(obj);
}
return(objList);
}
catch (Exception)
{
throw;
}
finally
{
conn.CloseConn();
}
}
public clsUserCommission getById(int id)
{
try
{
clsUserCommission obj = new clsUserCommission();
SqlCommand com = new SqlCommand("iBet_tblUserCommission_Get", conn.GetConn());
com.CommandType = System.Data.CommandType.StoredProcedure;
com.Parameters.AddWithValue("@Id", id);
conn.OpenConn();
SqlDataReader dr = com.ExecuteReader();
while (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["CommA"] != DBNull.Value)
{
obj.CommA = Convert.ToDecimal(dr["CommA"]);
}
if (dr["CommB"] != DBNull.Value)
{
obj.CommB = Convert.ToDecimal(dr["CommB"]);
}
if (dr["CommC"] != DBNull.Value)
{
obj.CommC = Convert.ToDecimal(dr["CommC"]);
}
if (dr["CommD"] != DBNull.Value)
{
obj.CommD = Convert.ToDecimal(dr["CommD"]);
}
if (dr["Comm1x2"] != DBNull.Value)
{
obj.Comm1x2 = Convert.ToDecimal(dr["Comm1x2"]);
}
if (dr["CommOther"] != DBNull.Value)
{
obj.CommOther = Convert.ToDecimal(dr["CommOther"]);
}
if (dr["CreateBy"] != DBNull.Value)
{
obj.CreateBy = Convert.ToInt64(dr["CreateBy"]);
}
if (dr["CreateDate"] != DBNull.Value)
{
obj.CreateDate = Convert.ToDateTime(dr["CreateDate"]);
}
if (dr["ModifyBy"] != DBNull.Value)
{
obj.ModifyBy = Convert.ToInt64(dr["ModifyBy"]);
}
if (dr["ModifyDate"] != DBNull.Value)
{
obj.ModifyDate = Convert.ToDateTime(dr["ModifyDate"]);
}
}
return obj;
}
catch (Exception)
{
throw;
}
finally
{
conn.CloseConn();
}
}
