public List <ClassInfoModel> GetClassData(string classId)
{
var id = Guid.Parse(classId);
List <ClassInfoModel> classInfoModelList = new List <ClassInfoModel>();
using (var dbConn = new SapremaFinalContext())
{
IEnumerable <SapClass> sapClassList = dbConn.SapClass.Where(a => a.ClassGroupId == id);
if (sapClassList == null)
{
return(null);
}
foreach (SapClass sapClass in sapClassList)
{
ClassInfoModel classInfoModel = new ClassInfoModel()
{
ClassCreatedBy = sapClass.ClassCreatedBy,
ClassName = sapClass.ClassName,
ClassLevel = Convert.ToInt32(sapClass.ClassLevel),
ClassTheme = sapClass.ClassTheme,
ClassDescription = sapClass.ClassDescription,
ClassId = sapClass.ClassId,
GroupId = sapClass.ClassGroupId.Value
};
classInfoModelList.Add(classInfoModel);
}
return(classInfoModelList);
}
}
public List <MeditationStoreModel> GetUserMeditations(string id)
{
List <MeditationStoreModel> meditationStoreModel = new List <MeditationStoreModel>();
using (var dbConn = new SapremaFinalContext())
{
var meditationList = dbConn.SapMeditations.ToList();
foreach (var record in meditationList)
{
var meditationStars = dbConn.SapReviewMeditation.Where(a => a.MeditationId == record.MeditationId).Select(r => r.ReviewStars).DefaultIfEmpty().Average();
MeditationStoreModel mModel = new MeditationStoreModel()
{
MeditationName = record.MeditationName,
//MeditationImage = record.MeditationImage.ToString(),
MeditationCreator = record.MeditationCreator, //new Get().GetTeacherName(record.MeditationCreator),
MeditationTheme = record.MeditationTheme,
MeditationType = record.MeditationType,
MeditationId = record.MeditationId.ToString(),
MeditationRating = meditationStars,
MeditationPurchased = new Get().GetMeditationPurchased(id, record.MeditationId)
};
meditationStoreModel.Add(mModel);
}
return(meditationStoreModel);
}
}
/*
* Come back to this: Round review to nearest .5 to work with star rating in CSS
* Check for null within reviews
* */
public List <MeditationModel> GetAllMeditations()
{
List <MeditationModel> meditationsModel = new List <MeditationModel>();
using (var dbConn = new SapremaFinalContext())
{
var meditationsList = dbConn.SapMeditations.ToList();
foreach (var record in meditationsList)
{
//var meditationStars = dbConn.SapReviewMeditation.Where(a => a.MeditationId == record.MeditationId).Select(r => r.ReviewStars).DefaultIfEmpty().Average();
MeditationModel mModel = new MeditationModel()
{
MeditationName = record.MeditationName,
MeditationDescription = record.MeditationDescription.ToString(),
MeditationCreator = record.MeditationCreator.ToString(),
MeditationTheme = record.MeditationTheme,
MeditationType = record.MeditationType,
MeditationId = record.MeditationId.ToString(),
MeditationRating = 5
};
meditationsModel.Add(mModel);
}
return(meditationsModel);
}
}
/*
* Get a list of all poses and see if a user has chosen ot omit them
* */
public List <UserPosesModel> GetAllUserPoses(string id)
{
List <UserPosesModel> userPoseModel = new List <UserPosesModel>();
using (var dbConn = new SapremaFinalContext())
{
var poseList = dbConn.SapPoses.ToList();
foreach (var record in poseList)
{
UserPosesModel uModel = new UserPosesModel()
{
PoseId = record.PoseId,
PoseName = record.PoseName,
PoseLevel = record.PoseLevel,
PoseTheme = record.PoseTheme,
PoseOmit = new Get().CheckOmit(id, record.PoseId)
};
userPoseModel.Add(uModel);
}
return(userPoseModel);
}
}
/*
* Get all reviews of a single meditation
* */
public List <ReviewModel> GetAllMeditationReviews(string meditationId)
{
List <ReviewModel> meditationsReviewModel = new List <ReviewModel>();
var id = Guid.Parse(meditationId);
using (var dbConn = new SapremaFinalContext())
{
var reviewList = dbConn.SapReviewMeditation.Where(a => a.MeditationId == id).ToList();
foreach (var record in reviewList)
{
ReviewModel mModel = new ReviewModel()
{
ReviewId = record.ReviewMeditationId,
ItemId = record.MeditationId,
ReviewComment = record.ReviewComment,
ReviewStars = record.ReviewStars,
Username = new Get().GetUserName(record.UserId)
};
meditationsReviewModel.Add(mModel);
}
return(meditationsReviewModel);
}
}
/*
* Get a username
* */
public string GetUserName(string id)
{
using (var dbConn = new SapremaFinalContext())
{
var username = dbConn.AspNetUsers.Where(a => a.Id == id).Select(b => b.UserName).FirstOrDefault();
return(username);
}
}
/*
* Get a teachers name
* */
public string GetTeacherName(string id)
{
using (var dbConn = new SapremaFinalContext())
{
var name = dbConn.SapTeachers.Where(a => a.TeachId == id).Select(b => b.FullName).FirstOrDefault();
return(name);
}
}
/*
* Get all meditation types
* */
public List <string> GetMeditationTypes()
{
using (var dbConn = new SapremaFinalContext())
{
var typeList = dbConn.SapMeditations.Select(a => a.MeditationType).Distinct().ToList();
return(typeList);
}
}
/*
* Test get to check API database connection
* */
public AspNetUsers GetUser(string userId)
{
using (var dbConn = new SapremaFinalContext())
{
var user = dbConn.AspNetUsers.Where(a => a.Id == userId).SingleOrDefault();
return(user);
}
}
// This returns a single teacher id
public string GetTeacher(string teacherId)
{
using (var dbConn = new SapremaFinalContext())
{
var teacher = dbConn.SapTeachers.Where(a => a.TeachId == teacherId).SingleOrDefault();
var teachId = teacher.TeachId;
return(teachId);
}
}
//public IQueryable<SapPoses> GetUserPoses(string userId)
//{
// using (var dbConn = new SapremaFinalContext())
// {
// var userPoseId = dbConn.SapUserPoses.Where(a => a.UserId == userId).Select(b => b.PoseId).ToList();
// var poses = dbConn.SapPoses.Where(a => userPoseId.Contains(a.PoseId));
// return poses;
// }
//}
// This returns the list of poses within the app
public Dictionary <string, List <SapPoses> > GetPoseList()
{
using (var dbConn = new SapremaFinalContext())
{
var poseList = dbConn.SapPoses.GroupBy(themeName => themeName.PoseTheme)
.ToDictionary(kv => kv.Key, kv => kv.ToList());
return(poseList);
}
}
public bool CreateMeditation(SapMeditations meditation)
{
using (var dbConn = new SapremaFinalContext())
{
meditation.MeditationId = Guid.NewGuid();
dbConn.SapMeditations.Add(meditation);
dbConn.SaveChanges();
return(true);
}
}
public bool CreateGroup(SapGroups group)
{
using (var dbConn = new SapremaFinalContext())
{
group.GroupId = Guid.NewGuid();
dbConn.SapGroups.Add(group);
dbConn.SaveChanges();
return(true);
}
}
public bool CreateMeditationReview(SapReviewMeditation meditationReview)
{
using (var dbConn = new SapremaFinalContext())
{
meditationReview.ReviewMeditationId = Guid.NewGuid();
dbConn.SapReviewMeditation.Add(meditationReview);
dbConn.SaveChanges();
return(true);
}
}
// This returns a teachers studio
public string GetTeacherSite(string teacherId)
{
//Models.ManageViewModels.TeacherModelVM teacherModelVM = new Models.ManageViewModels.TeacherModelVM();
using (var dbConn = new SapremaFinalContext())
{
var teacher = dbConn.SapTeachers.Where(a => a.TeachId == teacherId).SingleOrDefault();
var site = teacher.Site;
return(site);
}
}
public MeditationViewModel GetSingleMeditation(string meditationId)
{
Guid medId = Guid.Parse(meditationId);
using (var dbConn = new SapremaFinalContext())
{
return(dbConn.SapMeditations.Where(meditation => meditation.MeditationId == medId).Select(meditation => new MeditationViewModel()
{
MeditateName = meditation.MeditationName, MeditateTheme = meditation.MeditationTheme, MeditateType = meditation.MeditationType, ImageUrl = new DALHelpers().ConvertToImagePath(meditation.MeditationId, "~/images/meditationimg/")
}).FirstOrDefault());
}
}
public List <MyGroupsViewModel> GetMyGroups(String groupId)
{
var groupGuid = Guid.Parse(groupId);
using (var dbConn = new SapremaFinalContext())
{
return(dbConn.SapGroups.Where(group => group.GroupId == groupGuid).Select(group => new MyGroupsViewModel()
{
GroupName = group.GroupName, GroupTeacher = group.GroupAdmin, GroupDescription = group.GroupDescription, GroupId = group.GroupId.ToString()
}).ToList());
}
}
// This returns all teachers
public ManageTeachersViewModel ManageTeachers()
{
ManageTeachersViewModel manageTeacherViewModels = new ManageTeachersViewModel();
using (var dbConn = new SapremaFinalContext())
{
manageTeacherViewModels.TeacherItems = dbConn.SapTeachers.Select(teacher => new ManageTeacherItem()
{
TeachId = teacher.TeachId, FullName = teacher.FullName, Verified = teacher.Verified
}).ToList();
return(manageTeacherViewModels);
}
}
//public ManageMeditationsViewModel GetAllMeditations(string teacherId)
public ManageMeditationsViewModel GetTeachers()
{
ManageMeditationsViewModel manageMeditationViewModels = new ManageMeditationsViewModel();
using (var dbConn = new SapremaFinalContext())
{
manageMeditationViewModels.MeditationItems = dbConn.SapMeditations.Select(meditation => new ManageMeditationItem()
{
MeditationId = meditation.MeditationId, MeditationName = meditation.MeditationName
}).ToList();
return(manageMeditationViewModels);
}
}
public PlayMeditationViewModel GetPlayMeditation(Guid meditationId)
{
PlayMeditationViewModel playMeditationViewModel = new PlayMeditationViewModel();
using (var dbConn = new SapremaFinalContext())
{
dbConn.SapMeditations.Where(a => a.MeditationId == meditationId).Select(meditatation => new PlayMeditationViewModel()
{
MeditationId = meditatation.MeditationId, MeditationImage = meditatation.MeditationImage, MeditationName = meditatation.MeditationName, MedPath = new DALHelpers().ConvertToAudioPath(meditatation.MeditationId)
});
//Select(meditation => new playMeditationViewModel() { MeditationId = meditation.MeditationId, MeditationImage = meditation.MeditationImage, MeditationName = meditation.MeditationName }).ToList();
return(playMeditationViewModel);
}
}
//Add user group join to db
public bool CreateUserGroup(string userId, Guid groupId)
{
using (var dbConn = new SapremaFinalContext())
{
SapUserGroups sapUserGroup = new SapUserGroups()
{
UserId = userId,
GroupId = groupId,
//UsergroupKey = Guid.NewGuid()
};
dbConn.SapUserGroups.Add(sapUserGroup);
dbConn.SaveChanges();
};
return(true);
}
//Adds user meditation purchase to db
public bool CreateUserMeditation(Guid meditationId, string userId)
{
using (var dbConn = new SapremaFinalContext())
{
SapUserMeditations sapUserMeditation = new SapUserMeditations()
{
MeditationId = meditationId,
UserId = userId,
//UsermeditationKey = Guid.NewGuid()
};
dbConn.SapUserMeditations.Add(sapUserMeditation);
dbConn.SaveChanges();
};
return(true);
}
public bool CreateFlaggedItem(FlaggedModel flaggedModel)
{
using (var dbConn = new SapremaFinalContext())
{
if (flaggedModel.FlagType.Equals("class"))
{
SapFlagClasses classFlag = new SapFlagClasses()
{
FlagId = Guid.NewGuid(),
ClassId = flaggedModel.ItemId,
ClassReviewId = flaggedModel.ReviewId,
UserId = flaggedModel.FlaggedBy,
ReasonFlagged = flaggedModel.ReasonFlagged,
FlagComment = flaggedModel.FlagComment,
FlagResolved = false
};
dbConn.SapFlagClasses.Add(classFlag);
dbConn.SaveChanges();
return(true);
}
else if (flaggedModel.FlagType.Equals("meditation"))
{
SapFlagMeditations meditationFlag = new SapFlagMeditations()
{
FlagId = Guid.NewGuid(),
MeditationId = flaggedModel.ItemId,
MeditationReviewId = flaggedModel.ReviewId,
UserId = flaggedModel.FlaggedBy,
ReasonFlagged = flaggedModel.ReasonFlagged,
FlagComment = flaggedModel.FlagComment,
FlagResolved = false
};
dbConn.SapFlagMeditations.Add(meditationFlag);
dbConn.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
public bool UpdateGroup(SapGroups group)
{
using (var dbConn = new SapremaFinalContext())
{
SapGroups sapGroups = dbConn.SapGroups.Where(a => a.GroupId == group.GroupId).FirstOrDefault();
sapGroups.GroupName = group.GroupName;
sapGroups.GroupStatus = group.GroupStatus;
sapGroups.GroupDescription = group.GroupDescription;
sapGroups.GroupLevel = group.GroupLevel;
dbConn.SaveChanges();
};
return(true);
}
public bool RegisterRole(string userId)
{
using (var dbConn = new SapremaFinalContext())
{
Guid newId = Guid.NewGuid();
AspNetUserRoles aspNetUserRoles = new AspNetUserRoles()
{
UserId = userId,
RoleId = "88fea492-c81d-440d-8252-72f6b900a83b",
UserRoleId = newId
};
dbConn.AspNetUserRoles.Add(aspNetUserRoles);
dbConn.SaveChanges();
};
return(true);
}
//Adds completed class details to db
public bool CreateClassComplete(string userId, DateTime dateComplete, Guid classId)
{
using (var dbConn = new SapremaFinalContext())
{
SapClassComplete sapClassComplete = new SapClassComplete()
{
ClassId = classId,
UserId = userId,
//DateComplete = dateComplete,
//ClasscompleteKey = Guid.NewGuid()
};
dbConn.SapClassComplete.Add(sapClassComplete);
dbConn.SaveChanges();
};
return(true);
}
/*
* Check if a meditation is purchased
* */
public bool GetMeditationPurchased(string userId, Guid meditationId)
{
using (var dbConn = new SapremaFinalContext())
{
var purchased = dbConn.SapUserMeditations.Where(a => a.UserId == userId && a.MeditationId == meditationId).SingleOrDefault();
if (purchased != null)
{
return(true);
}
else
{
return(false);
}
}
}
public ManageMeditationsViewModel GetMeditation(string meditationId)
{
Guid medId = Guid.Parse(meditationId);
using (var dbConn = new SapremaFinalContext())
{
var manageMeditationsViewModel = dbConn.SapMeditations.Where(meditation => meditation.MeditationId == medId).Select(meditation => new ManageMeditationsViewModel()
{
MeditateName = meditation.MeditationName, MeditateTheme = meditation.MeditationTheme, MeditateType = meditation.MeditationType, ImageUrl = new DALHelpers().ConvertToImagePath(meditation.MeditationImage, "~/images/meditationimg/"), MeditationId = meditation.MeditationId.ToString()
}).FirstOrDefault();
manageMeditationsViewModel.MeditationItems = dbConn.SapMeditations.Select(meditation => new ManageMeditationItem()
{
MeditationId = meditation.MeditationId, MeditationName = meditation.MeditationName
}).ToList();
return(manageMeditationsViewModel);
}
}
/*
* Check omit status of pose
* */
public bool CheckOmit(string userId, string poseId)
{
using (var dbConn = new SapremaFinalContext())
{
var omit = dbConn.SapUserPoses.Where(a => a.UserId == userId && a.PoseId == poseId).FirstOrDefault();
if (omit == null)
{
return(false);
}
else
{
return(true);
}
}
}
public bool OmitPose(string itemid, string userid)
{
SapUserPoses userPose = new SapUserPoses()
{
UserId = userid,
PoseId = itemid,
UserPoseId = Guid.NewGuid()
};
using (var dbConn = new SapremaFinalContext())
{
dbConn.SapUserPoses.Add(userPose);
dbConn.SaveChanges();
return(true);
}
}
