public void InsertShopify(IList <IList <Object> > values, IList <Object> listaParametros) { try { string names = string.Empty; int pedidos = 0; Conexiones conn = new Conexion.Conexiones(); SqlConnection conexion = conn.procesadorabd(); using (conexion) { for (int i = 1; i < values.Count; i++) { SqlCommand cmd = new SqlCommand(conn.AddShopify(), conexion); SqlDataReader read = cmd.ExecuteReader(); read.Read(); int o = 0; int id = read.GetInt32(0); foreach (var item in values[i]) { string columna = Convert.ToString(listaParametros[o]); o++; string data = Convert.ToString(item); if (columna == "Line item origin location" || columna == "Line item discount allocations" || columna == "Line item destination location") { data = data.Replace("'", "'+''''+'"); } conn.actualizarInsercion(columna, data, id); if (columna == "Name" && !names.Contains(data)) { pedidos = pedidos + 1; if (i == 1) { names = data; } else { names = names + ", " + data; } } } read.Close(); conn.EjecutarLog(id, "Fila insertada correctamente", "OK INST DATA SHOPIFY"); } conn.Correo(pedidos, names); conexion.Close(); } } catch (Exception e) { Conexion.Conexiones c = new Conexiones(); c.EjecutarLog(0, e.ToString(), "ERROR INST DATA SHOPIFY"); } }
public void Diferencia(IList <Object> listaParametros) { try { Conexiones conn = new Conexion.Conexiones(); SqlConnection conexion = conn.procesadorabd(); using (conexion) { SqlCommand cmd = new SqlCommand(conn.ConsultaColumnsShopify(), conn.procesadorabd()); DataTable colu = new DataTable(); SqlDataAdapter ad = new SqlDataAdapter(cmd); ad.Fill(colu); int columnasBD = colu.Rows.Count; int totalParametros = listaParametros.Count; foreach (var item in listaParametros) { bool exist = false; string it = Convert.ToString(item); foreach (DataRow rows in colu.Rows) { if (Convert.ToString(rows.ItemArray[0]) == it) { exist = true; break; } } if (!exist) { conn.InsertarColumna(it); conn.EjecutarLog(0, "Nueva columna insertada: " + it + ".", "OK INST DIFERENCIA"); } } conexion.Close(); } } catch (Exception e) { Conexion.Conexiones c = new Conexiones(); c.EjecutarLog(0, e.ToString(), "ERROR INST NEW PARAMETROS"); } }
public string ConsultaGoogleSheets() { try { SheetsService sheetsService = new SheetsService(new BaseClientService.Initializer { HttpClientInitializer = GetCredential(), ApplicationName = "Google-SheetsSample/0.1", }); string spreadsheetId = "1_iIbyZZAzO02HOA-3l38FCJxq9Mm_MHaZ8l7NvFtw44"; string range = "A1:FZ3000"; SpreadsheetsResource.ValuesResource.GetRequest.ValueRenderOptionEnum valueRenderOption = (SpreadsheetsResource.ValuesResource.GetRequest.ValueRenderOptionEnum) 0; SpreadsheetsResource.ValuesResource.GetRequest.DateTimeRenderOptionEnum dateTimeRenderOption = (SpreadsheetsResource.ValuesResource.GetRequest.DateTimeRenderOptionEnum) 0; SpreadsheetsResource.ValuesResource.GetRequest request = sheetsService.Spreadsheets.Values.Get(spreadsheetId, range); request.ValueRenderOption = valueRenderOption; request.DateTimeRenderOption = dateTimeRenderOption; Google.Apis.Sheets.v4.Data.ValueRange response = request.Execute(); IList <IList <Object> > values = response.Values; IList <Object> listaParametros = values[0]; Diferencia(listaParametros); InsertShopify(values, listaParametros); return(JsonConvert.SerializeObject(response)); } catch (Exception e) { Conexion.Conexiones c = new Conexiones(); c.EjecutarLog(0, e.ToString(), "ERROR CONSULTA DATA SHOPIFY"); return(e.ToString()); } }