public static Boolean InsertAttributeRecord(LogicalTree.Support_Classes.Attribute objAttribute)
{
bool insertSuccessful = false;
if (objAttribute == (LogicalTree.Support_Classes.Attribute)null)
{
return(insertSuccessful);
}
string insertString = "INSERT INTO dbo.tblAttribute (attribute_name) VALUES ('{0}')";
insertString = string.Format(insertString, objAttribute.Attribute_Name, objAttribute.Application_Name);
insertSuccessful = Data_Layer.InsertTypeRecord(insertString, Data_Layer.ltConnectionString);
return(insertSuccessful);
}
public static bool InsertAttributeDbTableFieldRecord(Attribute_Db_Table_Field objAttribute_Db_Table_Field)
{
bool insertSuccessful = false;
if (objAttribute_Db_Table_Field == (Attribute_Db_Table_Field)null)
{
return(insertSuccessful);
}
objAttribute_Db_Table_Field.Attribute_Db = "\'[" + objAttribute_Db_Table_Field.Attribute_Db + "]\'";
objAttribute_Db_Table_Field.Attribute_Table = "\'[" + "dbo" + "].[" + objAttribute_Db_Table_Field.Attribute_Table + "]\'";
objAttribute_Db_Table_Field.Attribute_Field_Id = "\'[" + objAttribute_Db_Table_Field.Attribute_Field_Id + "]\'";
string insertString = "INSERT INTO dbo.tblAttribute_Db_Table_Field (attribute_id, attribute_database, attribute_table, attribute_field_id, attribute_field_description, application_name) VALUES ({0}, {1}, {2}, {3}, '{4}', '{5}')";
insertString = string.Format(insertString, objAttribute_Db_Table_Field.Attribute_Id, objAttribute_Db_Table_Field.Attribute_Db, objAttribute_Db_Table_Field.Attribute_Table, objAttribute_Db_Table_Field.Attribute_Field_Id, objAttribute_Db_Table_Field.Attribute_Field_Desc, objAttribute_Db_Table_Field.Application_Name);
insertSuccessful = Data_Layer.InsertTypeRecord(insertString, Data_Layer.ltConnectionString);
return(insertSuccessful);
}
