public JsonResult UserTypeTableAjax(JQueryDataTableParamModel param)
{
#region byDefaultReturnData
int rowCount = 0;
int lnRowCount = 0;
var result = from q in new List <UserType>()
select new
{
q.Id,
q.Name
};
#endregion
var oUserType = new UserType();
if (!string.IsNullOrEmpty(Request.QueryString["Name"]))
{
oUserType.Name = Request.QueryString["Name"];
}
DataTableProcessModel m = new DataTableProcessModel();
DataTableProcessModel dtProcess = DataTableProcesses.DataTableEslestir(param, m);
//oUserType.SortCol = dtProcess.SortCol;
//oUserType.SortType = dtProcess.SortType;
//oUserType.Page = dtProcess.Page;
//oUserType.RowPerPage = dtProcess.RowPerPage;
//var oResultModel = DAL.Account.UserType.GetUserType(oUserType);
var filters = new Filters <UserType>();
//filters.Add(Convert.ToBoolean(oUserType.Name), x => x.Name == oUserType.Name);
filters.Add(true, x => x.IsDeleted == false);
var sorts = new Sorts <UserType>();
sorts.Add(dtProcess.SortCol == "Id", x => x.Name);
var getUsers = _db.UserTypes.Paginate(dtProcess.Page, dtProcess.RowPerPage, sorts, filters);
if (getUsers.RecordCount > 0)
{
var lstUserType = getUsers.Results;
rowCount = getUsers.RecordCount;
lnRowCount = rowCount;
result = from q in lstUserType
select new
{
q.Id,
q.Name
};
}
return(Json(new
{
param.sEcho,
iTotalRecords = rowCount,
iTotalDisplayRecords = lnRowCount,
aaData = result
},
JsonRequestBehavior.AllowGet));
}
public JsonResult GetNewsDataTable(JQueryDataTableParamModel param)
{
var oNews = new News();
if (!string.IsNullOrEmpty(Request.QueryString["NewsSearch"]))
{
oNews.Title = Request.QueryString["NewsSearch"];
}
if (!string.IsNullOrEmpty(Request.QueryString["Category"]))
{
oNews.CategoryId = Convert.ToInt32(Request.QueryString["Category"]);
}
if (!string.IsNullOrEmpty(Request.QueryString["InsertedBy"]))
{
oNews.InsertedBy = Convert.ToInt32(Request.QueryString["InsertedBy"]);
}
CultureInfo newCulture = (CultureInfo)Thread.CurrentThread.CurrentCulture.Clone();
newCulture.DateTimeFormat.ShortDatePattern = "dd-MM-yyyy";
newCulture.DateTimeFormat.DateSeparator = "-";
Thread.CurrentThread.CurrentCulture = newCulture;
if (!string.IsNullOrEmpty(Request.QueryString["FromDate"]))
{
string date = Request.QueryString["FromDate"];
oNews.FromDate = CommonHelpExtension.ConvertToUTC(Convert.ToDateTime(date, newCulture));
}
if (!string.IsNullOrEmpty(Request.QueryString["ToDate"]))
{
string date = Request.QueryString["ToDate"];
oNews.ToDate = CommonHelpExtension.ConvertToUTC(Convert.ToDateTime(date, newCulture));
}
DataTableProcessModel m = new DataTableProcessModel();
DataTableProcessModel dtProcess = DataTableProcesses.DataTableEslestir(param, m);
//oNews.SortCol = dtProcess.SortCol;
//oNews.SortType = dtProcess.SortType;
//oNews.Page = dtProcess.Page;
//oNews.RowPerPage = dtProcess.RowPerPage;
//var getNews = DAL.News.News.NewsGet(oNews, 0);
var filters = new Filters <News>();
filters.Add(oNews.Id > 0, x => x.Id == oNews.Id);
filters.Add(oNews.FromDate != new DateTime() && oNews.FromDate != null, x => x.PublishDate >= oNews.FromDate);
filters.Add(oNews.ToDate != new DateTime() && oNews.ToDate != null, x => x.PublishDate <= oNews.ToDate);
filters.Add(!string.IsNullOrEmpty(oNews.Title), x => x.Title.Contains(oNews.Title));
filters.Add(true, x => x.IsDeleted == false);
filters.Add(true, x => x.CategoryId == 1);
var sorts = new Sorts <News>();
sorts.Add(dtProcess.SortCol == "Id", x => x.Id);
sorts.Add(dtProcess.SortCol == "Title", x => x.Title);
sorts.Add(dtProcess.SortCol == "PublishDate", x => x.PublishDate);
var getNews = _db.News.Paginate(dtProcess.Page, dtProcess.RowPerPage, sorts, filters);
if (getNews.RecordCount > 0)
{
var getNewsResult = getNews.Results;
int rowCount = getNews.RecordCount;
int lnRowCount = rowCount;
var result = from q in getNewsResult
select new
{
q.Id,
q.IsActive,
q.CategoryId,
q.Image,
q.Status,
q.Title,
q.ViewsCount,
q.InsertedBy,
PublishDate = q.PublishDate.ToString("yyyy-MM-dd HH:mm:ss"),
InsertedByName = q.UserAccount.Name,
q.Category.NameAr,
q.Category.NameEn,
};
return(Json(new
{
param.sEcho,
iTotalRecords = rowCount,
iTotalDisplayRecords = lnRowCount,
aaData = result
},
JsonRequestBehavior.AllowGet));
}
else
{
int rowCount = getNews.RecordCount;
int lnRowCount = rowCount;
var result = from q in getNews.Results
select new
{
q.Id,
q.IsActive,
q.CategoryId,
q.Image,
q.Status,
q.Title,
q.ViewsCount,
q.InsertedBy,
PublishDate = q.PublishDate.ToString("yyyy-MM-dd HH:mm:ss"),
q.UserAccount.Name,
q.Category.NameAr,
q.Category.NameEn,
};
return(Json(new
{
param.sEcho,
iTotalRecords = rowCount,
iTotalDisplayRecords = lnRowCount,
aaData = result
},
JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetCategoriesDataTable(JQueryDataTableParamModel param)
{
var oCategory = new Category();
if (!string.IsNullOrEmpty(Request.QueryString["Id"]))
{
oCategory.Id = Convert.ToInt32(Request.QueryString["Id"]);
}
DataTableProcessModel m = new DataTableProcessModel();
DataTableProcessModel dtProcess = DataTableProcesses.DataTableEslestir(param, m);
//oCategory.SortCol = dtProcess.SortCol;
//oCategory.SortType = dtProcess.SortType;
//oCategory.Page = dtProcess.Page;
//oCategory.RowPerPage = dtProcess.RowPerPage;
//oCategory.IsList = true;
//var getCategory = DAL.News.News.CategoryGet(oCategory);
var filters = new Filters <Category>();
filters.Add(oCategory.Id > 0, x => x.Id == oCategory.Id);
filters.Add(true, x => x.IsDeleted == false);
filters.Add(true, x => x.Id > 1);
var sorts = new Sorts <Category>();
sorts.Add(dtProcess.SortCol == "Id", x => x.Id);
var getCategory = _db.Categories.Paginate(dtProcess.Page, 100, sorts, filters);
if (getCategory.RecordCount > 0)
{
var getCategoryResult = getCategory.Results;
int rowCount = getCategory.RecordCount;
int lnRowCount = rowCount;
var result = from q in getCategoryResult
select new
{
q.Id,
q.NameAr,
q.NameEn
};
return(Json(new
{
param.sEcho,
iTotalRecords = rowCount,
iTotalDisplayRecords = lnRowCount,
aaData = result
},
JsonRequestBehavior.AllowGet));
}
else
{
int rowCount = getCategory.RecordCount;
int lnRowCount = rowCount;
var result = from q in getCategory.Results
select new
{
q.Id,
q.NameAr,
q.NameEn
};
return(Json(new
{
param.sEcho,
iTotalRecords = rowCount,
iTotalDisplayRecords = lnRowCount,
aaData = result
},
JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetStaticPagesDataTable(JQueryDataTableParamModel param)
{
var oStaticPage = new StaticPage();
if (!string.IsNullOrEmpty(Request.QueryString["Id"]))
{
oStaticPage.Id = Convert.ToInt32(Request.QueryString["Id"]);
}
DataTableProcessModel m = new DataTableProcessModel();
DataTableProcessModel dtProcess = DataTableProcesses.DataTableEslestir(param, m);
//oStaticPage.SortCol = dtProcess.SortCol;
//oStaticPage.SortType = dtProcess.SortType;
//oStaticPage.Page = dtProcess.Page;
//oStaticPage.RowPerPage = dtProcess.RowPerPage;
//var getStaticPage = DAL.News.StaticPages.StaticPagesGet(oStaticPage);
//var filters = new Filters<StaticPage>();
//filters.Add(Convert.ToBoolean(oUserType.Name), x => x.Name == oUserType.Name);
//filters.Add(true, x => x.IsDeleted == false);
var sorts = new Sorts <StaticPage>();
sorts.Add(dtProcess.SortCol == "Id", x => x.Id);
var getStaticPage = _db.StaticPages.Paginate(dtProcess.Page, dtProcess.RowPerPage, sorts);
if (getStaticPage.RecordCount > 0)
{
var getStaticPageResult = getStaticPage.Results;
int rowCount = getStaticPage.RecordCount;
int lnRowCount = rowCount;
var result = from q in getStaticPageResult
select new
{
q.Id,
q.Image,
q.PageName
};
return(Json(new
{
param.sEcho,
iTotalRecords = rowCount,
iTotalDisplayRecords = lnRowCount,
aaData = result
},
JsonRequestBehavior.AllowGet));
}
else
{
int rowCount = getStaticPage.RecordCount;
int lnRowCount = rowCount;
var result = from q in getStaticPage.Results
select new
{
q.Id,
q.Image,
q.PageName
};
return(Json(new
{
param.sEcho,
iTotalRecords = rowCount,
iTotalDisplayRecords = lnRowCount,
aaData = result
},
JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetPagesDataTable(JQueryDataTableParamModel param)
{
var oPages = new Pages();
if (!string.IsNullOrEmpty(Request.QueryString["PageId"]))
{
oPages.Id = Convert.ToInt32(Request.QueryString["PageId"]);
}
if (!string.IsNullOrEmpty(Request.QueryString["ParentId"]))
{
oPages.ParentId = Convert.ToInt32(Request.QueryString["ParentId"]);
}
DataTableProcessModel m = new DataTableProcessModel();
DataTableProcessModel dtProcess = DataTableProcesses.DataTableEslestir(param, m);
oPages.SortCol = dtProcess.SortCol;
oPages.SortType = dtProcess.SortType;
oPages.Page = dtProcess.Page;
oPages.RowPerPage = dtProcess.RowPerPage;
var getPages = DAL.Account.Pages.PagesGet(oPages, false);
var getPagesResult = new List <Pages>();
if (getPages.HasResult)
{
getPagesResult = getPages.Results;
int rowCount = getPages.RowCount;
int lnRowCount = rowCount;
var result = from q in getPagesResult
select new
{
q.Id,
q.Name,
q.IsActive,
ParentName = q.OParentPage.Name,
q.Link
};
return(Json(new
{
param.sEcho,
iTotalRecords = rowCount,
iTotalDisplayRecords = lnRowCount,
aaData = result
},
JsonRequestBehavior.AllowGet));
}
else
{
int rowCount = getPages.RowCount;
int lnRowCount = rowCount;
var result = from q in getPagesResult
select new
{
q.Id,
q.Name,
q.IsActive,
ParentName = q.OParentPage.Name,
q.Link
};
return(Json(new
{
param.sEcho,
iTotalRecords = rowCount,
iTotalDisplayRecords = lnRowCount,
aaData = result
},
JsonRequestBehavior.AllowGet));
}
}
public JsonResult UserTypeTableAjax(JQueryDataTableParamModel param)
{
var oUserType = new UserType();
if (!string.IsNullOrEmpty(Request.QueryString["Name"]))
{
oUserType.Name = Request.QueryString["Name"];
}
DataTableProcessModel m = new DataTableProcessModel();
DataTableProcessModel dtProcess = DataTableProcesses.DataTableEslestir(param, m);
oUserType.SortCol = dtProcess.SortCol;
oUserType.SortType = dtProcess.SortType;
oUserType.Page = dtProcess.Page;
oUserType.RowPerPage = dtProcess.RowPerPage;
var isNotSuper = User.UserTypeId != 1;
var oResultModel = DAL.Account.UserType.GetUserType(oUserType);
var lstUserType = new List <UserType>();
if (oResultModel.HasResult)
{
lstUserType = oResultModel.Results;
int rowCount = oResultModel.RowCount;
int lnRowCount = rowCount;
var result = from u in lstUserType
select new
{
u.Id,
u.Name,
};
return(Json(new
{
param.sEcho,
iTotalRecords = rowCount,
iTotalDisplayRecords = lnRowCount,
aaData = result
},
JsonRequestBehavior.AllowGet));
}
else
{
int rowCount = oResultModel.RowCount;
int lnGoster = rowCount;
var result = from u in lstUserType
select new
{
u.Id,
u.Name,
};
return(Json(new
{
param.sEcho,
iTotalRecords = rowCount,
iTotalDisplayRecords = lnGoster,
aaData = result
},
JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetConstantDataTable(JQueryDataTableParamModel param)
{
var oConstant = new Constant();
if (!string.IsNullOrEmpty(Request.QueryString["ConstantId"]))
{
oConstant.Id = Convert.ToInt32(Request.QueryString["ConstantId"]);
}
if (!string.IsNullOrEmpty(Request.QueryString["ParentId"]))
{
oConstant.ParentId = Convert.ToInt32(Request.QueryString["ParentId"]);
}
DataTableProcessModel m = new DataTableProcessModel();
DataTableProcessModel dtProcess = DataTableProcesses.DataTableEslestir(param, m);
oConstant.SortCol = dtProcess.SortCol;
oConstant.SortType = dtProcess.SortType;
oConstant.Page = dtProcess.Page;
oConstant.RowPerPage = dtProcess.RowPerPage;
var getConstant = DAL.Account.Constant.ConstantGet(oConstant);
var getConstantResult = new List <Constant>();
if (getConstant.HasResult)
{
getConstantResult = getConstant.Results;
int rowCount = getConstant.RowCount;
int lnRowCount = rowCount;
var result = from q in getConstantResult
select new
{
q.Id,
q.Name,
ParentName = q.OParent.Name,
q.ParentId,
q.Comment,
q.Icon
};
return(Json(new
{
param.sEcho,
iTotalRecords = rowCount,
iTotalDisplayRecords = lnRowCount,
aaData = result
},
JsonRequestBehavior.AllowGet));
}
else
{
int rowCount = getConstant.RowCount;
int lnRowCount = rowCount;
var result = from q in getConstantResult
select new
{
q.Id,
q.Name,
ParentNameAr = q.OParent.Name,
q.ParentId,
q.Comment,
q.Icon
};
return(Json(new
{
param.sEcho,
iTotalRecords = rowCount,
iTotalDisplayRecords = lnRowCount,
aaData = result
},
JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetUserDataTable(JQueryDataTableParamModel param)
{
var oUser = new UserAccounts();
if (!string.IsNullOrEmpty(Request.QueryString["Name"]))
{
oUser.Name = Request.QueryString["Name"];
}
if (!string.IsNullOrEmpty(Request.QueryString["UserTypeId"]))
{
oUser.UserTypeId = Convert.ToInt32(Request.QueryString["UserTypeId"]);
}
DataTableProcessModel m = new DataTableProcessModel();
DataTableProcessModel dtProcess = DataTableProcesses.DataTableEslestir(param, m);
oUser.SortCol = dtProcess.SortCol;
oUser.SortType = dtProcess.SortType;
oUser.Page = dtProcess.Page;
oUser.RowPerPage = dtProcess.RowPerPage;
var getUsers = DAL.Account.UserAccounts.UserAccountGet(oUser);
var getUserResult = new List <UserAccounts>();
if (getUsers.HasResult)
{
getUserResult = getUsers.Results;
if (User.Id != 1)
{
var toRemove = getUserResult.Single(q => q.Id == 1);
getUserResult.Remove(toRemove);
}
int rowCount = getUsers.RowCount;
int lnRowCount = rowCount;
var result = from q in getUserResult
select new
{
q.Id,
q.Name,
q.IsActive,
UserTypeName = q.OUserType.Name,
q.Email,
q.Avatar,
q.Mobile,
q.Gender
};
return(Json(new
{
param.sEcho,
iTotalRecords = rowCount,
iTotalDisplayRecords = lnRowCount,
aaData = result
},
JsonRequestBehavior.AllowGet));
}
else
{
int rowCount = getUsers.RowCount;
int lnRowCount = rowCount;
var result = from q in getUserResult
select new
{
q.Id,
q.Name,
q.IsActive,
UserTypeName = q.OUserType.Name,
q.Email,
q.Avatar,
q.Mobile,
q.Gender
};
return(Json(new
{
param.sEcho,
iTotalRecords = rowCount,
iTotalDisplayRecords = lnRowCount,
aaData = result
},
JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetErrorsLogsDataTable(JQueryDataTableParamModel param)
{
var oErrorLog = new ErrorsLogs();
DataTableProcessModel m = new DataTableProcessModel();
DataTableProcessModel dtProcess = DataTableProcesses.DataTableEslestir(param, m);
oErrorLog.SortCol = dtProcess.SortCol;
oErrorLog.SortType = dtProcess.SortType;
oErrorLog.Page = dtProcess.Page;
oErrorLog.RowPerPage = dtProcess.RowPerPage;
oErrorLog.IsList = false;
var getErrorsLogs = DAL.Account.ErrorsLogs.ErrorLogsGet(oErrorLog);
var getErrorsLogsResult = new List <ErrorsLogs>();
if (getErrorsLogs.HasResult)
{
getErrorsLogsResult = getErrorsLogs.Results;
int rowCount = getErrorsLogs.RowCount;
int lnRowCount = rowCount;
var result = from q in getErrorsLogsResult
select new
{
q.Id,
q.UserId,
q.IP,
q.UserAgent,
q.Browser,
q.ErrorMessage,
q.Link,
ErrorDate = q.ErrorDate.ToString("yyyy-MM-dd hh:mm tt"),
q.IsSolved,
q.IsAjax,
q.PostedData
};
return(Json(new
{
param.sEcho,
iTotalRecords = rowCount,
iTotalDisplayRecords = lnRowCount,
aaData = result
},
JsonRequestBehavior.AllowGet));
}
else
{
int rowCount = getErrorsLogs.RowCount;
int lnRowCount = rowCount;
var result = from q in getErrorsLogsResult
select new
{
q.Id,
q.UserId,
q.IP,
q.UserAgent,
q.Browser,
q.ErrorMessage,
q.Link,
ActionDate = q.ErrorDate.ToString("yyyy-MM-dd hh:mm tt"),
q.IsSolved,
q.IsAjax,
q.PostedData
};
return(Json(new
{
param.sEcho,
iTotalRecords = rowCount,
iTotalDisplayRecords = lnRowCount,
aaData = result
},
JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetConstantDataTable(JQueryDataTableParamModel param)
{
#region byDefaultReturnData
int rowCount = 0;
int lnRowCount = 0;
var result = from q in new List <Constant>()
select new
{
q.Id,
ConstantName = q.NameAr,
ParentName = q.Parent.NameAr,
q.ParentId,
q.Comment,
q.Icon
};
#endregion
var oConstant = new Constant();
if (!string.IsNullOrEmpty(Request.QueryString["ConstantId"]))
{
oConstant.Id = Convert.ToInt32(Request.QueryString["ConstantId"]);
}
if (!string.IsNullOrEmpty(Request.QueryString["ParentId"]))
{
oConstant.ParentId = Convert.ToInt32(Request.QueryString["ParentId"]);
}
DataTableProcessModel m = new DataTableProcessModel();
DataTableProcessModel dtProcess = DataTableProcesses.DataTableEslestir(param, m);
//oConstant.SortCol = dtProcess.SortCol;
//oConstant.SortType = dtProcess.SortType;
//oConstant.Page = dtProcess.Page;
//oConstant.RowPerPage = dtProcess.RowPerPage;
var filters = new Filters <Constant>();
filters.Add(oConstant.Id > 0, x => x.Id == oConstant.Id);
filters.Add(oConstant.ParentId > 0, x => x.ParentId == oConstant.ParentId);
filters.Add(true, x => x.IsDeleted == false);
var sorts = new Sorts <Constant>();
sorts.Add(dtProcess.SortCol == "Id", x => x.Id);
sorts.Add(dtProcess.SortCol == "NameAr", x => x.NameAr);
sorts.Add(dtProcess.SortCol == "parentId", x => x.ParentId);
var getConstant = _db.Constants.Paginate(dtProcess.Page, dtProcess.RowPerPage, sorts, filters);
if (getConstant.RecordCount > 0)
{
var getConstantResult = getConstant.Results.ToList();
foreach (var constant in getConstantResult)
{
constant.Parent = getConstantResult.FirstOrDefault(x => x.Id == constant.ParentId);
}
rowCount = getConstant.RecordCount;
lnRowCount = rowCount;
result = from q in getConstantResult
select new
{
q.Id,
ConstantName = q.NameAr,
ParentName = q.Parent?.NameAr,
q.ParentId,
q.Comment,
q.Icon
};
}
return(Json(new
{
param.sEcho,
iTotalRecords = rowCount,
iTotalDisplayRecords = lnRowCount,
aaData = result
},
JsonRequestBehavior.AllowGet));
}
public JsonResult GetUserDataTable(JQueryDataTableParamModel param)
{
#region byDefaultReturnData
int rowCount = 0;
int lnRowCount = 0;
var result = from q in new List <UserAccount>()
select new
{
q.Id,
q.Name,
q.IsActive,
UserTypeName = q.UserType.Name,
q.Email,
q.Avatar,
q.Mobile,
q.Gender
};
#endregion
var oUser = new UserAccount();
if (!string.IsNullOrEmpty(Request.QueryString["Name"]))
{
oUser.Name = Request.QueryString["Name"];
}
if (!string.IsNullOrEmpty(Request.QueryString["UserTypeId"]))
{
oUser.UserTypeId = Convert.ToInt32(Request.QueryString["UserTypeId"]);
}
DataTableProcessModel m = new DataTableProcessModel();
DataTableProcessModel dtProcess = DataTableProcesses.DataTableEslestir(param, m);
//oUser.SortCol = dtProcess.SortCol;
//oUser.SortType = dtProcess.SortType;
//oUser.Page = dtProcess.Page;
//oUser.RowPerPage = dtProcess.RowPerPage;
//var getUsers = DAL.Account.UserAccounts.UserAccountGet(oUser);
var filters = new Filters <UserAccount>();
filters.Add(Convert.ToBoolean(oUser.Name), x => x.Name == oUser.Name);
filters.Add(oUser.UserTypeId > 0, x => x.UserTypeId == oUser.UserTypeId);
filters.Add(User.UserTypeId != 1, x => x.UserTypeId > 1);
filters.Add(true, x => x.IsDeleted == false);
var sorts = new Sorts <UserAccount>();
sorts.Add(dtProcess.SortCol == "Name", x => x.Name);
sorts.Add(dtProcess.SortCol == "Id", x => x.Id);
var getUsers = _db.UserAccounts.Include(x => x.UserType).Paginate(dtProcess.Page, dtProcess.RowPerPage, sorts, filters);
if (getUsers.RecordCount > 0)
{
var getUsersResult = getUsers.Results;
rowCount = getUsers.RecordCount;
lnRowCount = rowCount;
result = from q in getUsersResult
select new
{
q.Id,
q.Name,
q.IsActive,
UserTypeName = q.UserType.Name,
q.Email,
q.Avatar,
q.Mobile,
q.Gender
};
}
return(Json(new
{
param.sEcho,
iTotalRecords = rowCount,
iTotalDisplayRecords = lnRowCount,
aaData = result
},
JsonRequestBehavior.AllowGet));
}
