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