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