public CreateTrigger GenerateCreateTriggerStatement(Trigger t)
{
CreateTrigger ct = new CreateTrigger();
ct.Trigger = t;
return(ct);
}
public string GenerateCreateTriggerScript(CreateTrigger CreateTriggerStatement)
{
string Tmp =
"drop trigger dbo." + CreateTriggerStatement.Trigger.TriggerName + Environment.NewLine;
Tmp += CreateTriggerStatement.Trigger.Body;
return(Tmp);
}
private static void GenerateAuditTableTriggers(string schema, string tableName, StringBuilder sqlBuilder, AuditUpdateParameters updateParameters, Action <string, float?> reportProgress)
{
reportProgress(string.Format("Generating Triggers for {0}.{1}", schema, tableName), null);
CreateTrigger triggerTemplate = new CreateTrigger(schema, tableName, updateParameters);
string sql = triggerTemplate.TransformText();
sqlBuilder.AppendLine(sql);
reportProgress(string.Format("Generated Triggers for {0}.{1}", schema, tableName), null);
}
public async Task <IActionResult> Create([FromBody] CreateTrigger createTrigger)
{
var schedulingResult = await _schedulingService.AddJobSchedule(createTrigger.JobGroup, createTrigger.JobName, createTrigger.CronExpression,
createTrigger.TriggerDescription);
if (!schedulingResult.IsSuccessful)
{
return(BadRequest(new ErrorResponse {
ErrorMessage = schedulingResult.ErrorMessage
}));
}
return(Ok(_mapper.Map <SchedulingResult, TriggerSuccessfullyCreated>(schedulingResult)));
}
public IEnumerable <Action> ToActions()
{
List <Action> actions = new List <Action>();
foreach (Frame frame in this.Frames)
{
int index = this.Frames.IndexOf(frame);
bool loopNow = this.IsLooping && index == this.Frames.Count - 1;
ActionBuilder actionBuilder = new ActionBuilder();
CreateTrigger create = new CreateTrigger();
AdoneTrigger adone = new AdoneTrigger();
double frameDelay = frame.Delay.TotalMilliseconds;
double delay = frameDelay + this.Frames.Take(index).Sum(f => f.Delay.TotalMilliseconds);
create.AddCommand(new NameCommand {
Name = this.Name
});
create.AddCommand(new AnimateCommand {
Name = "me",
Animation = ".",
FrameCount = 1,
ImageCount = 1,
FrameDelay = (int)(delay)
});
adone.AddCommand(frame.Commands.ToArray());
if (loopNow)
{
// re-fire first frame on final frame completion
adone.AddCommand(new AstartCommand {
Name = this.Name
});
}
actionBuilder.AddTrigger(create).AddTrigger(adone);
actions.Add(actionBuilder.Build());
}
return(actions);
}
public static CreateTrigger GetCreateVcsTrigger(string buildConfigId)
{
var createTrigger = new CreateTrigger
{
BuildTypeLocator = "id:" + buildConfigId,
TypeId = "vcsTrigger",
TriggerProperties = new CreateTeamCityProperties
{
Properties = new List <CreateTeamCityProperty>
{
new CreateTeamCityProperty
{
Name = "quietPeriodMode",
Value = "DO_NOT_USE"
}
}
}
};
return(createTrigger);
}
public static CreateTrigger GetCreateVcsTrigger(string buildConfigId)
{
var createTrigger = new CreateTrigger
{
BuildTypeLocator = "id:" + buildConfigId,
TypeId = "vcsTrigger",
TriggerProperties = new CreateTeamCityProperties
{
Properties = new List<CreateTeamCityProperty>
{
new CreateTeamCityProperty
{
Name = "quietPeriodMode",
Value = "DO_NOT_USE"
}
}
}
};
return createTrigger;
}
private async void toolStripMenuItem2_Click(object sender, EventArgs e)
{
var node = (TreeNode)this.menuMenus.Tag;
if (node == null)
{
return;
}
if (node.Text.Equals("TABLES"))
{
this.TableCreate = new TableCreate(true, string.Empty);
if (TableCreate.ShowDialog() == DialogResult.OK)
{
try
{
var result = await this.controller.ExecuteConsult(TableCreate.Query);
if (result == 0)
{
this.treeViewDataConecction.Nodes.Clear();
var nodes = (await this.controller.GethTreeNodes()).ToArray();
this.treeViewDataConecction.Nodes.AddRange(nodes);
MessageBox.Show("The table was crate suscefully");
}
else
{
MessageBox.Show("Not was create the table");
}
}
catch (Exception exc)
{
MessageBox.Show("Internal error:" + exc.Message);
}
}
}
else if (node.Text.Equals("VIEWS"))
{
this.CreateView = new CreateView(true, string.Empty);
if (this.CreateView.ShowDialog() == DialogResult.OK)
{
try
{
var query = this.CreateView.Sql;
var result = await this.controller.ExecuteConsult(query);
if (result == 0)
{
this.treeViewDataConecction.Nodes.Clear();
var nodes = (await this.controller.GethTreeNodes()).ToArray();
this.treeViewDataConecction.Nodes.AddRange(nodes);
MessageBox.Show("The view was crate suscefully");
}
else
{
MessageBox.Show("Not was create the view");
}
}
catch (Exception)
{
MessageBox.Show("Internal error");
}
}
}
else if (node.Text.Equals("TRIGGERS"))
{
this.CreateTrigger = new CreateTrigger(true, string.Empty, this.controller.datab);
if (this.CreateTrigger.ShowDialog() == DialogResult.OK)
{
try
{
var query = this.CreateTrigger.Sql;
var result = await this.controller.ExecuteConsult(query);
if (result == 0)
{
this.treeViewDataConecction.Nodes.Clear();
var nodes = (await this.controller.GethTreeNodes()).ToArray();
this.treeViewDataConecction.Nodes.AddRange(nodes);
MessageBox.Show("The trigger was crate suscefully");
}
else
{
MessageBox.Show("Not was create the trigger");
}
}
catch (Exception exc)
{
MessageBox.Show("Internal error:" + exc.Message);
}
}
}
else if (node.Text.Equals("INDEXS"))
{
var nodeP = node.Parent;
if (nodeP == null)
{
return;
}
this.CreateIndex = new CreateIndex(true, "", this.controller.datab, nodeP.Text);
if (this.CreateIndex.ShowDialog() == DialogResult.OK)
{
try
{
var query = this.CreateIndex.Sql;
var result = await this.controller.ExecuteConsult(query);
if (result == 0)
{
this.treeViewDataConecction.Nodes.Clear();
var nodes = (await this.controller.GethTreeNodes()).ToArray();
this.treeViewDataConecction.Nodes.AddRange(nodes);
MessageBox.Show("The index was crate suscefully");
}
else
{
MessageBox.Show("Not was create the index");
}
}
catch (Exception esx)
{
MessageBox.Show("Internal error:" + esx.Message);
}
}
}
}