public static void InsertProffesional(DTO.ProffessionalPost proffessional)
{
using (DAL.TafToTafEntities2 db = new DAL.TafToTafEntities2())
{
db.Users.Add
(
new DAL.User()
{
KindUser = 2,
FirstName = proffessional.Name,
UserName = "******",
Password = proffessional.Id.ToString(),
Email = proffessional.ProffesionalEmail,
LastName = ""
}
);
db.SaveChanges();
ProfessionalDTO professionalDto = new ProfessionalDTO()
{
Monday = proffessional.Monday,
Name = proffessional.Name,
NumHourWork = proffessional.NumHourWork,
ProfessionKind = proffessional.ProfessionKind,
Sunday = proffessional.Sunday,
Thuesday = proffessional.Thuesday,
Tursday = proffessional.Tursday,
Wednesday = proffessional.Wednesday,
UserID = db.Users.FirstOrDefault(u => u.Password == proffessional.Id.ToString()).Id
};
db.Professionals.Add(ProfessionalC.ToProfessional(professionalDto));
//send Email Please
db.SaveChanges();
}
PublicLogic.SendEmail("TLT2", proffessional.Id.ToString(), proffessional.ProffesionalEmail);
}
public static List <ProfessionalDTO> SelectProffesionals()
{
List <ProfessionalDTO> ProffesionalsList = new List <ProfessionalDTO>();
using (DAL.TafToTafEntities2 db = new DAL.TafToTafEntities2())
{
var proffesionals = db.Professionals.OrderBy(p => p.ProfessionKind).ToList();
foreach (var proffesional in proffesionals)
{
ProffesionalsList.Add(ProfessionalC.ToProfessionalDto(proffesional));
}
}
return(ProffesionalsList);
}
