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