public static void InsertActionwordCurrentRow(Actionword aw)
{
var sh = (Excel.Worksheet)application.ActiveSheet;
var cur = (Excel.Range)application.ActiveCell;
long c;
if (!IsTestdataSheet(sh)) return;
long row = cur.Row;
string cont_str = "&Cont";
sh.Rows[row].Insert();
sh.Rows[row].Insert();
row++;
sh.Cells[row-1, 1].Style = "actionword";
sh.Cells[row, 1].Style = "actionword";
sh.Cells[row, 1].Value = aw.Name;
sh.Cells[row, 1].Activate();
long maxnr = TFDatabase.Active.Settings.ArgumentsPerRow + 1;
c = 2;
foreach (var arg in aw.Arguments)
{
sh.Cells[row - 1, c].Value = arg.Name;
sh.Cells[row - 1, c].Style = "argument";
sh.Cells[row, c].Style = "testdata";
sh.Cells[row, c].Value = arg.DefaultValue;
c++;
if (c == maxnr)
{
sh.Cells[row, c].Value = cont_str;
sh.Cells[row, c].Style = "testdata";
c = 2;
row++;
sh.Rows[row].Insert();
sh.Cells[row, 1].Style = "actionword";
row++;
sh.Rows[row].Insert();
sh.Cells[row, 1].Style = "actionword";
sh.Cells[row, 1].Value = cont_str;
}
}
}
internal static Nullable<bool> ShowEditActionword(Actionword aw)
{
var dlg = new EditActionword();
dlg.CurrentActionword = aw;
return dlg.ShowDialog();
}
public static Actionword New(Element element, string name)
{
var actionword = new Actionword() { Element = element, Name = name };
actionword._isnew = true;
return actionword;
}
public static Argument New(Actionword actionword, string name)
{
var argument = new Argument();
var conn = TFDatabase.Active.Connection;
int arg_nr = actionword.Arguments.Count + 2;
var cmd = new OleDbCommand("INSERT INTO [argument] ([actionword_id], [argument_number], [name]) VALUES (@Parent, @Number, @Name)", conn);
cmd.Parameters.AddWithValue("@Parent", actionword.ID);
cmd.Parameters.AddWithValue("@Number", arg_nr);
cmd.Parameters.AddWithValue("@Name", name);
cmd.ExecuteNonQuery();
cmd = new OleDbCommand("SELECT @@IDENTITY AS IDVal", conn);
object o = cmd.ExecuteScalar();
var id = Convert.ToInt32(o.ToString());
argument.ID = id;
argument.Name = name;
argument.Number = arg_nr;
argument.Actionword = actionword;
return argument;
}
public static List<Actionword> GetList(Element element = null)
{
var list = new List<Actionword>();
var conn = TFDatabase.Active.Connection;
OleDbCommand cmd;
if (element == null)
{
cmd = new OleDbCommand("SELECT * FROM [actionword]", conn);
}
else
{
cmd = new OleDbCommand("SELECT * FROM [actionword] WHERE [element]=@ID", conn);
cmd.Parameters.AddWithValue("@ID", element.ID);
}
var reader = cmd.ExecuteReader();
while (reader.Read())
{
var aw = new Actionword() {
ID = Convert.ToInt32(reader["actionword_ID"].ToString())
, Name = reader["actionword"].ToString()
, Description = reader["description"].ToString()
, Actions = reader["actions"].ToString()
, PreCondition = reader["precondition"].ToString()
, PostCondition = reader["postcondition"].ToString()
, Element = element
};
aw.Dirty = false;
if ( reader["start_screen"]==null )
aw.StartScreen = int.Parse(reader["start_screen"].ToString());
if (reader["end_screen"] == null)
aw.EndScreen = int.Parse(reader["end_screen"].ToString());
list.Add(aw);
}
cmd.Dispose();
return list;
}