public static string ChoosePrimaryFile()
{
IdeaClient client = null;
CommonDialogs commonDialogs = null;
try
{
client = new IdeaClient();
UtilityCasewareIdea.ShowWindow();
commonDialogs = client.CommonDialogs();
string temp = commonDialogs.FileExplorer();
if (temp != "")
{
client.OpenDatabase(temp);
}
return(temp);
}
catch (Exception)
{
return("");
}
finally
{
UtilityCasewareIdea.DisposeCom(client);
UtilityCasewareIdea.DisposeCom(commonDialogs);
}
}
public void Run(string chosenDB, int numberOfFieldsToAdd, string defaultStatusFieldName, string defaultCommentFieldName = null, int lengthOfCommentField = 0)
{
IdeaClient client = null;
IdeaDatabase db = null;
TableDef table = null;
Field field = null;
dynamic task = null;
string eqn = "-1";
try
{
client = new IdeaClient();
db = client.OpenDatabase(chosenDB);
task = db.TableManagement();
table = db.TableDef();
for (int i = 1; i <= numberOfFieldsToAdd; i++)
{
field = table.NewField();
field.name = defaultStatusFieldName + i;
field.description = "";
field.type = COMDBLib.VBFieldType.WI_MULTISTATE;
field.Equation = eqn;
field.Decimals = 0;
task.AppendField(field);
if (defaultCommentFieldName != null)
{
field = table.NewField();
field.name = defaultCommentFieldName + i;
field.description = "";
field.type = COMDBLib.VBFieldType.WI_EDIT_CHAR;
field.Equation = "\"\"";
field.Length = lengthOfCommentField;
task.AppendField(field);
}
}
task.PerformTask();
db.CommitDatabase();
}
catch (Exception ex)
{
throw ex;
}
finally
{
UtilityCasewareIdea.DisposeCom(client);
UtilityCasewareIdea.DisposeCom(db);
UtilityCasewareIdea.DisposeCom(table);
UtilityCasewareIdea.DisposeCom(field);
UtilityCasewareIdea.DisposeCom(task);
}
}