public async Task <IActionResult> GetTellersDaybook([FromBody] Daybook data)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var now = data.Date.Date;
var sum = _tellerRepository.GetAll().Where(t => t.TellerId.Equals(data.TellerId)).FirstOrDefault();
if (sum == null)
{
return(BadRequest("Teller Id Doesn't Exist"));
}
var open = sum.Transactions.Where(c => c.Type == "Debit" && c.NominalId == sum.NominalId && c.TellerId == sum.TellerId && c.Date < now).Select(a => a.Amount).Sum()
- sum.Transactions.Where(c => c.Type == "Credit" && c.NominalId == sum.NominalId && c.TellerId == sum.TellerId && c.Date.Date < now).Select(a => a.Amount).Sum();
var cash = new
{
Opening = open,
Credit = sum.Transactions.Where(c => c.Type == "Credit" && c.NominalId == sum.NominalId && c.TellerId == sum.TellerId && c.Date.Date == now).Select(a => a.Amount).Sum(),
Debit = sum.Transactions.Where(c => c.Type == "Debit" && c.NominalId == sum.NominalId && c.TellerId == sum.TellerId && c.Date.Date == now).Select(a => a.Amount).Sum(),
Balance = (sum.Transactions.Where(c => c.Type == "Debit" && c.NominalId == sum.NominalId && c.TellerId == sum.TellerId && c.Date.Date == now).Select(a => a.Amount).Sum()
- sum.Transactions.Where(c => c.Type == "Credit" && c.NominalId == sum.NominalId && c.TellerId == sum.TellerId && c.Date.Date == now).Select(a => a.Amount).Sum())
+ open
};
var trans = _transactionRepository.Query().Where(t => t.TellerId == sum.TellerId && t.NominalId == sum.NominalId && t.Date.Date == data.Date.Date);
return(Ok(new { cash, trans }));
}
private void btnFilters_Click(object sender, EventArgs e)
{
Reports.Accountbooks.Daybook frmdayBook = new Daybook();
frmdayBook.ShowDialog();
}
internal void insertOnSubmit(Daybook daybook)
{
db.Daybooks.InsertOnSubmit(daybook);
}
private void tlistAccountbook_MouseDown(object sender, MouseEventArgs e)
{
DevExpress.XtraTreeList.TreeListHitInfo hi = tlistAccountbook.CalcHitInfo(e.Location);
if (hi.HitInfoType == DevExpress.XtraTreeList.HitInfoType.Cell)
{
string selectedNode = hi.Node[Accountbooks].ToString();
switch (selectedNode)
{
case "Account Group Ledger":
Reports.Accountbooks.AccountGroupLedger frmAccGrp = new Reports.Accountbooks.AccountGroupLedger();
frmAccGrp.StartPosition = FormStartPosition.CenterParent;
frmAccGrp.ShowDialog();
break;
case "Account Ledger":
Reports.Accountbooks.AccountLedger frmAccLed = new Reports.Accountbooks.AccountLedger();
frmAccLed.ShowDialog();
break;
case "Bank Book":
Bankbook frmBook = new Bankbook();
frmBook.ShowDialog();
break;
case "Cash Book Single":
CashbookSingle frmCashbook = new CashbookSingle();
frmCashbook.ShowDialog();
break;
case "Day Book":
Daybook frmday = new Daybook();
frmday.ShowDialog();
break;
case "Payment Register":
PaymentRegister frmpay = new PaymentRegister();
frmpay.ShowDialog();
break;
case "Purchase Register":
PurchaseRegister frmpurc = new PurchaseRegister();
frmpurc.ShowDialog();
break;
case "Purchase Return Register":
PurchaseReturnRegister frmPurcre = new PurchaseReturnRegister();
frmPurcre.ShowDialog();
break;
case "Receipt Register":
RecepitRegister frmRece = new RecepitRegister();
frmRece.ShowDialog();
break;
case "Sales Register":
Saleregister frmsale = new Saleregister();
frmsale.ShowDialog();
break;
case "Sales Return Register":
SalesReturnRegister frmsaleret = new SalesReturnRegister();
frmsaleret.ShowDialog();
break;
case "Sub Ledger":
SubLedger frmsub = new SubLedger();
frmsub.ShowDialog();
break;
default:
break;
}
}
//string selectedNode = (sender as TreeList).FocusedNode.GetValue(0).ToString();
}
