public ActionResult Enquiry(PaymentSearch search)
{
var sqlPath = System.Web.Hosting.HostingEnvironment.MapPath("~/App_Data/sql/payments.txt");
using (var session = NHibernateHelper.CreateSessionFactory())
{
using (var transaction = session.BeginTransaction())
{
var sql = System.IO.File.ReadAllText(sqlPath);
var data =
from x in session.CreateSQLQuery(sql).DynamicList()
select new
{
x.Id,
x.ReceivedFrom,
x.Date,
x.Amount,
x.PaymentType,
x.TransactionType,
x.Renewal_id,
x.Username,
x.EstablishmentName
};
var enquirySearchList = new List <EnquirySearch>();
if (data.Any())
{
foreach (var d in data)
{
var enquirySearch = new EnquirySearch
{
Id = d.Id,
ReceivedFrom = d.ReceivedFrom,
Date = d.Date,
Amount = d.Amount,
PaymentType = d.PaymentType,
TransactionType = d.TransactionType,
ReceivedBy = d.Username,
EstablishmentName = d.EstablishmentName
};
enquirySearchList.Add(enquirySearch);
}
}
var jsonResult =
from x in enquirySearchList
select x;
return(Json(jsonResult));
}
}
}
public ActionResult Enquiry(PaymentSearch search)
{
var sqlPath = System.Web.Hosting.HostingEnvironment.MapPath("~/App_Data/sql/payments.txt");
using (var session = NHibernateHelper.CreateSessionFactory())
{
using (var transaction = session.BeginTransaction())
{
var sql = System.IO.File.ReadAllText(sqlPath);
var data =
from x in session.CreateSQLQuery(sql).DynamicList()
select new
{
x.Id,
x.ReceivedFrom,
x.Date,
x.Amount,
x.PaymentType,
x.TransactionType,
x.Renewal_id,
x.Username,
x.EstablishmentName
};
var enquirySearchList = new List<EnquirySearch>();
if (data.Any())
{
foreach (var d in data)
{
var enquirySearch = new EnquirySearch
{
Id = d.Id,
ReceivedFrom = d.ReceivedFrom,
Date = d.Date,
Amount = d.Amount,
PaymentType = d.PaymentType,
TransactionType = d.TransactionType,
ReceivedBy = d.Username,
EstablishmentName = d.EstablishmentName
};
enquirySearchList.Add(enquirySearch);
}
}
var jsonResult =
from x in enquirySearchList
select x;
return Json(jsonResult);
}
}
}
