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