//Функция создания по
private int addSoftwareIntoDB(ResultTableRows allInfo)
{
configProxyForLoadDataFromBDAndExecute("INSERT INTO Software VALUES(" +
checkExistVendorInDB(allInfo).ToString() + ",NULL,0,'" + allInfo.po + "',0);");
ConverterSingleColumnFromDataSet converter = new ConverterSingleColumnFromDataSet();
return(int.Parse(converter.convert(configProxyForLoadDataFromBDAndExecute(
"SELECT SoftwareID FROM Software WHERE Code='" + allInfo.po + "'"))[0]));
}
//Функция создания пользователя
private int addUserIntoDB(string userName, string host)
{
configProxyForLoadDataFromBDAndExecute("INSERT INTO Users VALUES('" + userName +
"','" + host + "')");
ConverterSingleColumnFromDataSet converter = new ConverterSingleColumnFromDataSet();
return(int.Parse(converter.convert(configProxyForLoadDataFromBDAndExecute(
"SELECT UserID FROM Users WHERE name='" + userName + "' AND host='" + host +
"'"))[0]));
}
//Функция получения id vendor по его имени
private int checkExistVendorInDB(ResultTableRows allInfo)
{
ConverterSingleColumnFromDataSet converter = new ConverterSingleColumnFromDataSet();
DataSet ds = configProxyForLoadDataFromBDAndExecute(
"SELECT VendorID FROM Vendor WHERE Name='" + allInfo.vendor + "'");
if (converter.convert(ds) != null)
{
return(int.Parse(converter.convert(ds)[0]));
}
else
{
addVendorIntoDB(allInfo);
ds = configProxyForLoadDataFromBDAndExecute(
"SELECT VendorID FROM Vendor WHERE Name='" + allInfo.vendor + "'");
return(int.Parse(converter.convert(ds)[0]));
}
}