/// <summary>
/// برای نمایش جدولی نماها در تنظیمات
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public GetQueriesResponse GetQueries(AjaxGetRequest request)
{
GetQueriesResponse response = new GetQueriesResponse();
try
{
int index = (request.PageNumber - 1) * request.PageSize;
int count = request.PageSize;
Infrastructure.Domain.Response <Query> querysResponse = _queryRepository
.FindAll(index, count);
IEnumerable <QueryView> querys = querysResponse.data
.ConvertToQueryViews().OrderBy(o => o.CreateDate);
response.QueryViews = querys;
response.TotalCount = querysResponse.totalCount;
}
catch (Exception ex)
{
throw;
}
return(response);
}
public JsonResult MainMenuItems_Read(string parentMenuName)
{
MainMenusGetRequest request = new MainMenusGetRequest();
request.ParentMenuName = parentMenuName;
request.EmployeeID = GetEmployee().ID;
GetMainMenusResponse mainMenus = new GetMainMenusResponse();
if (request.ParentMenuName != "CustomersView")
{
mainMenus = _mainMenuService.GetMainMenus(request);
mainMenus.success = true;
}
// لینک منوی مشتریان
else
{
IList <MainMenuView> mainMenuView = new List <MainMenuView>();
// Get queries from database
GetQueriesResponse queriesResponse = this._queryService.GetQueries(new GetQueriesRequest()
{
EmployeeID = GetEmployee().ID
});
// prepare data to send to client
if (queriesResponse != null && queriesResponse.QueryViews != null)
{
foreach (var query in queriesResponse.QueryViews)
{
mainMenuView.Add(new MainMenuView()
{
SubmenuName = query.Title,
SubmenuUrl = "Customer/Customers_Read?queryID=" + query.ID.ToString(),
xType = query.xType,
Icon = "Content/images/fam/customers.png",
ID = query.ID,
columns = new ColumnViews(query.Columns),
PreLoad = query.PreLoad,
CustomerCount = query.CustomerCount
});
}
}
mainMenus.data = mainMenuView;
mainMenus.success = true;
mainMenus.TotalCount = queriesResponse.TotalCount;
}
return(Json(mainMenus, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// برای بدست آوردن لینک کوئریها
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public GetQueriesResponse GetQueries(GetQueriesRequest request)
{
GetQueriesResponse response = new GetQueriesResponse();
try
{
// current Employee
Employee currentEmployee = _employeeRepository.FindBy(request.EmployeeID);
// All Queries
IEnumerable <Query> queries = _queryRepository.FindAll().ToList();
// Output List
IList <Query> outPutQueries = new List <Query>();
// اگر مشتری اجازه رویت ندارد از لیست حذف شود
foreach (var query in queries)
{
if (currentEmployee.CanView(query))
{
outPutQueries.Add(query);
}
}
IEnumerable <QueryView> queryViews = outPutQueries
.ConvertToQueryViews().OrderBy(o => o.CreateDate);
response.QueryViews = queryViews;
response.TotalCount = queryViews.Count();
}
catch (Exception ex)
{
throw;
}
return(response);
}
public ActionResult Query_Read([DataSourceRequest] DataSourceRequest request)
{
GetQueriesResponse queryResponse = new GetQueriesResponse();
#region Access Check
bool hasPermission = GetEmployee().IsGuaranteed("Query_Read");
if (!hasPermission)
{
var _result = new DataSourceResult()
{
Data = queryResponse.QueryViews,
Total = queryResponse.TotalCount
};
ModelState.AddModelError("", "AccessDenied");
return(Json(_result));
}
#endregion
QueryHomePageView queryHomePageView = new QueryHomePageView();
queryHomePageView.EmployeeView = GetEmployee();
AjaxGetRequest getRequest = new AjaxGetRequest();
getRequest.PageSize = request.PageSize == 0 ? 10 : request.PageSize;
getRequest.PageNumber = request.Page;
queryResponse = this._queryService.GetQueries(getRequest);
queryHomePageView.QueryViews = queryResponse.QueryViews;
queryHomePageView.Count = queryResponse.TotalCount;
var result = new DataSourceResult()
{
Data = queryResponse.QueryViews,
Total = queryResponse.TotalCount
};
return(Json(result));
}
protected JsonResult CustomerQueryLinks_Read()
{
IList <MainMenuView> mainMenuView = new List <MainMenuView>();
#region Access Check
bool hasPermission = GetEmployee().IsGuaranteed("Query_Read");
if (!hasPermission)
{
ModelState.AddModelError("", "AccessDenied");
return(Json(mainMenuView, JsonRequestBehavior.AllowGet));
}
#endregion
GetQueriesResponse queriesResponse = this._queryService.GetQueries(new GetQueriesRequest()
{
EmployeeID = GetEmployee().ID
});
if (queriesResponse != null && queriesResponse.QueryViews != null)
{
foreach (var query in queriesResponse.QueryViews)
{
mainMenuView.Add(new MainMenuView()
{
SubmenuName = query.Title,
SubmenuUrl = "Customer/Query/" + query.ID.ToString(),
xType = "",
Icon = "",
ID = query.ID
});
}
}
return(Json(mainMenuView, JsonRequestBehavior.AllowGet));
}
