public PagedModel<ImportCustomer> GetImportError(ImportCustomerCriteria c)
{
this.ImportCustomerRepository = new ImportCustomerRepository(this.Db);
PagedModel<ImportCustomer> m = new PagedModel<ImportCustomer>();
var r = this.ImportCustomerRepository.FindByCriteria(c)
.Where(o => !o.IsProcessed && !String.IsNullOrEmpty(o.ErrorMsg) && o.ImportKey.Equals(c.ImportKeySrh ));
r = r.OrderBy(o => o.Id);
m.RecordCount = r.Count();
if (c.pagesize.HasValue) {
int page = c.page ?? 1;
int pageCount = m.RecordCount / c.pagesize.Value;
if (m.RecordCount % c.pagesize.Value > 0) {
pageCount++;
}
int skip = (page - 1) * c.pagesize.Value;
if (skip > 0) {
r = r.Skip(skip);
}
r = r.Take(c.pagesize.Value);
}
m.Data = r.ToList();
return m;
}
public PagedModel<ImportCustomer> FindByCriteria(ImportCustomerCriteria c)
{
PagedModel<ImportCustomer> m = new PagedModel<ImportCustomer>();
var r = this.Repository.FindByCriteria(c);
if(!String.IsNullOrEmpty(c.sortname)){
if(c.sortname.ToLower().Equals("id")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.Id);
}else{
r = r.OrderByDescending(o=>o.Id);
}
}
if(c.sortname.ToLower().Equals("importkey")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.ImportKey);
}else{
r = r.OrderByDescending(o=>o.ImportKey);
}
}
if(c.sortname.ToLower().Equals("schoolid")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.SchoolId);
}else{
r = r.OrderByDescending(o=>o.SchoolId);
}
}
if(c.sortname.ToLower().Equals("schoolname")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.SchoolName);
}else{
r = r.OrderByDescending(o=>o.SchoolName);
}
}
if(c.sortname.ToLower().Equals("level")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.Level);
}else{
r = r.OrderByDescending(o=>o.Level);
}
}
if(c.sortname.ToLower().Equals("marketyear")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.MarketYear);
}else{
r = r.OrderByDescending(o=>o.MarketYear);
}
}
if(c.sortname.ToLower().Equals("infosource")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.InfoSource);
}else{
r = r.OrderByDescending(o=>o.InfoSource);
}
}
if(c.sortname.ToLower().Equals("name")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.Name);
}else{
r = r.OrderByDescending(o=>o.Name);
}
}
if(c.sortname.ToLower().Equals("gender")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.Gender);
}else{
r = r.OrderByDescending(o=>o.Gender);
}
}
if(c.sortname.ToLower().Equals("tel")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.Tel);
}else{
r = r.OrderByDescending(o=>o.Tel);
}
}
if(c.sortname.ToLower().Equals("provinceid")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.ProvinceId);
}else{
r = r.OrderByDescending(o=>o.ProvinceId);
}
}
if(c.sortname.ToLower().Equals("provincename")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.ProvinceName);
}else{
r = r.OrderByDescending(o=>o.ProvinceName);
}
}
if(c.sortname.ToLower().Equals("cityid")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.CityId);
}else{
r = r.OrderByDescending(o=>o.CityId);
}
}
if(c.sortname.ToLower().Equals("cityname")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.CityName);
}else{
r = r.OrderByDescending(o=>o.CityName);
}
}
if(c.sortname.ToLower().Equals("districtid")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.DistrictId);
}else{
r = r.OrderByDescending(o=>o.DistrictId);
}
}
if(c.sortname.ToLower().Equals("districtname")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.DistrictName);
}else{
r = r.OrderByDescending(o=>o.DistrictName);
}
}
if(c.sortname.ToLower().Equals("address")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.Address);
}else{
r = r.OrderByDescending(o=>o.Address);
}
}
if(c.sortname.ToLower().Equals("mobile")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.Mobile);
}else{
r = r.OrderByDescending(o=>o.Mobile);
}
}
if(c.sortname.ToLower().Equals("qq")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.QQ);
}else{
r = r.OrderByDescending(o=>o.QQ);
}
}
if(c.sortname.ToLower().Equals("clazz")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.Clazz);
}else{
r = r.OrderByDescending(o=>o.Clazz);
}
}
if(c.sortname.ToLower().Equals("score")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.Score);
}else{
r = r.OrderByDescending(o=>o.Score);
}
}
if(c.sortname.ToLower().Equals("postcode")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.Postcode);
}else{
r = r.OrderByDescending(o=>o.Postcode);
}
}
if(c.sortname.ToLower().Equals("contact")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.Contact);
}else{
r = r.OrderByDescending(o=>o.Contact);
}
}
if(c.sortname.ToLower().Equals("importtype")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.ImportType);
}else{
r = r.OrderByDescending(o=>o.ImportType);
}
}
if(c.sortname.ToLower().Equals("isprocessed")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.IsProcessed);
}else{
r = r.OrderByDescending(o=>o.IsProcessed);
}
}
if(c.sortname.ToLower().Equals("errormsg")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.ErrorMsg);
}else{
r = r.OrderByDescending(o=>o.ErrorMsg);
}
}
}
m.RecordCount = r.Count();
if (c.pagesize.HasValue) {
int page = c.page ?? 1;
int pageCount = m.RecordCount / c.pagesize.Value;
if (m.RecordCount % c.pagesize.Value > 0) {
pageCount++;
}
int skip = (page - 1) * c.pagesize.Value;
if (skip > 0) {
r = r.Skip(skip);
}
r = r.Take(c.pagesize.Value);
}
m.Data = r.ToList();
return m;
}
