protected void Update(AbstractComponent abstrComp)
{
base.Update(abstrComp);
RawSqlExecuteNonQueryAction updateAction = new RawSqlExecuteNonQueryAction();
updateAction.CommandText = _updateCommandText;
updateAction.AddParameter("@InstanceId", abstrComp.InstanceId, DbType.Int32);
//throw new NotImplementedException("What to do with InstanceId?");
//if (abstrComp.ParentComponent != null)
// updateAction.AddParameter("@ParentComponentId", abstrComp.ParentComponent.InstanceId, DbType.Int32);
//else
// updateAction.AddParameter("@ParentComponentId", null, DbType.Int32);
updateAction.AddParameter("@TopVal", abstrComp.Top.Value, DbType.Int32);
updateAction.AddParameter("@TopUnit", (int)abstrComp.Top.Unit, DbType.Int32);
updateAction.AddParameter("@LeftVal", abstrComp.Left.Value, DbType.Int32);
updateAction.AddParameter("@LeftUnit", (int)abstrComp.Left.Unit, DbType.Int32);
updateAction.AddParameter("@HeightVal", abstrComp.Height.Value, DbType.Int32);
updateAction.AddParameter("@HeightUnit", (int)abstrComp.Height.Unit, DbType.Int32);
updateAction.AddParameter("@WidthVal", abstrComp.Width.Value, DbType.Int32);
updateAction.AddParameter("@WidthUnit", (int)abstrComp.Width.Unit, DbType.Int32);
this.ExecuteCommand(updateAction);
}
protected void Delete(ClassDefinition classDef)
{
RawSqlExecuteNonQueryAction deleteAction = new RawSqlExecuteNonQueryAction();
deleteAction.CommandText = _deleteCommandText;
deleteAction.AddParameter("@ClassDefinitionId", classDef.ClassDefinitionId, DbType.Int32);
this.ExecuteCommand(deleteAction);
}
protected void Delete(Instance instance)
{
RawSqlExecuteNonQueryAction deleteAction = new RawSqlExecuteNonQueryAction();
deleteAction.CommandText = _deleteCommandText;
deleteAction.AddParameter("@InstanceId", instance.InstanceId, DbType.Int32);
this.ExecuteCommand(deleteAction);
}
protected void Delete(BindablePointDefinition bindPointDef)
{
RawSqlExecuteNonQueryAction deleteAction = new RawSqlExecuteNonQueryAction();
deleteAction.CommandText = _deleteCommandText;
deleteAction.AddParameter("@BindablePointDefinitionId", bindPointDef.BindablePointDefinitionId, DbType.Int32);
this.ExecuteCommand(deleteAction);
}
protected void Delete(Binding binding)
{
RawSqlExecuteNonQueryAction deleteAction = new RawSqlExecuteNonQueryAction();
deleteAction.CommandText = _deleteCommandText;
deleteAction.AddParameter("@BindingId", binding.BindingId, DbType.Int32);
this.ExecuteCommand(deleteAction);
}
protected void Delete(PlugLocation plugLoc)
{
RawSqlExecuteNonQueryAction deleteAction = new RawSqlExecuteNonQueryAction();
deleteAction.CommandText = _deleteCommandText;
deleteAction.AddParameter("@PlugLocationId", plugLoc.PlugLocationId, DbType.Int32);
this.ExecuteCommand(deleteAction);
}
protected void Delete(AbstractComponent abstrComp)
{
RawSqlExecuteNonQueryAction deleteAction = new RawSqlExecuteNonQueryAction();
deleteAction.CommandText = _deleteCommandText;
deleteAction.AddParameter("@InstanceId", abstrComp.InstanceId, DbType.Int32);
this.ExecuteCommand(deleteAction);
base.Delete(abstrComp);
}
protected void Update(Instance instance)
{
RawSqlExecuteNonQueryAction updateAction = new RawSqlExecuteNonQueryAction();
updateAction.CommandText = _updateCommandText;
updateAction.AddParameter("@InstanceId", instance.InstanceId, DbType.Int32);
updateAction.AddParameter("@ClassDefinitionId", instance.ClassDefinitionId, DbType.Int32);
updateAction.AddParameter("@InstanceName", instance.InstanceName, DbType.String);
this.ExecuteCommand(updateAction);
}
protected void Delete(StaticContent rootCont)
{
RawSqlExecuteNonQueryAction deleteAction = new RawSqlExecuteNonQueryAction();
deleteAction.CommandText = _deleteCommandText;
deleteAction.AddParameter("@InstanceId", rootCont.InstanceId, DbType.Int32);
this.ExecuteCommand(deleteAction);
base.Delete(rootCont);
}
protected void Update(Binding binding)
{
RawSqlExecuteNonQueryAction updateAction = new RawSqlExecuteNonQueryAction();
updateAction.CommandText = _updateCommandText;
updateAction.AddParameter("@BindingId", binding.BindingId, DbType.Int32);
updateAction.AddParameter("@ImplementationId", binding.ImplementationId, DbType.Int32);
updateAction.AddParameter("@BindablePointId", binding.BindablePointId, DbType.Int32);
this.ExecuteCommand(updateAction);
}
protected void Update(BindablePoint bindPoint)
{
RawSqlExecuteNonQueryAction updateAction = new RawSqlExecuteNonQueryAction();
updateAction.CommandText = _updateCommandText;
updateAction.AddParameter("@BindablePointId", bindPoint.BindablePointId, DbType.Int32);
updateAction.AddParameter("@BindablePointDefinitonId", bindPoint.BindablePointDefinitionId, DbType.Int32);
updateAction.AddParameter("@InstanceId", bindPoint.InstanceId, DbType.Int32);
updateAction.AddParameter("@Active", bindPoint.Active, DbType.Boolean);
this.ExecuteCommand(updateAction);
}
protected void Update(PlugFile plugFile)
{
RawSqlExecuteNonQueryAction updateAction = new RawSqlExecuteNonQueryAction();
updateAction.CommandText = _updateCommandText;
updateAction.AddParameter("@PlugFileId", plugFile.PlugFileId, DbType.Int32);
updateAction.AddParameter("@PlugFileName", plugFile.PlugFileName, DbType.String);
updateAction.AddParameter("@RelativeIncomingPath", plugFile.RelativeIncomingPath, DbType.String);
updateAction.AddParameter("@DestinationLocationId", plugFile.DestinationLocationId, DbType.Int32);
updateAction.AddParameter("@PlugId", plugFile.PlugId, DbType.Int32);
this.ExecuteCommand(updateAction);
}
protected void Update(PlugLocation plugLoc)
{
RawSqlExecuteNonQueryAction updateAction = new RawSqlExecuteNonQueryAction();
updateAction.CommandText = _updateCommandText;
updateAction.AddParameter("@PlugLocationId", plugLoc.PlugLocationId, DbType.Int32);
updateAction.AddParameter("@PlugLocationName", plugLoc.PlugLocationName, DbType.String);
updateAction.AddParameter("@PlugLocationDescription", plugLoc.PlugLocationDescription, DbType.String);
updateAction.AddParameter("@PlugLocationPath", plugLoc.PlugLocationPath, DbType.String);
updateAction.AddParameter("@PlugId", plugLoc.PlugId, DbType.Int32);
this.ExecuteCommand(updateAction);
}
public override void InstallRequiredEnvironment()
{
if (this.Context == null)
{
throw new InvalidOperationException("You should set Context property before calling InstallRequiredEnvironment method");
}
string command = new StreamReader(sqlFileName).ReadToEnd();
RawSqlExecuteNonQueryAction createTableAction = new RawSqlExecuteNonQueryAction();
createTableAction.CommandText = command; //_createTableCommandText;
this.ExecuteCommand(createTableAction);
}
protected void Update(PlugIn plug)
{
RawSqlExecuteNonQueryAction updateAction = new RawSqlExecuteNonQueryAction();
updateAction.CommandText = _updateCommandText;
updateAction.AddParameter("@PlugName", plug.PlugName, DbType.String);
updateAction.AddParameter("@PlugFriendlyName", plug.PlugFriendlyName, DbType.String);
updateAction.AddParameter("@PlugDescription", plug.PlugDescription, DbType.String);
updateAction.AddParameter("@PlugVersion", plug.PlugVersion, DbType.String);
updateAction.AddParameter("@Active", plug.Active, DbType.Boolean);
updateAction.AddParameter("@PlugId", plug.PlugId, DbType.Int32);
this.ExecuteCommand(updateAction);
}
protected void Update(BindablePointDefinition bindPointDef)
{
RawSqlExecuteNonQueryAction updateAction = new RawSqlExecuteNonQueryAction();
updateAction.CommandText = _updateCommandText;
updateAction.AddParameter("@BindablePointDefinitionId", bindPointDef.BindablePointDefinitionId, DbType.Int32);
updateAction.AddParameter("@ClassDefinitionId", bindPointDef.ClassDefinitionId, DbType.Int32);
updateAction.AddParameter("@BindablePointName", bindPointDef.BindablePointName, DbType.String);
updateAction.AddParameter("@BindablePointFriendlyName", bindPointDef.BindablePointFriendlyName, DbType.String);
updateAction.AddParameter("@BindablePointDescription", bindPointDef.BindablePointDescription, DbType.String);
updateAction.AddParameter("@InterfaceId", bindPointDef.InterfaceId, DbType.Int32);
this.ExecuteCommand(updateAction);
}
protected void Update(ClassDefinition classDef)
{
RawSqlExecuteNonQueryAction updateAction = new RawSqlExecuteNonQueryAction();
updateAction.CommandText = _updateCommandText;
updateAction.AddParameter("@ClassDefinitionId", classDef.ClassDefinitionId, DbType.Int32);
updateAction.AddParameter("@ClassName", classDef.ClassName, DbType.String);
updateAction.AddParameter("@ClassDefinitionDescription", classDef.ClassDefinitionDescription, DbType.String);
updateAction.AddParameter("@Active", classDef.Active, DbType.Boolean);
updateAction.AddParameter("@FileId", classDef.FileId, DbType.Int32);
updateAction.AddParameter("@PlugId", classDef.PlugId, DbType.Int32);
this.ExecuteCommand(updateAction);
}
protected void Update(StaticContent rootCont)
{
base.Update(rootCont);
RawSqlExecuteNonQueryAction updateAction = new RawSqlExecuteNonQueryAction();
updateAction.CommandText = _updateCommandText;
updateAction.AddParameter("@InstanceId", rootCont.InstanceId, DbType.Int32);
updateAction.AddParameter("@ParentInstanceId", rootCont.ParentContent.InstanceId, DbType.Int32);
updateAction.AddParameter("@ContentFriendlyName", rootCont.ContentFriendlyName, DbType.String);
updateAction.AddParameter("@ContentDescription", rootCont.ContentDescription, DbType.String);
updateAction.AddParameter("@ContentImageSrc", rootCont.ContentImageSrc, DbType.String);
this.ExecuteCommand(updateAction);
}
