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)));
}
