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