public ListOfPersons GetListOfPersonWithDescription(ISqlFactory iSqlFactory) { ListOfPersons lPerson = new ListOfPersons(); try { IPersonDB person = new PersonDb(); var ageGroup = GetListOfAgeGroup(iSqlFactory); lPerson = person.GetDataFromPersonTable(iSqlFactory); foreach (var item in lPerson.lPersonModel) { item.Description = ageGroup.ListOfAgeGroup.Where(x => x.MinAge <= item.Age && x.MaxAge > item.Age).Select(z => z.Description).SingleOrDefault(); } } catch (DbException ex) { lPerson.Message.Add(new Response { MessageCode = "Error", MessageDetails = ex.Message }); } return(lPerson); }
public ListOfPersons SearchForPerson(PersonModel personModel, ISqlFactory iSqlFactory) { ListOfPersons lSearchPerson = new ListOfPersons(); try { IPersonDB person = new PersonDb(); var lPerson = GetListOfPersonWithDescription(iSqlFactory); lSearchPerson.lPersonModel = lPerson.lPersonModel.Where(x => x.FirstName == personModel.FirstName || x.LastName == personModel.LastName) .Select(z => new PersonModel { Id = z.Id, FirstName = z.FirstName, LastName = z.LastName, Age = z.Age, Description = z.Description }).ToList(); } catch (DbException ex) { lSearchPerson.Message.Add(new Response { MessageCode = "Error", MessageDetails = ex.Message }); } return(lSearchPerson); }
public ListOfPersons GetListOfPersons() { ListOfPersons lPersons = new ListOfPersons(); PersonBiz personBiz = new PersonBiz(); AgeRanger.Data.AgeRangerDataFactory ageRangerDataFactory = new Data.AgeRangerDataFactory(); ISqlFactory sqlFactory = ageRangerDataFactory.GetReposotory(); lPersons = personBiz.GetListOfPersonWithDescription(sqlFactory); return(lPersons); }
public ListOfPersons GetListOfPerson(ISqlFactory sqlFactory) { ListOfPersons lPerson = new ListOfPersons(); try { IPersonDB person = new PersonDb(); lPerson = person.GetDataFromPersonTable(sqlFactory); } catch (DbException ex) { lPerson.Message.Add(new Response { MessageCode = "Error", MessageDetails = ex.Message }); } return(lPerson); }
/// <summary> /// Get record from Person table. /// </summary> /// <param name="selectCommand"></param> /// <returns></returns> public ListOfPersons GetDataFromPersonTable(ISqlFactory iSqlFactory) { ListOfPersons lPerson = new ListOfPersons(); lPerson.lPersonModel = new List <PersonModel>(); PersonModel person; try { DbCommand command; DbDataReader datareader; string Sqlcommand = "Select * from Person"; using (DbConnection conn = iSqlFactory.CreateConnection()) { conn.Open(); command = iSqlFactory.ExecuteCommand(Sqlcommand, conn); datareader = command.ExecuteReader(); while (datareader.Read()) { person = new PersonModel(); person.Id = Convert.ToInt32(datareader["Id"]); person.FirstName = datareader["FirstName"].ToString(); person.LastName = datareader["LastName"].ToString(); person.Age = Convert.ToInt32(datareader["Age"]); lPerson.lPersonModel.Add(person); } } } catch (DbException ex) { lPerson.Message.Add(new Response { MessageCode = "Error", MessageDetails = ex.Message }); } return(lPerson); }
static void Main(string[] args) { ListOfPersons NewPerson = new ListOfPersons(); string Filepath = @"C:\Users\stenk\samples"; string Filename = @"Frozen.txt"; string fullpath = Path.Combine(Filepath, Filename); string[] Personsfromfile = File.ReadAllLines(fullpath); foreach (string line in Personsfromfile) { string[] tempArray = line.Split(new char[] { '/' }, StringSplitOptions.RemoveEmptyEntries); string personName = tempArray[0]; string Itemname = tempArray[1]; NewPerson.Addpersonstolist(personName, Itemname); } NewPerson.PrintPerson(); }