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