protected internal string Save(int cid, string name, string category, string code, string viewid, int type, string attributes, string pivotColumn)
{
string templateid = Shared.generateID();
Tech.Data.Query.DBQuery dBQuery = DBQuery.InsertInto(TalentozTemplate.Table)
.Field(TalentozTemplate.ViewID.Name)
.Field(TalentozTemplate.ClientID.Name)
.Field(TalentozTemplate.TemplateID.Name)
.Field(TalentozTemplate.Name.Name)
.Field(TalentozTemplate.TemplateCode.Name)
.Field(TalentozTemplate.Category.Name)
.Field(TalentozTemplate.TemplateType.Name)
.Field(TalentozTemplate.ViewFields.Name)
.Field(TalentozTemplate.PivotColumn.Name)
.Field(TalentozTemplate.LastUPD.Name)
.Values(DBConst.String(viewid),
DBConst.Int32(cid),
DBConst.String(templateid),
DBConst.String(name),
DBConst.String(code),
DBConst.String(category),
DBConst.Const(System.Data.DbType.Int32, type),
DBConst.String(attributes),
DBConst.String(pivotColumn),
DBConst.Const(System.Data.DbType.DateTime, DateTime.Today)
);
if (db.ExecuteNonQuery(dBQuery) > 0)
{
return(templateid);
}
else
{
return("");
}
}
/// <summary>
///
/// </summary>
/// <param name="name"></param>
/// <param name="componentID"></param>
/// <param name="isRequired"></param>
/// <param name="isUnique"></param>
/// <param name="isCore"></param>
/// <param name="isReadonly"></param>
/// <param name="isSecured"></param>
/// <param name="lookupId"></param>
/// <param name="type"></param>
/// <param name="length"></param>
/// <param name="defaultValue"></param>
/// <param name="fileExtension"></param>
/// <param name="isNull"></param>
/// <param name="isPrimary"></param>
/// <param name="isAuto"></param>
/// <returns></returns>
protected internal string SaveAttribute(string name, string displayName, string componentID,
bool isRequired, bool isUnique, bool isCore,
bool isReadonly,
bool isSecured,
int lookupId,
int type,
int length,
string defaultValue,
string fileExtension,
bool isNull,
bool isPrimary,
bool isAuto,
string lookupComponent,
string componentDisplayField)
{
string attID = Shared.generateID();
Tech.Data.Query.DBQuery dBQuery = DBQuery.InsertInto(TalentozSchemaInfo.Table)
.Field(TalentozSchemaInfo.ComponentID.Name).Field(TalentozSchemaInfo.FieldID.Name).Field(TalentozSchemaInfo.AttributeName.Name)
.Field(TalentozSchemaInfo.DisplayName.Name).Field(TalentozSchemaInfo.IsRequired.Name).Field(TalentozSchemaInfo.IsUnique.Name)
.Field(TalentozSchemaInfo.IsCore.Name).Field(TalentozSchemaInfo.IsReadOnly.Name).Field(TalentozSchemaInfo.IsSecured.Name)
.Field(TalentozSchemaInfo.LookUpID.Name).Field(TalentozSchemaInfo.AttributeType.Name).Field(TalentozSchemaInfo.Length.Name)
.Field(TalentozSchemaInfo.DefaultValue.Name).Field(TalentozSchemaInfo.FileExtension.Name)// .Field(TalentozSchemaInfo.RegExp.Name)
.Field(TalentozSchemaInfo.IsNullable.Name)
.Field(TalentozSchemaInfo.ISPrimaryKey.Name)
.Field(TalentozSchemaInfo.IsAuto.Name)
.Field(TalentozSchemaInfo.LookupComponent.Name)
.Field(TalentozSchemaInfo.ComponentLookupDisplayName.Name)
.Field(TalentozSchemaInfo.LastUPD.Name)
.Values(DBConst.String(componentID),
DBConst.String(attID),
DBConst.String(name),
DBConst.String(displayName),
DBConst.Const(System.Data.DbType.Boolean, isRequired),
DBConst.Const(System.Data.DbType.Boolean, isUnique),
DBConst.Const(System.Data.DbType.Boolean, isCore),
DBConst.Const(System.Data.DbType.Boolean, isReadonly),
DBConst.Const(System.Data.DbType.Boolean, isSecured),
DBConst.Const(System.Data.DbType.Int32, lookupId),
DBConst.Const(System.Data.DbType.Int32, type),
DBConst.Const(System.Data.DbType.Int32, length),
DBConst.Const(System.Data.DbType.String, defaultValue),
DBConst.Const(System.Data.DbType.String, fileExtension),
DBConst.Const(System.Data.DbType.Boolean, isNull),
DBConst.Const(System.Data.DbType.Boolean, isPrimary),
DBConst.Const(System.Data.DbType.Boolean, isAuto),
DBConst.Const(System.Data.DbType.String, lookupComponent),
DBConst.Const(System.Data.DbType.String, componentDisplayField),
DBConst.Const(System.Data.DbType.DateTime, DateTime.Today)
);
if (db.ExecuteNonQuery(dBQuery) > 0)
{
return(attID);
}
else
{
return("");
}
}
/// <summary>
///
/// </summary>
/// <param name="pName"></param>
/// <param name="category"></param>
/// <param name="schemaType"></param>
/// <param name="title"></param>
/// <param name="primarykeys"></param>
/// <param name="state"></param>
/// <param name="tableName"></param>
/// <returns></returns>
protected internal string SaveComponent(string pName,
string category,
int schemaType,
string title,
string primarykeys,
int state,
string tableName,
string entityKey
)
{
string ComponentId = Shared.generateID();
Tech.Data.Query.DBQuery dBQuery = DBQuery.InsertInto(TalentozSchema.Table)
.Field(TalentozSchema.ComponentID.Name)
.Field(TalentozSchema.ComponentName.Name)
.Field(TalentozSchema.Category.Name)
.Field(TalentozSchema.ComponentType.Name)
.Field(TalentozSchema.Title.Name)
.Field(TalentozSchema.ComponentState.Name)
.Field(TalentozSchema.TableName.Name)
.Field(TalentozSchema.LastUPD.Name)
.Field(TalentozSchema.PrimaryKeys.Name)
.Field(TalentozSchema.EntityKey.Name)
.Values(DBConst.String(ComponentId),
DBConst.String(pName),
DBConst.String(category),
DBConst.Int32(schemaType),
DBConst.String(title),
DBConst.Int32(state),
DBConst.String(tableName),
DBConst.DateTime(DateTime.Today),
DBConst.String(primarykeys),
DBConst.String(entityKey));
if (db.ExecuteNonQuery(dBQuery) > 0)
{
return(ComponentId);
}
else
{
return("");
}
}
protected virtual DBClause DoRead(string element, XmlReader reader, XmlReaderContext context)
{
DBClause c = null;
switch (element)
{
case (XmlHelper.Select):
c = DBSelectQuery.Select();
break;
case (XmlHelper.Delete):
c = DBDeleteQuery.Delete();
break;
case (XmlHelper.Update):
c = DBUpdateQuery.Update();
break;
case (XmlHelper.Insert):
c = DBInsertQuery.InsertInto();
break;
case (XmlHelper.Script):
c = DBQuery.Script();
break;
case (XmlHelper.Use):
c = DBUseQuery.Use();
break;
case (XmlHelper.Table):
c = DBTable.Table();
break;
case (XmlHelper.Fields):
c = DBSelectSet.Select();
break;
case (XmlHelper.AField):
c = DBField.Field();
break;
case (XmlHelper.AllFields):
c = DBField.AllFields();
break;
case (XmlHelper.From):
c = DBTableSet.From();
break;
case (XmlHelper.Where):
c = DBFilterSet.Where();
break;
case (XmlHelper.Group):
c = DBGroupBySet.GroupBy();
break;
case (XmlHelper.Order):
c = DBOrderSet.OrderBy();
break;
case (XmlHelper.Assignments):
c = DBAssignSet.Assign();
break;
case (XmlHelper.Values):
c = DBValueSet.Values();
break;
case (XmlHelper.Join):
c = DBJoin.Join();
break;
case (XmlHelper.Function):
c = DBFunction.Function();
break;
case (XmlHelper.Constant):
c = DBConst.Null();
break;
case (XmlHelper.Top):
c = DBTop.Top();
break;
case (XmlHelper.UnaryOp):
c = DBComparison.Not();
break;
case (XmlHelper.Compare):
c = DBComparison.Compare();
break;
case (XmlHelper.Between):
c = DBComparison.Between();
break;
case (XmlHelper.Parameter):
//parameter is a special case.
//we add them to akeyed colection if they are not already registered
//then at the end we set the values at the end
string name = reader.GetAttribute(XmlHelper.Name);
DBParam aparam;
if (context.Parameters.TryGetParameter(name, out aparam))
{
c = aparam;
}
else
{
aparam = DBParam.Param();
aparam.Name = name;
context.Parameters.Add(aparam);
c = aparam;
}
break;
case (XmlHelper.OrderBy):
c = DBOrder.OrderBy();
break;
case (XmlHelper.Calculation):
c = DBCalc.Calculate();
break;
case (XmlHelper.Aggregate):
c = DBAggregate.Aggregate();
break;
case (XmlHelper.ValueGroup):
c = DBValueGroup.Empty();
break;
case (XmlHelper.BooleanOperator):
c = DBBooleanOp.Compare();
break;
case (XmlHelper.Assign):
c = DBAssign.Assign();
break;
case (XmlHelper.InnerSelect):
c = DBSubQuery.SubSelect();
break;
case (XmlHelper.Multiple):
c = DBMultiComparisonRef.Many();
break;
case (XmlHelper.QueryOptionSet):
c = new DBQueryHintOptionSet();
break;
case (XmlHelper.QueryOption):
c = DBQueryHintOption.QueryOption();
break;
case (XmlHelper.CreateSproc):
c = DBCreateProcedureQuery.CreateProcedure();
break;
case (XmlHelper.Declare):
c = DBDeclaration.Declare();
break;
case (XmlHelper.CreateTable):
c = DBCreateTableQuery.Table();
break;
case (XmlHelper.ColumnDefinition):
c = DBColumn.Column();
break;
case (XmlHelper.PrimaryKey):
c = DBPrimaryKey.PrimaryKey();
break;
case (XmlHelper.ForeignKey):
c = DBForeignKey.ForeignKey();
break;
case (XmlHelper.CreateIndex):
c = DBCreateIndexQuery.Index();
break;
case (XmlHelper.CreateView):
c = DBCreateViewQuery.CreateView();
break;
case (XmlHelper.CreateSequence):
c = DBCreateSequenceQuery.Sequence();
break;
case (XmlHelper.DropTable):
c = DBDropTableQuery.DropTable();
break;
case (XmlHelper.DropIndex):
c = DBDropIndexQuery.DropIndex();
break;
case (XmlHelper.DropView):
c = DBDropViewQuery.DropView();
break;
case (XmlHelper.DropSproc):
c = DBDropProcedureQuery.DropProcedure();
break;
case (XmlHelper.DropSequence):
c = DBDropSequenceQuery.DropSequence();
break;
default:
throw XmlHelper.CreateException("The XML data could not be deserialized because the element {1} was not recognised. {0}", reader, null, element);
}
if (c != null)
{
c.ReadXml(reader, context);
}
return(c);
}
