internal vwManager FindManagerCredentials(string userName, string password) { try { using (CompanyDBEntities context = new CompanyDBEntities()) { string encryptedPassword = EncryptionHelper.Encrypt(password); vwManager managerToFind = (from m in context.vwManagers where m.Username == userName && m.UserPassword == encryptedPassword select m).First(); return(managerToFind); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Doctor not found!" + ex.Message.ToString()); return(null); } }
internal vwManager AddManager(vwManager manager) { try { using (CompanyDBEntities context = new CompanyDBEntities()) { tblUser newUser = new tblUser(); newUser.FirstName = manager.FirstName; newUser.LastName = manager.LastName; newUser.JMBG = manager.JMBG; newUser.Gender = manager.Gender; newUser.Residence = manager.Residence; newUser.MarriageStatus = manager.MarriageStatus; newUser.Username = manager.Username; newUser.UserPassword = manager.UserPassword; context.tblUsers.Add(newUser); context.SaveChanges(); manager.UserID = newUser.UserID; tblManager newManager = new tblManager(); newManager.Email = manager.Email; newManager.ReservedPassword = manager.ReservedPassword; newManager.SuccessfulProjects = manager.SuccessfulProjects; newManager.OfficeNumber = manager.OfficeNumber; newManager.UserID = manager.UserID; context.tblManagers.Add(newManager); context.SaveChanges(); manager.ManagerID = newManager.ManagerID; return(manager); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }