public async Task <List <Cliente> > Clientes(string user) { try { string query = $@" Select cliente, nombre from EXACTUSDB.SYN_CLIENTE where cliente in( SELECT IdCliente FROM FORMULACION.formula where UsuarioRegistro like '%{user}%' ) "; List <Cliente> res = await RemoteDAO.QueryToList <Cliente>(query); return(res); } catch (Exception ex) { throw ex; } }
public async Task <List <Articulo> > Articulos() { try { string query = $@" select * from exactusdb.syn_Articulo where articulo like '%01.13' or articulo like '%01.14' or articulo like '%01.26' or articulo like '%01.34' or articulo like '%02.13' or articulo like '%02.14' or articulo like '%01.62' "; List <Articulo> res = await RemoteDAO.QueryToList <Articulo>(query); return(res); } catch (Exception ex) { throw ex; } }
public static ServiceResult <DataTable> testRemoteTable(Mapping mapping) { String query = "Select " + mapping.UserIDColumnName + "," + mapping.TimeColumnName + "," + mapping.TransactionTypeColumnName + " from " + mapping.TableName; ServiceResult <DataTable> result = RemoteDAO.ExecuteQuery(query, mapping.ConnectionString, mapping.ConnectionProvider); return(result); }
public async Task <List <Formula> > Formulas(string user) { try { string query = $@"SELECT * FROM FORMULACION.formula where UsuarioRegistro like '%{user}%'"; List <Formula> res = await RemoteDAO.QueryToList <Formula>(query); return(res); } catch (Exception ex) { throw ex; } }
public async Task <List <Articulo> > PullChanges_Articulos() { try { List <Articulo> articulos = await LocalDAO.QueryToList <Articulo>("select Articulo, FCH_HORA_ULT_MODIF from Articulo"); List <Insumo> insumo = articulos.Select(x => new Insumo { id = x.ARTICULO, UltimaModificacion = x.FCH_HORA_ULT_MODIF.ToString("o").Substring(0, 23) }).ToList(); List <Articulo> actualizados = new List <Articulo>(); var insumosPaginados = insumo.PaginateList(500); insumosPaginados.ForEach(async lista => { string query = "FORMULACION.usp_Articulos_Diferencias"; //PREGUNTO A LA BBDD SI ESTOS REGISTROS CAMBIARON Y OBTENGO SOLO LOS QUE CAMBIARON var concatenados = ConcatInsumo(lista); var parametros = new Dictionary <string, dynamic>(); parametros.Add($"@insumo", concatenados + ";"); List <Articulo> res = RemoteDAO.QueryToList <Articulo>(query, parametros, true); //SI HUBO RESULTADOS ELIMINO LOS LOCALES CON ESOS IDS if (res.Count != 0) { res.ForEach(x => actualizados.Add(x)); //ELIMINO EN LOCAL var parametrosDelete = new Dictionary <string, dynamic>(); parametrosDelete.Add("@articulos", String.Join(",", res.Select(z => z.ARTICULO).ToList())); await LocalDAO.QueryWithParam("delete from Articulo where articulo in(@articulos)", parametrosDelete); //GUARDO LA VERSIÓN MÁS RECIENTE QUE ESTABA EN LA BASE DE DATOS. await Guardar(res); } }); return(actualizados); } catch (Exception ex) { throw ex; } }
public async Task <List <Detalle> > Detalles(string user) { try { string query = $@" Select * from FORMULACION.formuladetalle where IdFormula in( SELECT idFormula FROM FORMULACION.formula where UsuarioRegistro like '%{user}%' ) "; List <Detalle> res = await RemoteDAO.QueryToList <Detalle>(query); return(res); } catch (Exception ex) { throw ex; } }
public static bool moveToRemoteTable(String Customer) { ServiceResult <DataTable> result = MappingService.getMappingInfo(); if (result == null || !result.IsSuccess() || result.Result.Rows.Count == 0) { SystemContext.Log(SystemContext.RootLogger, LogLevel.CORE, "Could not get mapping info"); return(false); } if (!result.IsSuccess()) { SystemContext.Log(SystemContext.RootLogger, LogLevel.CORE, result.ErrorMessage.englishValue); } DataRow Mapping = result.Result.Rows[0]; if (Customer.Equals("AL-Sorayai")) { return(moveToRemoteTable_AlSorayai(Mapping["CONNECTION_STRING"].ToString().Trim(), Mapping["DB_TYPE"].ToString().Trim())); } ServiceResult <DataTable> newTransactions = getNewTransactions(); foreach (DataRow transaction in newTransactions.Result.Rows) { DateTime transactionTime = DateTime.Parse(transaction["TRANS_DATE"].ToString()); String TransactionType = transaction["TRANS_TYPE"].ToString().Equals("0") ? Mapping["IN_TRANS_MAPPING"].ToString() : Mapping["OUT_TRANS_MAPPING"].ToString(); String deviceName = transaction["DEVICE_NAME"].ToString(); String insertCommand = "INSERT INTO " + Mapping["TRANS_TABLE"].ToString().Trim() + "(" + Mapping["USER_ID_COL"].ToString().Trim() + "," + Mapping["TIME_COL"].ToString().Trim() + "," + Mapping["TRANS_TYPE_COL"].ToString().Trim() + "," + Mapping["DEVICE_NAME_COL"].ToString().Trim() + ") VALUES('" + transaction["USER_ID"].ToString().Trim() + "','" + transactionTime.ToString(Mapping["TIME_FORMAT"].ToString().Trim()) + "','" + TransactionType.ToString().Trim() + "','" + deviceName + "')"; ServiceResult <String> remoteResult = RemoteDAO.ExecuteNoneQuery(insertCommand, Mapping["CONNECTION_STRING"].ToString().Trim(), Mapping["DB_TYPE"].ToString().Trim()); String setMoveFlagQuery = "UPDATE TRANSACTIONS SET IS_MOVED = 'y'" + "WHERE DEVICE_NAME = '" + transaction["DEVICE_NAME"].ToString() + "'" + "AND USER_ID = '" + transaction["USER_ID"].ToString() + "'" + "AND TRANS_TYPE = '" + transaction["TRANS_TYPE"].ToString() + "'" + "AND TRANS_DATE = '" + transaction["TRANS_DATE"].ToString() + "';"; if (remoteResult.IsSuccess()) { DAL.DAO.ExecuteNoneQuery(setMoveFlagQuery); } else { if (!remoteResult.ErrorMessage.errorCode.Equals("-2146232060")) { string[] paramlist = new string[4]; paramlist[0] = transaction["DEVICE_NAME"].ToString(); paramlist[1] = transaction["USER_ID"].ToString(); paramlist[2] = transaction["TRANS_DATE"].ToString(); paramlist[3] = transaction["TRANS_TYPE"].ToString(); SystemContext.LogWithParams(SystemContext.RootLogger, LogLevel.CORE, remoteResult.ErrorMessage.englishValue, paramlist); } else { DAL.DAO.ExecuteNoneQuery(setMoveFlagQuery); } } } return(true); }