public object PostCreateUsers(userTab user) { var result = objEntity.userTabs.Where(s => s.email == user.email).FirstOrDefault(); if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { if (result == null) { objEntity.userTabs.Add(new userTab() { fullName = user.fullName, email = user.email, password = user.password, roleId = user.roleId, isActive = user.isActive, cId = user.cId }); objEntity.SaveChanges(); } else { return("Email Id already Exists"); } } catch (Exception) { throw; } return("Data Inserted Successfully"); }
public object PostLoginUsers(userTab userLogin) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { var result = from x in objEntity.userTabs.Where(x => x.email == userLogin.email && x.password == userLogin.password && x.isActive == true) select x; return(result); } catch (Exception) { throw; } }
public IEnumerable <userTab> GetNonActiveTeacher() { try { userTab objTeacher = new userTab(); //return objEntity.userTabs.Where(x => x.roleId == null).ToArray(); var result = from s in objEntity.userTabs where s.roleId == null && s.isActive == true select s; return(result); } catch (Exception) { throw; } }
public object UpdateTeacherRole(userTab teacher) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { userTab objTeacher = new userTab(); objTeacher = objEntity.userTabs.Find(teacher.uId); if (objTeacher != null) { objTeacher.roleId = teacher.roleId; } objEntity.Entry(objTeacher).Property("roleId").IsModified = true; int i = objEntity.SaveChanges(); return(i); } catch (Exception) { throw; } }