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