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 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 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); }