public clsBalance getByAccId(Int64 accid) { try { clsBalance obj = new clsBalance(); SqlCommand com = new SqlCommand("iBet_tblBalance_GetByAccId", conn.GetConn()); com.CommandType = System.Data.CommandType.StoredProcedure; com.Parameters.AddWithValue("@AccId", accid); conn.OpenConn(); SqlDataReader dr = com.ExecuteReader(); if (dr.Read()) { if (dr["Id"] != DBNull.Value) { obj.Id = Convert.ToInt64(dr["Id"]); } if (dr["AccId"] != DBNull.Value) { obj.AccId = Convert.ToInt64(dr["AccId"]); } if (dr["CashBalance"] != DBNull.Value) { obj.CashBalance = Convert.ToDecimal(dr["CashBalance"]); } if (dr["YesCashBalance"] != DBNull.Value) { obj.YesCashBalance = Convert.ToDecimal(dr["YesCashBalance"]); } if (dr["TotalBalance"] != DBNull.Value) { obj.TotalBalance = Convert.ToDecimal(dr["TotalBalance"]); } if (dr["YesTotalBalance"] != DBNull.Value) { obj.YesTotalBalance = Convert.ToDecimal(dr["YesTotalBalance"]); } if (dr["OutStanding"] != DBNull.Value) { obj.OutStanding = Convert.ToDecimal(dr["OutStanding"]); } if (dr["Credit"] != DBNull.Value) { obj.Credit = Convert.ToDecimal(dr["Credit"]); } if (dr["BetCredit"] != DBNull.Value) { obj.BetCredit = Convert.ToDecimal(dr["BetCredit"]); } if (dr["CreateDate"] != DBNull.Value) { obj.CreateDate = Convert.ToDateTime(dr["CreateDate"]); } if (dr["ModifyDate"] != DBNull.Value) { obj.ModifyDate = Convert.ToDateTime(dr["ModifyDate"]); } if (dr["Active"] != DBNull.Value) { obj.Active = Convert.ToInt32(dr["Active"]); } if (dr["Close"] != DBNull.Value) { obj.Close = Convert.ToInt32(dr["Close"]); } if (dr["Suspended"] != DBNull.Value) { obj.Suspended = Convert.ToInt32(dr["Suspended"]); } if (dr["MemberCredit"] != DBNull.Value) { obj.MemberCredit = Convert.ToDecimal(dr["MemberCredit"]); } } return(obj); } catch (Exception) { throw; } finally { conn.CloseConn(); } }
/// <summary> /// Danh sách tất cả các Balance /// </summary> /// <returns>List</returns> public List <clsBalance> getAll() { try { List <clsBalance> objList = new List <clsBalance>(); SqlCommand com = new SqlCommand("iBet_tblBalance_Gets", conn.GetConn()); com.CommandType = System.Data.CommandType.StoredProcedure; conn.OpenConn(); SqlDataReader dr = com.ExecuteReader(); while (dr.Read()) { clsBalance obj = new clsBalance(); if (dr["Id"] != DBNull.Value) { obj.Id = Convert.ToInt64(dr["Id"]); } if (dr["AccId"] != DBNull.Value) { obj.AccId = Convert.ToInt64(dr["AccId"]); } if (dr["CashBalance"] != DBNull.Value) { obj.CashBalance = Convert.ToDecimal(dr["CashBalance"]); } if (dr["YesCashBalance"] != DBNull.Value) { obj.YesCashBalance = Convert.ToDecimal(dr["YesCashBalance"]); } if (dr["TotalBalance"] != DBNull.Value) { obj.TotalBalance = Convert.ToDecimal(dr["TotalBalance"]); } if (dr["YesTotalBalance"] != DBNull.Value) { obj.YesTotalBalance = Convert.ToDecimal(dr["YesTotalBalance"]); } if (dr["OutStanding"] != DBNull.Value) { obj.OutStanding = Convert.ToDecimal(dr["OutStanding"]); } if (dr["Credit"] != DBNull.Value) { obj.Credit = Convert.ToDecimal(dr["Credit"]); } if (dr["BetCredit"] != DBNull.Value) { obj.BetCredit = Convert.ToDecimal(dr["BetCredit"]); } if (dr["CreateDate"] != DBNull.Value) { obj.CreateDate = Convert.ToDateTime(dr["CreateDate"]); } if (dr["ModifyDate"] != DBNull.Value) { obj.ModifyDate = Convert.ToDateTime(dr["ModifyDate"]); } objList.Add(obj); } return(objList); } catch (Exception) { throw; } finally { conn.CloseConn(); } }