public ActionResult FindDetails(Models.Person personModel)
{
var results = PersonRepository.SearchPerson(personModel.FirstName, personModel.LastName);
var personList = new List <Person>();
foreach (var item in results)
{
var tempAge = item.Age;
var person = new Person
{
Id = item.Id,
FirstName = item.FirstName,
LastName = item.LastName,
Age = item.Age,
Description = ListAgeGroup.Find(x => tempAge >= x.MinAge && tempAge < x.MaxAge).Description
};
personList.Add(person);
}
ViewBag.PersonDetails = personList;
return(View());
}
/// <summary>
/// Get all data from from AgeGroup
/// </summary>
/// <param name="iSqlFactory"></param>
/// <returns>list</returns>
public ListAgeGroup GetAgeGroup(ISqlFactory iSqlFactory)
{
ListAgeGroup lAgeGroup = new ListAgeGroup();
lAgeGroup.ListOfAgeGroup = new List <AgeGroupModel>();
try
{
DbDataReader datareader;
DbCommand command;
string sqlcommand = "SELECT * From AgeGroup";
using (DbConnection conn = iSqlFactory.CreateConnection())
{
conn.Open();
command = iSqlFactory.ExecuteCommand(sqlcommand, conn);
datareader = command.ExecuteReader();
while (datareader.Read())
{
var ageGroup = new AgeGroupModel();
ageGroup.Id = Convert.ToInt32(datareader["Id"]);
ageGroup.MinAge = Convert.ToInt32(datareader["MinAge"] == DBNull.Value ? null : datareader["MinAge"]);
ageGroup.MaxAge = Convert.ToInt32(datareader["MaxAge"] == DBNull.Value ? null : datareader["MaxAge"]);
ageGroup.Description = datareader["Description"].ToString();
lAgeGroup.ListOfAgeGroup.Add(ageGroup);
}
}
}
catch (DbException ex)
{
lAgeGroup.Message.Add(new Response
{
MessageCode = "Error",
MessageDetails = ex.Message
});
}
return(lAgeGroup);
}
public ListAgeGroup GetListOfAgeGroup(ISqlFactory iSqlFactory)
{
ListAgeGroup lAgeGroup = new ListAgeGroup();
try
{
IPersonDB person = new PersonDb();
lAgeGroup = person.GetAgeGroup(iSqlFactory);
}
catch (DbException ex)
{
lAgeGroup.Message.Add(new Response
{
MessageCode = "Error",
MessageDetails = ex.Message
});
}
return(lAgeGroup);
}
public ActionResult GetDetails()
{
var result = PersonRepository.GetAllPerson();
var personList = new List <Person>();
foreach (var item in result)
{
var tempAge = item.Age;
var person = new Person
{
Id = item.Id,
FirstName = item.FirstName,
LastName = item.LastName,
Age = item.Age,
Description = ListAgeGroup.Find(x => tempAge >= x.MinAge && (x.MaxAge != 0 ? tempAge < x.MaxAge : true)).Description
};
personList.Add(person);
}
return(View(personList));
}
