public static SqlDataBaseOjectHandler GlobalPerformQuery(string query)
{
SqlDataBaseOjectHandler handler = new SqlDataBaseOjectHandler();
try
{
SqlCommand command = new SqlCommand(query, SqlConnectionClass.getConn());
SqlConnectionClass.getConn().Open();
System.Data.ConnectionState state = SqlConnectionClass.getConn().State;
if (!(state == System.Data.ConnectionState.Open))
{
Helper_Classes_namespace.ErrorMessages.setErrorMessage(" Sorry no Db Connection !!!!!!! ", true);
handler.hasErrors = true;
return(handler);
}
command.ExecuteNonQuery();
handler.reader = command.ExecuteReader();
}
catch (System.Exception em)
{
Helper_Classes_namespace.ErrorMessages.setErrorMessage(em.ToString(), true);
handler.hasErrors = true;
}
return(handler);
}
public SqlCommand PerformQuery(string query)
{
SqlCommand command = new SqlCommand(query, SqlConnectionClass.getConn());
SqlConnectionClass.getConn().Open();
System.Data.ConnectionState state = SqlConnectionClass.getConn().State;
if (!(state == System.Data.ConnectionState.Open))
{
MessageBox.Show(" Sorry no Db Connection !!!!!!! ");
return(null);
}
return(command);
}
public static void ClosePerformQuery()
{
SqlConnectionClass.getConn().Close();
}
