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 ProfessionalDTO SelectProfessionalByUserID(int id) { using (DAL.TafToTafEntities2 db = new DAL.TafToTafEntities2()) { var professional = db.Professionals.FirstOrDefault(p => p.userID == id); if (professional == null) { return(null); } return(Converters.ProfessionalC.ToProfessionalDto(professional)); } }
public static UserDto Login(string username, string password) { using (DAL.TafToTafEntities2 db = new DAL.TafToTafEntities2()) { var user = db.Users.FirstOrDefault(p => p.UserName == username && p.Password == password); if (user == null) { return(null); } return(UserC.ToUserDto(user)); } }
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); }
public static UserDto IsLoggedIn(string token) { int idUser = TokenLogic.DecodeToken(token); using (DAL.TafToTafEntities2 db = new DAL.TafToTafEntities2()) { var user = db.Users.FirstOrDefault(u => u.Id == idUser); if (user == null) { return(null); } return(UserC.ToUserDto(user)); } }
public static List <KinderGardenDto> SelectKinderGardens() { List <KinderGardenDto> listKinderGardens = new List <KinderGardenDto>(); using (DAL.TafToTafEntities2 db = new DAL.TafToTafEntities2()) { var kinderGardens = db.KinderGardens.ToList(); foreach (var kinderGarden in kinderGardens) { listKinderGardens.Add(KinderGardenC.ToKinderGardenDto(kinderGarden)); } } return(listKinderGardens); }
public static void EditProffesional(int id, DTO.ProfessionalDTO professional) { using (DAL.TafToTafEntities2 db = new DAL.TafToTafEntities2()) { var editProffesional = db.Professionals.FirstOrDefault(p => p.Id == id); if (editProffesional != null) { editProffesional.Name = professional.Name; editProffesional.NumHourWork = professional.NumHourWork; editProffesional.Sunday = professional.Sunday; editProffesional.Monday = professional.Monday; editProffesional.Thuesday = professional.Thuesday; editProffesional.Wednesday = professional.Wednesday; editProffesional.Tursday = professional.Tursday; } db.SaveChanges(); } }
public static List <KinderGardenDto> SelectWorkersKinderGardens(int profossionalId)//בוחרת גנים שהעובדת עובדת בהם { List <KinderGardenDto> listKinderGardens = new List <KinderGardenDto>(); List <int> kndId = new List <int>(); using (DAL.TafToTafEntities2 db = new DAL.TafToTafEntities2()) { var calendersKinderGarden = db.Calanders.Where(c => c.ProfessionalId == profossionalId && c.DateStart != null && c.DateStart.Value.Year == year).ToList(); foreach (var calenderkndg in calendersKinderGarden) { if (kndId.Contains(calenderkndg.KinderGardenId.Value) == false) { kndId.Add(calenderkndg.KinderGardenId.Value); } } foreach (var kndid in kndId) { listKinderGardens.Add(KinderGardenC.ToKinderGardenDto(db.KinderGardens.First(knd => knd.Id == kndid))); } } return(listKinderGardens); }
public static void DeleteProffesional(int id) { try { using (DAL.TafToTafEntities2 db = new DAL.TafToTafEntities2()) { var proffesional = db.Professionals.FirstOrDefault(p => p.Id == id); if (proffesional != null) { db.Professionals.Remove(proffesional); } var userProffesional = db.Users.FirstOrDefault(uP => uP.Password == proffesional.Id.ToString()); if (userProffesional != null) { db.Users.Remove(userProffesional); } db.SaveChanges(); } } catch (Exception ex) { throw new Exception(ex.Message); } }