private void SumColumns()
{
SumDugovna = JournalDetails.Sum(x => x.Dugovna);
SumPotrazna = JournalDetails.Sum(x => x.Potrazna);
SumStanje = SumDugovna - SumPotrazna;
SidesEqual = SumStanje == 0;
}
private async void SaveChanges()
{
IsLoading = true;
await _accountingJournalEndpoint.Update(JournalDetails.ToList());
ResetCommandsAndView();
}
public ActionResult Details(int?id, bool?showHidden, bool?showDeleted)
{
var entries = _context.JournalEntries.ToList();
var data = new JournalDetails();
data.Journal = _context.Journals.SingleOrDefault(j => j.Id == id);
if (data.Journal == null)
{
return(HttpNotFound());
}
foreach (JournalEntry jrnEntry in entries)
{
if (jrnEntry.JournalId == id && jrnEntry.Flag == JournalEntry.EntryFlag.N)
{
data.Entries.Add(jrnEntry);
}
if (jrnEntry.JournalId == id && showHidden == true && jrnEntry.Flag == JournalEntry.EntryFlag.H)
{
data.ShowHidden = true;
data.Entries.Add(jrnEntry);
}
if (jrnEntry.JournalId == id && showDeleted == true && jrnEntry.Flag == JournalEntry.EntryFlag.D)
{
data.ShowDeleted = true;
data.Entries.Add(jrnEntry);
}
}
data.Entries.Reverse();
return(View(data));
}
private void SumColumns()
{
SumDugovna = JournalDetails.Sum(x => x.Dugovna);
SumPotrazna = JournalDetails.Sum(x => x.Potrazna);
SumStanje = SumDugovna - SumPotrazna;
SidesEqual = SumStanje == 0;
SaveChangesCommand.RaiseCanExecuteChanged();
}
private void AddNewRow()
{
if (JournalDetails == null)
{
JournalDetails = new ObservableCollection <AccountingJournalModel>();
}
if (SelectedJournalDetail != null)
{
JournalDetails.Add(SelectedJournalDetail);
}
SumColumns();
OpenJournal();
}
private async void ProcessJournalToMainLedger()
{
IsLoading = true;
int journamNumber = await _accountingJournalEndpoint.LatestJournalNumber();
foreach (var item in JournalDetails)
{
item.DatumKnjizenja = SelectedJournal.DatumKnjizenja;
item.BrojTemeljnice = journamNumber + 1;
}
await _accountingJournalEndpoint.Post(JournalDetails.ToList());
//Delete temporary journal with number 0
await _accountingJournalEndpoint.Delete(new AccountingJournalModel
{
BrojTemeljnice = SelectedJournal.BrojTemeljnice,
VrstaTemeljnice = SelectedJournal.VrstaTemeljnice
});
ResetCommandsAndView();
}
private async void SaveJournal()
{
await _accountingJournalEndpoint.Post(JournalDetails.ToList());
}
private void DeleteRow()
{
JournalDetails.Remove(SelectedJournalDetail);
SumColumns();
}
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 = dtpDateTime.Value;
jr.EmpoloyeeId = Convert.ToInt32(cmbEmployeeLedger.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
{
JournalDetails jrd = new 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 = Convert.ToDecimal(dgvDetails.Rows[i].Cells["colAmount"].Value);
jrd.Debit = 0;
}
jrd.Insert();
}
catch { }
}
MessageBox.Show(voucher.Name + @" Journal Inserted");
voucher.CurrentNumber += 1;
voucher.Update();
MyContorls.Hylper.Clear(this);
dgvDetails.Rows.Clear();
loadNumber();
}
else
{
MessageBox.Show(jr.Error);
}
}
protected JournalDetails GetObject(DataRow dr)
{
JournalDetails objJournalDetails = new JournalDetails();
objJournalDetails.JournalDetailsId = (dr["JournalDetailsId"] == DBNull.Value) ? 0 : (Int64)dr["JournalDetailsId"];
objJournalDetails.MasterId = (dr["MasterId"] == DBNull.Value) ? 0 : (Int64)dr["MasterId"];
objJournalDetails.AccountNo = (dr["AccountNo"] == DBNull.Value) ? 0 : (Int64)dr["AccountNo"];
objJournalDetails.Debit = (dr["Debit"] == DBNull.Value) ? 0 : (Decimal)dr["Debit"];
objJournalDetails.Credit = (dr["Credit"] == DBNull.Value) ? 0 : (Decimal)dr["Credit"];
objJournalDetails.Description = (dr["Description"] == DBNull.Value) ? "" : (String)dr["Description"];
objJournalDetails.CompanyId = (dr["CompanyId"] == DBNull.Value) ? 0 : (Int32)dr["CompanyId"];
objJournalDetails.VoucherNo = (dr["VoucherNo"] == DBNull.Value) ? "" : (String)dr["VoucherNo"];
return objJournalDetails;
}
