public void When_Surname_And_DateOfBirth_AreNotNullOrEmpty_Then_Filter_Message_Returns_Correct_Value()
{
// Arrange
var surname = Fixture.Create <string>();
var dateOfBirth = Fixture.Create <string>();
var sut = new SearchParameterViewModel(null, surname, dateOfBirth);
// Act
var result = sut.FilterMessage;
// Assert
Assert.IsTrue(result.Contains(surname));
Assert.IsTrue(result.Contains(dateOfBirth));
}
public IActionResult Get([FromQuery] SearchParameterViewModel model)
{
if (!ModelState.IsValid)
{
return(BadRequest(GetModelStateErrorResponse(ModelState)));
}
var resp = Search(model);
if (resp.Type != ResponseType.Success)
{
return(BadRequest(resp));
}
return(Ok(resp));
}
internal IEnumerable <IllustrationListViewModel> GetIllustrationList(SearchParameterViewModel searchParameter, bool isSuperUser)
{
var IllustrationDetails = new List <IllustrationDetail>();
if (!isSuperUser)
{
IllustrationDetails = _context.IllustrationDetails.Where(x => x.PartnerEmail == searchParameter.PartnerEmail && x.PartnerOrganisation == searchParameter.PartnerOrganisation).Include(x => x.IllustrationProposedPortfolio).OrderByDescending(x => x.GenerateDate).ToList();
}
else
{
IllustrationDetails = _context.IllustrationDetails.Include(x => x.IllustrationProposedPortfolio).OrderByDescending(x => x.GenerateDate).ToList();
}
searchParameter.IllustrationUniqueReference = string.IsNullOrEmpty(searchParameter.IllustrationUniqueReference) ? "" : searchParameter.IllustrationUniqueReference.ToLower();
if (searchParameter.IllustrationFrom != null && searchParameter.IllustrationTo != null)
{
searchParameter.IllustrationTo = searchParameter.IllustrationTo.Value.AddHours(23).AddMinutes(59).AddSeconds(59);
}
if (!string.IsNullOrEmpty(searchParameter.ClientName) || !string.IsNullOrEmpty(searchParameter.PartnerName) || !string.IsNullOrEmpty(searchParameter.CompanyName) || !string.IsNullOrEmpty(searchParameter.IllustrationUniqueReference) || searchParameter.IllustrationTo != null || searchParameter.IllustrationFrom != null)
{
IllustrationDetails = IllustrationDetails.Where(f =>
//Advisor Search
(string.IsNullOrEmpty(searchParameter.PartnerName) || (!string.IsNullOrEmpty(f.PartnerName) && f.PartnerName.ToLower().Contains(searchParameter.PartnerName.ToLower())))
//Client Search
& (string.IsNullOrEmpty(searchParameter.ClientName) || f.ClientName.ToLower().Contains(searchParameter.ClientName.ToLower()))
//Company Search
& (string.IsNullOrEmpty(searchParameter.CompanyName) || f.PartnerOrganisation.ToLower().Contains(searchParameter.CompanyName.ToLower()))
//Company Search
& (string.IsNullOrEmpty(searchParameter.IllustrationUniqueReference) || f.IllustrationUniqueReference.ToLower().Contains(searchParameter.IllustrationUniqueReference.ToLower()))
& ((!searchParameter.IllustrationFrom.HasValue || f.GenerateDate >= searchParameter.IllustrationFrom.Value)
& (!searchParameter.IllustrationTo.HasValue || f.GenerateDate <= searchParameter.IllustrationTo.Value))).ToList();
}
List <IllustrationListViewModel> response = new List <IllustrationListViewModel>();
response = _mapper.Map(IllustrationDetails, response);
return(response);
}
public JsonResult SearchIllustration(SearchParameterViewModel searchParams)
{
//check model validation for any empty waitttttttt
//bool isNull = false;
//if (searchParams.AdvisorName == null & searchParams.ClientName == null & searchParams.CompanyName == null
// & searchParams.IllustrationFrom == null & searchParams.IllustrationTo == null & searchParams.IllustrationUniqueReference == null)
//{
// isNull = true;
// return Json(new { Error = isNull });
//}
if (!ModelState.IsValid)
{
var errors = new List <string>();
foreach (var state in ModelState)
{
foreach (var error in state.Value.Errors)
{
errors.Add(error.ErrorMessage);
}
}
return(Json(new { Data = errors, Success = false }));
}
if (searchParams.IllustrationFrom > searchParams.IllustrationTo)
{
var errors = new List <string>();
errors.Add("To Date cannot be less than the From Date.");
return(Json(new { Data = errors, Success = false }));
}
var result = _illustrationHelper.GetIllustrationList(searchParams, true);
return(Json(new { Data = result, Success = true }));
}
private ApiResponse <PagedListResponse <ParameterViewModel> > Search(SearchParameterViewModel model)
{
var apiResp = new ApiResponse <PagedListResponse <ParameterViewModel> >
{
Type = ResponseType.Fail,
Data = new PagedListResponse <ParameterViewModel>()
};
var request = new FilteredPagedListRequest <SearchParameterCriteria>
{
FilterCriteria = new SearchParameterCriteria
{
Name = model.Name,
IncludeSystemParameters = model.IncludeSystemParameters
},
IncludeRecordsTotal = model.IncludeRecordsTotal,
Limit = model.Limit,
Offset = model.Offset
};
var resp = _parameterService.Search(request);
apiResp.Data.Items = resp.Items.Select(p => new ParameterViewModel
{
Id = p.Id,
TypeId = p.TypeId,
Order = p.Order,
Value = p.Value,
Description = p.Description,
IsSystem = p.IsSystem
});
apiResp.Data.RecordsTotal = resp.RecordsTotal;
apiResp.Type = ResponseType.Success;
return(apiResp);
}
///Get all items with some search condition
public List <TViewModel> GetAll(SearchParameterViewModel searchParameters)
{
throw new NotImplementedException();
}
public ActionResult ExportCSV(SearchParameterViewModel searchParameter)
{
var result = _illustrationHelper.GetIllustrationList(searchParameter, true);
// StringBuilder sbheader = new StringBuilder();
//StringBuilder sbheader = new StringBuilder();
StringBuilder sb = new StringBuilder();
sb.Append(string.Format("{0},", "Introducer"));
sb.Append(string.Format("{0},", "Account Reference"));
sb.Append(string.Format("{0},", "Account Name"));
sb.Append(string.Format("{0},", "Lead Type or Name"));
sb.Append(string.Format("{0},", "Last Name"));
sb.Append(string.Format("{0},", "Name"));
sb.Append(string.Format("{0},", "Adviser's Email Address"));
sb.Append(string.Format("{0},", "Marketing Source"));
sb.Append(string.Format("{0},", "Categories"));
sb.Append(string.Format("{0},", "Client Category"));
sb.Append(string.Format("{0},", "Salesperson"));
sb.Append(string.Format("{0},", "Account Manager"));
sb.Append(string.Format("{0},", "Minimum Deposit"));
sb.Append(string.Format("{0},", "Maximum Deposit"));
sb.Append(string.Format("{0},", "Source Function"));
sb.Append(string.Format("{0},", "Advisor"));
sb.Append(string.Format("{0},", "Introducer Account"));
sb.Append(string.Format("{0},", "Umbrella Organisation")).AppendLine();
foreach (var data in result)
{
string[] name;
string fname = string.Empty;
string LName = string.Empty;
if (!string.IsNullOrEmpty(data.ClientName))
{
if (data.ClientName.Contains(" "))
{
name = data.ClientName.Split(" ");
if (name.Length > 1)
{
List <string> fName = name.Take(name.Length - 1).ToList();
foreach (var item in fName)
{
fname += item + " ";
}
LName = name.Last();
}
}
else
{
fname = data.ClientName;
}
}
sb.Append(string.Format("{0},", "No"));
sb.Append(string.Format("{0},", data.IllustrationUniqueReference));
sb.Append(string.Format("{0},", data.ClientName));
sb.Append(string.Format("{0},", "Personal"));
sb.Append(string.Format("{0},", LName)); //Last Name
sb.Append(string.Format("{0},", fname)); //First Name
sb.Append(string.Format("{0},", data.PartnerEmail));
sb.Append(string.Format("{0},", "Introducer Referral"));
sb.Append(string.Format("{0},", "Client"));
sb.Append(string.Format("{0},", data.ClientType == "0" ? "Individual" : "Joint"));
sb.Append(string.Format("{0},", ""));
sb.Append(string.Format("{0},", ""));
sb.Append(string.Format("{0},", data.TotalDeposit));
sb.Append(string.Format("{0},", data.TotalDeposit));
sb.Append(string.Format("{0},", "Introducer"));
sb.Append(string.Format("{0},", data.PartnerName));
sb.Append(string.Format("{0},", data.PartnerOrganisation));
sb.Append(string.Format("{0},", string.Empty)).AppendLine();
}
// byte[] buffer = Encoding.ASCII.GetBytes();
return(Json(new { Data = sb.ToString(), FileName = "Illustration.csv" }));
}
