public void _zendesk(object _p) { objSQL _params; int i; try { _params = (objSQL)_p; using (RedshiftWorker sql = new RedshiftWorker("PSQL_salesdashboard")) { DataTable dt = new DataTable(); OdbcDataAdapter da = new OdbcDataAdapter(); DataRow dr; dt.TableName = _params._tablename; sql.GetDT(_params._sql, ref da, ref dt); if (dt.Rows.Count == 0) { dr = dt.NewRow(); for (i = 0; i < _params._fields.Count(); i++) { if (_params._dr[i].ToString().Length > 0) { dr[i] = @_params._dr[i]; } } dr["dsn"] = Guid.NewGuid(); dr["imported"] = DateTime.Now; dt.Rows.Add(dr); } else { dr = dt.Rows[0]; for (i = 0; i < _params._fields.Count(); i++) { if (_params._dr[i].ToString().Replace("[", "").Replace("]", "").Length > 0) { dr[i] = @_params._dr[i]; } } dr["lastupdate"] = DateTime.Now; } sql.UpdateDT(ref da, ref dt); } } catch (Exception ex) { string err = string.Format("{0}: {1}", MethodBase.GetCurrentMethod().Name, ex.ToString()); Nlogger.Error(err); } }
/// <summary> /// because AWS redshift doesn't support clacluetd functions dt_values are set by update /// </summary> public void _dtUpdate() { try { using (RedshiftWorker sql = new RedshiftWorker("PSQL_salesdashboard")) { sql.ExcuteSQL(AppConfig.GetString("update_dt_dealstage", "", "AWSRedshift_Statements")); sql.ExcuteSQL(AppConfig.GetString("update_dt_created", "", "AWSRedshift_Statements")); } } catch (Exception ex) { string err = string.Format("{0}: {1}", MethodBase.GetCurrentMethod().Name, ex.ToString()); Nlogger.Error(err); } }