private void setSurveyTemplate()
{
var tq = new TQueryBuilder(TQueryType._Create);
tq.TableName("cs_SurveyTemplate");
tq.AddField("SurveyTemplateID", true, true, FieldType._Number, false);
tq.AddField("Name", false, false, FieldType._String, false);
tq.AddField("Category", false, false, FieldType._String, false);
tq.AddField("Description", false, false, FieldType._Text, false);
tq.AddField("IntroductionNote", false, false, FieldType._Text, false);
tq.AddField("ThanksNote", false, false, FieldType._Text, false);
tq.AddField("PagesID", false, false, FieldType._String, false);
tq.AddField("LastUPD", false, false, FieldType._DateTime, false);
rd.ExecuteTQuery(tq);
}
protected bool UpdateEntityFieldType(ComponentAttribute attr)
{
Data.Component c = new Data.Component();
TQueryBuilder tq;
tq = new TQueryBuilder(TQueryType._AlterTableColumnDataType);
tq.TableName(this.TableName.Replace(" ", ""));
if (attr.InstanceID > 0)
{
tq.AddField(attr.Name, attr.IsKey, attr.IsUnique, base.getDataType(attr.FieldType), true, "");
c.ExecuteNonQuery(tq);
return(true);
}
else
{
return(true);
}
}
public bool ExecuteNonQuery(TQueryBuilder tq)
{
try
{
if (rd.ExecuteTQuery(tq).Result)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw new Exception("Unable to Create Entity", ex.InnerException);
}
}
protected bool AddEntityField(ComponentAttribute componentAttribute)
{
Data.Component c = new Data.Component();
TQueryBuilder tq;
tq = new TQueryBuilder(TQueryType._AlterColumnName);
tq.TableName(this.TableName.Replace(" ", ""));
if (componentAttribute.InstanceID > 0)
{
// tq.AddField(fd.Name, fd.IsKey, fd.IsUnique, fd.FieldType, true, "");
tq.AddField(componentAttribute.Name, componentAttribute.IsKey, componentAttribute.IsUnique, base.getDataType(componentAttribute.FieldType), true, "");
c.ExecuteNonQuery(tq);
return(true);
}
else
{
return(true);
}
}
private void setTemplateQuestion()
{
var tq = new TQueryBuilder(TQueryType._Create);
tq.TableName("cs_SurveyTemplate_Questions");
tq.AddField("SurveyTemplateID", true, true, FieldType._Number, false);
tq.AddField("QuestionID", true, true, FieldType._Number, false);
tq.AddField("QuestionName", false, false, FieldType._String, false);
tq.AddField("Description", false, false, FieldType._Text, false);
tq.AddField("QuestionType", false, false, FieldType._Number, false);
tq.AddField("Note", false, false, FieldType._Text, false);
tq.AddField("IsRequired", false, false, FieldType._Question, false);
tq.AddField("MaxLength", false, false, FieldType._Number, false);
tq.AddField("ValidationMessage", false, false, FieldType._Text, false);
tq.AddField("SelectionChoice", false, false, FieldType._String, false);
tq.AddField("PageNo", false, false, FieldType._Number, false);
tq.AddField("EnableComment", false, false, FieldType._Question, false);
tq.AddField("LastUPD", false, false, FieldType._DateTime, false);
rd.ExecuteTQuery(tq);
}
/// <summary>
///
/// </summary>
/// <param name="pClientID"></param>
/// <param name="pEntityFieldID"></param>
/// <param name="pEntityID"></param>
/// <param name="pFieldName"></param>
/// <param name="pFieldDescription"></param>
/// <param name="pFieldType"></param>
/// <param name="LookUpID"></param>
/// <param name="pIsRequired"></param>
/// <param name="pIsUnique"></param>
/// <param name="pIsKeyField"></param>
/// <param name="pEnableContentLimit"></param>
/// <param name="pContentLimit"></param>
/// <param name="pMin"></param>
/// <param name="pMax"></param>
/// <param name="pFileExtension"></param>
/// <param name="pIsCore"></param>
/// <param name="pIsEditable"></param>
/// <param name="pEnableEncription"></param>
/// <param name="pAcceptNull"></param>
/// <param name="pDisplayName"></param>
/// <param name="value"></param>
/// <param name="isReadonly"></param>
/// <param name="defaultValue"></param>
/// <param name="displayorder"></param>
/// <param name="pmaxLength"></param>
/// <param name="displayName"></param>
/// <param name="autoIncrement"></param>
/// <param name="incrementfrom"></param>
/// <param name="incrementby"></param>
/// <returns></returns>
internal protected bool AddField(int pClientID, int pEntityFieldID, Int32 pEntityID, string pFieldName, string pFieldDescription, EntityFieldType pFieldType,
int LookUpID, bool pIsRequired, bool pIsUnique, bool pIsKeyField,
bool pEnableContentLimit, string pMin, string pMax, string pFileExtension,
bool pIsCore, bool pIsEditable, bool pEnableEncription, bool pAcceptNull, string pDisplayName, string value, bool isReadonly,
string defaultValue, int displayorder, int pmaxLength, string displayName, bool autoIncrement,
int incrementfrom, int incrementby)
{
TQueryBuilder tq;
EntityField fd = new EntityField(pFieldName, pEntityFieldID, pFieldType, pIsKeyField, pIsRequired, pIsUnique, LookUpID, pIsCore, pEntityID, value, isReadonly,
defaultValue, displayorder, new List <string>(), pMin, pMax, pmaxLength, displayName, autoIncrement, incrementfrom, incrementby,
Description, pEnableEncription, pEnableContentLimit);
fd.InstanceID = pEntityFieldID;
if (pEntityFieldID <= 0)
{
tq = new TQueryBuilder(TQueryType._AlterTable);
tq.TableName(this.TableName.Replace(" ", ""));
if (fd.SaveField())
{
if (fd.InstanceID > 0)
{
tq.AddField(fd.Name, fd.IsKey, fd.IsUnique, getDataType(fd.FieldType), true, "");
dataEntity.ExecuteNonQuery(tq);
}
return(true);
}
else
{
return(false);
}
}
else
{
return(true);
}
}
/// <summary>
/// Save Entity
/// </summary>
/// <returns></returns>
internal protected Services.ErrorHandling.ErrorInfoCollection Save()
{
SetDefault();
if (this.TableName == "")
{
Errors.Add("Table Name not generated.Contact system admin", Services.ErrorHandling.ErrorInfo.ErrorType._critical);
return(Errors);
}
else if (this.EntityInstances.Count == 0)
{
Errors.Add("Unable to generate table because field count is zero contact system admin", Services.ErrorHandling.ErrorInfo.ErrorType._critical);
return(Errors);
}
TQueryBuilder tq;
if (this.EntityKey > 0)
{
if (!dataEntity.CheckEntityExist(this.TableName, this.EntityKey))
{
EntitySchema en = new EntitySchema(this.EntityKey);
if (dataEntity.Update(-1, this.EntityKey, this.TableName, this.Name, this.Description, string.Join(",", this.PrimaryKeys.ToArray()), this.EntityType))
{
Errors.Add(ModuleName + "updated successfully", Services.ErrorHandling.ErrorInfo.ErrorType._noerror);
tq = new TQueryBuilder(TQueryType._AddPrimarykey);
if (this.EntityKey > 0)
{
tq.TableName(this.TableName.Replace(" ", ""));
foreach (EntityField fd in this.EntityInstances)
{
if (fd.IsKey == true)
{
tq.AddField(fd.Name, fd.IsKey, fd.IsUnique, getDataType(fd.FieldType), true, "");
}
}
dataEntity.ExecuteNonQuery(tq);
}
}
else
{
Errors.Add("Unable to update " + ModuleName, Services.ErrorHandling.ErrorInfo.ErrorType._critical);
}
}
else
{
Errors.Add("table already exist", Services.ErrorHandling.ErrorInfo.ErrorType._critical);
}
//Write code here to update dataschema when updating tabl name,primarykeysss
}
else
{
if (!dataEntity.CheckEntityExist(this.TableName, -1))
{
this.EntityKey = dataEntity.Save(-1, this.TableName, this.Name, this.Description, string.Join(",", this.PrimaryKeys.ToArray()), this.EntityType);
tq = new TQueryBuilder(TQueryType._Create);
if (this.EntityKey > 0)
{
tq.TableName(this.TableName.Replace(" ", ""));
foreach (EntityField fd in this.EntityInstances)
{
tq.AddField(fd.Name, fd.IsKey, fd.IsUnique, getDataType(fd.FieldType), true, "");
}
dataEntity.ExecuteNonQuery(tq);
}
}
else
{
Errors.Add("table already exist", Services.ErrorHandling.ErrorInfo.ErrorType._critical);
}
}
return(Errors);
}
