public static void CrearCompromiso(Compromiso compromiso)
{
string query = string.Format("insert into compromiso (id_acta) values ({0})", compromiso.id_acta);
MySqlConnection databaseConnection = new MySqlConnection(connectionString);
MySqlCommand commandDatabase = new MySqlCommand(query, databaseConnection);
commandDatabase.CommandTimeout = 60;
int resultado;
try
{
databaseConnection.Open();
resultado = commandDatabase.ExecuteNonQuery();
if (resultado != 1)
{
throw new Exception("Error creando el compromiso.");
}
}
catch
{
throw;
}
finally
{
databaseConnection.Close();
}
}
public void Guardar(Compromiso entidad)
{
CompromisoEstadoRepositorio compromisoEstadoRepositorio;
using (_contexto = new ALICORPContexto(true))
{
try
{
_repositorio = new CompromisoRepositorio(_contexto.Connection, _contexto.Transaction);
compromisoEstadoRepositorio = new CompromisoEstadoRepositorio(_contexto.Connection, _contexto.Transaction);
entidad.Codigo = (_repositorio.Contar(entidad.EstructuraId) + 1).ToString("D10");
if (_repositorio.Guardar(entidad))
{
compromisoEstadoRepositorio.Guardar(new CompromisoEstado
{
CompromisoId = entidad.Id,
Estado = EstadoCompromiso.NUEVO
});
}
_contexto.Transaction.Commit();
}
catch (Exception ex)
{
_contexto?.Transaction.Rollback();
throw ex;
}
}
}
public static Compromiso ObtenerCompromiso(string idCompromiso)
{
Compromiso compromiso = new Compromiso();
string query = "select * from compromiso where id_compromiso = " + idCompromiso;
MySqlConnection databaseConnection = new MySqlConnection(connectionString);
MySqlCommand commandDatabase = new MySqlCommand(query, databaseConnection);
commandDatabase.CommandTimeout = 60;
MySqlDataReader reader;
try
{
databaseConnection.Open();
reader = commandDatabase.ExecuteReader();
while (reader.Read())
{
compromiso = new Compromiso(reader.GetInt16(0), reader.GetInt16(1));
}
return(compromiso);
}
catch
{
throw;
}
finally
{
databaseConnection.Close();
}
}
public ActionResult Nuevo(CompromisoModel.Nuevo model)
{
try
{
Validar(model);
if (ModelState.IsValid)
{
Compromiso entidad = model.Get();
entidad.EstructuraId = _estructuraId;
entidad.Estado = EstadoCompromiso.NUEVO;
_compromisoLogica = new CompromisoLogica();
_compromisoLogica.Guardar(entidad);
return(Content(entidad.Id.ToString()));
}
else
{
Response.StatusCode = (int)HttpStatusCode.BadRequest;
return(PartialView("_Error"));
}
}
catch (Exception ex)
{
Response.StatusCode = (int)HttpStatusCode.BadRequest;
ViewBag.Message = ex.Message;
return(PartialView("_Error"));
}
}
public bool Guardar(Compromiso entidad)
{
bool respuesta = false;
try
{
using (var cmd = CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "usp_Compromiso_Guardar";
cmd.Parameters.AddWithValue("@codigo", entidad.Codigo);
cmd.Parameters.AddWithValue("@descripcion", entidad.Descripcion);
cmd.Parameters.AddWithValue("@detalle", entidad.Detalle ?? Convert.DBNull);
cmd.Parameters.AddWithValue("@impacto", entidad.Impacto ?? Convert.DBNull);
cmd.Parameters.AddWithValue("@estado", entidad.Estado);
cmd.Parameters.AddWithValue("@estructuraid", entidad.EstructuraId);
cmd.Parameters.AddWithValue("@tableroid", entidad.TableroId);
entidad.Id = int.Parse(cmd.ExecuteScalar().ToString());
respuesta = entidad.Id > 0;
}
return(respuesta);
}
catch (Exception)
{
throw new Exception("Ocurrio un error al momento de guardar el compromiso.");
}
}
public ActionResult Ver(int id, bool parcial = true)
{
try
{
_compromisoLogica = new CompromisoLogica();
_estructuraLogica = new EstructuraLogica();
Compromiso model = _compromisoLogica.Buscar(id);
ViewBag.Tablero = string.Concat("/ALICORP", _estructuraLogica.Ruta(model.TableroId)?.ToUpper() ?? "");
ViewBag.Ruta = string.Concat("/ALICORP", _estructuraLogica.Ruta(model.EstructuraId)?.ToUpper() ?? "");
if (parcial)
{
return(PartialView("_Ver", model));
}
else
{
return(View(model));
}
}
catch (Exception ex)
{
Response.StatusCode = (int)HttpStatusCode.BadRequest;
ViewBag.Message = ex.Message;
return(PartialView("_Error"));
}
}
public ActionResult Nuevo(string callBack = "SetCompromiso")
{
try
{
_estructuraLogica = new EstructuraLogica();
Compromiso model = new Compromiso {
EstructuraId = _estructuraId
};
ViewBag.Tableros = _estructuraLogica.Listar(new EstructuraFiltro {
Tablero = true
}) ?? new List <Estructura>();
ViewBag.Ruta = string.Concat("/ALICORP", _estructuraLogica.Ruta(_estructuraId)?.ToUpper() ?? "");
ViewBag.CallBack = callBack;
return(PartialView("_Nuevo", model));
}
catch (Exception ex)
{
Response.StatusCode = (int)HttpStatusCode.BadRequest;
ViewBag.Message = ex.Message;
return(PartialView("_Error"));
}
}
public bool Actualizar(Compromiso entidad)
{
bool respuesta = false;
try
{
using (var cmd = CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "usp_Compromiso_Actualizar";
cmd.Parameters.AddWithValue("@id", entidad.Id);
cmd.Parameters.AddWithValue("@descripcion", entidad.Descripcion);
cmd.Parameters.AddWithValue("@detalle", entidad.Detalle ?? Convert.DBNull);
cmd.Parameters.AddWithValue("@impacto", entidad.Impacto ?? Convert.DBNull);
respuesta = cmd.ExecuteNonQuery() > 0;
}
return(respuesta);
}
catch (Exception)
{
throw new Exception("Ocurrio un error al momento de actualizar el compromiso.");
}
}
public ActionResult Editar(CompromisoModel.Editar model)
{
try
{
Validar(model);
if (ModelState.IsValid)
{
Compromiso entidad = model.Get();
_compromisoLogica = new CompromisoLogica();
_compromisoLogica.Actualizar(entidad);
return(Content(model.Id.ToString()));
}
else
{
Response.StatusCode = (int)HttpStatusCode.BadRequest;
return(PartialView("_Error"));
}
}
catch (Exception ex)
{
Response.StatusCode = (int)HttpStatusCode.BadRequest;
ViewBag.Message = ex.Message;
return(PartialView("_Error"));
}
}
public async Task <Response> ActualizarCompromiso(Compromiso compromiso)
{
try
{
var request = JsonConvert.SerializeObject(compromiso);
var content = new StringContent(request, Encoding.UTF8, "application/json");
var client = new HttpClient();
client.BaseAddress = new Uri(Constants.Constants.VentasWS);
var url = "api/Compromiso/ActualizarCompromiso";
var response = await client.PostAsync(url, content);
if (!response.IsSuccessStatusCode)
{
return(null);
}
return(new Response
{
IsSuccess = true,
Message = "Actualizado",
});
// var log = JsonConvert.DeserializeObject<LogPosition>(result);
}
catch (Exception ex)
{
return(null);
}
}
public static void ActualizarCompromiso(Compromiso compromiso)
{
string query = string.Format("UPDATE compromiso SET id_acta = {0} WHERE id_compromiso = {1}", compromiso.id_acta, compromiso.id_compromiso);
MySqlConnection databaseConnection = new MySqlConnection(connectionString);
MySqlCommand commandDatabase = new MySqlCommand(query, databaseConnection);
commandDatabase.CommandTimeout = 60;
int resultado;
try
{
databaseConnection.Open();
resultado = commandDatabase.ExecuteNonQuery();
if (resultado != 1)
{
throw new Exception("Error actualizando el compromiso.");
}
}
catch
{
throw;
}
finally
{
databaseConnection.Close();
}
}
private async void addCompromiso()
{
compromiso.IdTipoCompromiso = tipoSelect.IdTipoCompromiso;
if (Compromiso != null)
{
ListaCompromiso.Add(Compromiso);
}
Compromiso = new Compromiso();
}
public async Task <IActionResult> Create([Bind("Notas")] Compromiso compromiso)
{
if (ModelState.IsValid)
{
_context.Add(compromiso);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(compromiso));
}
public async void Update()
{
var compromiso = new Compromiso
{
IdCompromiso = id,
Solucion = Solucion,
};
var response = await apiService.ActualizarCompromiso(compromiso);
if (response.IsSuccess)
{
await dialogService.ShowMessage("Actualización", "Actualizado correctamente");
await PopupNavigation.PopAllAsync();
}
}
public void Actualizar(Compromiso entidad)
{
using (_contexto = new ALICORPContexto(true))
{
try
{
_repositorio = new CompromisoRepositorio(_contexto.Connection, _contexto.Transaction);
_repositorio.Actualizar(entidad);
_contexto.Transaction.Commit();
}
catch (Exception ex)
{
_contexto?.Transaction.Rollback();
throw ex;
}
}
}
public async Task <IHttpActionResult> PutCompromiso(Compromiso compromisoAux)
{
var compromiso = await db.Compromiso.Where(x => x.IdCompromiso == compromisoAux.IdCompromiso).FirstOrDefaultAsync();
compromiso.Solucion = compromisoAux.Solucion;
db.Entry(compromiso).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
throw;
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult Seguimiento(int id)
{
try
{
_compromisoLogica = new CompromisoLogica();
_estructuraLogica = new EstructuraLogica();
Compromiso model = _compromisoLogica.Buscar(id, true);
ViewBag.Ruta = string.Concat("/ALICORP", _estructuraLogica.Ruta(model.EstructuraId)?.ToUpper() ?? "");
return(PartialView("_Seguimiento", model));
}
catch (Exception ex)
{
Response.StatusCode = (int)HttpStatusCode.BadRequest;
ViewBag.Message = ex.Message;
return(PartialView("_Error"));
}
}
public async Task <Response> InsertarCompromiso(Compromiso compromiso)
{
try
{
db.Compromiso.Add(compromiso);
await db.SaveChangesAsync();
return(new Response {
IsSuccess = true,
});
}
catch (Exception ex)
{
return(new Response {
IsSuccess = false,
Message = ex.Message
});
}
}
public Compromiso Buscar(int id)
{
Compromiso entidad = null;
try
{
using (var cmd = CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "usp_Compromiso_Buscar";
cmd.Parameters.AddWithValue("@id", id);
using (var rd = cmd.ExecuteReader())
{
while (rd.Read())
{
entidad = new Compromiso
{
Codigo = rd.GetString(0),
Descripcion = rd.GetString(1),
Impacto = !rd.IsDBNull(2) ? rd.GetString(2) : null,
Estado = (EstadoCompromiso)rd.GetInt32(3),
EstructuraId = rd.GetInt32(4),
Detalle = !rd.IsDBNull(5) ? rd.GetString(5) : null,
TableroId = rd.GetInt32(6),
Respuesta = !rd.IsDBNull(7) ? rd.GetString(7) : null,
FechaRegistro = rd.GetDateTime(8)
};
}
rd.Close();
}
}
return(entidad);
}
catch (Exception)
{
throw new Exception("Error al momento de buscar el compromiso.");
}
}
public ActionResult Editar(int id, string callBack = "SetCompromiso")
{
try
{
_estructuraLogica = new EstructuraLogica();
_compromisoLogica = new CompromisoLogica();
Compromiso model = _compromisoLogica.Buscar(id);
ViewBag.Tablero = string.Concat("/ALICORP", _estructuraLogica.Ruta(model.TableroId)?.ToUpper() ?? "");
ViewBag.CallBack = callBack;
return(PartialView("_Editar", model));
}
catch (Exception ex)
{
Response.StatusCode = (int)HttpStatusCode.BadRequest;
ViewBag.Message = ex.Message;
return(PartialView("_Error"));
}
}
