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