public async Task <IEnumerable <TdsResource> > GetAll()
{
var tds = await _database.TdssFor(AccountingUnitId)
.Include(td => td.Supplier)
.ToListAsync();
return(_mapper.Map <List <Tds>, List <TdsResource> >(tds.Where(td => td.IsActive).ToList()));
}
public IEnumerable GetGstr7(int searchMonth, int year, string accountingUnitId)
{
var frmDate = new DateTime(year, searchMonth, 1);
var toDate = frmDate.AddMonths(1).AddDays(-1);
var fp = searchMonth.ToString("00") + year.ToString();
var accountingUnit = _database.AccountingUnits.SingleOrDefault(ai => ai.Id == accountingUnitId);
var gstr7 = _database.TdssFor(accountingUnit.Id).Where(co => co.IsActive == true)
.ForDateRange(frmDate, toDate)
.GroupBy(a => a.Supplier.Gstin)
.Select(a => new Gstr7 {
Gstin = a.Key,
IgstAmount = a.Sum(b => b.IgstAmount),
CgstAmount = a.Sum(b => b.CgstAmount),
SgstAmount = a.Sum(b => b.SgstAmount),
TdsAmount = a.Sum(b => b.TdsAmount),
}).ToList();
return(gstr7);
}