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);
}
}
