public IEnumerable <CustomerDTO> GetCustomers(CustomersRequest request = null)
{
Expression <Func <CustomerDTO, bool> > firstNameExpression;
Expression <Func <CustomerDTO, bool> > lastNameExpression;
Expression <Func <CustomerDTO, bool> > finalExpression;
if (request == null || (request.LastName == null && request.FirstName == null))
{
finalExpression = null;
}
else if (request.LastName == null || request.FirstName == null)
{
if (request.FirstName != null)
{
finalExpression = x => x.FirstName == request.FirstName;
}
else
{
finalExpression = x => x.LastName == request.LastName;
}
}
else
{
firstNameExpression = x => x.FirstName == request.FirstName;
lastNameExpression = x => x.LastName == request.LastName;
finalExpression = firstNameExpression.And(lastNameExpression);
}
using (var unitOfWork = _factory.GetInstance())
{
return(unitOfWork.GetCustomers(finalExpression));
}
}
public BaseEntity Post(string lang, BaseEntity entity, string parent = null)
{
var plugin = new Natec.Entities.CustomersPlugin();
plugin.SetApiContext(apiContext);
var requestData = new CustomersRequest()
{
IDType = 0,
ProfileType = 1,
Name = entity.Name,
ParentNode = 1,
StatusID = 5,
ParentID = 1,
isUpdateNodeTree = 1,
};
var results = new List <ValidationResult>();
var isValid = Validator.TryValidateObject(requestData, new ValidationContext(requestData), results, true);
if (!isValid)
{
throw new ArgumentException("request model is not valid");
}
BaseEntity rez;
rez = plugin.Post("uk", requestData);
return(rez);
}
public IActionResult CustomerAdd(CustomersRequest customer)
{
var orderAdd = new Customer() { Id= order.Id , Status = order.Status, Driver_id = order.Driver_id, Created_at = order.Created_at, Update_at = order.Update_at};
Orders.Add(orderAdd);
return Ok(new { data = Orders });
}
public ActionResult Find(OrdersRequestViewModel request)
{
var customerRequest = new CustomersRequest();
if (request.CustomersRequest == null)
{
customerRequest = null;
}
else
{
customerRequest.FirstName = request.CustomersRequest.FirstName;
customerRequest.LastName = request.CustomersRequest.LastName;
}
var managerRequest = new ManagersRequest();
if (request.ManagersRequest == null)
{
managerRequest = null;
}
else
{
managerRequest.LastName = request.ManagersRequest.LastName;
}
var orderRequest = new OrdersRequest()
{
Cost = request.Cost,
CustomersRequest = customerRequest,
ManagersRequest = managerRequest
};
return(PartialView("_OrdersTable",
Mapper.Map <IEnumerable <OrderViewModel> >(_service.GetOrders(orderRequest))));
}
public override async Task GetCustomers(CustomersRequest request, IServerStreamWriter <CustomerModel> responseStream, ServerCallContext context)
{
List <CustomerModel> output = new List <CustomerModel>
{
new CustomerModel
{
Name = "tortoruga",
Age = 1,
IsActive = true,
},
new CustomerModel
{
Name = "teste",
Age = 0,
IsActive = false,
}
};
foreach (var custumer in output)
{
await Task.Delay(2000);
await responseStream.WriteAsync(custumer);
}
}
public override async Task GetAllCustomers(CustomersRequest request,
IServerStreamWriter <CustomersResponse> responseStream, ServerCallContext context)
{
await foreach (var item in repository.GetCustomers())
{
await responseStream.WriteAsync(item.ToCustomerResponse());
}
}
public IActionResult CustomerAdd(CustomersRequest customer)
{
var customerAdd = new Customer()
{
Id = customer.Id, Full_name = customer.Full_name, Username = customer.Username, Email = customer.Email, Phone_number = customer.Phone_number, Created_at = customer.Created_at, Update_at = customer.Update_at
};
Customers.Add(customerAdd);
return(Ok(new { data = Customers }));
}
public ActionResult Find(CustomersRequestViewModel request)
{
var customerRequest = new CustomersRequest()
{
FirstName = request.FirstName,
LastName = request.LastName
};
return(PartialView("_CustomersTable",
Mapper.Map <IEnumerable <CustomerViewModel> >(_service.GetCustomers(customerRequest))));
}
public IActionResult Create([FromBody] CustomersRequest customersRequest)
{
_unitOfWorkDapper.CustomersCommand.Add(customersRequest, 1);
var result = _unitOfWorkDapper.Commit();
if (result)
{
return(Ok(new OkResponse("Movies Added Successfully !")));
}
else
{
return(StatusCode(StatusCodes.Status500InternalServerError, "Something Went Wrong"));
}
}
public void Add(CustomersRequest customersViewModel, long userId)
{
var param = new DynamicParameters();
param.Add("@FirstName", customersViewModel.FirstName);
param.Add("@LastName", customersViewModel.LastName);
param.Add("@MobileNo", customersViewModel.MobileNo);
param.Add("@LandlineNo", customersViewModel.LandlineNo);
param.Add("@EmailId", customersViewModel.EmailId);
param.Add("@Street", customersViewModel.Street);
param.Add("@City", customersViewModel.City);
param.Add("@State", customersViewModel.State);
param.Add("@Pincode", customersViewModel.Pincode);
param.Add("@CreatedBy", userId);
_dbConnection.Execute("Usp_InsertCustomer", param, _dbTransaction, 0, CommandType.StoredProcedure);
}
public BaseEntity Put(string id, string lang, BaseEntity entity)
{
var plugin = new Natec.Entities.CustomersPlugin();
plugin.SetApiContext(apiContext);
Natec.Widecoup.Customers_Response_GETBYID_OUTPUT pluginCustomerToEdit;
pluginCustomerToEdit = (Customers_Response_GETBYID_OUTPUT)plugin.GetById(new Customers_Request_GETBYID
{
abn_ID = Int32.Parse(entity.Id),
lang = "uk"
}, "uk").Item2;
pluginCustomerToEdit.AbonentFullName = entity.Name;
var requestData = new CustomersRequest()
{
IDType = 0,
ProfileType = pluginCustomerToEdit.ProfileType,
Name = pluginCustomerToEdit.AbonentFullName,
isUpdateNodeTree = 1,
ID = pluginCustomerToEdit.abn_ExternalID
};
var validErr = new List <ValidationResult>();
var isValid = Validator.TryValidateObject(requestData, new ValidationContext(requestData), validErr, true);
if (!isValid)
{
throw new ArgumentException("request model is not valid");
}
var rez = plugin.Put(pluginCustomerToEdit.abn_ID.ToString(), "uk", requestData);
return(rez);
}
public object Get(CustomersRequest request)
{
var cache = Redis.As<CustomerDto>();
bool cacheExists = cache.Lists["customers"].Any();
bool enoughResults = cache.Lists["customers"].Count > request.PageSize;
if (cacheExists && enoughResults)
{
var customersResponse = cache.Lists["customers"].AsEnumerable();
return customersResponse.Skip(request.PageNumber*request.PageSize)
.Take(request.PageSize);
}
var customerList = MongoHost.Db.GetCollection<MongoCustomer>("Customers").AsQueryable();
//var response = customerList.Skip(request.PageNumber*request.PageSize)
// .Take(request.PageSize)
// .ToList();
var response = customerList.ToList();
//return new QueryResponse<List<CustomerDto>>
//{
// ResponseStatus = new ResponseStatus(),
// Results = AutoMapper.Mapper.Map<List<CustomerDto>>(response),
// Links = new List<Link>{}
//};
var customerResponse = AutoMapper.Mapper.Map<List<CustomerDto>>(response);
cache.Lists["customers"].Clear();
cache.Lists["customers"].AddRange(customerResponse);
cache.ExpireEntryIn("customers", TimeSpan.FromHours(6));
return customerResponse.Skip(request.PageNumber * request.PageSize)
.Take(request.PageSize);
}