public ActionResult CustomerTransactionDetail(Guid UID)
{
var status = "error";
try
{
if (!Authenticated)
{
status = "Session Expired";
}
else
{
var StringUID = Convert.ToString(UID);
var Detail = db.CustomerLedgerReport(StringUID);
//var objIpm = db.Customers.Where(x => x.UID == UID).Select(s => s.Id).FirstOrDefault();
//var Detail = (from cp in db.CustomerPayments
// join c in db.Customers on
// cp.CustomerId equals c.Id
// where cp.CustomerId == objIpm
// 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));
}