public CargarVereda ActualizarVereda(AgregarVereda vereda, int id) { conectar.Open(); SqlCommand cm = new SqlCommand("UPDATE COM.VEREDA SET VER_DESC = @DESCRIPCION, MUN_ID = @MUNICIPIO WHERE VER_ID = @VEREDA", conectar); cm.Parameters.AddWithValue("DESCRIPCION", vereda.descripcion); cm.Parameters.AddWithValue("MUNICIPIO", vereda.municipio); cm.Parameters.AddWithValue("VEREDA", id); cm.ExecuteNonQuery(); CargarVereda cargarVereda = null; cm = new SqlCommand(" SELECT" + " 'ver_id' = V.VER_ID," + " 'ver_descripcion' = V.VER_DESC," + " 'mun_id' = M.MUN_ID," + " 'mun_descripcion' = M.MUN_DESC," + " 'dep_id' = D.DEP_ID," + " 'dep_descripcion' = D.DEP_DESC FROM COM.VEREDA V" + " INNER JOIN COM.MUNICIPIO M ON M.MUN_ID = V.MUN_ID" + " INNER JOIN COM.DEPARTAMENTO D ON D.DEP_ID = M.DEP_ID" + " WHERE V.VER_ID = " + id, conectar); DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(cm); da.Fill(ds, "vereda"); DataTable dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { object departamento = new { id = Convert.ToInt32(dr["dep_id"]), descripcion = dr["dep_descripcion"].ToString() }; object municipio = new { id = Convert.ToInt32(dr["mun_id"]), descripcion = dr["mun_descripcion"].ToString() }; cargarVereda = new CargarVereda { id = Convert.ToInt32(dr["ver_id"]), descripcion = dr["ver_descripcion"].ToString(), departamento = departamento, municipio = municipio }; } conectar.Close(); return(cargarVereda); }
public CargarVereda AgregarVereda(AgregarVereda agregarVereda) { conectar.Open(); SqlCommand cm = new SqlCommand("INSERT INTO COM.VEREDA (VER_DESC, MUN_ID) VALUES ('" + agregarVereda.descripcion + "', '" + agregarVereda.municipio + "')", conectar); cm.ExecuteNonQuery(); CargarVereda cargarVereda = null; cm = new SqlCommand(" SELECT TOP 1" + " 'ver_id' = V.VER_ID," + " 'ver_descripcion' = V.VER_DESC," + " 'mun_id' = M.MUN_ID," + " 'mun_descripcion' = M.MUN_DESC," + " 'dep_id' = D.DEP_ID," + " 'dep_descripcion' = D.DEP_DESC FROM COM.VEREDA V" + " INNER JOIN COM.MUNICIPIO M ON M.MUN_ID = V.MUN_ID" + " INNER JOIN COM.DEPARTAMENTO D ON D.DEP_ID = M.DEP_ID " + " ORDER BY V.VER_ID DESC", conectar); DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(cm); da.Fill(ds, "vereda"); DataTable dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { object departamento = new { id = Convert.ToInt32(dr["dep_id"]), descripcion = dr["dep_descripcion"].ToString() }; object municipio = new { id = Convert.ToInt32(dr["mun_id"]), descripcion = dr["mun_descripcion"].ToString() }; cargarVereda = new CargarVereda { id = Convert.ToInt32(dr["ver_id"]), descripcion = dr["ver_descripcion"].ToString(), departamento = departamento, municipio = municipio }; } conectar.Close(); return(cargarVereda); }
public IActionResult PostVereda([FromBody] AgregarVereda agregarVereda) { try { fincaRepositor = new FincaRepositor(_config, Request); return(Ok(new { statusCode = 200, message = "success", vereda = fincaRepositor.AgregarVereda(agregarVereda) })); } catch (Exception ex) { return(new ResponseContext().getFauilureResponse(ex)); } }
public IActionResult UpdateVereda(int id, [FromBody] AgregarVereda vereda) { try { fincaRepositor = new FincaRepositor(_config, Request); if (!fincaRepositor.ExistVereda(id)) { throw new Exception("La vereda no existe."); } return(Ok(new { statusCode = 200, message = "success", vereda = fincaRepositor.ActualizarVereda(vereda, id) })); } catch (Exception ex) { return(new ResponseContext().getFauilureResponse(ex)); } }