public ActionResult JournalDetails()
{
List <JournalDetailsModel> list = new List <JournalDetailsModel>();
var items = (from t2 in db.Voucher_Entry_Debit
where t2.voucher_type == "Journal" && t2.voucher_sno == 1
select new
{
id = t2.voucher_entry_id,
voucheerno = t2.voucher_no,
voucherdate = t2.voucher_date,
debitname = t2.tblLedgerMaster.LedgerName,
recordno = t2.record_no
}).SingleOrDefault();
if (items != null)
{
JournalDetailsModel model = new JournalDetailsModel();
//model.voucherentryid = Convert.ToInt32(items.id);
model.voucherno = Convert.ToInt32(items.voucheerno);
model.voucherdate = items.voucherdate;
model.recordno = Convert.ToInt32(items.recordno);
model.debitledgername = items.debitname;
list.Add(model);
}
return(View(list));
}
public static Collection <JournalDetailsModel> GetJournalDetailCollection(string json)
{
Collection <JournalDetailsModel> details = new Collection <JournalDetailsModel>();
var jss = new JavaScriptSerializer();
dynamic result = jss.Deserialize <dynamic>(json);
foreach (var item in result)
{
JournalDetailsModel detail = new JournalDetailsModel();
detail.StatementReference = item[0];
detail.AccountCode = item[1];
detail.Account = item[2];
detail.CashRepositoryCode = item[3];
detail.CurrencyCode = item[4];
detail.Debit = Conversion.TryCastDecimal(item[5]);
detail.Credit = Conversion.TryCastDecimal(item[6]);
detail.ExchangeRate = Conversion.TryCastDecimal(item[7]);
detail.LocalCurrencyDebit = Conversion.TryCastDecimal(item[8]);
detail.LocalCurrencyCredit = Conversion.TryCastDecimal(item[9]);
details.Add(detail);
}
return(details);
}
private void AddRowToTable(string accountCode, string account, string cashRepository, string statementReference, decimal debit, decimal credit)
{
Collection <JournalDetailsModel> table = this.GetTable();
JournalDetailsModel model = new JournalDetailsModel();
model.AccountCode = accountCode;
model.Account = account;
model.CashRepository = cashRepository;
model.StatementReference = statementReference;
model.Debit = debit;
model.Credit = credit;
table.Add(model);
this.Session[this.ID] = table;
}
