public GetGeneralResponse <IEnumerable <EmployeeView> > GetEmployeesByGroup(Guid GroupID, int pageSize, int pageNumber) { GetGeneralResponse <IEnumerable <EmployeeView> > response = new GetGeneralResponse <IEnumerable <EmployeeView> >(); try { int index = (pageNumber - 1) * pageSize; int count = pageSize; // By Hojjat Infrastructure.Querying.Query query = new Infrastructure.Querying.Query(); Criterion criteria = new Criterion("Group.ID", GroupID, CriteriaOperator.Equal); query.Add(criteria); // Response <Employee> employees = _employeeRepository.FindBy(query, index, count); response.data = employees.data.ConvertToEmployeeViews(); response.totalCount = employees.totalCount; } catch (Exception ex) { throw; } return(response); }
public GetGeneralResponse <IEnumerable <SuctionModeDetailview> > GetSuctionModeDetailBySuctionModeAll(Guid SuctionModeID, int pageSize, int pageNumber, IList <Sort> sort) { GetGeneralResponse <IEnumerable <SuctionModeDetailview> > response = new GetGeneralResponse <IEnumerable <SuctionModeDetailview> >(); try { int index = (pageNumber - 1) * pageSize; int count = pageSize; Infrastructure.Querying.Query query = new Infrastructure.Querying.Query(); if (SuctionModeID != Guid.Empty) { Criterion criteriasuctionModeID = new Criterion("SuctionMode.ID", SuctionModeID, CriteriaOperator.Equal); query.Add(criteriasuctionModeID); } Response <SuctionModeDetail> suctioModeDetailviews = _suctionModeDetailRepository.FindBy(query, index, count, sort); var temp = suctioModeDetailviews.data.Where(x => x.Discontinued != true); response.data = temp.ConvertToSuctionModeViews(); response.totalCount = temp.Count(); } catch (Exception ex) { response.ErrorMessages.Add(ex.Message); if (ex.InnerException != null) { response.ErrorMessages.Add(ex.InnerException.Message); } } return(response); }
public GetGeneralResponse <SupportDeliverServiceView> GetSupportDeliverService(Guid SupportID) { GetGeneralResponse <SupportDeliverServiceView> response = new GetGeneralResponse <SupportDeliverServiceView>(); try { Query query = new Query(); Criterion supportIDCriteria = new Criterion("Support.ID", SupportID, CriteriaOperator.Equal); query.Add(supportIDCriteria); SupportDeliverService supportDeliverService = _supportDeliverServiceRepository.FindBy(query).FirstOrDefault(); response.data = supportDeliverService.ConvertToSupportDeliverServiceView(); response.totalCount = 1; } catch (Exception ex) { response.ErrorMessages.Add(ex.Message); if (ex.InnerException != null) { response.ErrorMessages.Add(ex.InnerException.Message); } } return(response); }
public GetGeneralResponse <IEnumerable <CreditServiceView> > GetCreditServices(int pageSize, int pageNumber) { GetGeneralResponse <IEnumerable <CreditServiceView> > response = new GetGeneralResponse <IEnumerable <CreditServiceView> >(); try { int index = (pageNumber - 1) * pageSize; int count = pageSize; Response <CreditService> creditService = new Response <CreditService>(); creditService = _creditServiceRepository.FindAll(index, count); response.data = creditService.data.ConvertToCreditServiceViews(); response.totalCount = creditService.totalCount; } catch (Exception ex) { response.ErrorMessages.Add(ex.Message); if (ex.InnerException != null) { response.ErrorMessages.Add(ex.InnerException.Message); } } return(response); }
public GetGeneralResponse <IEnumerable <ProductLogView> > GetProductLogsByProductInStore(Guid ProductID, int PageSize, int PageNumber, IList <Sort> sort) { GetGeneralResponse <IEnumerable <ProductLogView> > response = new GetGeneralResponse <IEnumerable <ProductLogView> >(); try { int index = (PageNumber - 1) * PageSize; int count = PageSize; Infrastructure.Querying.Query query = new Infrastructure.Querying.Query(); Criterion criteriaproductID = new Criterion("Product.ID", ProductID, CriteriaOperator.Equal); query.Add(criteriaproductID); Response <ProductLog> productLoges = _productLogRepository.FindBy(query, index, count, sort); productLoges.data = productLoges.data.Where(x => x.Store != null); response.data = productLoges.data.ConvertToProductLogViews(); response.totalCount = productLoges.totalCount; } catch (Exception ex) { response.ErrorMessages.Add(ex.Message); if (ex.InnerException != null) { response.ErrorMessages.Add(ex.InnerException.Message); } } return(response); }
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); }
public GetGeneralResponse <IEnumerable <ProblemView> > GetProblems(Guid customerID, int pageSize, int pageNumber, IList <Sort> sort) { GetGeneralResponse <IEnumerable <ProblemView> > response = new GetGeneralResponse <IEnumerable <ProblemView> >(); try { int index = (pageNumber - 1) * pageSize; int count = pageSize; Infrastructure.Querying.Query query = new Infrastructure.Querying.Query(); Criterion criteria = new Criterion("Customer.ID", customerID, CriteriaOperator.Equal); query.Add(criteria); Response <Problem> problems = _problemRepository.FindBy(query, index, count, sort); response.data = problems.data.ConvertToProblemViews(); response.totalCount = problems.totalCount; } catch (Exception ex) { throw; } return(response); }
public GetGeneralResponse <IEnumerable <CampaignPaymentView> > GetCampaignPaymentsByAgent(int pageSize, int pageNumber, Guid CampaignAgentID) { GetGeneralResponse <IEnumerable <CampaignPaymentView> > response = new GetGeneralResponse <IEnumerable <CampaignPaymentView> >(); try { int index = (pageNumber - 1) * pageSize; int count = pageSize; Query query = new Query(); Criterion CampaignAgentIDCriteria = new Criterion("CampaignAgent.ID", CampaignAgentID, CriteriaOperator.Equal); query.Add(CampaignAgentIDCriteria); Response <CampaignPayment> campaignpaymentes = _campaignPaymentRepository.FindBy(query, index, count); response.data = campaignpaymentes.data.ConvertToCampaignPaymentViews(); response.totalCount = campaignpaymentes.totalCount; } catch (Exception ex) { response.ErrorMessages.Add(ex.Message); if (ex.InnerException != null) { response.ErrorMessages.Add(ex.InnerException.Message); } } return(response); }
public GetGeneralResponse <IEnumerable <FiscalView> > GetAllFiscals(int pageSize, int pageNumber, IList <Sort> sort, IList <FilterData> filter) { GetGeneralResponse <IEnumerable <FiscalView> > response = new GetGeneralResponse <IEnumerable <FiscalView> >(); try { int index = (pageNumber - 1) * pageSize; int count = pageSize; //foreach (var item in sort) //{ // if (item.SortColumn == "Balance") // item.SortColumn = "Customer.Balance"; //} string query = FilterUtilityService.GenerateFilterHQLQuery(filter, "Fiscal", sort); Response <Fiscal> fiscals = _fiscalRepository.FindAll(query, index, count); response.data = fiscals.data.ConvertToFiscalViews(); response.totalCount = fiscals.totalCount; } catch (Exception ex) { response.ErrorMessages.Add(ex.Message); if (ex.InnerException != null) { response.ErrorMessages.Add(ex.InnerException.Message); } } return(response); }
public GetGeneralResponse <IEnumerable <GetSuctionModeCost2View> > GetSuctionModeCostReport2(IList <FilterData> filter, IList <Sort> sort) { GetGeneralResponse <IEnumerable <GetSuctionModeCost2View> > response = new GetGeneralResponse <IEnumerable <GetSuctionModeCost2View> >(); string query = FilterUtilityService.GenerateFilterHQLQuery(filter, "CampaignPayment", sort); Response <CampaignPayment> campaignPayment = _campaignPaymentRepository.FindBy(query); var result = campaignPayment.data.GroupBy(l => l.CampaignAgent.ID) .Select(lg => new { ID = lg.Key, Sum = lg.Sum(x => x.Amount), CampaignAgent = lg.FirstOrDefault().CampaignAgent.CampaignAgentName, }); IList <GetSuctionModeCost2View> list = new List <GetSuctionModeCost2View>(); foreach (var item in result) { GetSuctionModeCost2View getSuctionModeCost1View = new GetSuctionModeCost2View(); getSuctionModeCost1View.ID = item.ID; getSuctionModeCost1View.CampaignAgentName = item.CampaignAgent; getSuctionModeCost1View.Amount = item.Sum; list.Add(getSuctionModeCost1View); } response.data = list; response.totalCount = list.Count(); return(response); }
public GetGeneralResponse <IEnumerable <GetcampaignAgents> > GetSuctionModeCostReport3(IList <FilterData> filter, IList <Sort> sort) { GetGeneralResponse <IEnumerable <GetcampaignAgents> > response = new GetGeneralResponse <IEnumerable <GetcampaignAgents> >(); string query = FilterUtilityService.GenerateFilterHQLQuery(filter, "CampaignPayment", sort); Response <CampaignPayment> campaignPayment = _campaignPaymentRepository.FindBy(query); IList <GetcampaignAgents> list = new List <GetcampaignAgents>(); foreach (var item in campaignPayment.data) { list.Add(new GetcampaignAgents() { PaymentDate = item.PaymentDate, SuctionModeDetailID = item.SuctionModeDetail.ID, SuctionModeID = item.SuctionModeDetail.SuctionMode.ID, SuctionMoedName = item.SuctionModeDetail.SuctionModeDetailName, SuctionModeDetailName = item.SuctionModeDetail.SuctionMode.SuctionModeName, Amount = item.Amount }); } response.data = list; response.totalCount = list.Count(); return(response); }
public GetGeneralResponse <IEnumerable <GetSuctionModeCost1View> > GetSuctionModeCostReport1(IList <FilterData> filter, IList <Sort> sort) { GetGeneralResponse <IEnumerable <GetSuctionModeCost1View> > response = new GetGeneralResponse <IEnumerable <GetSuctionModeCost1View> >(); string query = FilterUtilityService.GenerateFilterHQLQuery(filter, "CampaignPayment", sort); Response <CampaignPayment> campaignPayment = _campaignPaymentRepository.FindBy(query); IList <GetSuctionModeCost1View> list = new List <GetSuctionModeCost1View>(); foreach (var item in campaignPayment.data) { GetSuctionModeCost1View getSuctionModeCost1View = new GetSuctionModeCost1View(); getSuctionModeCost1View.CampaignAgentName = item.CampaignAgent.CampaignAgentName; getSuctionModeCost1View.Amount = item.Amount; getSuctionModeCost1View.SuctionModeDetailName = item.SuctionModeDetail.SuctionModeDetailName; getSuctionModeCost1View.SuctionModeName = item.SuctionModeDetail.SuctionMode.SuctionModeName; getSuctionModeCost1View.PaymentDate = item.PaymentDate; list.Add(getSuctionModeCost1View); } response.data = list; response.totalCount = list.Count(); return(response); }
//public JsonResult PersenceSupports_Read(Guid CustomerID, int? PageSize, int? PageNumber) //{ // GetGeneralResponse<IEnumerable<PersenceSupportView>> response = new GetGeneralResponse<IEnumerable<PersenceSupportView>>(); // #region Access Check // bool hasPermission = GetEmployee().IsGuaranteed("PersenceSupports_Read"); // if (!hasPermission) // { // response.ErrorMessages.Add("AccessDenied"); // return Json(response, JsonRequestBehavior.AllowGet); // } // #endregion // int _PageSize = PageSize == null ? -1 : (int)PageSize; // int _PageNumber = PageNumber == null ? -1 : (int)PageNumber; // response = _persenceSupportService.GetPersenceSupports(CustomerID, _PageSize, _PageNumber); // return Json(response, JsonRequestBehavior.AllowGet); //} /// <summary> /// خواندن تمام پشتیبانی های حضوری با قابلیت فیلتر سازی /// </summary> /// <param name="CreateEmployeeID"></param> /// <param name="CustomerID"></param> /// <param name="SupportType"></param> /// <param name="StartCreateDate"></param> /// <param name="EndCreateDate"></param> /// <param name="StartPlanDate"></param> /// <param name="EndPlanDate"></param> /// <param name="Installer"></param> /// <param name="Deliverd"></param> /// <param name="StartDeliverDate"></param> /// <param name="EndDeliverDate"></param> /// <param name="PageSize"></param> /// <param name="PageNumber"></param> /// <returns></returns> public JsonResult PersenceSupports_Read(Guid?CustomerID, Guid?CreateEmployeeID, int?SupportType, string StartCreateDate, string EndCreateDate, string StartPlanDate, string EndPlanDate, Guid?Installer, bool?Deliverd, string StartDeliverDate, string EndDeliverDate, int?PageSize, int?PageNumber, string sort) { GetGeneralResponse <IEnumerable <PersenceSupportView> > response = new GetGeneralResponse <IEnumerable <PersenceSupportView> >(); #region Access Check bool hasPermission = GetEmployee().IsGuaranteed("PersenceSupports_Read"); if (!hasPermission) { response.ErrorMessages.Add("AccessDenied"); return(Json(response, JsonRequestBehavior.AllowGet)); } #endregion ///ابتدای مقدار دهی به مقادیر ورودی CreateEmployeeID = CreateEmployeeID == null ? Guid.Empty : CreateEmployeeID; CustomerID = CustomerID == null ? Guid.Empty : CustomerID; SupportType = SupportType == null ? 0 : SupportType; Installer = Installer == null ? Guid.Empty : Installer; //انتهای مقدار دهی به مقادیر ورودی int _PageSize = PageSize == null ? -1 : (int)PageSize; int _PageNumber = PageNumber == null ? -1 : (int)PageNumber; response = _persenceSupportService.GetCustomizedPersenceSupports(CustomerID, CreateEmployeeID, SupportType, StartCreateDate, EndCreateDate, StartPlanDate, EndPlanDate, Installer, Deliverd, StartDeliverDate, EndDeliverDate, _PageSize, _PageNumber, ConvertJsonToObject(sort)); return(Json(response, JsonRequestBehavior.AllowGet)); }
public GetGeneralResponse <IEnumerable <LocalPhoneStoreView> > GetLocalPhoneStores(int pageSize, int pageNumber, IList <FilterData> filter, IList <Sort> sort) { var response = new GetGeneralResponse <IEnumerable <LocalPhoneStoreView> >(); try { int index = (pageNumber - 1) * pageSize; int count = pageSize; string query = FilterUtilityService.GenerateFilterHQLQuery(filter, "LocalPhoneStore", sort); Response <LocalPhoneStore> localPhoneStores = _localPhoneStoreRepository.FindAll(query, index, count); response.data = localPhoneStores.data.ConvertToLocalPhoneStoreViews(); response.totalCount = localPhoneStores.totalCount; } catch (Exception ex) { response.ErrorMessages.Add(ex.Message); if (ex.InnerException != null) { response.ErrorMessages.Add(ex.InnerException.Message); } } return(response); }
//Added By Zafari // برگرداند دسترسی های یک گروه public JsonResult Permissions_Test(Guid GroupID, int?pageSize, int?pageNumber) { GetGeneralResponse <IEnumerable <Permit> > response = new GetGeneralResponse <IEnumerable <Permit> >(); #region Check Access bool hasPermission = GetEmployee().IsGuaranteed("GroupPermission_Read"); if (!hasPermission) { ModelState.AddModelError("", "AccessDenied"); return(Json(response, JsonRequestBehavior.AllowGet)); } #endregion int PageSize = pageSize == null ? -1 : (int)pageSize; int PageNumber = pageNumber == null ? -1 : (int)pageNumber; int index = (PageNumber - 1) * PageSize; int count = PageSize; GroupView groupView = _groupService.GetGroup(new GetRequest() { ID = GroupID }).GroupView; response.data = count != -1 ? groupView.Permissions.Skip(index).Take(count) : groupView.Permissions; response.totalCount = groupView.Permissions.Count(); //.GroupBy(g => g.Permission.Group) return(Json(response.data, JsonRequestBehavior.AllowGet)); }
public GetGeneralResponse <FiscalView> GetFollowUpNumber(int FollowNumber) { GetGeneralResponse <FiscalView> response = new GetGeneralResponse <FiscalView>(); try { Infrastructure.Querying.Query query = new Query(); Criterion criteria = new Criterion("FollowNumber", FollowNumber, CriteriaOperator.Equal); query.Add(criteria); Fiscal fiscal = _fiscalRepository.FindBy(query).First(); response.data = fiscal.ConvertToFiscalView(); } catch (Exception ex) { response.ErrorMessages.Add(ex.Message); if (ex.InnerException != null) { response.ErrorMessages.Add(ex.InnerException.Message); } } return(response); }
public GetGeneralResponse <IEnumerable <ProductPriceView> > GetProductPrices(Guid ProductID, int pageSize, int pageNumber, IList <Sort> sort) { GetGeneralResponse <IEnumerable <ProductPriceView> > response = new GetGeneralResponse <IEnumerable <ProductPriceView> >(); int index = (pageNumber - 1) * pageSize; int count = pageSize; try { Infrastructure.Querying.Query query = new Infrastructure.Querying.Query(); if (ProductID != Guid.Empty) { Criterion criteriaProductID = new Criterion("Product.ID", ProductID, CriteriaOperator.Equal); query.Add(criteriaProductID); } Response <ProductPrice> productPrices = _productPriceRepository.FindBy(query, index, count, sort); response.data = productPrices.data.ConvertToProductPriceViews(); response.totalCount = productPrices.totalCount; } catch (Exception ex) { response.ErrorMessages.Add(ex.Message); if (ex.InnerException != null) { response.ErrorMessages.Add(ex.InnerException.Message); } } return(response); }
public JsonResult ToDos_ReferedEmployee_Read(Guid?CreateEmployeeID, Guid?ReferedEployeeID, Guid?CustomerID, int?Close, int?TaskStatusID, string StartDateRange, string EndDateRange, int?pageSize, int?pageNumber, string sort) { GetGeneralResponse <IEnumerable <ToDoView> > response = new GetGeneralResponse <IEnumerable <ToDoView> >(); EmployeeView employee = GetEmployee(); int PageSize = -1;// pageSize == null ? -1 : (int)pageSize; int PageNumber = pageNumber == null ? -1 : (int)pageNumber; Guid referedEmployeeID = ReferedEployeeID == null ?Guid.Empty : (Guid)ReferedEployeeID; Guid createEmployeeID = CreateEmployeeID == null?GetEmployee().ID : (Guid)CreateEmployeeID; Guid customerID = CustomerID == null ? Guid.Empty : (Guid)CustomerID; response = _toDoService.GetReferedEmployeeToDos(createEmployeeID, referedEmployeeID, Close, TaskStatusID, StartDateRange, EndDateRange, customerID, PageSize, PageNumber, ConvertJsonToObject(sort)); if (response.data != null) { foreach (var item in response.data) { if (item.CreateEmployeeID == employee.ID) { item.IsMine = true; } foreach (var _item in item.ToDoResults) { if (_item.ReferedEmployeeID == employee.ID) { _item.IsMine = true; } } } } return(Json(response, JsonRequestBehavior.AllowGet)); }
public GetGeneralResponse <IEnumerable <NoteView> > GetNotes(Guid customerID, int pageSize, int pageNumber) { GetGeneralResponse <IEnumerable <NoteView> > response = new GetGeneralResponse <IEnumerable <NoteView> >(); try { int index = (pageNumber - 1) * pageSize; int count = pageSize; Infrastructure.Querying.Query query = new Infrastructure.Querying.Query(); Criterion criteria = new Criterion("Customer.ID", customerID, CriteriaOperator.Equal); query.Add(criteria); Response <Note> notes = _noteRepository.FindBy(query, index, count); response.data = notes.data.ConvertToNoteViews(); response.totalCount = notes.totalCount; } catch (Exception ex) { } return(response); }
public GetGeneralResponse <IEnumerable <LocalPhoneView> > GetLocalPhones(int pageSize, int pageNumber, List <FilterData> filter, IList <Sort> sort) { GetGeneralResponse <IEnumerable <LocalPhoneView> > response = new GetGeneralResponse <IEnumerable <LocalPhoneView> >(); int index = (pageNumber - 1) * pageSize; int count = pageSize; Response <LocalPhone> localPhones = new Response <LocalPhone>(); string query = FilterUtilityService.GenerateFilterHQLQuery(filter, "LocalPhone", sort); if (count > 0) { localPhones = _localPhoneRepository.FindAll(query, index, count); } else { localPhones = _localPhoneRepository.FindAll(query); } response.data = localPhones.data.ConvertToLocalPhoneViews(); response.totalCount = localPhones.totalCount; return(response); }
public GetGeneralResponse <IEnumerable <CreditServiceView> > GetCreditServices(int pageSize, int pageNumber, IList <Sort> sort, IList <FilterData> filter) { GetGeneralResponse <IEnumerable <CreditServiceView> > response = new GetGeneralResponse <IEnumerable <CreditServiceView> >(); try { int index = (pageNumber - 1) * pageSize; int count = pageSize; string query = FilterUtilityService.GenerateFilterHQLQuery(filter, "CreditService", sort); Response <CreditService> creditService = new Response <CreditService>(); creditService = _creditServiceRepository.FindAll(query, index, count); response.data = creditService.data.ConvertToCreditServiceViews(); response.totalCount = creditService.totalCount; } catch (Exception ex) { response.ErrorMessages.Add(ex.Message); if (ex.InnerException != null) { response.ErrorMessages.Add(ex.InnerException.Message); } } return(response); }
public GetGeneralResponse <IEnumerable <NotificationView> > GetNotifications(IList <FilterData> filter, IList <Sort> sort, int pageSize, int pageNumber) { GetGeneralResponse <IEnumerable <NotificationView> > response = new GetGeneralResponse <IEnumerable <NotificationView> >(); try { int index = (pageNumber - 1) * pageSize; int count = pageSize; string query = FilterUtilityService.GenerateFilterHQLQuery(filter, "Notification", sort); Response <Notification> notifications = _notificationRepository.FindAll(query); response.data = notifications.data.ConvertToNotificationViews(); response.totalCount = notifications.totalCount; } catch (Exception ex) { response.ErrorMessages.Add(ex.Message); if (ex.InnerException != null) { response.ErrorMessages.Add(ex.InnerException.Message); } } return(response); }
public GetGeneralResponse <IEnumerable <ProductLogView> > GetProductLogs(int PageSize, int PageNumber) { GetGeneralResponse <IEnumerable <ProductLogView> > response = new GetGeneralResponse <IEnumerable <ProductLogView> >(); try { int index = (PageNumber - 1) * PageSize; int count = PageSize; Response <ProductLog> productLoges = _productLogRepository.FindAll(index, count); response.data = productLoges.data.ConvertToProductLogViews(); response.totalCount = productLoges.totalCount; } catch (Exception ex) { response.ErrorMessages.Add(ex.Message); if (ex.InnerException != null) { response.ErrorMessages.Add(ex.InnerException.Message); } } return(response); }
public GetGeneralResponse <IEnumerable <SupportStatusView> > GetAllSupportStatuses(int pageSize, int pageNumber) { GetGeneralResponse <IEnumerable <SupportStatusView> > response = new GetGeneralResponse <IEnumerable <SupportStatusView> >(); try { int index = (pageNumber - 1) * pageSize; int count = pageSize; Response <SupportStatus> supportStatuses = _supportStatusRepository.FindAll(index, count); response.data = supportStatuses.data.ConvertToSupportStatusViews(); response.totalCount = supportStatuses.totalCount; } catch (Exception ex) { response.ErrorMessages.Add(ex.Message); if (ex.InnerException != null) { response.ErrorMessages.Add(ex.InnerException.Message); } } return(response); }
public JsonResult Couriers_read(int?pageSize, int?pageNumber, IList <FilterData> filter, string sort) { GetGeneralResponse <IEnumerable <CourierView> > response = new GetGeneralResponse <IEnumerable <CourierView> >(); int PageNumber = pageNumber == null ? -1 : (int)pageNumber; int PageSize = pageSize == null ? -1 : (int)pageSize; #region Access Check and retrive data EmployeeView employee = GetEmployee(); bool hasPermission = employee.IsGuaranteed("Courier_CangeStatus"); if (hasPermission) { response = _courierService.GetAllCouriers(PageSize, PageNumber, filter, ConvertJsonToObject(sort)); } else { response = _courierService.GetAllCouriersByEmployee(PageSize, PageNumber, filter, ConvertJsonToObject(sort), employee.ID); } #endregion return(Json(response, JsonRequestBehavior.AllowGet)); }
public GetGeneralResponse <IEnumerable <SmsEmployeeView> > GetSmsEmployeeByOwner(Guid EmployeeID, int pageSize, int pageNumber) { GetGeneralResponse <IEnumerable <SmsEmployeeView> > response = new GetGeneralResponse <IEnumerable <SmsEmployeeView> >(); try { int index = (pageNumber - 1) * pageSize; int count = pageSize; Query query = new Query(); Criterion ctr = new Criterion("Employee.ID", EmployeeID, CriteriaOperator.Equal); query.Add(ctr); Response <SmsEmployee> smsEmployees = _smsEmployeeRepository.FindBy(query, index, count); response.data = smsEmployees.data.ConvertTosmsEmployeeViews(); response.totalCount = smsEmployees.totalCount; } catch (Exception ex) { response.ErrorMessages.Add(ex.Message); if (ex.InnerException != null) { response.ErrorMessages.Add(ex.InnerException.Message); } } return(response); }
public GetGeneralResponse <IEnumerable <ProductSaleDetailView> > GetProductSaleDetails_ByProductID(Guid productID) { GetGeneralResponse <IEnumerable <ProductSaleDetailView> > response = new GetGeneralResponse <IEnumerable <ProductSaleDetailView> >(); try { string hqlQuery = String.Format(@" Select sd From ProductSaleDetail sd Join sd.ProductPrice pp Join pp.Product p Where p.ID = '{0}'", productID); IEnumerable <ProductSaleDetail> productSaleDetails = _productSaleDetailRepository.FindBy(hqlQuery).data; if (productSaleDetails != null) { IEnumerable <ProductSaleDetailView> productSaleDetailView = productSaleDetails.ConvertToProductSaleDetailViews(); response.data = productSaleDetailView; } } catch (Exception ex) { response.ErrorMessages.Add(ex.Message); } return(response); }
public JsonResult Employees_Read_ByGroup(Guid GroupID, int?pageSize, int?pageNumber) { GetGeneralResponse <IEnumerable <SimpleEmployeeView> > response = new GetGeneralResponse <IEnumerable <SimpleEmployeeView> >(); GetGeneralResponse <IEnumerable <EmployeeView> > request = new GetGeneralResponse <IEnumerable <EmployeeView> >(); IList <SimpleEmployeeView> list = new List <SimpleEmployeeView>(); int PageNumber = pageNumber == null ? -1 : (int)pageNumber; int PageSize = pageSize == null ? -1 : (int)pageSize; request = _employeeService.GetEmployeesByGroup(GroupID, PageSize, PageNumber); foreach (EmployeeView employeeView in request.data) { if (!employeeView.Discontinued) { list.Add(new SimpleEmployeeView() { ID = employeeView.ID, EmployeeID = employeeView.ID, Name = employeeView.Name, GroupID = employeeView.GroupID, GroupName = employeeView.GroupName, }); } } response.data = list; response.totalCount = request.totalCount; return(Json(response, JsonRequestBehavior.AllowGet)); }
public GetGeneralResponse <IEnumerable <QueryEmployeeView> > GetQueryEmployees(Guid QueryID, int pageSize, int pageNumber) { GetGeneralResponse <IEnumerable <QueryEmployeeView> > response = new GetGeneralResponse <IEnumerable <QueryEmployeeView> >(); try { int index = (pageNumber - 1) * pageSize; int count = pageSize; Infrastructure.Querying.Query query = new Infrastructure.Querying.Query(); Criterion criteria = new Criterion("Query.ID", QueryID, CriteriaOperator.Equal); query.Add(criteria); IEnumerable <QueryEmployeeView> queryEmployees = _queryEmployeeRepository.FindBy(query) .ConvertToQueryEmployeeViews(); response.data = queryEmployees; } catch (Exception ex) { response.ErrorMessages.Add(ex.Message); if (ex.InnerException != null) { response.ErrorMessages.Add(ex.InnerException.Message); } } return(response); }
public GetGeneralResponse <IEnumerable <EmployeeView> > GetEmployeesInstaller() { GetGeneralResponse <IEnumerable <EmployeeView> > response = new GetGeneralResponse <IEnumerable <EmployeeView> >(); try { Query query = new Query(); Criterion criteria = new Criterion("InstallExpert", true, CriteriaOperator.Equal); query.Add(criteria); IEnumerable <Employee> simpleEmployees = _employeeRepository.FindBy(query); IEnumerable <EmployeeView> item = simpleEmployees.ConvertToEmployeeViews(); var simpleEmployeeViews = item as EmployeeView[] ?? item.ToArray(); foreach (var d in simpleEmployeeViews) { d.Permissions = null; } response.data = simpleEmployeeViews; response.totalCount = simpleEmployeeViews.Count(); } catch (Exception ex) { response.ErrorMessages.Add(ex.Message); } return(response); }