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); } } }