public void SetUserWeightTech(string pUserId, int pWeight) { using (touchdbEntities context = new touchdbEntities()) { context.sp_User_TechRegister(Guid.Parse(pUserId), pWeight); } }
public void DeleteUserEntertainment(string pUserId, int pGenreId) { using (touchdbEntities context = new touchdbEntities()) { context.sp_User_EntertainmentDelete(Guid.Parse(pUserId), pGenreId); } }
public void DeleteUser(string pUserId) { using (touchdbEntities context = new touchdbEntities()) { context.sp_UserDelete(Guid.Parse(pUserId)); } }
public void FindAllMatch(string pUserId) { using (touchdbEntities context = new touchdbEntities()) { context.sp_FindAllMatchForUser(Guid.Parse(pUserId)); } }
public List <sp_GetUserMatchs_Result> GetUserMatch(string pUserId) { using (touchdbEntities context = new touchdbEntities()) { var pUserMatch = context.sp_GetUserMatchs(Guid.Parse(pUserId)).ToList(); return(pUserMatch); } }
public List <sp_UserSelect_Result> UserMasterSelect() { using (touchdbEntities context = new touchdbEntities()) { var pRegisteredUsers = context.sp_UserSelect().ToList(); return(pRegisteredUsers); } }
public List <sp_FacultySelect_Result> FacultyMasterSelect(int pFacultyId) { using (touchdbEntities context = new touchdbEntities()) { var pFacultyMaster = context.sp_FacultySelect(pFacultyId).ToList(); return(pFacultyMaster); } }
public List <sp_SportsSelect_Result> SportsMasterSelect(int pGenreId) { using (touchdbEntities context = new touchdbEntities()) { var pSportMaster = context.sp_SportsSelect(pGenreId).ToList(); return(pSportMaster); } }
public List <sp_MusicSelect_Result> MusicMasterSelect(int pGenreId) { using (touchdbEntities context = new touchdbEntities()) { var pMusicMaster = context.sp_MusicSelect(pGenreId).ToList(); return(pMusicMaster); } }
public List <sp_GetUserSportLikes_Result> GetUserSportLikes(string pUserId) { using (touchdbEntities context = new touchdbEntities()) { var pUserGetUserSportLikes = context.sp_GetUserSportLikes(Guid.Parse(pUserId)).ToList(); return(pUserGetUserSportLikes); } }
public sp_UserUpdatePhoto_Result UpdateUserPhoto(string pUserId, string pImageUrl) { using (touchdbEntities context = new touchdbEntities()) { var pUserPhoto = context.sp_UserUpdatePhoto(Guid.Parse(pUserId), pImageUrl).FirstOrDefault(); return(pUserPhoto); } }
public List <sp_EntertainmentSelect_Result> EntertainmentMasterSelect(int pGenreId) { using (touchdbEntities context = new touchdbEntities()) { var pEnterMaster = context.sp_EntertainmentSelect(pGenreId).ToList(); return(pEnterMaster); } }
public sp_UserSelectPassword_Result GetUserPassword(Guid pUserId) { using (touchdbEntities context = new touchdbEntities()) { var Password = context.sp_UserSelectPassword(pUserId).FirstOrDefault(); return(Password); } }
public sp_UserSelectByEmail_Result GetUserByEmail(string pEmail) { using (touchdbEntities context = new touchdbEntities()) { var pUser = context.sp_UserSelectByEmail(pEmail).FirstOrDefault(); return(pUser); } }
public sp_User_SportRegister_Result SetUserLikesSport(string pUserId, int pGenreId) { using (touchdbEntities context = new touchdbEntities()) { var pSportRegistered = context.sp_User_SportRegister(Guid.Parse(pUserId), pGenreId).FirstOrDefault(); return(pSportRegistered); } }
public sp_UserSelectById_Result GetUserProfile(string pUserId) { using (touchdbEntities context = new touchdbEntities()) { var pUserProfile = context.sp_UserSelectById(Guid.Parse(pUserId)).FirstOrDefault(); return(pUserProfile); } }
public sp_UserUpdateProfile_Result UpdateUserProfile(string pUserId, string pFirstName, string pLastName, string pPhoneNumber, DateTime pNacDate, char pGender, char pGenderPref, string pEmail, int pFaculty, string pImageUrl) { using (touchdbEntities context = new touchdbEntities()) { var pUserProfile = context.sp_UserUpdateProfile(Guid.Parse(pUserId), pFirstName, pLastName, pPhoneNumber, pNacDate, pGender.ToString(), pGenderPref.ToString(), pEmail, pFaculty, pImageUrl).FirstOrDefault(); return(pUserProfile); } }
public sp_UserRegister_Result RegisterUser(string pEmail, string pPassword, string pFirstName, string pLastName, string pPhoneNumber) { using (touchdbEntities context = new touchdbEntities()) { var pRegisteredUser = context.sp_UserRegister(pEmail, pPassword, pFirstName, pLastName, pPhoneNumber).FirstOrDefault(); return(pRegisteredUser); } }