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);
}
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_SaveByPayment(BLL.Payment P)
{
var EntryNo = string.Format("PMT-{0}", P.Id);
DAL.Journal j = DB.Journals.Where(x => x.EntryNo == EntryNo).FirstOrDefault();
if (j == null)
{
var pd = P.PDetails.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 = Journal_NewRefNo(DateTime.Now);
j.JournalDate = P.PaymentDate;
var CId = FundMasterIdByLedgerName(ld.LedgerName);
if (CId != 0)
{
var LName = LedgerNameByFund(Caller.FundMasterId);
j.JournalDetails.Add(new DAL.JournalDetail()
{
LedgerId = LedgerIdByKeyAndFund(BLL.DataKeyValue.CashLedger_Key, CId),
DrAmt = P.Amount,
Particulars = P.Particulars
});
j.JournalDetails.Add(new DAL.JournalDetail()
{
LedgerId = LedgerIdByFund(LName, CId),
CrAmt = P.Amount,
Particulars = P.Particulars
});
DB.Journals.Add(j);
DB.SaveChanges();
}
}
}
else
{
j.JournalDate = P.PaymentDate;
foreach (var jd in j.JournalDetails)
{
if (jd.CrAmt != 0)
{
jd.CrAmt = P.Amount;
}
if (jd.DrAmt != 0)
{
jd.DrAmt = P.Amount;
}
jd.Particulars = P.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 bool Find_JEntryNo(string entryNo, BLL.Payment PO)
{
DAL.Journal d = DB.Journals.Where(x => x.EntryNo == entryNo & x.Id != PO.Id && x.JournalDetails.FirstOrDefault().Ledger.AccountGroup.CompanyId == Caller.CompanyId).FirstOrDefault();
if (d == null)
{
return(false);
}
else
{
return(true);
}
}
public bool Journal_Delete(long pk)
{
try
{
DAL.Journal d = DB.Journals.Where(x => x.Id == pk).FirstOrDefault();
if (d != null)
{
DB.JournalDetails.RemoveRange(d.JournalDetails);
DB.Journals.Remove(d);
DB.SaveChanges();
LogDetailStore(Journal_DALtoBLL(d), LogDetailType.DELETE);
}
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);
}
private void btnSave_Click(object sender, EventArgs e)
{
ep.Clear();
int er = 0;
if (txtNumber.Text == "")
{
er++;
ep.SetError(txtNumber, "Required");
}
if (cmbLedger.SelectedValue == null || cmbLedger.SelectedValue.ToString() == "")
{
er++;
ep.SetError(cmbLedger, "Select");
}
if (dgvDetails.Rows.Count < 2)
{
er++;
ep.SetError(dgvDetails, "Enter Details");
}
if (er > 0)
{
return;
}
DAL.Journal jr = new DAL.Journal();
jr.Date = dtpDate.Value;
jr.EmployeeId = Convert.ToInt32(cmbEmployee.SelectedValue);
jr.LedgerId = Convert.ToInt32(cmbLedger.SelectedValue);
jr.Number = txtNumber.Text;
jr.Remarks = txtRemarks.Text;
jr.VoucherId = Convert.ToInt32(cmbVoucher.SelectedValue);
if (voucher.Nature == "Debit")
{
jr.Debit = 0;
jr.Credit = 100;
}
else
{
jr.Credit = 0;
jr.Debit = 100;
}
if (jr.Insert())
{
for (int i = 0; i < dgvDetails.Rows.Count; i++)
{
try
{
DAL.JournalDetails jrd = new DAL.JournalDetails();
jrd.JournalId = jr.LastId;
jrd.LedgerId = Convert.ToInt32(dgvDetails.Rows[i].Cells["colLedger"].Value);
jrd.Remarks = dgvDetails.Rows[i].Cells["colRemarks"].Value.ToString();
if (voucher.Nature == "Debit")
{
jrd.Credit = 0;
jrd.Debit = Convert.ToDecimal(dgvDetails.Rows[i].Cells["colamount"].Value);
}
else
{
jrd.Credit = 100;
jrd.Debit = 0;
}
jrd.Insert();
}
catch { }
}
MessageBox.Show(voucher.Name + "Journal Inserted");
voucher.CurrentNumber += 1;
voucher.Update();
MyControls.Helper.clear(this);
loadNumber();
}
else
{
MessageBox.Show(jr.Error);
}
}
