public static bool UpdateAttributeDbTableFieldRecord(Attribute_Db_Table_Field objAttribute_Db_Table_Field)
{
bool updateSuccessful = false;
if (objAttribute_Db_Table_Field == null)
{
return(updateSuccessful);
}
if (objAttribute_Db_Table_Field.Attribute_Id == 0)
{
return(updateSuccessful);
}
if (string.IsNullOrEmpty(objAttribute_Db_Table_Field.Attribute_Db) || string.IsNullOrEmpty(objAttribute_Db_Table_Field.Attribute_Table) || string.IsNullOrEmpty(objAttribute_Db_Table_Field.Attribute_Field_Id) || string.IsNullOrEmpty(objAttribute_Db_Table_Field.Attribute_Field_Desc))
{
return(updateSuccessful);
}
string updateString = "UPDATE tblAttribute_Db_Table_Field SET attribute_id = {0}, attribute_database = '{1}', attribute_table = '{2}', attribute_field_id = '{3}', attribute_field_description = '{4}', attribute_main_table = '{5}' WHERE attribute_db_table_field_id = {6}";
updateString = string.Format(updateString, 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.Attribute_Main_Table, objAttribute_Db_Table_Field.Attribute_Db_Table_Field_Id);
updateSuccessful = Data_Layer.UpdateTypeRecord(updateString, Data_Layer.ltConnectionString);
return(updateSuccessful);
}
public static List <Attribute_Db_Table_Field_Value> GetAttributeDbTableFieldValueRecordList(Attribute_Db_Table_Field objAttribute_Db_Table_Field)
{
String selectString = null;
String insertString = null;
List <Attribute_Db_Table_Field_Value> lstAttributeDbTableFieldValue = null;
Attribute_Db_Table_Field_Value objAttributeDbTableFieldValue = null;
if (objAttribute_Db_Table_Field == null)
{
return(lstAttributeDbTableFieldValue);
}
lstAttributeDbTableFieldValue = new List <Attribute_Db_Table_Field_Value>();
selectString = "SELECT " + objAttribute_Db_Table_Field.Attribute_Field_Id + ", " + objAttribute_Db_Table_Field.Attribute_Field_Desc + " FROM " + objAttribute_Db_Table_Field.Attribute_Db + '.' + objAttribute_Db_Table_Field.Attribute_Table;
SqlConnection conn = new SqlConnection(Data_Layer.arcConnectionString);
SqlCommand comm = new SqlCommand(selectString, conn);
SqlDataReader rdr;
try
{
conn.Open();
rdr = comm.ExecuteReader();
while (rdr.Read())
{
objAttributeDbTableFieldValue = new Attribute_Db_Table_Field_Value();
objAttributeDbTableFieldValue.Attribute_Db_Table_Field_Value_Value = Convert.ToString(rdr["period_id"]);
objAttributeDbTableFieldValue.Attribute_Db_Table_Field_Id = objAttribute_Db_Table_Field.Attribute_Db_Table_Field_Id;
lstAttributeDbTableFieldValue.Add(objAttributeDbTableFieldValue);
}
for (int i = 0; i < lstAttributeDbTableFieldValue.Count; i++)
{
insertString = "INSERT INTO [LogicalTree].[dbo].[tblAttribute_Db_Table_Field_Value] (attribute_db_table_field_value, attribute_db_table_field_id) values ('{0}', {1})";
insertString = String.Format(insertString, lstAttributeDbTableFieldValue[i].Attribute_Db_Table_Field_Value_Value, lstAttributeDbTableFieldValue[i].Attribute_Db_Table_Field_Id);
Data_Layer.InsertTypeRecord(insertString, Data_Layer.ltConnectionString);
}
}
catch
{
lstAttributeDbTableFieldValue = null;
}
finally
{
conn.Close();
comm.Dispose();
}
return(lstAttributeDbTableFieldValue);
}
public static bool DeleteAttributeDbTableFieldRecord(Attribute_Db_Table_Field objAttribute_Db_Table_Field)
{
bool deleteSuccessful = false;
if (objAttribute_Db_Table_Field == (Attribute_Db_Table_Field)null)
{
return(deleteSuccessful);
}
string deleteStatement = string.Format("DELETE FROM tblAttribute_Db_Table_Field WHERE attribute_db_table_field_id = {0}", objAttribute_Db_Table_Field.Attribute_Db_Table_Field_Id.ToString());
deleteSuccessful = Data_Layer.DeleteTypeRecord(deleteStatement, Data_Layer.ltConnectionString);
return(deleteSuccessful);
}
public static Boolean InsertAttributeRecord(Support_Classes.Attribute objAttribute)
{
bool insertSuccessful = false;
if (objAttribute == (Support_Classes.Attribute)null)
{
return(insertSuccessful);
}
string insertString = "INSERT INTO dbo.tblAttribute (attribute_name) VALUES ('{0}')";
insertString = string.Format(insertString, objAttribute.Attribute_Name);
insertSuccessful = Data_Layer.InsertTypeRecord(insertString, Data_Layer.ltConnectionString);
return(insertSuccessful);
}
public static bool InsertAttributeDbTableFieldValueRecord(Attribute_Db_Table_Field_Value objAttribute_Db_Table_Field_Value)
{
bool insertSuccessful = false;
if (objAttribute_Db_Table_Field_Value == (Attribute_Db_Table_Field_Value)null)
{
return(insertSuccessful);
}
string insertString = "INSERT INTO dbo.tblAttribute_Db_Table_Field_Value (attribute_db_table_field_value, attribute_db_table_field_id) VALUES ('{0}', {1})";
insertString = string.Format(insertString, objAttribute_Db_Table_Field_Value.Attribute_Db_Table_Field_Value_Value, objAttribute_Db_Table_Field_Value.Attribute_Db_Table_Field_Id);
insertSuccessful = Data_Layer.InsertTypeRecord(insertString, Data_Layer.ltConnectionString);
return(insertSuccessful);
}
public static Boolean UpdateAttributeRecord(Support_Classes.Attribute objAttribute)
{
bool updateSuccessful = false;
if (objAttribute == null)
{
return(updateSuccessful);
}
if (string.IsNullOrEmpty(objAttribute.Attribute_Name))
{
return(updateSuccessful);
}
string updateString = "UPDATE tblAttribute SET attribute_name = '{0}' WHERE attribute_id = {1}";
updateString = string.Format(updateString, objAttribute.Attribute_Name, objAttribute.Attribute_Id);
updateSuccessful = Data_Layer.UpdateTypeRecord(updateString, Data_Layer.ltConnectionString);
return(updateSuccessful);
}
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 + "]\'";
objAttribute_Db_Table_Field.Attribute_Main_Table = "\'[" + "dbo" + "].[" + objAttribute_Db_Table_Field.Attribute_Main_Table + "]\'";
string insertString = "INSERT INTO dbo.tblAttribute_Db_Table_Field (attribute_id, attribute_database, attribute_table, attribute_field_id, attribute_field_description, attribute_main_table) 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.Attribute_Main_Table);
insertSuccessful = Data_Layer.InsertTypeRecord(insertString, Data_Layer.ltConnectionString);
return(insertSuccessful);
}
