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