public IHttpActionResult AddUserByTeacher(m_AddUser request)
{
if (ModelState.IsValid)
{
try
{
if (!_Anthen.Check_HaveUser(request.username)) //check user have in database
{
var adduser = _User.R_AddUsersByteacher(request); //add user to databbase
if (adduser != null) //if user add success
{
return(Json(new { newUser = adduser }));
}
else//if user add fail
{
return(Json("Fail add user."));
}
}
else
{
return(Json("Have this user in database."));
}
}
catch (Exception ex)
{
return(Json(ex.Message));
}
}
else
{
return(Json("This field is required."));
}
}
//add user
public Users R_AddUsers(m_AddUser NewUser)
{
var res = db.Database.SqlQuery <Users>("EXEC [quickquiz].[s_Adduser] @username,@password,@user_type",
new SqlParameter("@username", NewUser.username),
new SqlParameter("@password", Convert.ToBase64String(Encoding.UTF8.GetBytes(NewUser.password))),
new SqlParameter("@user_type", NewUser.user_type)
).FirstOrDefault();
return(res);
}
//update user
public Users R_UpdateUsers(int id, m_AddUser UpdateUser)
{
var update = db.Users.FirstOrDefault(e => e.user_id == id);
update.username = UpdateUser.username;
update.password = UpdateUser.password;
update.user_type_id = UpdateUser.user_type;
int res = db.SaveChanges();
return(res > 0 ? update : null);
}
