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 <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 <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 <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 <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 <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 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 <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);
}
public GetGeneralResponse <IEnumerable <NegotiationView> > GetChildNegotiations(Guid EmployeeID, int pageSize,
int pageNumber, IList <FilterData> filter, IList <Sort> sort)
{
GetGeneralResponse <IEnumerable <NegotiationView> > response = new GetGeneralResponse <IEnumerable <NegotiationView> >();
try
{
Employee employee = _employeeRepository.FindBy(EmployeeID);
IList <Guid> ChildIds = new List <Guid>();
var temp = employee.GetAllChild();
foreach (var item in temp)
{
ChildIds.Add(item.ID);
}
IList <FilterData> Filters = new List <FilterData>();
int index = (pageNumber - 1) * pageSize;
int count = pageSize;
if (filter != null)
{
foreach (var item in filter)
{
Filters.Add(item);
}
}
IList <string> Ids = new List <string>();
foreach (var item in ChildIds)
{
Ids.Add(item.ToString());
}
Filters.Add(new FilterData()
{
data = new data()
{
comparison = "eq",
type = "list",
value = Ids.ToArray()
},
field = "ReferedEmployee.ID"
});
string query = FilterUtilityService.GenerateFilterHQLQuery(Filters, "Negotiation", sort);
Response <Negotiation> negotiations = _negotiationRepository.FindAll(query, index, count);
response.data = negotiations.data.ConvertToNegotiationViews();
response.totalCount = negotiations.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> > GetFiscals(Guid customerID, 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;
IList <FilterData> _filter = new List <FilterData>();
_filter.Add(new FilterData()
{
data = new data()
{
comparison = "eq",
type = "string",
value = new[] { customerID.ToString() }
},
field = "Customer.ID"
});
if (filter != null)
{
foreach (var item in filter)
{
_filter.Add(item);
}
}
foreach (var item in sort)
{
if (item.SortColumn == "Balance")
{
item.SortColumn = "Customer.Balance";
}
}
string newquery = FilterUtilityService.GenerateFilterHQLQuery(_filter, "Fiscal", sort);
Response <Fiscal> fiscals = _fiscalRepository.FindAll(newquery, index, count);
response.data = fiscals.data.ConvertToFiscalViews();
response.totalCount = fiscals.totalCount;
}
catch (Exception ex)
{
response.ErrorMessages.Add(ex.Message);
}
return(response);
}
public GetGeneralResponse <IEnumerable <ProductLogView> > GetProductLogsByFilter(IList <FilterData> filters)
{
GetGeneralResponse <IEnumerable <ProductLogView> > response = new GetGeneralResponse <IEnumerable <ProductLogView> >();
string query = FilterUtilityService.GenerateFilterHQLQuery(filters, "ProductLog", null);
Response <ProductLog> productLogViews = _productLogRepository.FindBy(query);
response.data = productLogViews.data.ConvertToProductLogViews();
response.totalCount = productLogViews.totalCount;
return(response);
}
public GetGeneralResponse <IEnumerable <NotificationView> > NotificationReadByEmployee(Guid ReferedEmployeeID, int pageSize, int pageNumber, IList <FilterData> filter, IList <Sort> sort)
{
GetGeneralResponse <IEnumerable <NotificationView> > response = new GetGeneralResponse <IEnumerable <NotificationView> >();
IList <FilterData> Filter = new List <FilterData>();
if (filter != null)
{
foreach (var item in filter)
{
Filter.Add(item);
}
}
Filter.Add(new FilterData()
{
data = new data()
{
comparison = "eq",
type = "string",
value = new[] { ReferedEmployeeID.ToString() }
},
field = "ReferedEmployee.ID"
});
try
{
int index = (pageNumber - 1) * pageSize;
int count = pageSize;
string query = FilterUtilityService.GenerateFilterHQLQuery(Filter, "Notification", sort);
Response <Notification> notifications = _notificationRepository.FindAll(query, index, count);
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 <CallLogView> > GetOwnCallLog(int pageSize, int pageNumber,
IList <FilterData> filter, IList <Sort> sort, Guid EmployeeID)
{
var response = new GetGeneralResponse <IEnumerable <CallLogView> >();
try
{
IList <FilterData> Filters = new List <FilterData>();
if (filter != null)
{
foreach (var item in filter)
{
Filters.Add(item);
}
}
Filters.Add(new FilterData()
{
data = new data()
{
comparison = "eq",
type = "list",
value = new [] { EmployeeID.ToString() }
},
field = "CreateEmployee"
});
int index = (pageNumber - 1) * pageSize;
int count = pageSize;
string query = FilterUtilityService.GenerateFilterHQLQuery(Filters, "CallLog", sort);
Response <CallLog> callLogs = _callLogRepository.FindAll(query, index, count);
response.data = callLogs.data.ConvertToCallLogViews();
response.totalCount = callLogs.totalCount;
}
catch (Exception ex)
{
response.ErrorMessages.Add(ex.Message);
if (ex.InnerException != null)
{
response.ErrorMessages.Add(ex.InnerException.Message);
}
}
return(response);
}
public GetGeneralResponse <IEnumerable <EmployeeView> > GetEmployees(Guid?groupID, int pageSize, int pageNumber, List <FilterData> filter, List <Sort> sort)
{
GetGeneralResponse <IEnumerable <EmployeeView> > response = new GetGeneralResponse <IEnumerable <EmployeeView> >();
try
{
int index = (pageNumber - 1) * pageSize;
int count = pageSize;
Response <Employee> employees = new Response <Employee>();
if (groupID != null)
{
Query query = new Query();
Criterion criteria = new Criterion("Group.ID", groupID, CriteriaOperator.Equal);
query.Add(criteria);
employees = _employeeRepository.FindBy(query, index, count);
}
else
{
string query = FilterUtilityService.GenerateFilterHQLQuery(filter, "Employee", sort);
if (count == -1)
{
employees = _employeeRepository.FindAll(query);
}
else
{
employees = _employeeRepository.FindAll(query, index, count);
}
}
foreach (var item in employees.data)
{
item.Permissions = null;
}
response.data = employees.data.ConvertToEmployeeViews();
response.totalCount = employees.totalCount;
}
catch (Exception ex)
{
response.ErrorMessages.Add(ex.Message);
}
return(response);
}
public GetGeneralResponse <IEnumerable <CourierView> > GetAllCouriers(int pageSize, int pageNumber,
IList <FilterData> filter, IList <Sort> sort)
{
GetGeneralResponse <IEnumerable <CourierView> > response = new GetGeneralResponse <IEnumerable <CourierView> >();
try
{
int index = (pageNumber - 1) * pageSize;
int count = pageSize;
string query = FilterUtilityService.GenerateFilterHQLQuery(filter, "Courier", sort);
Response <Courier> couriers = _courierRepository.FindAll(query, index, count);
foreach (var item in couriers.data)
{
long Bonus = 0;
if (item.Sale.UncreditSaleDetails.Any())
{
Bonus += item.Sale.UncreditSaleDetails.Sum(x => x.Bonus);
}
if (item.Sale.CreditSaleDetails.Any())
{
Bonus += item.Sale.CreditSaleDetails.Sum(x => x.Bonus);
}
if (item.Sale.ProductSaleDetails.Any())
{
Bonus += item.Sale.ProductSaleDetails.Sum(x => x.Bonus);
}
item.Bonus = Bonus;
}
response.data = couriers.data.ConvertToCourierViews();
response.totalCount = couriers.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(IList <FilterData> filters)
{
GetGeneralResponse <IEnumerable <ProductSaleDetailView> > response = new GetGeneralResponse <IEnumerable <ProductSaleDetailView> >();
try
{
string query = FilterUtilityService.GenerateFilterHQLQuery(filters, "ProductSaleDetail", null);
Response <ProductSaleDetail> productSaleDetails = _productSaleDetailRepository.FindBy(query);
response.data = productSaleDetails.data.ConvertToProductSaleDetailViews();
response.totalCount = productSaleDetails.totalCount;
}
catch (Exception ex)
{
response.ErrorMessages.Add(ex.Message);
}
return(response);
}
public GetGeneralResponse <IEnumerable <CenterView> > GetCenters(int pageSize, int pageNumber, string CenterName, IList <Sort> sort, IList <FilterData> filter)
{
GetGeneralResponse <IEnumerable <CenterView> > response = new GetGeneralResponse <IEnumerable <CenterView> >();
try
{
int index = (pageNumber - 1) * pageSize;
int count = pageSize;
Response <Center> centersResponse = new Response <Center>();
if (CenterName != null)
{
Infrastructure.Querying.Query query = new Infrastructure.Querying.Query();
Criterion CriteriaCentrName = new Criterion("CenterName", CenterName, CriteriaOperator.Contains);
query.Add(CriteriaCentrName);
centersResponse = _centerRepository.FindBy(query, -1, -1, null);
}
else
{
if (index < 0 || count < 0)
{
string query = FilterUtilityService.GenerateFilterHQLQuery(filter, "Center", sort);
centersResponse = _centerRepository.FindAll(query);
}
else
{
string query = FilterUtilityService.GenerateFilterHQLQuery(filter, "Center", sort);
centersResponse = _centerRepository.FindAll(query, index, count);
}
}
response.data = centersResponse.data.ConvertToCenterViews();
response.totalCount = centersResponse.totalCount;
}
catch (Exception ex)
{
response.ErrorMessages.Add(ex.Message);
}
return(response);
}
public GetGeneralResponse <IEnumerable <AgencyView> > GetAgencies(bool?Discontinued, int pageSize, int pageNumber, IList <Sort> sort, IList <FilterData> filter)
{
GetGeneralResponse <IEnumerable <AgencyView> > response = new GetGeneralResponse <IEnumerable <AgencyView> >();
try
{
int index = (pageNumber - 1) * pageSize;
int count = pageSize;
Response <Agency> agencies = new Response <Agency>();
//IList<Sort> sortOrders = new List<Sort>();
//sortOrders.Add(new Sort("SortOrder"));
if (filter != null)
{
string query = FilterUtilityService.GenerateFilterHQLQuery(filter, "Agency", sort);
agencies = _agencyRepository.FindAll(query, index, count);
}
else
{
agencies = _agencyRepository.FindAllWithSort(index, count, sort);
}
if (Discontinued == false)
{
response.data = agencies.data.ConvertToAgencyViews().Where(x => x.Discontinued == false);
}
else
{
response.data = agencies.data.ConvertToAgencyViews();
}
response.totalCount = agencies.totalCount;
}
catch (Exception ex)
{
response.ErrorMessages.Add(ex.Message);
}
return(response);
}
public GetGeneralResponse <IEnumerable <SupportDeliverServiceView> > GetSupportDeliverServices(int pageSize,
int pageNumber, IList <FilterData> filter)
{
GetGeneralResponse <IEnumerable <SupportDeliverServiceView> > response = new GetGeneralResponse <IEnumerable <SupportDeliverServiceView> >();
try
{
string Filter = FilterUtilityService.GenerateFilterHQLQuery(filter, "SupportDeliverService", null);
Response <SupportDeliverService> supportDeliverService = _supportDeliverServiceRepository.FindAll(Filter);
response.data = supportDeliverService.data.ConvertToSupportDeliverServiceViews();
response.totalCount = supportDeliverService.totalCount;
}
catch (Exception ex)
{
response.ErrorMessages.Add(ex.Message);
if (ex.InnerException != null)
{
response.ErrorMessages.Add(ex.InnerException.Message);
}
}
return(response);
}
public GetGeneralResponse <IEnumerable <LocalPhoneStoreView> > GetUnReservedLocalPhoneStores()
{
var response = new GetGeneralResponse <IEnumerable <LocalPhoneStoreView> >();
IList <FilterData> filter = new List <FilterData>();
filter.Add(new FilterData()
{
data = new data()
{
comparison = "eq",
type = "boolean",
value = new [] { bool.FalseString }
},
field = "Reserved"
});
try
{
string query = FilterUtilityService.GenerateFilterHQLQuery(filter, "LocalPhoneStore", null);
Response <LocalPhoneStore> localPhoneStores = _localPhoneStoreRepository.FindAll(query);
response.data = localPhoneStores.data.ConvertToLocalPhoneStoreViews().OrderBy(x => x.LocalPhoneNumber);
response.totalCount = localPhoneStores.totalCount;
}
catch (Exception ex)
{
response.ErrorMessages.Add(ex.Message);
if (ex.InnerException != null)
{
response.ErrorMessages.Add(ex.InnerException.Message);
}
}
return(response);
}
public GetGeneralResponse <IEnumerable <GetSaleDetailReportView> > GetSaleReport(IList <FilterData> filters)
{
GetGeneralResponse <IEnumerable <GetSaleDetailReportView> > response =
new GetGeneralResponse <IEnumerable <GetSaleDetailReportView> >();
string query = FilterUtilityService.GenerateFilterHQLQuery(filters, "ProductSaleDetail", null);
Response <ProductSaleDetail> productSaleDetails = _productSaleDetailRepository.FindAll(query);
IList <GetSaleDetailReportView> Report = new List <GetSaleDetailReportView>();
foreach (ProductSaleDetail _productSaleDetail in productSaleDetails.data)
{
GetSaleDetailReportView item = new GetSaleDetailReportView();
item.ADSLPhone = _productSaleDetail.Sale.Customer.ADSLPhone;
item.CenterName = _productSaleDetail.Sale.Customer.Center == null
? ""
: _productSaleDetail.Sale.Customer.Center.CenterName;
item.Name = _productSaleDetail.Sale.Customer.Name;
item.ProductPriceName = _productSaleDetail.ProductPrice.ProductPriceTitle;
item.ProductName = _productSaleDetail.ProductPrice.Product.ProductName;
item.BonusDate = _productSaleDetail.BonusDate;
item.ComissionDate = _productSaleDetail.ComissionDate;
if (_productSaleDetail.IsRollbackDetail)
{
item.Bonus = _productSaleDetail.Bonus;
item.Comission = _productSaleDetail.Comission;
item.DeliverDate = _productSaleDetail.MainSaleDetail.DeliverDate;
item.DeliverEmployeeName = _productSaleDetail.MainSaleDetail.DeliverEmployee == null
? ""
: (string)_productSaleDetail.MainSaleDetail.DeliverEmployee.Name;
item.Discount = _productSaleDetail.MainSaleDetail.LineDiscount;
item.Imposition = _productSaleDetail.MainSaleDetail.LineImposition;
item.Price = _productSaleDetail.MainSaleDetail.UnitPrice;
item.Count = _productSaleDetail.MainSaleDetail.Units;
item.RollBackEmployeeName = _productSaleDetail.CreateEmployee.Name;
item.RollBackPrice = _productSaleDetail.RollbackPrice;
item.RoolBackDate = _productSaleDetail.CreateDate;
item.SaleDate = _productSaleDetail.MainSaleDetail.CreateDate;
item.Total = _productSaleDetail.LineTotal;
item.TotalRollBack = _productSaleDetail.Units;
item.SaleEmployeeName = _productSaleDetail.MainSaleDetail.CreateEmployee.Name;
}
else
{
item.Bonus = _productSaleDetail.Bonus;
item.Comission = _productSaleDetail.Comission;
item.DeliverDate = _productSaleDetail.DeliverDate;
item.DeliverEmployeeName = _productSaleDetail.DeliverEmployee == null
? ""
: (string)_productSaleDetail.DeliverEmployee.Name;
item.Discount = _productSaleDetail.LineDiscount;
item.Imposition = _productSaleDetail.LineImposition;
item.Price = _productSaleDetail.UnitPrice;
item.Count = _productSaleDetail.Units;
item.SaleDate = _productSaleDetail.CreateDate;
item.Total = _productSaleDetail.LineTotal;
item.SaleDate = _productSaleDetail.Sale.CreateDate;
item.SaleEmployeeName = _productSaleDetail.CreateEmployee.Name;
item.CustomerID = _productSaleDetail.Sale.Customer.ID;
if (_productSaleDetail.Rollbacked)
{
Infrastructure.Querying.Query q = new Query();
Criterion crt = new Criterion("MainSaleDetail.ID", _productSaleDetail.ID, CriteriaOperator.Equal);
q.Add(crt);
ProductSaleDetail RollbakedProductSaleDetail = _productSaleDetailRepository.FindBy(q).FirstOrDefault();
if (RollbakedProductSaleDetail != null)
{
item.RollBackEmployeeName = RollbakedProductSaleDetail.CreateEmployee.Name;
item.RollBackPrice = RollbakedProductSaleDetail.LineTotal;
item.RoolBackDate = RollbakedProductSaleDetail.CreateDate;
item.TotalRollBack = RollbakedProductSaleDetail.Units;
}
}
}
Report.Add(item);
}
response.data = Report;
response.totalCount = Report.Count();
return(response);
}
public GetGeneralResponse <IEnumerable <SupportView> > GetSupports(int pageSize, int pageNumber,
IList <FilterData> filter, IList <Sort> sort, int LastState)
{
GetGeneralResponse <IEnumerable <SupportView> > response = new GetGeneralResponse <IEnumerable <SupportView> >();
try
{
int index = (pageNumber - 1) * pageSize;
int count = pageSize;
IList <FilterData> Filters = new List <FilterData>();
if (filter != null)
{
foreach (var item in filter)
{
Filters.Add(item);
}
}
if (LastState == 0)
{
}
if (LastState == 1)
{
Filters.Add(new FilterData()
{
data = new data()
{
comparison = "eq",
type = "boolean",
value = new[] { bool.TrueString }
},
field = "SupportStatus.IsLastSupportState"
});
}
if (LastState == 2)
{
Filters.Add(new FilterData()
{
data = new data()
{
comparison = "eq",
type = "boolean",
value = new[] { bool.FalseString }
},
field = "SupportStatus.IsLastSupportState"
});
}
string query = FilterUtilityService.GenerateFilterHQLQuery(Filters, "Support", sort);
Response <Support> supports = new Response <Support>();
supports = _supportRepository.FindAll(query, index, count);
response.data = supports.data.ConvertToSupportViews();
response.totalCount = supports.totalCount;
}
catch (Exception ex)
{
response.ErrorMessages.Add(ex.Message);
if (ex.InnerException != null)
{
response.ErrorMessages.Add(ex.InnerException.Message);
}
}
return(response);
}
public GetGeneralResponse <IEnumerable <CourierView> > GetAllCouriersByEmployee(int pageSize, int pageNumber,
IList <FilterData> filter, IList <Sort> sort, Guid EmployeeID)
{
GetGeneralResponse <IEnumerable <CourierView> > response = new GetGeneralResponse <IEnumerable <CourierView> >();
try
{
int index = (pageNumber - 1) * pageSize;
int count = pageSize;
IList <FilterData> _filter = new List <FilterData>();
if (filter != null)
{
foreach (var filterData in filter)
{
_filter.Add(filterData);
}
}
#region Add Customer Filter
_filter.Add(new FilterData()
{
data = new data()
{
comparison = "eq",
type = "list",
value = new[] { EmployeeID.ToString() }
},
field = "CreateEmployee.ID"
});
#endregion
string query = FilterUtilityService.GenerateFilterHQLQuery(_filter, "Courier", sort);
Response <Courier> couriers = _courierRepository.FindAll(query, index, count);
foreach (var item in couriers.data)
{
long Bonus = 0;
if (item.Sale.UncreditSaleDetails.Any())
{
Bonus += item.Sale.UncreditSaleDetails.Sum(x => x.Bonus);
}
if (item.Sale.CreditSaleDetails.Any())
{
Bonus += item.Sale.CreditSaleDetails.Sum(x => x.Bonus);
}
if (item.Sale.ProductSaleDetails.Any())
{
Bonus += item.Sale.ProductSaleDetails.Sum(x => x.Bonus);
}
item.Bonus = Bonus;
}
response.data = couriers.data.ConvertToCourierViews();
response.totalCount = couriers.totalCount;
}
catch (Exception ex)
{
response.ErrorMessages.Add(ex.Message);
if (ex.InnerException != null)
{
response.ErrorMessages.Add(ex.InnerException.Message);
}
}
return(response);
}
public GetGeneralResponse <IEnumerable <SupportOwnView> > GetOwnSupports(Guid EmployeeID, int pageSize, int pageNumber, IList <FilterData> filter, IList <Sort> sort)
{
GetGeneralResponse <IEnumerable <SupportOwnView> > response = new GetGeneralResponse <IEnumerable <SupportOwnView> >();
try
{
int index = (pageNumber - 1) * pageSize;
int count = pageSize;
IList <FilterData> _filter = new List <FilterData>();
//_filter.Add(new FilterData()
//{
// data = new data() {
// comparison="eq",
// type="date",
// value=new[]{PersianDateTime.Now.Substring(0,10)}
// },
// field="DispatchDate"
//});
var employees = _employeeService.GetAllChilOfAnEmployee(EmployeeID);
IList <string> Ids = new List <string>();
if (employees.data.Any())
{
foreach (var item in employees.data)
{
Ids.Add(item.ID.ToString());
}
Ids.Add(EmployeeID.ToString());
FilterData Filter = new FilterData();
Filter.field = "ExpertEmployee.ID";
Filter.data = new data()
{
comparison = "eq",
type = "list",
value = Ids.ToArray()
};
_filter.Add(Filter);
}
//_filter.Add(new FilterData()
//{
// data = new data()
// {
// comparison = "eq",
// type = "string",
// value = new[] { EmployeeID.ToString() }
// },
// field = "ExpertEmployee.ID"
//});
if (!_filter.Any())
{
_filter.Add(new FilterData()
{
data = new data()
{
comparison = "eq",
type = "string",
value = new[] { EmployeeID.ToString() }
},
field = "ExpertEmployee.ID"
});
}
if (filter != null)
{
foreach (var item in filter)
{
_filter.Add(item);
}
}
string query = FilterUtilityService.GenerateFilterHQLQuery(_filter, "SupportExpertDispatch", sort);
Response <SupportExpertDispatch> supportExpertDispatch = _supportExpertDispatchRepository.FindAll(query, index, count);
response.data = supportExpertDispatch.data.ConvertToSupportOwnViews();
foreach (var item in supportExpertDispatch.data)
{
foreach (var _item in response.data)
{
if (item.ID == _item.ID)
{
if (item.Support.Customer.Sales.Where(x => x.ProductSaleDetails.Where(v => v.IsRollbackDetail != true).Where(v => v.Delivered != true).Count() > 0).Count() > 0)
{
_item.HasNotDeliveredProducts = true;
}
}
}
}
response.totalCount = supportExpertDispatch.totalCount;
}
catch (Exception ex)
{
response.ErrorMessages.Add(ex.Message);
}
return(response);
}
public GetGeneralResponse <IEnumerable <ToDoView> > GetReferedEmployeeToDos(Guid CreateEmployeeID, Guid ReferedEmployeeID, int?Close, int?TaskStatusID,
string StartDateRange, string EndDateRange, Guid CustomerID, int pageSize, int pageNumber, IList <Sort> sort)
{
GetGeneralResponse <IEnumerable <ToDoView> > response = new GetGeneralResponse <IEnumerable <ToDoView> >();
#region Temp Code
//IQueryable<ToDoResult> toDoViews = _toDoResultRepository.FindAll().AsQueryable();
//if (CreateEmployeeID != Guid.Empty)
//{
// toDoViews = toDoViews.Where(x => x.CreateEmployee.ID == CreateEmployeeID || x.ReferedEmployee.ID == CreateEmployeeID).AsQueryable();
//}
//if (ReferedEmployeeID != Guid.Empty)
//{
// toDoViews = toDoViews.Where(x => x.ReferedEmployee.ID == ReferedEmployeeID).AsQueryable();
//}
//if (StartDateRange != "")
//{
// toDoViews = toDoViews.Where(x => string.Compare(x.ToDo.StartDate.Substring(0, 10), StartDateRange) >= 0);
//}
//if (EndDateRange != "")
//{
// toDoViews = toDoViews.Where(x => string.Compare(x.ToDo.StartDate.Substring(0, 10), EndDateRange) <= 0);
//}
//switch (Close)
//{
// case 3:
// {
// toDoViews = toDoViews.Where(x => x.ToDo.PrimaryClosed == true);
// break;
// }
// case 2:
// {
// toDoViews = toDoViews.Where(x => x.ToDo.PrimaryClosed == false).Where(x => x.SecondaryClosed == true);
// break;
// }
// case 1:
// {
// toDoViews = toDoViews.Where(x => x.ToDo.PrimaryClosed == false).Where(x => x.SecondaryClosed == false);
// break;
// }
//}
//if (CustomerID != Guid.Empty)
//{
// toDoViews = toDoViews.Where(x => x.ToDo.Customer.ID == CustomerID);
//}
//var tt = toDoViews.Distinct().ConvertToToDoResultViews();
//response.data = toDoViews.Select(x => x.ToDo).Distinct().ConvertToToDoViews();
#region Temp
//try
//{
// int index = (pageNumber - 1) * pageSize;
// int count = pageSize;
// Infrastructure.Querying.Query query = new Query();
// switch (Close)
// {
// case null:
// {
// break;
// }
// //case 1:
// // {
// // Criterion criteriaSecondaryClosed = new Criterion("ToDo.PrimaryClosed", false, CriteriaOperator.Equal);
// // query.Add(criteriaSecondaryClosed);
// // break;
// // }
// case 2:
// {
// Criterion criteriaSecondaryClosed = new Criterion("SecondaryClosed", true, CriteriaOperator.Equal);
// query.Add(criteriaSecondaryClosed);
// break;
// }
// }
// Response<ToDoResult> toDoResults = _toDoResultRepository.FindBy(query, -1, -1);
// IEnumerable<ToDoResult> result = from r in toDoResults.data where r.ReferedEmployee.ID == ReferedEmployeeID || r.CreateEmployee.ID == ReferedEmployeeID select r;
// if (count != -1)
// {
// if (CustomerID != null)
// response.data = result.Select(w => w.ToDo).Distinct().ConvertToToDoViews().Skip(index).Take(count).Where(x => x.CustomerID == CustomerID);
// else
// response.data = result.Select(w => w.ToDo).Distinct().ConvertToToDoViews().Skip(index).Take(count);
// }
// else
// {
// if (CustomerID != null)
// {
// response.data = result.Select(w => w.ToDo).Distinct().ConvertToToDoViews().Where(x => x.CustomerID == CustomerID);
// response.totalCount = response.data.Count();
// }
// else
// {
// response.data = toDoResults.data.Select(w => w.ToDo).Distinct().ConvertToToDoViews();
// response.totalCount = response.data.Count();
// if (CreateEmployeeID != null)
// {
// response.data = response.data.Where(x => x.CreateEmployeeID == CreateEmployeeID);
// }
// }
// }
// if (StartDateRange != "")
// {
// response.data = response.data.Where(w => string.Compare(w.StartDate.Substring(0, 10), StartDateRange) >= 0);
// }
// if (EndDateRange != "")
// {
// response.data = response.data.Where(w => string.Compare(w.StartDate.Substring(0, 10), StartDateRange) <= 0);
// }
// switch (Close)
// {
// case null:
// {
// break;
// }
// case 1:
// {
// response.data = response.data.Where(x => x.PrimaryClosed == false);
// break;
// }
// case 2:
// {
// response.data = response.data.Where(x => x.PrimaryClosed == false);
// break;
// }
// case 3:
// {
// response.data = response.data.Where(x => x.PrimaryClosed == true);
// break;
// }
// }
// // اصلاح آدرس عکسها و پاس دادن آدرس جدید
// foreach (ToDoView toDo in response.data)
// {
// //if (ReferedEmployeeID != null)
// //{
// // toDo.ToDoResults =
// // toDo.ToDoResults.Where(x => x.ReferedEmployeeID == ReferedEmployeeID);
// //}
// if (toDo.CreateEmployeeID == ReferedEmployeeID)
// {
// toDo.IsMine = true;
// }
// if(toDo.Attachment!=null)
// toDo.Attachment = toDo.Attachment.Replace(@"\", "/").Substring(toDo.Attachment.IndexOf("data")); ;
// }
// int counter=0;
// IList<ToDoView> finalData=new List<ToDoView>();
// foreach (ToDoView toDo in response.data)
// {
// if(toDo.ToDoResults.Count()>0)
// finalData.Add(toDo);
// }
// response.data = finalData;
//}
//catch (Exception ex)
//{
// response.ErrorMessages.Add(ex.Message);
// if (ex.InnerException != null)
// response.ErrorMessages.Add(ex.InnerException.Message);
//}
//}
#endregion
#endregion
#region preparing Filters
IList <FilterData> filters = new List <FilterData>();
if (ReferedEmployeeID == Guid.Empty)
{
filters.Add(new FilterData()
{
data = new data()
{
type = "list",
comparison = "eq",
value = new[] { CreateEmployeeID.ToString() }
},
field = "ToDo.CreateEmployee.ID"
});
}
if (ReferedEmployeeID != Guid.Empty)
{
filters.Add(new FilterData()
{
data = new data()
{
type = "list",
comparison = "eq",
value = new[] { CreateEmployeeID.ToString() }
},
field = "ReferedEmployee.ID"
});
}
if (Close == 1)
{
filters.Add(new FilterData()
{
data = new data()
{
type = "boolean",
comparison = "eq",
value = new[] { bool.FalseString }
},
field = "SecondaryClosed"
});
filters.Add(new FilterData()
{
data = new data()
{
type = "boolean",
comparison = "eq",
value = new[] { bool.FalseString }
},
field = "ToDo.PrimaryClosed"
});
}
if (Close == 2)
{
filters.Add(new FilterData()
{
data = new data()
{
type = "boolean",
comparison = "eq",
value = new[] { bool.TrueString }
},
field = "SecondaryClosed"
});
filters.Add(new FilterData()
{
data = new data()
{
type = "boolean",
comparison = "eq",
value = new[] { bool.FalseString }
},
field = "ToDo.PrimaryClosed"
});
}
if (Close == 3)
{
filters.Add(new FilterData()
{
data = new data()
{
type = "boolean",
comparison = "eq",
value = new[] { bool.TrueString }
},
field = "ToDo.PrimaryClosed"
});
}
#region Payment Date
if (StartDateRange != null && EndDateRange == null)
{
FilterData Filter = new FilterData()
{
field = "ToDo.StartDate",
data = new data()
{
comparison = "gteq",
type = "date",
value = new[] { StartDateRange }
}
};
filters.Add(Filter);
}
if (EndDateRange != null && StartDateRange == null)
{
FilterData Filter = new FilterData()
{
field = "ToDo.StartDate",
data = new data()
{
comparison = "lteq",
type = "date",
value = new[] { EndDateRange }
}
};
filters.Add(Filter);
}
if (StartDateRange != null && EndDateRange != null)
{
FilterData Filter = new FilterData()
{
field = "ToDo.StartDate",
data = new data()
{
comparison = "gteq",
type = "date",
value = new[] { StartDateRange }
}
};
filters.Add(Filter);
}
#endregion
string query = FilterUtilityService.GenerateFilterHQLQuery(filters, "ToDoResult", null);
//if (StartDateRange != null && EndDateRange != null)
//{
// response.data =
// _toDoResultRepository.FindAll(query)
// .data.Select(x => x.ToDo)
// .Distinct()
// .Where(x => string.Compare(x.EndDate.Substring(0, 10), EndDateRange) >= 0)
// .ConvertToToDoViews();
//}
IEnumerable <ToDoResult> res = _toDoResultRepository.FindAll(query).data;
response.data = _toDoResultRepository.FindAll(query).data.Select(x => x.ToDo).Distinct().ConvertToToDoViews();
#endregion
return(response);
}
public GetGeneralResponse <IEnumerable <GetBankCasheReportView> > GetBankCasheReport(int?TransactionType, IEnumerable <Guid> MoneyAccountID,
string InvestStartDate, string InvestEndDate, string ConfirmStartDate, string ConfirmEndDate, IList <Sort> sort, bool NotConfirmed)
{
GetGeneralResponse <IEnumerable <GetBankCasheReportView> > response = new GetGeneralResponse <IEnumerable <GetBankCasheReportView> >();
try
{
#region Preparing Filters
IList <FilterData> filters = new List <FilterData>();
if (NotConfirmed == true)
{
FilterData TransactionTypeFilter = new FilterData()
{
field = "Confirm",
data = new data()
{
type = "numeric",
comparison = "eq",
value = new[] { "3" }
}
};
filters.Add(TransactionTypeFilter);
}
if (NotConfirmed == false)
{
FilterData TransactionTypeFilter = new FilterData()
{
field = "Confirm",
data = new data()
{
type = "numeric",
comparison = "eq",
value = new[] { "2" }
}
};
filters.Add(TransactionTypeFilter);
}
#region Transaction Type
if (TransactionType == 1)
{
FilterData TransactionTypeFilter = new FilterData()
{
field = "Cost",
data = new data()
{
type = "numeric",
comparison = "gt",
value = new[] { "0" }
}
};
filters.Add(TransactionTypeFilter);
}
if (TransactionType == 2)
{
FilterData TransactionTypeFilter = new FilterData()
{
field = "Cost",
data = new data()
{
type = "numeric",
comparison = "lt",
value = new[] { "0" }
}
};
filters.Add(TransactionTypeFilter);
}
#endregion
#region MoneyAccount
if (MoneyAccountID != null)
{
FilterData MoneyAccounFilter = new FilterData()
{
field = "MoneyAccountName",
data = new data()
{
type = "list",
value = MoneyAccountID.Select(x => x.ToString()).ToArray(),
}
};
filters.Add(MoneyAccounFilter);
}
#endregion
#region Invest Start Date
if (InvestStartDate != null && InvestEndDate == null)
{
FilterData InvestStartDateFilter = new FilterData()
{
field = "InvestDate",
data = new data()
{
comparison = "gteq",
type = "dateOnly",
value = new[] { InvestStartDate }
}
};
filters.Add(InvestStartDateFilter);
}
#endregion
#region Invest End Date
if (InvestEndDate != null && InvestStartDate == null)
{
FilterData InvestEndDateFilter = new FilterData()
{
field = "InvestDate",
data = new data()
{
comparison = "lteq",
type = "dateOnly",
value = new[] { InvestEndDate }
}
};
filters.Add(InvestEndDateFilter);
}
if (InvestEndDate != null & InvestStartDate != null)
{
FilterData ConfirmEndDateFilter = new FilterData()
{
field = "InvestDate",
data = new data()
{
comparison = "lteq",
type = "dateOnlyBetween",
value = new[] { InvestStartDate, InvestEndDate }
}
};
filters.Add(ConfirmEndDateFilter);
}
#endregion
#region Confirem Start Date
if (ConfirmStartDate != null && ConfirmEndDate == null)
{
FilterData ConfirmStartDateFilter = new FilterData()
{
field = "ConfirmDate",
data = new data()
{
comparison = "gteq",
type = "date",
value = new[] { ConfirmStartDate }
}
};
filters.Add(ConfirmStartDateFilter);
}
#endregion
#region Confirem End Date
if (ConfirmEndDate != null & ConfirmStartDate == null)
{
FilterData ConfirmEndDateFilter = new FilterData()
{
field = "ConfirmDate",
data = new data()
{
comparison = "lteq",
type = "date",
value = new[] { ConfirmStartDate }
}
};
filters.Add(ConfirmEndDateFilter);
}
if (ConfirmEndDate != null & ConfirmStartDate != null)
{
if (ConfirmEndDate == ConfirmStartDate)
{
FilterData ConfirmEndDateFilter = new FilterData()
{
field = "ConfirmDate",
data = new data()
{
comparison = "eq",
type = "date",
value = new[] { ConfirmStartDate }
}
};
filters.Add(ConfirmEndDateFilter);
}
else
{
FilterData ConfirmEndDateFilter = new FilterData()
{
field = "ConfirmDate",
data = new data()
{
comparison = "lteq",
type = "dateBetween",
value = new[] { ConfirmStartDate, ConfirmEndDate }
}
};
filters.Add(ConfirmEndDateFilter);
}
}
#region فقط فاکتور های تایید شده
FilterData ConfirmedFilter = new FilterData()
{
field = "Confirm",
data = new data()
{
type = "numeric",
comparison = "eq",
value = new[] { "2" }
}
};
filters.Add(ConfirmedFilter);
#endregion
#endregion
#endregion
string query = FilterUtilityService.GenerateFilterHQLQuery(filters, "Fiscal", sort);
Response <Fiscal> fiscals = _fiscalRepository.FindAll(query);
#region Preparing Report View
IList <GetBankCasheReportView> report = new List <GetBankCasheReportView>();
foreach (Fiscal fiscal in fiscals.data)
{
GetBankCasheReportView _report = new GetBankCasheReportView();
_report.ADSLPhone = fiscal.Customer.ADSLPhone;
_report.Bes = fiscal.Cost > 0 ? "بستانکار" : "";
_report.Bed = fiscal.Cost < 0 ? "بدهکار" : "";
_report.ConfiremdCost = fiscal.ConfirmedCost == null ? 0 : (long)fiscal.ConfirmedCost;
_report.ConfirmDate = fiscal.ConfirmDate;
if (fiscal.ConfirmEmployee != null)
{
_report.ConfirmEmployeeName = fiscal.ConfirmEmployee.Name;
}
_report.Cost = fiscal.Cost;
_report.CreateEmployeeName = fiscal.CreateEmployee.Name;
_report.InvestDate = fiscal.InvestDate;
_report.Name = fiscal.Customer.Name;
_report.SerialNumber = fiscal.SerialNumber;
_report.MoneyAccountName = fiscal.MoneyAccount.AccountName;
_report.Note = fiscal.Note;
_report.AccountingSerialNumber = fiscal.DocumentSerial;
_report.FiscalReciptNumber = fiscal.FiscalReciptNumber;
#region Preparing DOC Type
int docType = (int)fiscal.DocumentType;
if (docType == 1)
{
_report.DocType = "رسید عابر بانک";
}
else if (docType == 2)
{
_report.DocType = "فیش بانکی";
}
else if (docType == 3)
{
_report.DocType = "چک";
}
else if (docType == 4)
{
_report.DocType = "قبض صندوق";
}
else if (docType == 5)
{
_report.DocType = "رسید POS";
}
else if (docType == 6)
{
_report.DocType = "پرداخت اینترنتی";
}
else if (docType == 7)
{
_report.DocType = "سایت ماهان";
}
else if (docType == 8)
{
_report.DocType = "سایر موارد";
}
#endregion
report.Add(_report);
}
#endregion
response.data = report;
response.totalCount = report.Count();
}
catch (Exception ex)
{
response.ErrorMessages.Add(ex.Message);
if (ex.InnerException != null)
{
response.ErrorMessages.Add(ex.InnerException.Message);
}
}
return(response);
}