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);
}
}
}
/*
* Update flagged item status
* Come back to this for error reporting
* */
public bool ResolveFlaggedItem(string itemId, string status)
{
if (status.Equals("true") || status.Equals("false"))
{
var type = new Get().GetFlagType(itemId);
var id = Guid.Parse(itemId);
bool resolution = Boolean.Parse(status);
using (var dbConn = new SapremaFinalContext())
{
if (type.Equals("meditation"))
{
SapFlagMeditations sapFlagMeditations = dbConn.SapFlagMeditations.Where(a => a.FlagId == id).FirstOrDefault();
sapFlagMeditations.FlagResolved = resolution;
dbConn.SaveChanges();
return(true);
}
else if (type.Equals("class"))
{
SapFlagClasses sapFlagClasses = dbConn.SapFlagClasses.Where(a => a.FlagId == id).FirstOrDefault();
sapFlagClasses.FlagResolved = resolution;
dbConn.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
else
{
return(false);
}
}
public bool CreateMeditation(SapMeditations meditation)
{
using (var dbConn = new SapremaFinalContext())
{
meditation.MeditationId = Guid.NewGuid();
dbConn.SapMeditations.Add(meditation);
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);
}
}
public bool CreateGroup(SapGroups group)
{
using (var dbConn = new SapremaFinalContext())
{
group.GroupId = Guid.NewGuid();
dbConn.SapGroups.Add(group);
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);
}
//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 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);
}
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);
}
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 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);
}
}
/*
* Come back to this need to create proper saving for audio and image
* */
public bool UpdateMeditation(SapMeditations meditation)
{
using (var dbConn = new SapremaFinalContext())
{
SapMeditations sapMeditation = dbConn.SapMeditations.Where(a => a.MeditationId == meditation.MeditationId).FirstOrDefault();
sapMeditation.MeditationName = meditation.MeditationName;
sapMeditation.MeditationTheme = meditation.MeditationTheme;
sapMeditation.MeditationCreator = meditation.MeditationCreator;
sapMeditation.MeditationType = meditation.MeditationType;
sapMeditation.MeditationDescription = meditation.MeditationDescription;
dbConn.SaveChanges();
};
return(true);
}
//Add class review to db
public bool CreateClassReview(string userId, Guid classId, decimal reviewStars, string reviewComment)
{
using (var dbConn = new SapremaFinalContext())
{
SapReviewClass sapReviewClass = new SapReviewClass()
{
UserId = userId,
ClassId = classId,
ReviewStars = reviewStars,
ReviewComment = reviewComment,
//ReviewclassKey = Guid.NewGuid()
};
dbConn.SapReviewClass.Add(sapReviewClass);
dbConn.SaveChanges();
};
return(true);
}
//Add meditation review to db
public bool CreateMeditationReview(string userId, Guid meditationId, decimal reviewStars, string reviewComment)
{
using (var dbConn = new SapremaFinalContext())
{
SapReviewMeditation sapReviewMeditation = new SapReviewMeditation()
{
UserId = userId,
MeditationId = meditationId,
ReviewStars = reviewStars,
ReviewComment = reviewComment,
//ReviewmeditationKey = Guid.NewGuid()
};
dbConn.SapReviewMeditation.Add(sapReviewMeditation);
dbConn.SaveChanges();
};
return(true);
}
public bool IncludePose(string poseid, string userid)
{
using (var dbConn = new SapremaFinalContext())
{
var pose = dbConn.SapUserPoses.Where(a => a.UserId == userid && a.PoseId == poseid).FirstOrDefault();
if (pose != null)
{
dbConn.SapUserPoses.Remove(pose);
dbConn.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
//Adds a group to the db
public bool CreateGroup(string groupName, string groupDescription, string groupTeacher, int groupLevel)
{
using (var dbConn = new SapremaFinalContext())
{
SapGroups sapGroups = new SapGroups()
{
GroupId = Guid.NewGuid(),
GroupStatus = true,
GroupName = groupName,
GroupDescription = groupDescription,
//GroupTeacher = groupTeacher,
GroupLevel = groupLevel
};
dbConn.SapGroups.Add(sapGroups);
dbConn.SaveChanges();
};
return(true);
}
//Adds a created class to the db
public bool CreateClass(string classCreatedBy, int classLevel, string classTheme, string classDescription, Guid classGroupId, string classSequence)
{
using (var dbConn = new SapremaFinalContext())
{
SapClass sapClass = new SapClass()
{
ClassId = Guid.NewGuid(),
ClassCreatedBy = classCreatedBy,
ClassLevel = classLevel,
ClassTheme = classTheme,
ClassDescription = classDescription,
ClassGroupId = classGroupId,
//ClassSequence = classSequence
};
dbConn.SapClass.Add(sapClass);
dbConn.SaveChanges();
};
return(true);
}
//Adds teacher to db
public bool CreateTeacher(string teachId, string studio, string cert, string bio, string site, bool verified, string teacherName)
{
using (var dbConn = new SapremaFinalContext())
{
SapTeachers sapTeacher = new SapTeachers()
{
Studio = studio,
TeachId = teachId,
Cert = cert,
Verified = verified,
Bio = bio,
Site = site,
FullName = teacherName
};
dbConn.SapTeachers.Add(sapTeacher);
dbConn.SaveChanges();
};
return(true);
}
public bool CreateBuyMeditation(string userId, string meditationId)
{
var id = Guid.Parse(meditationId);
using (var dbConn = new SapremaFinalContext())
{
SapUserMeditations sapUserMeditations = new SapUserMeditations()
{
MeditationId = id,
UserId = userId,
UserMeditationsId = Guid.NewGuid()
};
dbConn.SapUserMeditations.Add(sapUserMeditations);
dbConn.SaveChanges();
return(true);
}
}
public bool DeleteUserMeditation(string userId, string meditationId)
{
var id = Guid.Parse(meditationId);
using (var dbConn = new SapremaFinalContext())
{
var meditation = dbConn.SapUserMeditations.Where(a => a.UserId == userId && a.MeditationId == id).FirstOrDefault();
if (meditation != null)
{
dbConn.SapUserMeditations.Remove(meditation);
dbConn.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
public bool DeleteGroup(string groupId, string userid)
{
var id = Guid.Parse(groupId);
using (var dbConn = new SapremaFinalContext())
{
var group = dbConn.SapGroups.Where(a => a.GroupId == id && a.GroupAdmin == userid).SingleOrDefault();
if (group != null)
{
dbConn.SapGroups.Remove(group);
dbConn.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
public bool DeleteMeditationReview(string meditationReviewId)
{
var id = Guid.Parse(meditationReviewId);
using (var dbConn = new SapremaFinalContext())
{
var meditationReview = dbConn.SapReviewMeditation.Where(a => a.ReviewMeditationId == id).SingleOrDefault();
if (meditationReview != null)
{
dbConn.SapReviewMeditation.Remove(meditationReview);
dbConn.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
public bool UpdateMeditation(string meditationId, string meditationName, string meditationTheme, string meditationCreator, string meditationType, IHostingEnvironment hostingEnvironment, IFormFile imgFile, IFormFile audioFile)
{
Guid medGuid = Guid.Parse(meditationId);
using (var dbConn = new SapremaFinalContext())
{
SapMeditations sapMeditation = dbConn.SapMeditations.Where(medId => medId.MeditationId == medGuid).FirstOrDefault();
sapMeditation.MeditationName = meditationName;
sapMeditation.MeditationTheme = meditationTheme;
sapMeditation.MeditationCreator = meditationCreator;
sapMeditation.MeditationType = meditationType;
dbConn.SaveChanges();
};
var imgSaved = new DAL.CreateImage(hostingEnvironment).CreateMeditationImage(medGuid, imgFile);
var audioSave = new DAL.CreateAudio(hostingEnvironment).CreateMeditationAudio(medGuid, audioFile);
return(true);
}
/*
* Update teacher verification status
* */
public bool UpdateTeacherVerification(string id, string status)
{
if (status.Equals("true") || status.Equals("false"))
{
bool verification = Boolean.Parse(status);
using (var dbConn = new SapremaFinalContext())
{
SapTeachers sapTeachers = dbConn.SapTeachers.Where(a => a.TeachId == id).FirstOrDefault();
sapTeachers.Verified = verification;
dbConn.SaveChanges();
};
return(true);
}
else
{
return(false);
}
}
//Adds a meditation to db on upload
public bool CreateMeditation(string meditationName, string meditationTheme, string meditationCreator, string meditationType, IHostingEnvironment hostingEnvironment, IFormFile imgFile, IFormFile audioFile)
{
Guid imgGuid = Guid.NewGuid();
using (var dbConn = new SapremaFinalContext())
{
SapMeditations sapMeditation = new SapMeditations()
{
MeditationId = imgGuid,
MeditationName = meditationName,
MeditationTheme = meditationTheme,
MeditationCreator = meditationCreator,
MeditationImage = imgGuid,
MeditationType = meditationType
};
dbConn.SapMeditations.Add(sapMeditation);
dbConn.SaveChanges();
};
var imgSaved = new DAL.CreateImage(hostingEnvironment).CreateMeditationImage(imgGuid, imgFile);
var audioSave = new DAL.CreateAudio(hostingEnvironment).CreateMeditationAudio(imgGuid, audioFile);
return(true);
}
