public cCash doUpdate(string username, CashCategory key, double?cash, AccountAuditType addspend)
{
cCash ret = null;
spCashReadListTableAdapter ta = new spCashReadListTableAdapter();
var dt = ta.doUpdate(username, key.ToString(), cash, addspend.ToString(), DateTime.Now);
if (dt != null)
{
if (dt.Rows.Count > 0)
{
var dr = dt.FirstOrDefault();
ret = getCash(dr);
}
}
return(ret);
}
public List <cCash> doReadList()
{
List <cCash> ret = null;
spCashReadListTableAdapter ta = new spCashReadListTableAdapter();
var dt = ta.doReadList();
if (dt != null && dt.Rows.Count > 0)
{
ret = new List <cCash>();
foreach (var dr in dt)
{
cCash cash = getCash(dr);
ret.Add(cash);
;
}
}
return(ret);
}
public List <cCash> cashTransactionList()
{
List <cCash> ret = null;
spCashReadListTableAdapter ta = new spCashReadListTableAdapter();
sitedb.spCashReadListDataTable dt = ta.GetData();
if (dt != null && dt.Rows.Count > 0)
{
ret = new List <cCash>();
foreach (sitedb.spCashReadListRow dr in dt)
{
ret.Add(new cCash(dr));
;
}
}
return(ret);
}
