public List <BLL.Journal> Journal_List(int?LedgerId, DateTime dtFrom, DateTime dtTo) { List <BLL.Journal> lstJournal = new List <BLL.Journal>(); BLL.Journal rp = new BLL.Journal(); foreach (var l1 in DB.JournalDetails.Where(x => x.Journal.JournalDate >= dtFrom && x.Journal.JournalDate <= dtTo && (LedgerId == null || x.LedgerId == LedgerId)).ToList()) { rp = new BLL.Journal(); rp.JDetail.CrAmt = l1.CrAmt; rp.JDetail.DrAmt = l1.DrAmt; rp.EntryNo = l1.Journal.EntryNo; rp.Id = l1.Journal.Id; rp.JDetail.LedgerId = l1.LedgerId; rp.JDetail.LedgerName = l1.Ledger.LedgerName; rp.Particular = l1.Journal.Particular; rp.JournalDate = l1.Journal.JournalDate; rp.RefCode = l1.Journal.RefCode; rp.VoucherNo = l1.Journal.VoucherNo; lstJournal.Add(rp); } return(lstJournal); }
public void LoadReport(BLL.Journal data) { try { List <BLL.Journal> JList = new List <BLL.Journal>(); List <BLL.FundMaster> CList = new List <BLL.FundMaster>(); List <BLL.JournalDetail> JDList = new List <BLL.JournalDetail>(); JList.Add(data); JDList.Add(data.JDetail); CList.Add(BLL.UserAccount.User.UserType.Fund); rptQuickJournal.Reset(); ReportDataSource data1 = new ReportDataSource("Journal", JList); ReportDataSource data2 = new ReportDataSource("FundMaster", CList); ReportDataSource data3 = new ReportDataSource("JDetails", data.JDetails); rptQuickJournal.LocalReport.DataSources.Add(data1); rptQuickJournal.LocalReport.DataSources.Add(data2); rptQuickJournal.LocalReport.DataSources.Add(data3); rptQuickJournal.LocalReport.ReportPath = @"Transaction\rptJournalReceipt.rdlc"; ReportParameter[] par = new ReportParameter[1]; par[0] = new ReportParameter("Fund", BLL.UserAccount.User.UserType.Fund.FundName); rptQuickJournal.LocalReport.SetParameters(par); rptQuickJournal.RefreshReport(); } catch (Exception ex) { } }
public BLL.Journal Journal_DALtoBLL(DAL.Journal d) { BLL.Journal J = d.toCopy <BLL.Journal>(new BLL.Journal()); foreach (var d_Jd in d.JournalDetails) { J.JDetails.Add(d_Jd.toCopy <BLL.JournalDetail>(new BLL.JournalDetail())); } return(J); }
public bool Journal_Save(BLL.Journal PO) { try { DAL.Journal d = DB.Journals.Where(x => x.Id == PO.Id).FirstOrDefault(); if (d == null) { d = new DAL.Journal(); DB.Journals.Add(d); PO.toCopy <DAL.Journal>(d); foreach (var b_pod in PO.JDetails) { DAL.JournalDetail d_pod = new DAL.JournalDetail(); b_pod.toCopy <DAL.JournalDetail>(d_pod); d.JournalDetails.Add(d_pod); } DB.SaveChanges(); PO.Id = d.Id; LogDetailStore(PO, LogDetailType.INSERT); } else { foreach (var d_SOd in d.JournalDetails) { BLL.JournalDetail b_SOd = PO.JDetails.Where(x => x.Id == d_SOd.Id).FirstOrDefault(); if (b_SOd == null) { d.JournalDetails.Remove(d_SOd); } } PO.toCopy <DAL.Journal>(d); foreach (var b_pod in PO.JDetails) { DAL.JournalDetail d_pod = d.JournalDetails.Where(x => x.Id == b_pod.Id).FirstOrDefault(); if (d_pod == null) { d_pod = new DAL.JournalDetail(); d.JournalDetails.Add(d_pod); } b_pod.toCopy <DAL.JournalDetail>(d_pod); } DB.SaveChanges(); LogDetailStore(PO, LogDetailType.UPDATE); } Clients.Clients(OtherLoginClientsOnGroup).Journal_RefNoRefresh(Journal_NewRefNo(DateTime.Now)); return(true); } catch (Exception ex) { } return(false); }
public BLL.Journal Journal_FindById(int id) { BLL.Journal PO = new BLL.Journal(); try { DAL.Journal d = DB.Journals.Where(x => x.Id == id && x.JournalDetails.FirstOrDefault().Ledger.AccountGroup.CompanyId == Caller.CompanyId).FirstOrDefault(); DB.Entry(d).Reload(); if (d != null) { d.toCopy <BLL.Journal>(PO); foreach (var d_pod in d.JournalDetails) { BLL.JournalDetail b_pod = new BLL.JournalDetail(); d_pod.toCopy <BLL.JournalDetail>(b_pod); PO.JDetails.Add(b_pod); b_pod.LedgerName = (d_pod.Ledger ?? DB.Ledgers.Find(d_pod.LedgerId) ?? new DAL.Ledger()).LedgerName; } } } catch (Exception ex) { } return(PO); }