public IHttpActionResult EditPrifile([FromBody] m_Users_Profile request, int Id) { if (ModelState.IsValid) { try { var qry = _Users.UserEditProfile(request, Id); if (qry != null) { return(Json(qry)); } return(BadRequest("Create user failed.")); } catch (Exception ex) { return(BadRequest(ex.Message)); } } return(BadRequest("Model is incorrect.")); }
public users UserEditProfile(m_Users_Profile request, int Id) { var qry = db.Database.SqlQuery <users>("EXEC [farmnet].[s_Users_Edit_Profile] @Id,@firstname,@lastname,@email,@serial_number,@house_no,@village_no,@sub_area,@area,@province,@postal_code", new SqlParameter("@Id", Id), new SqlParameter("@firstname", request.firstname), new SqlParameter("@lastname", request.lastname), new SqlParameter("@email", request.email), new SqlParameter("@serial_number", request.serial_number), new SqlParameter("@house_no", request.house_no), new SqlParameter("@village_no", request.village_no), new SqlParameter("@sub_area", request.sub_area), new SqlParameter("@area", request.area), new SqlParameter("@province", request.province), new SqlParameter("@postal_code", request.postal_code) ).FirstOrDefault(); if (qry != null) { return(qry); } return(null); }