public string HealthCheckConnection() { string flag = ""; SqlConnection connection = null; try { connection = new SqlConnection(SQLAdapter.GetConnection()); connection.Open(); flag = "Success"; } catch (Exception ex) { flag = "Error:" + ex.ToString(); PLog.Error("HealthCheck", ex, 0, ""); } finally { if (connection != null && connection.State == ConnectionState.Open) { connection.Close(); } } return(flag); }
public string Get(ArrayList param, string SPName, out string OutputParameterName, int iFlg, int CompanyIndex = 0) { OutputParameterName = ""; long ReturnValue = 0; try { if (General.DataBase.Equals("SQL")) { SQLDBResult dbResult = SQLAdapter.Execute(SPName, param, SQLAdapter.GetConnection(CompanyIndex)); if (dbResult.Parameters.ContainsKey((object)"@CodeGenerated")) { OutputParameterName = dbResult.Parameters[(object)"@CodeGenerated"].ToString(); } ReturnValue = Convert.ToInt64(dbResult.Parameters[(object)"@RETURN_VALUE"]); this.LogException(param, SPName, CompanyIndex, dbResult, "", ReturnValue); return(OutputParameterName); } } catch (Exception ex) { this.LogException(param, SPName, CompanyIndex, (SQLDBResult)null, ex.Message, ReturnValue); } return(""); }
public string Set(ArrayList param, string SPName, out long ReturnValue, int CompanyIndex = 0) { ReturnValue = 0L; try { if (General.DataBase.Equals("SQL")) { SQLDBResult dbResult = SQLAdapter.Execute(SPName, param, SQLAdapter.GetConnection(CompanyIndex)); ReturnValue = Convert.ToInt64(dbResult.Parameters[(object)"@RETURN_VALUE"]); this.LogException(param, SPName, CompanyIndex, dbResult, "", ReturnValue); if (dbResult.Contents != null) { if (dbResult.Contents.Tables.Count > 0) { if (dbResult.Contents.Tables[dbResult.Contents.Tables.Count - 1].Rows.Count > 0) { if (dbResult.Contents.Tables[dbResult.Contents.Tables.Count - 1].Columns.Contains("ErrorMessage")) { return(dbResult.Contents.Tables[dbResult.Contents.Tables.Count - 1].Rows[0]["ErrorMessage"].ToString()); } else if (dbResult.Contents.Tables[dbResult.Contents.Tables.Count - 1].Columns.Contains("DOCNAME")) { return(dbResult.Contents.Tables[dbResult.Contents.Tables.Count - 1].Rows[0]["DOCNAME"].ToString()); } } } } } } catch (Exception ex) { this.LogException(param, SPName, CompanyIndex, (SQLDBResult)null, ex.Message, ReturnValue); } return(string.Empty); }
public DataSet SetWithDataSet(ArrayList param, string SPName, out long ReturnValue, int CompanyIndex = 0) { ReturnValue = 0L; try { if (General.DataBase.Equals("SQL")) { SQLDBResult dbResult = SQLAdapter.Execute(SPName, param, SQLAdapter.GetConnection(CompanyIndex)); ReturnValue = Convert.ToInt64(dbResult.Parameters[(object)"@RETURN_VALUE"]); this.LogException(param, SPName, CompanyIndex, dbResult, "", ReturnValue); return(dbResult.Contents); } } catch (Exception ex) { this.LogException(param, SPName, CompanyIndex, (SQLDBResult)null, ex.Message, ReturnValue); } return(new DataSet()); }
public DataSet Get(ArrayList param, string SPName, int CompanyIndex = 0) { DataSet dataSet = new DataSet(); long ReturnValue = 0L; try { if (General.DataBase.Equals("SQL")) { SQLDBResult dbResult = SQLAdapter.Execute(SPName, param, SQLAdapter.GetConnection(CompanyIndex)); dataSet = dbResult.Contents; ReturnValue = Convert.ToInt64(dbResult.Parameters[(object)"@RETURN_VALUE"]); //if (SPName == "sp_GetUserDetails") // throw new Exception(); this.LogException(param, SPName, CompanyIndex, dbResult, "", ReturnValue); } } catch (Exception ex) { this.LogException(param, SPName, CompanyIndex, (SQLDBResult)null, ex, ReturnValue); } return(dataSet); }
public bool IsDatabaseExists() { try { SQLAdapter.Execute(" if exists(select name from sys.databases where name='pact2c') RAISERROR('-100',16,1) ", SQLAdapter.GetConnection()); return(false); } catch (Exception ex) { return(true); } }
public int ExecuteScript(string Query, int CompanyIndex = 0) { return(SQLAdapter.Execute(Query, SQLAdapter.GetConnection(CompanyIndex))); }