public Cookie UpdateInfo(UpdateDogInfo updateDogInfo) { Cookie cookie = new Cookie(); try { using (SqlConnection con = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand("Update_DogInfo", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@UserId", updateDogInfo.UserId); cmd.Parameters.AddWithValue("@DogName", updateDogInfo.DogName); cmd.Parameters.AddWithValue("@Vacination", updateDogInfo.Vacination); cmd.Parameters.AddWithValue("@HRecord", updateDogInfo.HRecord); con.Open(); //cmd.ExecuteNonQuery(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { cookie.isSuccess = Convert.ToBoolean(rdr["Status"]); } con.Close(); } return(cookie); } catch (Exception x) { cookie.isSuccess = false; return(cookie); } }
public bool UpdateInfo(UpdateDogInfo updateDogInfo) { bool result = false; using (SqlConnection con = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand("Update_DogInfo", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@UserId", updateDogInfo.UserId); cmd.Parameters.AddWithValue("@DogName", updateDogInfo.DogName); cmd.Parameters.AddWithValue("@Vacination", updateDogInfo.Vacination); cmd.Parameters.AddWithValue("@HRecord", updateDogInfo.HRecord); con.Open(); //cmd.ExecuteNonQuery(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { result = Convert.ToBoolean(rdr["Status"]); } con.Close(); } return(result); }
public ResponseResult <Cookie> Put([FromBody] UpdateDogInfo updateDogInfo) { ResponseResult <Cookie> result = new ResponseResult <Cookie>(); OwnerService ownerService = new OwnerService(); try { result.Result = null; result.IsSuccess = ownerService.UpdateInfo(updateDogInfo); } catch (Exception e) { result.IsSuccess = false; result.Message = e.Message; } return(result); }
public Cookie Put([FromBody] UpdateDogInfo updateDogInfo) { OwnerService ownerService = new OwnerService(); return(ownerService.UpdateInfo(updateDogInfo)); }