public GetFiscalsResponse GetFiscalsCreatedOrConfirmedWithMe(AjaxGetRequest request, string employeeID)
{
GetFiscalsResponse response = new GetFiscalsResponse();
try
{
int index = (request.PageNumber - 1) * request.PageSize;
int count = request.PageSize;
string query = "From Fiscal Where CreateEmployee.ID = '" + employeeID + "' Or ConfirmEmployee.ID = '" + employeeID + "'";
Infrastructure.Domain.Response <Fiscal> fiscalsResponse = _fiscalRepository
.FindAll(query, index, count);
IEnumerable <FiscalView> fiscals = fiscalsResponse.data
.ConvertToFiscalViews();
response.FiscalViews = fiscals;
response.Count = fiscalsResponse.totalCount;
}
catch (Exception ex)
{
throw;
}
return(response);
}
public GetEmailsResponse GetEmails(AjaxGetRequest request, IList <Sort> sort)
{
GetEmailsResponse response = new GetEmailsResponse();
int pageNumber = request.PageNumber == 0 ? 1 : request.PageNumber;
int pageSize = request.PageSize == 0 ? 10 : request.PageSize;
int index = (pageNumber - 1) * pageSize;
int count = pageSize;
try
{
Infrastructure.Querying.Query query = new Infrastructure.Querying.Query();
Criterion criterion = new Criterion("Customer.ID", request.ID, CriteriaOperator.Equal);
query.Add(criterion);
Infrastructure.Domain.Response <Email> emailsResponse = _emailRepository.FindBy(query, index, count, sort);
IEnumerable <EmailView> emails = emailsResponse.data.ConvertToEmailViews();
response.EmailViews = emails;
response.TotalCount = emailsResponse.totalCount;
}
catch (Exception ex)
{
throw;
}
return(response);
}
public GetFiscalsResponse GetFiscalsOfCustomer(AjaxGetRequest request, Guid customerID)
{
GetFiscalsResponse response = new GetFiscalsResponse();
try
{
int index = (request.PageNumber - 1) * request.PageSize;
int count = request.PageSize;
Query query = new Query();
Criterion criteria = new Criterion("Customer.ID", customerID, CriteriaOperator.Equal);
query.Add(criteria);
Response <Fiscal> fiscalsResponse = _fiscalRepository.FindBy(query, index, count);
IEnumerable <FiscalView> fiscals = fiscalsResponse.data.ConvertToFiscalViews();
response.FiscalViews = fiscals;
response.Count = fiscalsResponse.totalCount;
}
catch (Exception ex)
{
throw;
}
return(response);
}
/// <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 Emails_Read(Guid customerID, int pageSize, int pageNumber, string sort)
{
GetEmailsResponse response = new GetEmailsResponse();
#region Check Access
bool hasPermission = GetEmployee().IsGuaranteed("Emails_Read");
if (!hasPermission)
{
ModelState.AddModelError("", "AccessDenied");
return(Json(response, JsonRequestBehavior.AllowGet));
}
#endregion
AjaxGetRequest request = new AjaxGetRequest()
{
ID = customerID,
PageNumber = pageNumber,
PageSize = pageSize
};
if (customerID != null)
{
response = _emailService.GetEmails(request, ConvertJsonToObject(sort));
}
return(Json(response, JsonRequestBehavior.AllowGet));
}
public GetGeneralResponse <IEnumerable <LevelView> > GetRelatedLevels(AjaxGetRequest request)
{
GetGeneralResponse <IEnumerable <LevelView> > response = new GetGeneralResponse <IEnumerable <LevelView> >();
Guid levelID = request.ID;
try
{
int index = (request.PageNumber - 1) * request.PageSize;
int count = request.PageSize;
Infrastructure.Domain.Response <Level> levelsResponse = _levelRepository
.FindAllWithSort(index, count, null);
IEnumerable <LevelView> levels = levelsResponse.data
//.Where(w => w.Level.ID == levelID)
.ConvertToLevelViews();
response.data = levels;
response.totalCount = levelsResponse.totalCount;
////response.success = true;
}
catch (Exception ex)
{
}
return(response);
}
// Added By zafari
public GetProductsResponse GetProducts(AjaxGetRequest request)
{
GetProductsResponse response = new GetProductsResponse();
try
{
int index = (request.PageNumber - 1) * request.PageSize;
int count = request.PageSize;
Infrastructure.Domain.Response <Product> productsResponse = _productRepository
.FindAll(index, count);
IEnumerable <ProductView> products = productsResponse.data
.ConvertToProductViews();
response.ProductViews = products;
response.Count = productsResponse.totalCount;
}
catch (Exception ex)
{
throw;
}
return(response);
}
public GetFiscalsResponse GetFiscalsCanConfirm(AjaxGetRequest request, string employeeID)
{
GetFiscalsResponse response = new GetFiscalsResponse();
try
{
int index = (request.PageNumber - 1) * request.PageSize;
int count = request.PageSize;
string query = "From Fiscal F Where '" + employeeID
+ "' In (Select M.Employee.ID From F.MoneyAccount.MoneyAccountEmployees M)"
+ " AND Confirm <> 2 AND Confirm <> 3";
Response <Fiscal> fiscalsResponse = _fiscalRepository
.FindAll(query, index, count);
IEnumerable <FiscalView> fiscals = fiscalsResponse.data
.ConvertToFiscalViews();
response.FiscalViews = fiscals;
response.Count = fiscalsResponse.totalCount;
}
catch (Exception ex)
{
throw;
}
return(response);
}
/// <summary>
/// بدست آوردن مراحل بعدی
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public GetGeneralResponse <IEnumerable <LevelView> > GetNextLevels(AjaxGetRequest request)
{
GetGeneralResponse <IEnumerable <LevelView> > response = new GetGeneralResponse <IEnumerable <LevelView> >();
Level currentLevel = new Level();
try
{
currentLevel = _levelRepository.FindBy(request.ID);
response.data = currentLevel.NextLevels().ConvertToLevelViews();
////response.success = true;
response.totalCount = currentLevel.NextLevels().Count();
}
catch (Exception ex)
{
return(response);
}
return(response);
}
public GetGeneralResponse <IEnumerable <LevelTypeView> > GetLevelTypes(AjaxGetRequest request)
{
GetGeneralResponse <IEnumerable <LevelTypeView> > response = new GetGeneralResponse <IEnumerable <LevelTypeView> >();
try
{
int index = (request.PageNumber - 1) * request.PageSize;
int count = request.PageSize;
Infrastructure.Domain.Response <LevelType> levelTypesResponse = _levelTypeRepository.FindAll(index, count);
response.data = levelTypesResponse.data.ConvertToLevelTypeViews();
response.totalCount = levelTypesResponse.totalCount;
}
catch (Exception ex)
{
throw;
}
return(response);
}
public GetGeneralResponse <IEnumerable <ConditionView> > GetConditions(AjaxGetRequest request)
{
GetGeneralResponse <IEnumerable <ConditionView> > response = new GetGeneralResponse <IEnumerable <ConditionView> >();
try
{
int index = (request.PageNumber - 1) * request.PageSize;
int count = request.PageSize;
Response <Condition> conditionsResponse = _conditionRepository.FindAll(index, count);
response.data = conditionsResponse.data.ConvertToConditionViews();
response.totalCount = conditionsResponse.totalCount;
}
catch (Exception ex)
{
throw;
}
return(response);
}
public ActionResult LevelType_Read([DataSourceRequest] DataSourceRequest request)
{
LevelTypeHomePageView levelTypeHomePageView = new LevelTypeHomePageView();
levelTypeHomePageView.EmployeeView = GetEmployee();
GetGeneralResponse <IEnumerable <LevelTypeView> > levelTypeResponse = new GetGeneralResponse <IEnumerable <LevelTypeView> >();
#region Access Check
bool hasPermission = GetEmployee().IsGuaranteed("LevelType_Read");
if (!hasPermission)
{
var _result = new DataSourceResult()
{
Data = levelTypeResponse.data,
Total = levelTypeResponse.totalCount
};
ModelState.AddModelError("", "AccessDenied");
return(Json(_result));
}
#endregion
AjaxGetRequest getRequest = new AjaxGetRequest();
getRequest.PageSize = request.PageSize == 0 ? 10 : request.PageSize;
getRequest.PageNumber = request.Page;
levelTypeResponse = this._levelTypeService.GetLevelTypes(getRequest);
levelTypeHomePageView.LevelTypeViews = levelTypeResponse.data;
levelTypeHomePageView.Count = levelTypeResponse.totalCount;
var result = new DataSourceResult()
{
Data = levelTypeResponse.data,
Total = levelTypeResponse.totalCount
};
return(Json(result));
}
public GetFiscalsResponse GetFiscals(AjaxGetRequest request)
{
GetFiscalsResponse response = new GetFiscalsResponse();
try
{
int index = (request.PageNumber - 1) * request.PageSize;
int count = request.PageSize;
Response <Fiscal> fiscalsResponse = _fiscalRepository.FindAll(index, count);
IEnumerable <FiscalView> fiscals = fiscalsResponse.data.ConvertToFiscalViews();
response.FiscalViews = fiscals;
response.Count = fiscalsResponse.totalCount;
}
catch (Exception ex)
{
throw;
}
return(response);
}
public GetStoresResponse GetStores(AjaxGetRequest request)
{
GetStoresResponse response = new GetStoresResponse();
try
{
int index = (request.PageNumber - 1) * request.PageSize;
int count = request.PageSize;
Infrastructure.Domain.Response <Store> storesResponse = _storeRepository.FindAll(index, count);
IEnumerable <StoreView> stores = storesResponse.data.ConvertToStoreViews();
response.StoreViews = stores;
response.Count = storesResponse.totalCount;
}
catch (Exception ex)
{
throw;
}
return(response);
}
public ActionResult Product_Read([DataSourceRequest] DataSourceRequest request)
{
ProductHomePageView productHomePageView = new ProductHomePageView();
productHomePageView.EmployeeView = GetEmployee();
#region Access Check
bool hasPermission = GetEmployee().IsGuaranteed("Product_Read");
if (!hasPermission)
{
GetProductsResponse temp = new GetProductsResponse();
var _result = new DataSourceResult()
{
Data = temp.ProductViews,
Total = temp.Count
};
ModelState.AddModelError("", "AccessDenied");
return(Json(_result));
}
#endregion
AjaxGetRequest getRequest = new AjaxGetRequest();
getRequest.PageSize = request.PageSize == 0 ? 10 : request.PageSize;
getRequest.PageNumber = request.Page;
GetProductsResponse productResponse = this._productService.GetProducts(getRequest);
productHomePageView.ProductViews = productResponse.ProductViews;
productHomePageView.Count = productResponse.Count;
var result = new DataSourceResult()
{
Data = productResponse.ProductViews,
Total = productResponse.Count
};
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult Store_Read([DataSourceRequest] DataSourceRequest request)
{
GetStoresResponse storeResponse = new GetStoresResponse();
StoreHomePageView storeHomePageView = new StoreHomePageView();
storeHomePageView.EmployeeView = GetEmployee();
#region Access Check
bool hasPermission = GetEmployee().IsGuaranteed("Store_Read");
if (!hasPermission)
{
var _result = new DataSourceResult()
{
Data = storeResponse.StoreViews,
Total = storeResponse.Count
};
ModelState.AddModelError("", "AccessDenied");
return(Json(_result));
}
#endregion
AjaxGetRequest getRequest = new AjaxGetRequest();
getRequest.PageSize = request.PageSize == 0 ? 10 : request.PageSize;
getRequest.PageNumber = request.Page;
storeResponse = this._storeService.GetStores(getRequest);
storeHomePageView.StoreViews = storeResponse.StoreViews;
storeHomePageView.Count = storeResponse.Count;
var result = new DataSourceResult()
{
Data = storeResponse.StoreViews,
Total = storeResponse.Count
};
return(Json(result));
}
public ActionResult Condition_Read([DataSourceRequest] DataSourceRequest request)
{
ConditionHomePageView conditionHomePageView = new ConditionHomePageView();
conditionHomePageView.EmployeeView = GetEmployee();
GetGeneralResponse <IEnumerable <ConditionView> > conditionResponse = new GetGeneralResponse <IEnumerable <ConditionView> >();
#region Access Check
bool hasPermission = GetEmployee().IsGuaranteed("Condition_Read");
if (!hasPermission)
{
ModelState.AddModelError("", "AccessDenied");
var _result = new DataSourceResult()
{
Data = conditionResponse.data,
Total = conditionResponse.totalCount
};
return(Json(_result));
}
#endregion
AjaxGetRequest getRequest = new AjaxGetRequest();
getRequest.PageSize = request.PageSize == 0 ? 10 : request.PageSize;
getRequest.PageNumber = request.Page;
conditionResponse = this._conditionService.GetConditions(getRequest);
conditionHomePageView.ConditionViews = conditionResponse.data;
conditionHomePageView.Count = conditionResponse.totalCount;
var result = new DataSourceResult()
{
Data = conditionResponse.data,
Total = conditionResponse.totalCount
};
return(Json(result));
}
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));
}
public ActionResult Index()
{
ProductHomePageView productHomePageView = new ProductHomePageView();
productHomePageView.EmployeeView = GetEmployee();
#region Access Check
bool hasPermission = GetEmployee().IsGuaranteed("Product_Read");
if (!hasPermission)
{
ModelState.AddModelError("", "AccessDenied");
return(View(productHomePageView));
}
#endregion
AjaxGetRequest getRequest = new AjaxGetRequest();
getRequest.PageSize = 10;
getRequest.PageNumber = 1;
GetProductsResponse productResponse = this._productService.GetProducts(getRequest);
//GetProductsResponse productResponse = this._productService.GetProducts();
productHomePageView.ProductViews = productResponse.ProductViews;
productHomePageView.Count = productResponse.Count;
DataSourceRequest request = new DataSourceRequest
{
PageSize = 10,
Page = 1
};
Product_Read(request);
return(View(productHomePageView));
}
public GetGeneralResponse <IEnumerable <LevelConditionView> > GetLevelConditions(AjaxGetRequest request)
{
GetGeneralResponse <IEnumerable <LevelConditionView> > response = new GetGeneralResponse <IEnumerable <LevelConditionView> >();
Response <LevelCondition> levelConditionsResponse = new Response <LevelCondition>();
try
{
int index = (request.PageNumber - 1) * request.PageSize;
int count = request.PageSize;
// if request.id is not null => Find By LevelID
if (request.ID != Guid.Empty)
{
Guid levelID = request.ID;
}
else
{
levelConditionsResponse = _levelConditionRepository.FindAll(index, count);
}
response.data = levelConditionsResponse.data.ConvertToLevelConditionViews();
response.totalCount = levelConditionsResponse.totalCount;
}
catch (Exception ex)
{
throw;
}
return(response);
}
