private UpdateWorkshopRecordModel GetFCM(UpdateWorkshopRecordModel workshop)
{
var cmd = new MySqlCommand("SELECT fcm_token FROM admins WHERE job_titles_id = 3");
using (var conn = new MySqlConnection(GetConnectionString()))
{
try
{
cmd.Connection = conn;
cmd.Connection.Open();
using (var reader = cmd.ExecuteReader()){
if (reader.Read())
{
workshop.fcm = (string)reader["fcm_token"];
return(workshop);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
return(null);
}
public async Task <IActionResult> Put([FromForm] UpdateWorkshopRecordModel record)
{
// return Ok(record);
var workshop = workshops.ChangeState(record);
var apiwebFb = GetApiFireBaseKey();
var notification = new NotificationModel();
if (workshop != null)
{
var msj = "El folio con id: " + workshop.id + " a cambiado de estado";
var title = "Cambio de estado en folio";
var push = SendPushNotification(workshop.fcm, msj, title, workshop.id);
return(Ok(true));
}
return(Ok(false));
}
internal UpdateWorkshopRecordModel ChangeState(UpdateWorkshopRecordModel workshop)
{
// var w = new WorkshopRecordModel();
var cmd = new MySqlCommand("UPDATE workshop_records SET workshop_record_state_id = @workshop_record_state_id WHERE id = @id");
cmd.Parameters.AddWithValue("@workshop_record_state_id", workshop.workshop_record_sate_id);
cmd.Parameters.AddWithValue("@id", workshop.id);
using (var conn = new MySqlConnection(GetConnectionString()))
{
try
{
cmd.Connection = conn;
cmd.Connection.Open();
cmd.ExecuteNonQuery();
return(GetFCM(workshop));
}
catch (Exception ex)
{
throw ex;
}
}
}
