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);
}
