public FormAddSchedule(DBconnector.DBconnector connector)
{
InitializeComponent();
this.connector = connector;
DataTable dt = new DataTable();
string result = this.connector.GetProducts(dt);
if (result != "")
{
MessageBox.Show("Could not get products");
}
else
{
foreach(DataRow row in dt.Rows)
{
comboBox.Items.Add(row["SKU"].ToString());
}
if (comboBox.Items.Count != 0)
{
comboBox.SelectedIndex = 0;
}
}
}
private void PopulateDependencies()
{
string command = "EXEC sp_depends '" + this.Name + "'";
using (DBconnector dbc = new DBconnector())
{
dbc.ExecuteCommand(command, ProcedureType.Read);
foreach (DataRow row in dbc.GetResultTable().Rows)
{
string name = row.ItemArray[0].ToString();
string type = row.ItemArray[1].ToString();
// Skip stored procedures
if (type == "stored procedure")
{
continue;
}
string info = $"{type}: {name}";
if (!Dependencies.Contains(info))
{
Dependencies.Add(info);
}
}
}
}
private void PopulateProcedureDependencies()
{
string command = "SELECT DISTINCT referenced_entity_name FROM sys.dm_sql_referenced_entities ('";
command += this.Name + "', 'OBJECT') WHERE referenced_entity_name IN(select name from sys.procedures) ";
using (DBconnector dbc = new DBconnector())
{
dbc.ExecuteCommand(command, ProcedureType.Read);
foreach (DataRow row in dbc.GetResultTable().Rows)
{
NumberOfCalls += 1;
string storedProcedure = "dbo." + row.ItemArray[0].ToString();
StoredProcedure sp = new StoredProcedure(storedProcedure);
Procedures.Add(sp);
DependencyDepth += 1; // Increment the depth counter by one
sp.LookForDependencies();
NumberOfCalls += sp.NumberOfCalls;
}
}
}
public FormAddUser(DBconnector.DBconnector connector)
{
InitializeComponent();
this.connector = connector;
if (comboBoxUserType.Items.Count != 0)
{
comboBoxUserType.SelectedIndex = 0;
}
}
private void PopulateProcedureNamesList()
{
using (DBconnector dbc = new DBconnector())
{
string command = "SELECT name FROM sys.procedures ORDER BY name";
dbc.ExecuteCommand(command, ProcedureType.Read);
DataTable table = dbc.GetResultTable();
foreach (DataRow row in table.Rows)
{
ProcedureNamesList.Items.Add(row[0].ToString());
}
}
}
public FormRemoveUser(DBconnector.DBconnector connector)
{
InitializeComponent();
this.connector = connector;
}
public Object GetXData()
{
var service = new DBconnector();
public void initConnector(DBConnector iConnector)
{
this._connector = iConnector;
}
