public ActionResult CustomerTransactionDetailWithDate(Guid UID, DateTime fDate, DateTime tDate)
{
var status = "error";
try
{
tDate = tDate.AddDays(1);
fDate = fDate.AddDays(-1);
if (!Authenticated)
{
status = "Session Expired";
}
else
{
var objIpm = db.Customers.Where(x => x.UID == UID).Select(s => s.Id).FirstOrDefault();
var StringUID = Convert.ToString(UID);
var Detail = db.CustomerLedgerReportWithDateRange(StringUID, fDate, tDate);
//var Detail = (from cp in db.CustomerPayments
// join c in db.Customers on
// cp.CustomerId equals c.Id
// where cp.CustomerId == objIpm
// && cp.CreatedOn>=fDate && cp.CreatedOn <=tDate
// select new
// {
// cp.SoNumber,
// Name = c.Name,
// cp.EntryType,
// cp.CreatedOn,
// Debit = cp.Debit,
// Credit = cp.Credit,
// }).ToList();
status = JsonConvert.SerializeObject(Detail);
}
}
catch (Exception ex)
{
ApplicationExceptionLogging(ex.Message, ex.StackTrace, "ReportsController", "PoDetail");
}
return(Content(status));
}