public override string ToString()
{
return(string.Format("{0},{1},{2},{3},{4},{5},{6},{7},{8}",
Account,
TransDate.ToString("M/d/yyyy"),
Amount > 0 ? "$" + Amount : "($" + Amount * -1 + ")",
Balance > 0 ? "$" + Balance : "($" + Balance * -1 + ")",
Category,
Description,
Memo,
Notes,
TransType.ToString()));
}
public void Save(Context ctx)
{
CustomerInfo info = new CustomerInfo();
using (IConnection conn = Sync.GetConnection(ctx))
{
IPreparedStatement ps;
if (IsNew)
{
ps = conn.PrepareStatement(@"
INSERT INTO rtrans_hed
(
cust_id, trans_date, vouch_id, voser_id, docnum, htrn_explanation
)
VALUES
(
:cst_id,
:htrn_date,
:vouch_id,
:voser_id,
:htrn_docnum,
:htrn_expl
)");
//SELECT last_insert_id();
}
else
{
ps = conn.PrepareStatement(@"
UPDATE rtrans_hed SET
cust_id = :cst_id,
trans_date = :htrn_date,
vouch_id = :vouch_id,
voser_id = :voser_id,
docnum = :htrn_docnum,
htrn_explanation = :htrn_expl
WHERE id = :htrn_id");
ps.Set("htrn_id", HtrnId);
}
//ps.Set("comp_id", comp_id);
//ps.Set("bran_id", bran_id);
//ps.Set("store_id", store_id);
//ps.Set("per_id", per_id);
ps.Set("htrn_date", TransDate.ToString("yyyy-MM-dd HH:mm:ss"));
ps.Set("cst_id", CstId);
ps.Set("vouch_id", 1);
ps.Set("voser_id", 1);
ps.Set("htrn_docnum", HtrnDocnum);
//ps.Set("user_id", UserId);
//ps.Set("htrn_entry_date", HtrnEntryDate.ToString("yyyy-MM-dd HH:mm:ss"));
ps.Set("htrn_expl", HtrnExpl);
//ps.Set("htrn_net_val", HtrnNetVal);
//ps.Set("htrn_vat_val", HtrnVatVal);
if (IsNew)
{
ps.Execute();
ps = conn.PrepareStatement(@"SELECT TOP 1 id FROM rtrans_hed ORDER BY id DESC");
IResultSet rs = ps.ExecuteQuery();
if (rs.Next())
{
HtrnId = rs.GetInt("id");
}
}
else
{
ps.Execute();
}
ps.Close();
if (TransDetList != null)
{
foreach (var detail in TransDetList)
{
detail.Save(conn, this);
}
}
conn.Commit();
conn.Release();
}
}