public ResponseBD UpdateUser(int id, string password, string address, string email, string phone)
{
var response = new ResponseBD();
try
{
MySqlConnection cnn = new MySqlConnection(conexionString);
MySqlCommand cmd = new MySqlCommand();
MySqlDataAdapter da = new MySqlDataAdapter();
cmd = new MySqlCommand("USP_UsersUpdate", cnn);
cmd.Parameters.Add("id", MySqlDbType.VarChar).Value = id;
cmd.Parameters.Add("password", MySqlDbType.VarChar).Value = password;
cmd.Parameters.Add("address", MySqlDbType.VarChar).Value = address;
cmd.Parameters.Add("email", MySqlDbType.VarChar).Value = email;
cmd.Parameters.Add("phone", MySqlDbType.VarChar).Value = phone;
cmd.CommandType = CommandType.StoredProcedure;
cnn.Open();
int query = cmd.ExecuteNonQuery();
cnn.Close();
response.estado = true;
}
catch (Exception ex)
{
response.estado = false;
response.mensaje = "Ocurrio un problema en el servicio.";
}
return(response);
}
public ResponseBD InsertCommentAnalysis(int medicalAnalysisId, string description, string priority)
{
var response = new ResponseBD();
try
{
MySqlConnection cnn = new MySqlConnection(conexionString);
MySqlCommand cmd = new MySqlCommand();
MySqlDataAdapter da = new MySqlDataAdapter();
cmd = new MySqlCommand("USP_InsertCommentAnalysis", cnn);
cmd.Parameters.Add("medicalAnalysisId", MySqlDbType.Int32).Value = medicalAnalysisId;
cmd.Parameters.Add("description", MySqlDbType.VarChar).Value = description;
cmd.Parameters.Add("priority", MySqlDbType.VarChar).Value = priority;
cmd.CommandType = CommandType.StoredProcedure;
cnn.Open();
int query = cmd.ExecuteNonQuery();
cnn.Close();
response.estado = true;
}
catch (Exception ex)
{
response.estado = false;
response.mensaje = "Ocurrio un problema en el servicio.";
}
return(response);
}
public IHttpActionResult UpdateUser(int id, string password, string address, string email, string phone)
{
var response = new ResponseBD();
var responsebl = blLogin.UpdateUser(id, password, address, email, phone);
response.responseBD.Estado = responsebl.estado;
response.responseBD.Mensaje = responsebl.mensaje;
return(Json(response));
}
public IHttpActionResult InsertCommentAnalysis(int medicalAnalysisId, string description, string priority)
{
var response = new ResponseBD();
var responsebl = bl.InsertCommentAnalysis(medicalAnalysisId, description, priority);
response.responseBD.Estado = responsebl.estado;
response.responseBD.Mensaje = responsebl.mensaje;
return(Json(response));
}
