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