public void saveSpace(BackupSpaceModelRequest model) { var deleteQuery = @"delete from espaciobakups where date_format(FechaActualizacion,'%Y/%m/%d')=curdate() and Instance=@Instance;"; var insertBackupQuery = $@"INSERT INTO espaciobakups (Instance, PathBUFull, PathBUDif, PathBULog, PesoGbFull, PesoGbDif, PesoGbLog, FechaActualizacion) VALUES (@Instance, @PathBUFull, @PathBUDif, @PathBULog, @PesoGbFull, @PesoGbDif, @PesoGbLog, NOW());"; using (var conn = new MySqlConnection(ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString.ToString())) { if (conn.State == ConnectionState.Closed) { conn.Open(); } MySqlTransaction transaction = conn.BeginTransaction(); MySqlCommand cmd = conn.CreateCommand(); cmd.CommandType = CommandType.Text; try { // Delete 2 tables cmd.Parameters.Clear(); cmd.CommandText = deleteQuery; cmd.Parameters.AddWithValue("@Instance", model.Instance); cmd.ExecuteNonQuery(); // Insert table espaciobakups cmd.Parameters.Clear(); cmd.CommandText = insertBackupQuery; cmd.Parameters.AddWithValue("@Instance", model.Instance); cmd.Parameters.AddWithValue("@PathBUFull", model.PathBUFull); cmd.Parameters.AddWithValue("@PathBUDif", model.PathBUDif); cmd.Parameters.AddWithValue("@PathBULog", model.PathBULog); cmd.Parameters.AddWithValue("@PesoGbFull", model.PesoGbFull); cmd.Parameters.AddWithValue("@PesoGbDif", model.PesoGbDif); cmd.Parameters.AddWithValue("@PesoGbLog", model.PesoGbLog); cmd.ExecuteNonQuery(); // Save all changes transaction.Commit(); } catch (System.Exception ex) { transaction.Rollback(); throw ex; } finally { cmd.Dispose(); transaction.Dispose(); } } }
public ResponseBase saveSpace(BackupSpaceModelRequest request) { var response = new ResponseBase(); try { _backupService.saveSpace(request); response.Success = true; } catch (Exception ex) { response.Message = ex.Message.ToString(); Elmah.ErrorSignal.FromCurrentContext().Raise(ex); } return(response); }
public IHttpActionResult postSpace([FromBody] BackupSpaceModelRequest request) { if (request == null) { Elmah.ErrorSignal.FromCurrentContext().Raise(new Exception("El request esta vacio.")); return(BadRequest("El request esta vacio.")); } ResponseBase result = _backupManager.saveSpace(request); if (result.Success) { return(Ok()); } else { return(BadRequest(result.Message)); } }