public void LoadReport(BLL.Receipt data) { try { List <BLL.Receipt> RList = new List <BLL.Receipt>(); List <BLL.FundMaster> CList = new List <BLL.FundMaster>(); RList.Add(data); CList.Add(BLL.UserAccount.User.UserType.Fund); rptQuickReceipt.Reset(); ReportDataSource data1 = new ReportDataSource("Receipt", RList); ReportDataSource data2 = new ReportDataSource("FundMaster", CList); ReportDataSource data3 = new ReportDataSource("RDetails", data.RDetails); rptQuickReceipt.LocalReport.DataSources.Add(data1); rptQuickReceipt.LocalReport.DataSources.Add(data2); rptQuickReceipt.LocalReport.DataSources.Add(data3); rptQuickReceipt.LocalReport.ReportPath = @"Transaction\rptReceiptVoucher.rdlc"; ReportParameter[] par = new ReportParameter[2]; par[0] = new ReportParameter("AmountInWords", data.AmountInwords); par[1] = new ReportParameter("Fund", BLL.UserAccount.User.UserType.Fund.FundName); rptQuickReceipt.LocalReport.SetParameters(par); rptQuickReceipt.RefreshReport(); } catch (Exception ex) { } }
private void btnSave_Click(object sender, RoutedEventArgs e) { var l1 = dgvBankReconciliation.ItemsSource; if (l1 != null) { foreach (var d in l1) { var b = d as BLL.BankReconcilation; if (b != null) { if (b.EType == 'P') { BLL.Payment p = new BLL.Payment(); p.SearchText = b.EntryNo; p.Find(); p.Status = b.IsCompleted ? "Completed" : "Proccess"; p.Save(); } else if (b.EType == 'R') { BLL.Receipt R = new BLL.Receipt(); R.SearchText = b.EntryNo; R.Find(); R.Status = b.IsCompleted ? "Completed" : "Proccess"; R.Save(); } } } MessageBox.Show(Message.PL.Saved_Alert); App.frmHome.ShowWelcome(); } }
public BLL.Receipt Receipt_DALtoBLL(DAL.Receipt d) { BLL.Receipt R = d.toCopy <BLL.Receipt>(new BLL.Receipt()); foreach (var d_Pd in d.ReceiptDetails) { R.RDetails.Add(d_Pd.toCopy <BLL.ReceiptDetail>(new BLL.ReceiptDetail())); } return(R); }
public void SetEditedValue(string Variable, double Value) { BLL.Receipt ReceiptToSave = new BLL.Receipt(); ReceiptToSave.LoadByPrimaryKey(GRV.ID); switch (Variable) { case "GRVTotal": GRVTotal = Value; ReceiptToSave.TotalValue = Value; break; case "GRVAirFreight": GRVAirFreight = Value; ReceiptToSave.AirFreight = Value; break; case "GRVSeaFreight": GRVSeaFreight = Value; ReceiptToSave.SeaFreight = Value; break; case "GRVInlandFreight": GRVInlandFreight = Value; ReceiptToSave.InlandFreight = Value; break; case "GRVInsurance": GRVInsurance = Value; ReceiptToSave.Insurance = Value; break; case "GRVNBE": GRVNBE = Value; ReceiptToSave.NBE = Value; break; case "GRVCBE": GRVCBE = Value; ReceiptToSave.CBE = Value; break; case "GRVCustomDutyTax": GRVCustomDutyTax = Value; ReceiptToSave.CustomDutyTax = Value; break; case "GRVTransit": GRVTransit = Value; ReceiptToSave.TransitServiceCharge = Value; break; } ReceiptToSave.Save(); CalculateCostCoefficient(); PopulateDataTable(); }
void Journal_SaveByReceipt(BLL.Receipt R) { var EntryNo = string.Format("RPT-{0}", R.Id); DAL.Journal j = DB.Journals.Where(x => x.EntryNo == EntryNo).FirstOrDefault(); if (j == null) { var pd = R.RDetails.FirstOrDefault(); var ld = DB.Ledgers.Where(x => x.Id == pd.LedgerId).FirstOrDefault(); if (ld.LedgerName.StartsWith("CM-") || ld.LedgerName.StartsWith("WH-") || ld.LedgerName.StartsWith("DL-")) { j = new DAL.Journal(); j.EntryNo = R.EntryNo; j.JournalDate = R.ReceiptDate; var CId = CompanyIdByLedgerName(ld.LedgerName); if (CId != 0) { var LName = LedgerNameByCompanyId(Caller.CompanyId); j.JournalDetails.Add(new DAL.JournalDetail() { LedgerId = LedgerIdByKeyAndCompany(BLL.DataKeyValue.CashLedger_Key, CId), DrAmt = R.Amount, Particulars = R.Particulars }); j.JournalDetails.Add(new DAL.JournalDetail() { LedgerId = LedgerIdByCompany(LName, CId), CrAmt = R.Amount, Particulars = R.Particulars }); DB.Journals.Add(j); DB.SaveChanges(); } } } else { j.JournalDate = R.ReceiptDate; foreach (var jd in j.JournalDetails) { if (jd.CrAmt != 0) { jd.CrAmt = R.Amount; } if (jd.DrAmt != 0) { jd.DrAmt = R.Amount; } jd.Particulars = R.Particulars; } DB.SaveChanges(); } }
void Journal_DeleteByReceipt(BLL.Receipt P) { var EntryNo = string.Format("RPT-{0}", P.Id); DAL.Journal j = DB.Journals.Where(x => x.EntryNo == EntryNo).FirstOrDefault(); if (j != null) { Journal_Delete(j.Id); } }
public static void Log(BLL.Issue issue, BLL.Receipt receipt, decimal conversionfactor) { var errorCorrection = new ErrorCorrection(); errorCorrection.AddNew(); errorCorrection.UserID = CurrentContext.LoggedInUser.ID; errorCorrection.IssueID = issue.ID; errorCorrection.ReceiptID = receipt.ID; errorCorrection.ConversionFactor = conversionfactor; errorCorrection.Save(); }
public bool Find_REntryNo(string entryNo, BLL.Receipt PO) { DAL.Receipt d = DB.Receipts.Where(x => x.EntryNo == entryNo & x.Id != PO.Id && x.Ledger.AccountGroup.CompanyId == Caller.CompanyId).FirstOrDefault(); if (d == null) { return(false); } else { return(true); } }
public bool Receipt_Save(BLL.Receipt PO) { try { DAL.Receipt d = DB.Receipts.Where(x => x.Id == PO.Id).FirstOrDefault(); if (d == null) { d = new DAL.Receipt(); DB.Receipts.Add(d); PO.toCopy <DAL.Receipt>(d); foreach (var b_pod in PO.RDetails) { DAL.ReceiptDetail d_pod = new DAL.ReceiptDetail(); b_pod.toCopy <DAL.ReceiptDetail>(d_pod); d.ReceiptDetails.Add(d_pod); } DB.SaveChanges(); PO.Id = d.Id; LogDetailStore(PO, LogDetailType.INSERT); } else { foreach (var d_pod in d.ReceiptDetails) { BLL.ReceiptDetail b_pod = PO.RDetails.Where(x => x.Id == d_pod.Id).FirstOrDefault(); if (b_pod == null) { d.ReceiptDetails.Remove(d_pod); } } PO.toCopy <DAL.Receipt>(d); foreach (var b_pod in PO.RDetails) { DAL.ReceiptDetail d_pod = d.ReceiptDetails.Where(x => x.Id == b_pod.Id).FirstOrDefault(); if (d_pod == null) { d_pod = new DAL.ReceiptDetail(); d.ReceiptDetails.Add(d_pod); } b_pod.toCopy <DAL.ReceiptDetail>(d_pod); } DB.SaveChanges(); Clients.Clients(OtherLoginClientsOnGroup).Receipt_RefNoRefresh(Receipt_NewRefNo(DateTime.Now)); LogDetailStore(PO, LogDetailType.UPDATE); //Journal_SaveByReceipt(PO); } return(true); } catch (Exception ex) { } return(false); }
public void SaveChange() { BLL.Receipt ReceiptToSave = new BLL.Receipt(); ReceiptToSave.LoadByPrimaryKey(GRV.ID); ReceiptToSave.TotalValue = GRVTotal; ReceiptToSave.AirFreight = GRVAirFreight; ReceiptToSave.SeaFreight = GRVSeaFreight; ReceiptToSave.InlandFreight = GRVInlandFreight; ReceiptToSave.Insurance = GRVInsurance; ReceiptToSave.NBE = GRVNBE; ReceiptToSave.CBE = GRVCBE; ReceiptToSave.CustomDutyTax = GRVCustomDutyTax; ReceiptToSave.TransitServiceCharge = GRVTransit; ReceiptToSave.Provision = Provision; ReceiptToSave.Save(); }
public BLL.Receipt Receipt_Find(string SearchText) { BLL.Receipt PO = new BLL.Receipt(); try { DAL.Receipt d = DB.Receipts.Where(x => x.EntryNo == SearchText && x.Ledger.AccountGroup.CompanyId == Caller.CompanyId).FirstOrDefault(); DB.Entry(d).Reload(); if (d != null) { d.toCopy <BLL.Receipt>(PO); PO.LedgerName = (d.Ledger ?? DB.Ledgers.Find(d.LedgerId) ?? new DAL.Ledger()).LedgerName; foreach (var d_pod in d.ReceiptDetails) { BLL.ReceiptDetail b_pod = new BLL.ReceiptDetail(); d_pod.toCopy <BLL.ReceiptDetail>(b_pod); PO.RDetails.Add(b_pod); b_pod.LedgerName = (d_pod.Ledger ?? DB.Ledgers.Find(d_pod.LedgerId) ?? new DAL.Ledger()).LedgerName; } } } catch (Exception ex) { } return(PO); }
public List <BLL.Receipt> Receipt_List(int?LedgerId, DateTime dtFrom, DateTime dtTo, string Status) { List <BLL.Receipt> lstReceipt = new List <BLL.Receipt>(); BLL.Receipt rp = new BLL.Receipt(); foreach (var l in DB.Receipts. Where(x => x.ReceiptDate >= dtFrom && x.ReceiptDate <= dtTo && (x.LedgerId == LedgerId || LedgerId == null) && (Status == "" || x.Status == Status)).ToList()) { rp = new BLL.Receipt(); rp.Amount = l.Amount; rp.ChequeDate = l.ChequeDate; rp.ChequeNo = l.ChequeNo; rp.CleareDate = l.CleareDate; rp.EntryNo = l.EntryNo; rp.ExtraCharge = l.Extracharge; rp.Id = l.Id; rp.LedgerId = l.LedgerId; rp.LedgerName = l.Ledger.LedgerName; rp.Particulars = l.Particulars; rp.ReceiptDate = l.ReceiptDate; rp.ReceiptMode = l.ReceiptMode; rp.ReceivedFrom = l.ReceivedFrom; rp.RefCode = l.RefCode; rp.RefNo = l.RefNo; rp.Status = l.Status; rp.VoucherNo = l.VoucherNo; lstReceipt.Add(rp); } return(lstReceipt); }