public static void Write(PersonFullDisplayModel model)
{
Console.ForegroundColor = ConsoleColor.DarkBlue;
WriteLine($"Person: [{model.Id,-2}] - {model.FirstName} {model.LastName}");
Console.ResetColor();
WriteLine($" - Categories : {model.Category}");
WriteLine($" - Team : {model.Team}.");
}
public static PersonFullDisplayViewModel ToViewModel(this PersonFullDisplayModel src, IEnumerable <CategoryModel> categories = null)
{
var r = new PersonFullDisplayViewModel
{
Id = src.Id,
FirstName = src.FirstName,
LastName = src.LastName,
CategoryDisplay = src.Category,
};
if (categories != null)
{
var c = categories.ToViewModel(src.CategoryKey);
r.Categories = new ObservableCollection <CategoryViewModel>(c);
}
return(r);
}
public static PersonFullDisplayModel ToModel(this PersonFullDisplayViewModel src)
{
var result = new PersonFullDisplayModel
{
Id = src.Id,
FirstName = src.FirstName,
LastName = src.LastName,
Category = src.CategoryDisplay,
CategoryIds = (from c in src.Categories
where c.IsSelected
select c.Id).ToList(),
ReceptionIds = (from r in src.Receptions
where r.IsSelected
select r.Id).ToList()
};
return(result);
}
public void Create(PersonFullDisplayModel person)
{
var categories = new List <CategoryModel>();
foreach (var catId in person.CategoryIds)
{
categories.Add(new CategoryModel {
Id = catId
});
}
var p = new PersonModel
{
FirstName = person.FirstName,
LastName = person.LastName,
Categories = categories,
};
Create(p);
}
public IEnumerable <AbsenceDisplayModel> GetAbsencesOf(PersonFullDisplayModel person)
{
using (var c = NewConnection())
{
var sql = @"
select id as Id
, date_start as ""From""
, date_end as ""To""
, person_id as PersonId
from absence
where person_id = @pid
order by date_start desc";
using (var cmd = GetCommand(sql, c))
{
cmd.AddParameter("pid", person.Id);
var result = cmd.ExecuteReader()
.AsAbsenceDisplayModel();
return(result);
}
}
}
public static IEnumerable <PersonFullDisplayModel> AsPersonFullDisplayModel(this IDataReader reader)
{
var result = new List <PersonFullDisplayModel>();
while (reader.Read())
{
var person = new PersonFullDisplayModel
{
Category = (reader.HasColumn("Category")) ? reader["Category"] as string : null,
FirstName = (reader.HasColumn("FirstName")) ? reader["FirstName"] as string : null,
Id = (reader.HasColumn("Id")) ? (long)reader["Id"] : default(long),
CategoryKey = (reader.HasColumn("CategoryKey")) ? reader["CategoryKey"] as string : null,
LastName = (reader.HasColumn("LastName")) ? reader["LastName"] as string : null,
///
//CategoryIds = (reader.HasColumn("Id")) ? (long)reader["Id"] : default(long),
PickupRound = (reader.HasColumn("PickupRound")) ? reader["PickupRound"] as string : null,
PickupRoundId = (reader.HasColumn("PickupRoundId")) ? (long)reader["PickupRoundId"] : default(long),
Team = (reader.HasColumn("Team")) ? reader["Team"] as string : null,
TeamId = (reader.HasColumn("TeamId")) ? (long)reader["TeamId"] : default(long),
};
result.Add(person);
}
return(result);
}
public void Update(PersonFullDisplayModel person)
{
new UpdatePerson(DbLocator)
.WithContext(person)
.Execute();
}
