public ActionResult Payment(PaymentSearch search) { using (var session = NHibernateHelper.CreateSessionFactory()) { using (var transaction = session.BeginTransaction()) { var payments = session.CreateCriteria(typeof(Transaction)).List<Transaction>(); if (!string.IsNullOrEmpty(search.PaymentMethod)) { var paymentMethodId = Convert.ToInt32(search.PaymentMethod); payments = payments.Where(s => s.PaymentType.Id.Equals(paymentMethodId)).ToList(); } if (!string.IsNullOrEmpty(search.ReceivedByName)) { payments = payments.Where(s => s.ReceivedBy.Username.ToLower().Contains(search.ReceivedByName.ToLower())).ToList(); } if (!string.IsNullOrEmpty(search.EstablishmentName)) { payments = payments.Where(s => s.Renewal.Registration.EstablishmentName.ToLower().Contains(search.EstablishmentName.ToLower())).ToList(); } payments = payments.Where(s => s.Date >= search.CreatedFrom).ToList(); if (search.CreatedTo.Equals(DateTime.MinValue)) { payments = payments.Where(s => s.Date <= DateTime.MaxValue).ToList(); } else { payments = payments.Where(s => s.Date <= search.CreatedTo).ToList(); } var jsonResult = from x in payments select new { Search = x /*Id = x.Id, Created = x.Date, PaymentMethod = x.PaymentType.Name, ReceivedFrom = x.ReceivedBy, ReceivedByName = x.ReceivedBy.Username, x.Amount, x.Renewal.Registration.EstablishmentName*/ }; return Json(jsonResult); } } }
public ActionResult Payment(PaymentSearch search) { using (var session = NHibernateHelper.CreateSessionFactory()) { using (var transaction = session.BeginTransaction()) { var payments = session.CreateCriteria(typeof(Transaction)).List <Transaction>(); if (!string.IsNullOrEmpty(search.PaymentMethod)) { var paymentMethodId = Convert.ToInt32(search.PaymentMethod); payments = payments.Where(s => s.PaymentType.Id.Equals(paymentMethodId)).ToList(); } if (!string.IsNullOrEmpty(search.ReceivedByName)) { payments = payments.Where(s => s.ReceivedBy.Username.ToLower().Contains(search.ReceivedByName.ToLower())).ToList(); } if (!string.IsNullOrEmpty(search.EstablishmentName)) { payments = payments.Where(s => s.Renewal.Registration.EstablishmentName.ToLower().Contains(search.EstablishmentName.ToLower())).ToList(); } payments = payments.Where(s => s.Date >= search.CreatedFrom).ToList(); if (search.CreatedTo.Equals(DateTime.MinValue)) { payments = payments.Where(s => s.Date <= DateTime.MaxValue).ToList(); } else { payments = payments.Where(s => s.Date <= search.CreatedTo).ToList(); } var jsonResult = from x in payments select new { Search = x /*Id = x.Id, * Created = x.Date, * PaymentMethod = x.PaymentType.Name, * ReceivedFrom = x.ReceivedBy, * ReceivedByName = x.ReceivedBy.Username, * x.Amount, * x.Renewal.Registration.EstablishmentName*/ }; 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)); } } }
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); } } }