public DataTable ExecuteProcedure(ISqlComunicator SqlComunicator)
{
using (SqlConnection connection = CreateSQLConnection())
{
SqlCommand command = new SqlCommand(SqlComunicator.ProcedureName, connection);
command.CommandType = CommandType.StoredProcedure;
if (SqlComunicator.ParamList != null)
{
foreach (SqlParameter param in SqlComunicator.ParamList)
{
command.Parameters.Add(param);
}
}
SqlDataReader reader = command.ExecuteReader();
try
{
resultTable = new DataTable();
resultTable.Load(reader);
if (resultTable.Columns[0].ColumnName == "Succes")
{
MessageBox.Show(resultTable.Rows[0][0].ToString());
}
else if (resultTable.Columns[0].ColumnName == "Error")
{
MessageBox.Show(resultTable.Rows[0][0].ToString());
}
}
finally
{
reader.Close();
}
}
return(resultTable);
}
public DataTable ModifyData(ISqlComunicator SqlComunicator)
{
SqlComunicator.ModifyData();
return(ExecuteProcedure(SqlComunicator));
}
public DataTable AddData(ISqlComunicator SqlComunicator)
{
SqlComunicator.AddData();
return(ExecuteProcedure(SqlComunicator));
}
