public async Task <IActionResult> Index()
{
ProjectListModel model = new ProjectListModel();
var result = await _crudService.GetAll <ProjectModel>(Token, ProjectService.ProjectEntity, false);
if (result.Success)
{
model.Projects = result.Values.Select(p =>
new ProjectViewModel
{
Id = p.Id,
Name = p.Name,
CreateDate = p.CreateDate,
Description = p.Description,
ProjectUsersCount = p.ProjectUsers.Count,
ProjectMetricsCount = p.ProjectMetrics.Count
}).ToList();
}
else
{
AddMessageToModel(model, result.Message);
}
return(View(model));
}
public ActionResult List()
{
IEnumerable <ProjectDetails> projects = this.projectService.GetProjectsDetails();
var model = new ProjectListModel(projects);
return(this.View(model));
}
public ActionResult ProjectList()
{
var result = _postservice.GetAll();
var result3 = _postservice.GetAll();
//var a = result.Where(d => d.Flag == 0);
var result2 = _skillservice.GetAll();
ProjectListModel projectListModel = new ProjectListModel();
if (result != null)
{
foreach (var p in result.Data)
{
var select = _selectedWorkerService.GetAll().Data.Where(d => d.PostId == p.PostId).ToList();
if (select.Count == p.Members)
{
result3.Data.Remove(p);
}
}
}
result = result3;
projectListModel.PostAProjects = result.Data.OrderByDescending(m => m.PostId).ToList();
projectListModel.Skills = result2.Data;
return(View(projectListModel));
}
public ActionResult Index(int? page)
{
ProjectListModel model = new ProjectListModel();
PageModel.Title = "";
PageModel.Description = "";
PageModel.Author = "";
PageModel.Keywords = "";
//ListAccess la = new ListAccess();
//model.MostViewed = la.MostViewed(11, 20);
string url = HttpContext.Request.RawUrl;
//int catigoryRowId = DIYFEHelper.GetCatigoryRowId(url);
//model.CrumbLinkList = DIYFEHelper.GenerateCrumbLinks(catigoryRowId, linkPrefix);
using (var db = new DIYFE.EF.DIYFEEntities())
{
//model.ProjectList = db.Articles.Include("ArticleComments").Where(a => a.ArticleTypeId == 2).OrderBy(a => a.ArticleStatus.Any(aStat => aStat.StatusId == 1)).ToList();
model.PagedArticle = db.Articles.Include("ArticleComments").Where(a => a.ArticleTypeId == 1).OrderBy(a => a.CreatedDate).ToPagedList(page ?? 1, pageSize);
}
//model.ArticleList = la.ArticleList(catigoryId, 1);
return View(model);
}
public ActionResult FirstLevCategoryList(string categoryUrl, string subCategoryUrl, string subSubCategoryUrl, int? page)
{
ProjectListModel model = new ProjectListModel();
//model.MostViewed = la.MostViewed(11, 20);
//model.CrumbLinkList = new List<CustomHtmlLink>();
//AppStatic.Categories.Where(c => c.CategoryUrl == categoryUrl);
PageModel.Title = "";
PageModel.Description = "";
PageModel.Author = "";
PageModel.Keywords = "";
string url = HttpContext.Request.RawUrl;
Category cat = DIYFEHelper.GetCatigory(categoryUrl, subCategoryUrl, subSubCategoryUrl);
//int categoryRowId = DIYFEHelper.GetCatigoryRowId(categoryUrl, "", "");
model.CrumbLinkList = DIYFEHelper.GenerateCrumbLinks(cat, linkPrefix);
model.RelatedTreeView = DIYFEHelper.GenerateRelatedTreeView(cat, linkPrefix);
using (var db = new DIYFE.EF.DIYFEEntities())
{
model.PagedArticle = db.Articles.Include("ArticleComments")
.Include("ArticleStatus.StatusType")
.Where(a => a.ArticleTypeId == 2 && a.Category.CategoryId == cat.CategoryId)
.OrderBy(a => a.ArticleStatus.Any(aStat => aStat.StatusId == 1))
.ToPagedList(page ?? 1, pageSize);
}
return View(model);
}
public void TestProjectController_UpdateProjectsDeleteItem(string httpMethod)
{
SetUpProjectControllerForTesting(httpMethod);
projectController.CurrentUser = user;
ProjectsModel model = new ProjectsModel();
model.ProjectId = projectId;
FormCollection form = new FormCollection();
ProjectListModel projectListModel = new ProjectListModel();
long _projectId = this.db.Context.Projects.Where(p => p.OwnerId == user.UserId && p.ProjectStatusTypeId == ProjectStatusTypeEnum.Inactive).OrderByDescending(p => p.ProjectId).Select(p => p.ProjectId).FirstOrDefault();
projectListModel.ProjectId = _projectId;
model.Items.Add(projectListModel);
System.Collections.Specialized.NameValueCollection nameValueCollection = new System.Collections.Specialized.NameValueCollection();
nameValueCollection.Add(_projectId.ToString(), _projectId.ToString());
form.Add(nameValueCollection);
ViewResult result = projectController.UpdateProjectsDeleteItem(model, form) as ViewResult;
Assert.That(result, Is.Not.EqualTo(null));
Assert.That(result.ViewName, Is.EqualTo("Projects"));
Assert.That(result.Model, Is.Not.EqualTo(null));
Assert.That((result.Model as ProjectsModel).DeleteProjects.First().ProjectId, Is.EqualTo(_projectId));
}
public ActionResult Index(int?page)
{
ProjectListModel model = new ProjectListModel();
PageModel.Title = "";
PageModel.Description = "";
PageModel.Author = "";
PageModel.Keywords = "";
//ListAccess la = new ListAccess();
//model.MostViewed = la.MostViewed(11, 20);
string url = HttpContext.Request.RawUrl;
//int catigoryRowId = DIYFEHelper.GetCatigoryRowId(url);
//model.CrumbLinkList = DIYFEHelper.GenerateCrumbLinks(catigoryRowId, linkPrefix);
using (var db = new DIYFE.EF.DIYFEEntities())
{
//model.ProjectList = db.Articles.Include("ArticleComments").Where(a => a.ArticleTypeId == 2).OrderBy(a => a.ArticleStatus.Any(aStat => aStat.StatusId == 1)).ToList();
model.PagedArticle = db.Articles.Include("ArticleComments").Where(a => a.ArticleTypeId == 1).OrderBy(a => a.CreatedDate).ToPagedList(page ?? 1, pageSize);
}
//model.ArticleList = la.ArticleList(catigoryId, 1);
return(View(model));
}
//GET : /api/ProjectBoard/GetCurrentProjects
public ProjectListModel GetCurrentProjects(int id)
{
Project project = new Project();
if (id == 0)
{
project = _context.Projects.FirstOrDefault();
}
else
{
project = _context.Projects.Find(id);
}
if (project != null)
{
ProjectListModel currProject = new ProjectListModel {
Id = project.Id, ProjectTitle = project.ProjectTitle
};
return(currProject);
}
else
{
return(new ProjectListModel {
Id = 0, ProjectTitle = "No project in database."
});
}
}
public ActionResult FirstLevCategoryList(string categoryUrl, string subCategoryUrl, string subSubCategoryUrl, int?page)
{
ProjectListModel model = new ProjectListModel();
//model.MostViewed = la.MostViewed(11, 20);
//model.CrumbLinkList = new List<CustomHtmlLink>();
//AppStatic.Categories.Where(c => c.CategoryUrl == categoryUrl);
PageModel.Title = "";
PageModel.Description = "";
PageModel.Author = "";
PageModel.Keywords = "";
string url = HttpContext.Request.RawUrl;
//int categoryRowId = DIYFEHelper.GetCatigoryRowId(categoryUrl, "", "");
Category cat = DIYFEHelper.GetCatigory(categoryUrl, subCategoryUrl, subSubCategoryUrl);
model.CrumbLinkList = DIYFEHelper.GenerateCrumbLinks(cat, linkPrefix);
model.RelatedTreeView = DIYFEHelper.GenerateRelatedTreeView(cat, linkPrefix);
using (var db = new DIYFE.EF.DIYFEEntities())
{
//BASED ON CAT
model.ArticleList = db.Articles.Include("ArticleComments").Where(a => a.ArticleTypeId == 1 && a.Category.CategoryId == cat.CategoryId).OrderBy(a => a.CreatedDate);
model.PagedArticle = model.ArticleList.Concat(db.Articles.Include("ArticleComments").Include("ArticleStatus.StatusType").Where(a => a.ArticleTypeId == 2 && a.Category.CategoryId == cat.CategoryId).OrderBy(a => a.ArticleStatus.Any(aStat => aStat.StatusId == 1))).OrderByDescending(a => a.CreatedDate).ToPagedList(page ?? 1, pageSize);
//CHECK PAGING
//model.ArticleList = db.Articles.Include("ArticleComments").Where(a => a.ArticleTypeId == 1);
//model.PagedArticle = model.ArticleList.Concat(db.Articles.Include("ArticleComments").Include("ArticleStatus.StatusType").Where(a => a.ArticleTypeId == 2)).OrderBy(a => a.CreatedDate).ToPagedList(page ?? 1, pageSize);
}
//model.PagedArticle = model.ArticleList.ToPagedList(page ?? 1, pageSize);
return(View(model));
}
public ActionResult Index()
{
HttpCookie authCookie = Request.Cookies[FormsAuthentication.FormsCookieName];
if (authCookie != null)
{
FormsAuthenticationTicket authTicket = FormsAuthentication.Decrypt(authCookie.Value);
var user = _readOnlyRepository.FirstOrDefault <User>(x => x.Email == authTicket.UserData);
if (user != null)
{
var model = new ProjectListModel();
var typelist =
from ProjectEntity ute in _readOnlyRepository.GetAll <ProjectEntity>()
where ute.UserId == user.Id && !ute.Archived
select ute;
var typeList = new List <ProjectEntity>(typelist);
model.ProjectList = new List <ProjectListModel>();
foreach (var tL in typeList)
{
model.ProjectList.Add(new ProjectListModel
{
ProjectId = tL.Id,
ProjectName = tL.ProjectName,
ProjectDescription = tL.ProjectDescription
});
}
return(View(model));
}
}
return(RedirectToAction("Logout", "User"));
}
public ProjectListModel GetProjects()
{
ProjectListModel model = new ProjectListModel();
using (var db = new ProjectEntities())
{
var query = db.UserProjects.Select(x => x);
var projectList = query.ToList();
projectList.ForEach(project =>
{
model.Projects.Add(
new ProjectModel
{
ProjectID = project.ID,
Name = project.ProjectName,
Owner = project.ProjectOwner,
Details = project.ProjectDetails,
Image = project.ProjectImage,
Success = project.Successful
}
);
});
}
return(model);
}
public List <ProjectListModel> Get(string email)
{
var filter = Builders <ProjectModel> .Filter.Where(x => x.Members.Any(y => y.Email == email));
List <ProjectModel> projects = _database.FindAll(filter);
List <ProjectListModel> listing = new List <ProjectListModel>();
foreach (ProjectModel project in projects)
{
ProjectListModel p = new ProjectListModel
{
Id = project.Id,
Title = project.Title,
Members = new List <ProjectMembersModel>()
};
foreach (var member in project.Members)
{
p.Members.Add(new ProjectMembersModel
{
Email = member.Email,
Name = member.Name,
});
}
listing.Add(p);
}
return(listing);
}
public ActionResult Index()
{
ProjectListModel model = new ProjectListModel();
model.Projects = _projectService.GetAll();
return(View(model));
}
public string projectList(int page, int rows)
{
ProjectListModel pl = new ProjectListModel(page, rows);
string json = JsonConvert.SerializeObject(pl);
return(json);
}
public ActionResult ProjectList()
{
var result = postProjectDao.GetAll();
var result2 = skillsDao.GetAll();
ProjectListModel projectListModel = new ProjectListModel();
projectListModel.PostAProjects = result;
projectListModel.Skills = result2;
return(View(projectListModel));
}
//GET : /api/ProjectBoard/GetProjects
public List <ProjectListModel> GetProjects()
{
List <ProjectListModel> projectList = new List <ProjectListModel>();
foreach (Project project in _context.Projects.ToList())
{
ProjectListModel addProject = new ProjectListModel {
Id = project.Id, ProjectTitle = project.ProjectTitle
};
projectList.Add(addProject);
}
return(projectList);
}
public ActionResult ProjectList(ProjectSkills skill)
{
ProjectListModel projectListModel = new ProjectListModel();
var result = projectSkillDao.GetAllskill(skill.SkillID);
foreach (var projectSkillse in result)
{
var result2 = postProjectDao.GetByID(projectSkillse.PostID);
projectListModel.PostAProjects.Add(result2.Data);
}
var result3 = skillsDao.GetAll();
projectListModel.Skills = result3;
return(View(projectListModel));
}
public ActionResult Index(int?projectStatus, int?page)
{
ProjectListModel model = new ProjectListModel();
PageModel.Title = "";
PageModel.Description = "";
PageModel.Author = "";
PageModel.Keywords = "";
//ListAccess la = new ListAccess();
//NOTE: THIS QUERY IS TAKING FOREVER FOR SOME REASON
//model.MostViewed = la.MostViewed(11, 20);
//model.MostViewed = new List<CustomHtmlLink>();
//string url = HttpContext.Request.RawUrl;
//int catigoryRowId = DIYFEHelper.GetCatigoryRowId(url);
//model.CrumbLinkList = DIYFEHelper.GenerateCrumbLinks(catigoryRowId, linkPrefix);
using (var db = new DIYFE.EF.DIYFEEntities())
{
model.PagedArticle = db.Articles
.Include("ArticleComments")
.Include("ArticleStatus.StatusType")
.Where(a => a.ArticleTypeId == 2)
.OrderBy(a => a.ArticleStatus.Any(aStat => aStat.StatusId == 1))
.ToPagedList(page ?? 1, pageSize);
}
if (projectStatus != null)
{
using (var db = new DIYFE.EF.DIYFEEntities())
{
model.PagedArticle = db.Articles
.Include("ArticleComments")
.Include("ArticleStatus.StatusType")
.Where(a => a.ArticleTypeId == 2 && a.ArticleStatus.Any(aStat => aStat.StatusId == projectStatus))
.OrderByDescending(a => a.CreatedDate)
.ToPagedList(page ?? 1, pageSize);
}
//List<DIYFE.EF.Article> tempList = model.ProjectList.ToList();
//model.ProjectList = tempList.Where(a => a.ArticleStatus.Any(arts => arts.StatusId == projectStatus)).ToList();
//model.ProjectList.Concat(tempList.Where(a => !model.ProjectList.Contains(a)));
}
//model.ArticleList = la.ArticleList(catigoryId, 1);
return(View(model));
}
public ActionResult Index(int? projectStatus, int? page)
{
ProjectListModel model = new ProjectListModel();
PageModel.Title = "";
PageModel.Description = "";
PageModel.Author = "";
PageModel.Keywords = "";
//ListAccess la = new ListAccess();
//NOTE: THIS QUERY IS TAKING FOREVER FOR SOME REASON
//model.MostViewed = la.MostViewed(11, 20);
//model.MostViewed = new List<CustomHtmlLink>();
//string url = HttpContext.Request.RawUrl;
//int catigoryRowId = DIYFEHelper.GetCatigoryRowId(url);
//model.CrumbLinkList = DIYFEHelper.GenerateCrumbLinks(catigoryRowId, linkPrefix);
using (var db = new DIYFE.EF.DIYFEEntities())
{
model.PagedArticle = db.Articles
.Include("ArticleComments")
.Include("ArticleStatus.StatusType")
.Where(a => a.ArticleTypeId == 2)
.OrderBy(a => a.ArticleStatus.Any(aStat => aStat.StatusId == 1))
.ToPagedList(page ?? 1, pageSize);
}
if (projectStatus != null)
{
using (var db = new DIYFE.EF.DIYFEEntities())
{
model.PagedArticle = db.Articles
.Include("ArticleComments")
.Include("ArticleStatus.StatusType")
.Where(a => a.ArticleTypeId == 2 && a.ArticleStatus.Any(aStat => aStat.StatusId == projectStatus))
.OrderByDescending(a => a.CreatedDate)
.ToPagedList(page ?? 1, pageSize);
}
//List<DIYFE.EF.Article> tempList = model.ProjectList.ToList();
//model.ProjectList = tempList.Where(a => a.ArticleStatus.Any(arts => arts.StatusId == projectStatus)).ToList();
//model.ProjectList.Concat(tempList.Where(a => !model.ProjectList.Contains(a)));
}
//model.ArticleList = la.ArticleList(catigoryId, 1);
return View(model);
}
/// <summary>
/// Prepare paged project list model
/// </summary>
/// <param name="searchModel">Project search model</param>
/// <returns>Project list model</returns>
public ProjectListModel PrepareProjectListModel(ProjectSearchModel searchModel)
{
if (searchModel == null)
{
throw new ArgumentNullException(nameof(searchModel));
}
string userName = string.Empty;
if (_workContext.CurrentUser.UserTypeId == 2) //Researchers Role will see only owner projects
{
userName = _workContext.CurrentUser.UserName;
}
var projects = _projectService.GetAllProjects(projectNameTH: searchModel.SearchProjectName,
fiscalYear: searchModel.FiscalScheduleId,
projectStatusId: searchModel.ProjectStatusId,
agencyId: searchModel.AgencyId,
progressStatusId: searchModel.ProgressStatusId,
createdBy: userName,
pageIndex: searchModel.Page - 1, pageSize: searchModel.PageSize);
//prepare list model
var model = new ProjectListModel
{
Data = projects.Select(project =>
{
// fill in model values from the entity
var projectModel = new ProjectModel
{
Id = project.Id,
FiscalYear = project.FiscalYear,
ProjectCode = project.ProjectCode,
ProjectNameTh = project.ProjectNameTh,
ProjectStartDateName = CommonHelper.ConvertToThaiDate(project.ProjectStartDate),
ProgressStatusName = project.ProjectProgresses.LastOrDefault() != null ? project.ProjectProgresses.LastOrDefault().ProgressStatus.GetAttributeOfType <EnumMemberAttribute>().Value : string.Empty,
ProjectStatusName = (int)project.ProjectStatus != 0 ? project.ProjectStatus.GetAttributeOfType <EnumMemberAttribute>().Value : string.Empty,
};
return(projectModel);
}),
Total = projects.TotalCount
};
return(model);
}
public ActionResult ProjectList(ProjectSkills skill)
{
ProjectListModel projectListModel = new ProjectListModel();
var result = _proskillservice.GetAll().Data.Where(d => d.SkillName.Contains(skill.SkillName)).ToList();
foreach (var projectSkillse in result)
{
var result2 = _postservice.GetByID(projectSkillse.PostId);
var select = _selectedWorkerService.GetAll().Data.Where(d => d.PostId == result2.Data.PostId).ToList();
if (select.Count != result2.Data.Members)
{
projectListModel.PostAProjects.Add(result2.Data);
}
}
var result3 = _skillservice.GetAll();
projectListModel.Skills = result3.Data;
return(View(projectListModel));
}
public ProjectListModel PreaperProjectListModel(ProjectSearchModel projectSearchModel)
{
var projects = _projectService.SearchProjects(published: projectSearchModel.PublishId,
name: projectSearchModel.Name,
shortDescription: projectSearchModel.ShortDescription);
var model = new ProjectListModel().PrepareToGrid(projectSearchModel, projects, () =>
{
return(projects.Select(p =>
{
var projectModel = GetModelFromProject(p);
projectModel.FullDescription = null;
projectModel.SeName = _urlRecordService.GetSeName(p);
return projectModel;
}));
});
return(model);
}
public ActionResult Index(
string createdDate,
string isActive,
string isArchived,
string modifiedDate,
string projectName)
{
var model = new ProjectListModel();
var criteria =
new ProjectDataCriteria
{
CreatedDate = CriteriaHelper.ToDateRangeCriteria(createdDate),
IsActive = CriteriaHelper.ToBoolean(isActive),
IsArchived = CriteriaHelper.ToBoolean(isArchived),
Name = projectName,
ModifiedDate = CriteriaHelper.ToDateRangeCriteria(modifiedDate)
};
var projects = ProjectRepository.ProjectFetchInfoList(criteria);
model.Projects = projects;
var stories = StoryRepository.StoryFetchInfoList(projects.ToArray(), false);
model.Stories = stories;
var timelines = TimelineRepository.TimelineFetchInfoList(
projects.Select(row => row.ProjectId).Distinct().ToArray(), SourceType.Project);
model.Timelines = timelines;
var sprints = SprintRepository.SprintFetchInfoList(projects.ToArray(), false);
model.Sprints = sprints;
model.Actions.Add("Add a project", Url.Action("Create"), "primary");
return(this.View(model));
}
public void TestProjectController_ProjectsDelete(string httpMethod)
{
SetUpProjectControllerForTesting(httpMethod);
projectController.CurrentUser = user;
List <long> _projectIds = this.db.Context.Projects.Where(p => p.OwnerId == user.UserId && p.Name.Contains("AA")).Select(p => p.ProjectId).Take(3).ToList();
ProjectsModel model = new ProjectsModel();
PagedList <ProjectListModel> items = new PagedList <ProjectListModel>();
foreach (long projectId in _projectIds)
{
ProjectListModel item = new ProjectListModel();
item.ProjectId = projectId;
items.Add(item);
}
model.Items = items;
projectController.ViewData["PageMessages"] = new Messages();
projectController.ViewData["KeyMessages"] = new Messages();
FormCollection collection = new FormCollection();
for (int i = 0; i < model.Items.Count; i++)
{
collection[model.Items[i].ProjectId.ToString()] = model.Items[i].ProjectId.ToString();
}
ViewResult result = projectController.ProjectsDelete(model, collection) as ViewResult;
Assert.That(this.response.HasError, Is.EqualTo(false));
Assert.That(result, Is.Not.EqualTo(null));
Assert.That(result.ViewName, Is.EqualTo("Projects"));
}
public ActionResult List(GridCommand command, ProjectListModel model)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageNews))
return AccessDeniedView();
var projects = _projectService.GetAllProjects(model.SearchProjectName,pageIndex: command.Page - 1,pageSize: command.PageSize);
var gridModel = new GridModel<ProjectModel>
{
Data = projects.Select(x =>
{
var m = x.ToModel();
m.CreatedOn = _dateTimeHelper.ConvertToUserTime(x.CreatedOnUtc, DateTimeKind.Utc);
return m;
}),
Total = projects.TotalCount
};
return new JsonResult
{
Data = gridModel
};
}
public ActionResult List()
{
var model = new ProjectListModel();
return View(model);
}
public ActionResult SuccessfulProjects()
{
ProjectListModel model = service.GetProjects();
return(View(model));
}
public int CreateNewProject(ProjectListModel project)
{
string sQuery = "INSERT INTO dbo.ProjectList VALUES (@ProjectName); ";
return(_data.SaveData(sQuery, project, _connection.ConnectionStringName));
}
public IActionResult CreateProject(ProjectListModel project)
{
return(Ok(_project.CreateNewProject(project)));
}
public ActionResult ProjectList(ProjectSearchModel searchModel)
{
var data = _projectService.GetGridAll().ToList();
var model = new ProjectListModel();
model.Data = data;
model.Total = data.Count;
model.Errors = "";
return(Json(model));
//try
//{
// // Initialization.
// string search = Request.Form["search[value]"][0];
// string draw = Request.Form["draw"][0];
// string order = Request.Form["order[0][column]"][0];
// string orderDir = Request.Form["order[0][dir]"][0];
// int startRec = Convert.ToInt32(Request.Form["start"][0]);
// int pageSize = Convert.ToInt32(Request.Form["length"][0]);
// _logger.LogInformation("Call GetGridAll()");
// // Loading.
// List<ProjectGridViewModel> data = _projectService.GetGridAll().ToList();
// // Total record count.
// int totalRecords = data.Count;
// // Verification.
// //if (!string.IsNullOrEmpty(search) &&
// // !string.IsNullOrWhiteSpace(search))
// //{
// // // Apply search
// // data = data.Where(p => p.sr.ToString().ToLower().Contains(search.ToLower()) ||
// // p.ordertracknumber.ToLower().Contains(search.ToLower()) ||
// // p.quantity.ToString().ToLower().Contains(search.ToLower()) ||
// // p.productname.ToLower().Contains(search.ToLower()) ||
// // p.specialoffer.ToLower().Contains(search.ToLower()) ||
// // p.unitprice.ToString().ToLower().Contains(search.ToLower()) ||
// // p.unitpricediscount.ToString().ToLower().Contains(search.ToLower())).ToList();
// //}
// // Sorting.
// //data = this.SortByColumnWithOrder(order, orderDir, data);
// // Filter record count.
// int recFilter = data.Count;
// // Apply pagination.
// data = data.Skip(startRec).Take(pageSize).ToList();
// // Loading drop down lists.
// var result = this.Json(new { draw = Convert.ToInt32(draw), recordsTotal = totalRecords, recordsFiltered = recFilter, data = data });
// return result;
//}
//catch (Exception ex)
//{
// // Info
// Console.Write(ex);
// return null;
//}
}
