public IHttpActionResult EditPassword([FromBody] m_Users_Password request, int Id) { if (ModelState.IsValid) { try { if (_Users.Checkpassword(request.old_password)) { var qry = _Users.UserEditPassword(request, Id); if (qry != null) { return(Json(qry)); } return(BadRequest("Create user failed.")); } else { return(BadRequest("Old password incorrect.")); } } catch (Exception ex) { return(BadRequest(ex.Message)); } } return(BadRequest("Model is incorrect.")); }
public users UserEditPassword(m_Users_Password request, int Id) { request.new_password = Convert.ToBase64String(Encoding.UTF8.GetBytes(request.new_password)); var qry = db.Database.SqlQuery <users>("EXEC [farmnet].[s_Users_Edit_Password] @Id,@password", new SqlParameter("@Id", Id), new SqlParameter("@password", request.new_password) ).FirstOrDefault(); if (qry != null) { return(qry); } return(null); }