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