public JsonResult DataTableAjaxHandler(DataTableRequestModel requestModel)
{
StudentApprovalClientDataTable dataTable = new StudentApprovalClientDataTable(Request);
DataTableResultModel viewModel = LogicManager.GenerateApprovalDataTableResultViewModel(requestModel, dataTable);
return(Json(viewModel, JsonRequestBehavior.AllowGet));
}
private static void AssertDataTableResultModel(DataTableResultModel expected, DataTableResultModel actual)
{
Assert.AreEqual(expected.sEcho, actual.sEcho);
Assert.AreEqual(expected.iTotalDisplayRecords, actual.iTotalDisplayRecords);
Assert.AreEqual(expected.iTotalRecords, actual.iTotalRecords);
actual.aaData.Cast <string[]>().ToList().AssertItemsEqual(expected.aaData.Cast <string[]>().ToList());
}
public async Task <DataTableResultModel <OrderViewModel> > GetOrderList(DTParameterModel criteria, string mobileNumber = "")
{
try
{
DataTableResultModel <OrderViewModel> orderlist = new DataTableResultModel <OrderViewModel>();
int totalCount = 0;
List <OrderViewModel> list = (this.unitOfWork.Shop_Order_DetailsRepository.GetAllList(out totalCount, this.OrderBuildWhereFilter(criteria), this.OrderBuildOrderByFilter(criteria), true, criteria.Start != 0 ? criteria.Start / criteria.Length : 0, criteria.Length, "")).Where(x => x.retailer_mobile == mobileNumber).Select <Shop_Order_Details, OrderViewModel>((Func <Shop_Order_Details, OrderViewModel>)(x =>
{
OrderViewModel orderViewModel = new OrderViewModel();
orderViewModel.Order_Id = x.order_id == 0 ? 0 : x.order_id;
orderViewModel.retailer_mobile = x.retailer_mobile;
orderViewModel.Totalprice = x.Totalprice;
orderViewModel.payment_mode = x.payment_mode;
orderViewModel.order_status = x.order_status;
orderViewModel.orderDate = x.orderDate.ToString();
//orderViewModel.IsActive = Convert.ToBoolean(x.IsActive);
//orderViewModel.ResourceKey = Resource.LegalResource_Common_Edit + " " + Resource.LegalResource_Common_State;
return(orderViewModel);
})).ToList <OrderViewModel>();
orderlist.recordsTotal = totalCount;
orderlist.recordsFiltered = totalCount;
orderlist.sEcho = Convert.ToInt32(criteria.Draw);
orderlist.data = list;
return(orderlist);
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <JsonResult> GetDesignationList()
{
DataTableResultModel <DesignationModel> resultModel = await _designation.GetDesignationList();
return(await Task.Run(() =>
{
return Json(new { draw = 1, data = resultModel.ResultList });
}));
}
public async Task <JsonResult> GetUnitOfMeasurementList()
{
DataTableResultModel <UnitOfMeasurementModel> resultModel = await _unitOfMeasurement.GetUnitOfMeasurementList();
return(await Task.Run(() =>
{
return Json(new { draw = 1, data = resultModel.ResultList });
}));
}
public async Task <JsonResult> GetCompanyList()
{
DataTableResultModel <CompanyModel> resultModel = await _company.GetCompanyList();
return(await Task.Run(() =>
{
return Json(new { draw = 1, data = resultModel.ResultList });
}));
}
public async Task <JsonResult> GetFormList()
{
DataTableResultModel <FormModel> resultModel = await _form.GetFormList();
return(await Task.Run(() =>
{
return Json(new { draw = 1, data = resultModel.ResultList });
}));
}
public async Task <JsonResult> GetStateList()
{
DataTableResultModel <StateModel> resultModel = await _state.GetStateList();
return(await Task.Run(() =>
{
return Json(new { draw = 1, data = resultModel.ResultList });
}));
}
public async Task <JsonResult> GetVoucherSetupDetailList()
{
DataTableResultModel <VoucherSetupDetailModel> resultModel = await _voucherSetupDetail.GetVoucherSetupDetailList();
return(await Task.Run(() =>
{
return Json(new { draw = 1, data = resultModel.ResultList });
}));
}
public async Task <JsonResult> GetFinancialYearList()
{
DataTableResultModel <FinancialYearModel> resultModel = await _financialYear.GetFinancialYearList();
return(await Task.Run(() =>
{
return Json(new { draw = 1, data = resultModel.ResultList });
}));
}
public void GivenLogicManagerGeneratesViewModel_WhenDataTableAjaxHandler_ThenJsonResultContainsViewModel()
{
var request = new DataTableRequestModel();
var expected = new DataTableResultModel();
MockLogicManager.Expect(m => m.GenerateDataTableResultViewModel(Arg.Is(request), Arg <IClientDataTable <Program> > .Is.NotNull)).Return(expected);
JsonResult result = Target.DataTableAjaxHandler(request);
result.AssertGetData(expected);
}
public async Task <DataTableResultModel <TaskModel> > GetTasksAsync(int categoryId, jQueryDataTableParamModel param)
{
DataTableResultModel <TaskModel> model = new DataTableResultModel <TaskModel>();
using (var db = new DAL.ThingsToDoAppContext())
{
var query = categoryId != 0 ?
db.Tasks.Include(x => x.Category).Where(x => x.CategoryId == categoryId && !x.FinishedDate.HasValue).AsNoTracking()
: db.Tasks.Include(x => x.Category).AsNoTracking();
model.recordsTotal = await query.CountAsync();
var sortColumnIndex = param.iSortCol_0;
var sortDirection = param.sSortDir_0;
switch (sortColumnIndex)
{
case 1:
query = query.OrderByDirection(x => x.Description, sortDirection);
break;
default:
query = query.OrderByDirection(x => x.Title, sortDirection);
break;
}
if (!string.IsNullOrEmpty(param.sSearch))
{
string searchTerm = param.sSearch.ToLower();
query = query.Where(x => x.Title.ToLower().Contains(searchTerm) || x.Description.ToLower().Contains(searchTerm));
}
model.recordsFiltered = await query.CountAsync();
var entities = await query.Skip(param.iDisplayStart).Take(param.iDisplayLength).ToListAsync();
if (entities.Any())
{
model.data = entities.Select(x => new TaskModel
{
Id = x.Id,
Title = x.Title,
Description = x.Description,
CategoryName = x.Category.Title,
Priority = x.Priority,
FromDate = x.FromDate,
ToDataTableToDateFormat = x.ToDate.ToString("dd/MM/yyyy"),
ToDate = x.ToDate
}).ToList();
}
model.sEcho = param.sEcho;
}
return(model);
}
public void GivenAProvider_WhenGettingTableData_ThenJsonResultContainsViewModelFromLogicManager()
{
var request = new DataTableRequestModel();
var expected = new DataTableResultModel();
MockLogicManager.Expect(m => m.GenerateDataTableResultViewModel(Arg.Is(request), Arg <IClientDataTable <Provider> > .Is.NotNull)).Return(expected);
var result = Target.DataTableAjaxHandler(request) as JsonResult;
result.AssertGetData(expected);
}
public void WhenDataTableAjaxHandler_ThenJsonContainsGeneratedViewModel()
{
DataTableRequestModel model = new DataTableRequestModel();
DataTableResultModel expected = new DataTableResultModel();
MockLogicManager.Expect(m => m.GenerateDataTableResultViewModel(Arg.Is(model), Arg <IClientDataTable <ServiceOffering> > .Is.NotNull)).Return(expected);
JsonResult result = Target.DataTableAjaxHandler(model);
result.AssertGetData(expected);
}
public void WhenGetDataTableAjaxHandler_ThenReturnGeneratedViewModel()
{
DataTableRequestModel model = new DataTableRequestModel();
DataTableResultModel expected = new DataTableResultModel();
MockLogicManager.Expect(m => m.GenerateApprovalDataTableResultViewModel(Arg.Is(model), Arg <IClientDataTable <Student> > .Is.NotNull)).Return(expected);
JsonResult result = Target.DataTableAjaxHandler(model);
result.AssertGetData(expected);
}
public void WhenRequestDataTableAjaxHandler_ThenGenerateListViewModelReceivesCorrectDataTableRequest_AndResultPassedToJson()
{
DataTableResultModel expected = new DataTableResultModel();
DataTableRequestModel requestModel = new DataTableRequestModel();
MockAccountManager.Expect(m => m.GenerateDataTableResultViewModel(Arg.Is(requestModel), Arg <IClientDataTable <User> > .Is.NotNull)).Return(expected);
JsonResult result = Target.DataTableAjaxHandler(requestModel);
result.AssertGetData(expected);
}
public void GivenAPublicField_WhenGettingTableData_ThenActionColumnDataContainsIdAndName()
{
var request = new DataTableRequestModel();
var expected = new DataTableResultModel();
MockLogicManager.Expect(m => m.GenerateDataTableResultViewModel(Arg.Is(request), Arg <IClientDataTable <CustomField> > .Is.NotNull)).Return(expected);
var result = Target.DataTableAjaxHandler(request) as JsonResult;
result.AssertGetData(expected);
}
public void WhenGenerateDataTableResultViewModel_ThenViewModelContainsData()
{
HttpContextBase mockHttpContext = MockHttpContextFactory.Create();
DataTableRequestModel viewModel = new DataTableRequestModel {
iDisplayLength = 10
};
UserClientDataTable dataTable = new UserClientDataTable(mockHttpContext.Request, new DefaultSecurityConfiguration());
DataTableResultModel actual = Target.GenerateDataTableResultViewModel(viewModel, dataTable);
Assert.AreNotEqual(0, actual.aaData.Count());
}
public void GivenBinderCreatesResult_WhenGenerateDataTableResultViewModel_ThenReturnBindResult()
{
DataTableResultModel expected = new DataTableResultModel();
DataTableRequestModel requestModel = new DataTableRequestModel();
IClientDataTable <CustomField> dataTable = MockRepository.GenerateMock <IClientDataTable <CustomField> >();
MockDataTableBinder.Expect(m => m.Bind(Arg <IQueryable <CustomField> > .List.ContainsAll(Repositories.MockCustomFieldRepository.Items.OfType <PrivateHealthField>()), Arg.Is(dataTable), Arg.Is(requestModel))).Return(expected);
DataTableResultModel actual = Target.GenerateDataTableResultViewModel(requestModel, dataTable);
Assert.AreEqual(expected, actual);
}
public void WhenDataTableAjaxHandler_ThenReturnViewModelFromLogicManager()
{
DataTableRequestModel model = new DataTableRequestModel();
var expected = new DataTableResultModel();
MockLogicManager.Expect(m => m.GenerateDataTableResultViewModel(Arg.Is(model), Arg <IClientDataTable <Student> > .Is.NotNull)).Return(expected);
MockLogicManager.Expect(m => m.FindStudentProperties()).Return(Enumerable.Empty <Property>().ToList());
var result = Target.DataTableAjaxHandler(model);
result.AssertGetData(expected);
}
public void GivenBinderCreatesResult_WhenGenerateDataTableResultViewModel_ThenReturnBindResult()
{
DataTableResultModel expected = new DataTableResultModel();
DataTableRequestModel requestModel = new DataTableRequestModel();
IClientDataTable <Student> dataTable = MockRepository.GenerateMock <IClientDataTable <Student> >();
MockDataTableBinder.Expect(m => m.Bind(Repositories.MockStudentRepository.Items, dataTable, requestModel)).Return(expected);
DataTableResultModel actual = Target.GenerateDataTableResultViewModel(requestModel, dataTable);
Assert.AreEqual(expected, actual);
}
public void GivenBinderCreatesResult_WhenGenerateDataTableResultViewModel_ThenReturnBindResult()
{
DataTableResultModel expected = new DataTableResultModel();
DataTableRequestModel requestModel = new DataTableRequestModel();
IClientDataTable <Provider> dataTable = MockRepository.GenerateMock <IClientDataTable <Provider> >();
var expectedQuery = Data.Providers.Where(p => p.IsActive);
MockDataTableBinder.Expect(m => m.Bind(Arg <IQueryable <Provider> > .Matches(p => p.Where(pr => pr.IsActive).SequenceEqual(expectedQuery)), Arg.Is(dataTable), Arg.Is(requestModel))).Return(expected);
DataTableResultModel actual = Target.GenerateDataTableResultViewModel(requestModel, dataTable);
Assert.AreEqual(expected, actual);
}
public JsonResult GetProject(int length = 0, int draw = 0, int start = 0, search search = null, List <order> order = null)
{
int PageNumber = start / length + 1;
GetAllProjectsModel model = new GetAllProjectsModel()
{
PageNumber = PageNumber, PageSize = length
};
if (!string.IsNullOrEmpty(search.value))
{
model.projecttitle = search.value;
}
List <AllProjectsModel> GetProjects = new List <AllProjectsModel>();
var serialized = new JavaScriptSerializer().Serialize(model);
var client = new HttpClient();
var content = new StringContent(serialized, System.Text.Encoding.UTF8, "application/json");
client.BaseAddress = new Uri(HttpContext.Request.Url.AbsoluteUri);
var result = client.PostAsync(BaseURL + "/api/Project/GetProjectsByStatus", content).Result;
if (result.StatusCode == HttpStatusCode.OK)
{
var contents = result.Content.ReadAsStringAsync().Result;
GetProjects = new JavaScriptSerializer().Deserialize <List <AllProjectsModel> >(contents);
}
var resultSet = new DataTableResultModel();
resultSet.draw = draw;
resultSet.recordsTotal = GetProjects.Count() > 0 ? GetProjects.First().TotalRecords : 0;
resultSet.recordsFiltered = GetProjects.Count() > 0 ? GetProjects.First().TotalRecords : 0;
foreach (var recordFromDb in GetProjects)
{
var columns = new List <string>();
columns.Add(recordFromDb.TypeName);
columns.Add(recordFromDb.ProjectTitle);
columns.Add(string.IsNullOrEmpty(recordFromDb.StartDate) ? "NA" : DateTime.ParseExact(recordFromDb.StartDate, new[] { "yyyy-MM-dd", "yyyy/MM/dd" }, CultureInfo.InvariantCulture, DateTimeStyles.None).ToString("dd-MMM-yyyy"));
columns.Add(string.IsNullOrEmpty(recordFromDb.EndDate) ? "NA" : DateTime.ParseExact(recordFromDb.EndDate, new[] { "yyyy-MM-dd", "yyyy/MM/dd" }, CultureInfo.InvariantCulture, DateTimeStyles.None).ToString("dd-MMM-yyyy"));
columns.Add("<span class='label label-success'>" + recordFromDb.ProjectStatus + "</span>");
columns.Add((string.IsNullOrEmpty(recordFromDb.ProjectUrl) ? "NA" : recordFromDb.ProjectUrl));
columns.Add("<a href='/Project/ProjectAddendumDetails?ProjectId=" + recordFromDb.ProjectId + "'>Addendums Details</a>");
columns.Add("<a title='edit' class='btn green-dark' href='/Project/AddUpdateProject?ProjectId=" + recordFromDb.ProjectId + "'><i class='fa fa-edit'></i></a>");
columns.Add("<a href='/Project/UpdateProjectStatus?ProjectId=" + recordFromDb.ProjectId + "'>Update Status</a>");
columns.Add("<a href='javascript:' onclick='confirm(" + recordFromDb.ProjectId + ")' title='Click here to Archive' style='font-size:20px'><i class='fa fa-archive'></i></a>");
resultSet.data.Add(columns);
}
return(Json(resultSet, JsonRequestBehavior.AllowGet));
}
public async Task <JsonResult> GetSalesInvoiceTaxMasterList(int invoiceId)
{
DataTableResultModel <SalesInvoiceTaxModel> resultModel = await _salesInvoiceTax.GetSalesInvoiceTaxBySalesInvoiceId(invoiceId);
return(await Task.Run(() =>
{
return Json(new
{
draw = "1",
recordsTotal = resultModel.TotalResultCount,
data = resultModel.ResultList
});
}));
}
public void GivenStudentsWithSchools_WhenGettingDataTableAjaxHandler_ThenDataTableStateContainsColumns()
{
MockHttpContext.Request.Expect(m => m["iSortCol_0"]).Return("0");
MockHttpContext.Request.Expect(m => m["sSortDir_0"]).Return("asc");
DataTableRequestModel request = new DataTableRequestModel {
iDisplayLength = 10
};
JsonResult result = Target.DataTableAjaxHandler(request) as JsonResult;
DataTableResultModel actual = result.AssertGetData <DataTableResultModel>();
Assert.IsTrue(actual.aaData.Any());
}
public async Task <DataTableResultModel <ApplicationIdentityUserModel> > GetApplicationIdentityUserList()
{
DataTableResultModel <ApplicationIdentityUserModel> resultModel = new DataTableResultModel <ApplicationIdentityUserModel>();
IList <ApplicationIdentityUserModel> applicationIdentityUserModelList = await GetApplicationIdentityUserList(0, "");
if (null != applicationIdentityUserModelList && applicationIdentityUserModelList.Any())
{
resultModel = new DataTableResultModel <ApplicationIdentityUserModel>();
resultModel.ResultList = applicationIdentityUserModelList;
resultModel.TotalResultCount = applicationIdentityUserModelList.Count();
}
return(resultModel); // returns.
}
public async Task <DataTableResultModel <EmployeeModel> > GetEmployeeList()
{
DataTableResultModel <EmployeeModel> resultModel = new DataTableResultModel <EmployeeModel>();
IList <EmployeeModel> employeeModelList = await GetEmployeeList(0);
if (null != employeeModelList && employeeModelList.Any())
{
resultModel = new DataTableResultModel <EmployeeModel>();
resultModel.ResultList = employeeModelList;
resultModel.TotalResultCount = employeeModelList.Count();
}
return(resultModel); // returns.
}
public async Task <DataTableResultModel <DepartmentModel> > GetDepartmentList()
{
DataTableResultModel <DepartmentModel> resultModel = new DataTableResultModel <DepartmentModel>();
IList <DepartmentModel> departmentModelList = await GetDepartmentList(0);
if (null != departmentModelList && departmentModelList.Any())
{
resultModel = new DataTableResultModel <DepartmentModel>();
resultModel.ResultList = departmentModelList;
resultModel.TotalResultCount = departmentModelList.Count();
}
return(resultModel); // returns.
}
public async Task <DataTableResultModel <StatusModel> > GetStatusList()
{
DataTableResultModel <StatusModel> resultModel = new DataTableResultModel <StatusModel>();
IList <StatusModel> statusModelList = await GetStatusList(0);
if (null != statusModelList && statusModelList.Any())
{
resultModel = new DataTableResultModel <StatusModel>();
resultModel.ResultList = statusModelList;
resultModel.TotalResultCount = statusModelList.Count();
}
return(resultModel); // returns.
}
public async Task <DataTableResultModel <PurchaseInvoiceTaxModel> > GetPurchaseInvoiceTaxList()
{
DataTableResultModel <PurchaseInvoiceTaxModel> resultModel = new DataTableResultModel <PurchaseInvoiceTaxModel>();
IList <PurchaseInvoiceTaxModel> purchaseInvoiceTaxModelList = await GetPurchaseInvoiceTaxList(0, 0);
if (null != purchaseInvoiceTaxModelList && purchaseInvoiceTaxModelList.Any())
{
resultModel = new DataTableResultModel <PurchaseInvoiceTaxModel>();
resultModel.ResultList = purchaseInvoiceTaxModelList;
resultModel.TotalResultCount = purchaseInvoiceTaxModelList.Count();
}
return(resultModel); // returns.
}
