public static void mngError(Exception ex, string function, string module, string infoAdd, string title, eErrorLevel level, eErrorType varType, object connection) { // TODO: implement function fErrors f = new fErrors(); f.setErrorIcon(); f.setDetails(ex.Message); f.ShowDialog(); }
public bool execute(string sqlstmt, string function, string module, string title, eErrorLevel level) { int tryCount = 0; ors = null; while (tryCount < m_maxTryExecute) { if (pExecute(sqlstmt, function, module, title, level, tryCount == m_maxTryExecute)) { return true; } } return false; }
private bool pExecute(string sqlstmt, string function, string module, string title, eErrorLevel level, bool showError) { try { DbCommand ocmd = createCommand(sqlstmt); ocmd.ExecuteNonQuery(); return true; } catch (Exception ex) { if (showError) { cError.mngError(ex, "pExecute for " + module + "." + function, c_module, "sentencia: " + sqlstmt); } return false; } }
public bool existsInRecordEx(DataRow dr, DataColumn[] columns, string val, out bool founded, bool like, string function, string module, string title, eErrorLevel level) { return pExistsInRecord(dr, columns, val, out founded, like, function, module, title, level); }
private bool pExistsInRecord(DataRow dr, DataColumn[] columns, string val, out bool founded, bool like, string function, string module, string title, eErrorLevel level) { string filter = ""; founded = false; val = val.ToLower(); try { foreach (DataColumn col in columns) { System.TypeCode typeCode = System.Type.GetTypeCode(col.GetType()); ; switch (typeCode) { case System.TypeCode.Char: case System.TypeCode.String: if (like) { founded = dr[col.ColumnName].ToString().ToLower().Contains(val); } else { founded = dr[col.ColumnName].ToString().ToLower() == val; } break; case System.TypeCode.Decimal: case System.TypeCode.Double: case System.TypeCode.Int16: case System.TypeCode.Int32: case System.TypeCode.Int64: case System.TypeCode.Single: case System.TypeCode.UInt16: case System.TypeCode.UInt32: case System.TypeCode.UInt64: int ival; if (int.TryParse(val, out ival)) { founded = (int)dr[col.ColumnName] == ival; } break; case System.TypeCode.DateTime: break; case System.TypeCode.Boolean: founded = false; break; default: founded = false; break; } } return true; } catch (Exception ex) { cError.mngError(ex, "existsInRecord", module, "filter: " + filter); return false; } }
private bool pOpenRs(string sqlstmt, out DbDataReader ors, string function, string module, string title, eErrorLevel level, bool showError) { ors = null; try { DbCommand ocmd = createCommand(sqlstmt); ors = ocmd.ExecuteReader(); return true; } catch (Exception ex) { if (showError) { cError.mngError(ex, "openRs for " + module + "." + function, c_module, "sentencia: " + sqlstmt); } return false; } }
public bool existsInRecordset(DataTable dt, string field, string val, out bool founded, string function, string module, string title, eErrorLevel level) { string filter = field + " = " + val; founded = false; try { if (dt.Rows.Count == 0) { return false; } else { DataRow[] vdr = dt.Select(filter); founded = vdr.Length > 0; return true; } } catch (Exception ex) { cError.mngError(ex, "existsInRecordset", module, "filter: " + filter); return false; } }
public bool saveSp(string sqlstmt, out DbDataReader ors, int timeout, string function, string module, string title, eErrorLevel level) { int oldCommandTimeout = m_commandTimeout; if (timeout != -1) { m_commandTimeout = timeout; } bool rtn = openRs(sqlstmt, out ors, function, module, title, level); m_commandTimeout = oldCommandTimeout; return rtn; }
public bool openRs(string sqlstmt, out DbDataReader ors, string function, string module, string title, eErrorLevel level) { int tryCount = 0; ors = null; while (tryCount < m_maxTryOpenRs) { if (pOpenRs(sqlstmt, out ors, function, module, title, level, tryCount == m_maxTryOpenRs)) { return true; } } return false; }
private bool pGetNewId(string table, string fieldId, out int id, bool showError, string function, string module, string title, eErrorLevel level) { id = 0; try { string sqlstmt; DbDataReader ors; DbCommand ocmd; sqlstmt = "sp_dbgetnewid " + sqlString(table) + "," + sqlString(fieldId) + ",0"; ocmd = createCommand(sqlstmt); ors = ocmd.ExecuteReader(); if (ors.Read()) { id = (int)ors.GetInt32(0); return true; } else { return false; } } catch (Exception ex) { cError.mngError(ex, "pGetNewId for " + module + "." + function, c_module, ""); return false; } }
public bool getNewId(string table, string fieldId, out int id, string function, string module, string title, eErrorLevel level) { cMouseWait mouseWait = new cMouseWait(); id = cConstants.C_NO_ID; try { if (pGetNewId(table, fieldId, out id, false, function, module, title, level)) { return true; } else { if (pReconnectTry()) { return pGetNewId(table, fieldId, out id, true, function, module, title, level); } else return false; } } catch (Exception ex) { cError.mngError(ex, "getNewId for " + module + "." + function, c_module, ""); return false; } finally { mouseWait.Dispose(); } }
private bool pGetData(string table, string fieldId, string id, string field, out DbDataReader ors, string function, string module, string title, eErrorLevel level) { string sqlstmt; ors = null; sqlstmt = "select " + field + " from " + table + " where " + fieldId + " = " + id; return openRs(sqlstmt, out ors, function, module, title, level); }
public bool getData(string table, string fieldId, string id, string field, out DateTime data, string function, string module, string title, eErrorLevel level) { DbDataReader ors; data = cConstants.C_NO_DATE; if (pGetData(table, fieldId, id, field, out ors, function, module, title, level)) { if (ors.Read()) { data = ors.GetDateTime(0); } return true; } else return false; }
public bool getData(string table, string fieldId, string id, string field, out int data, string function, string module, string title, eErrorLevel level) { DbDataReader ors; data = 0; if (pGetData(table, fieldId, id, field, out ors, function, module, title, level)) { if (ors.Read()) { data = (int)ors.GetInt32(0); } return true; } else return false; }