public static List <LogicalTreeData> GenerateAndExecuteQuery(Attribute_Db_Table_Field objAttribute_Db_Table_Field) { List <LogicalTreeData> lstLogicalTreeData = null; lstLogicalTreeData = Attribute_Db_Table_Field_DL.GenerateAndExecuteQuery(objAttribute_Db_Table_Field); return(lstLogicalTreeData); }
public static bool UpdateAttributeDbTableField(Attribute_Db_Table_Field objAttribute_Db_Table_Field) { bool updateSuccessful = false; updateSuccessful = Attribute_Db_Table_Field_DL.UpdateAttributeDbTableFieldRecord(objAttribute_Db_Table_Field); return(updateSuccessful); }
public static bool InsertAttributeDbTableField(Attribute_Db_Table_Field objAttribute_Db_Table_Field) { bool insertSuccessful = false; insertSuccessful = Attribute_Db_Table_Field_DL.InsertAttributeDbTableFieldRecord(objAttribute_Db_Table_Field); return(insertSuccessful); }
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); }
private void SetComboBoxes() { objAttribute_Db_Table_Field = BusinessLayer <Attribute_Db_Table_Field> .ReturnCurrentTypeObject(bnsAttribute_Db_Table_Field); this.BindCmbAttribute(); Support_Classes.Attribute tmpAttribute = Attribute_BL.GetAttribute(objAttribute_Db_Table_Field.Attribute_Id); idx = cmbAttribute.FindString(tmpAttribute.Attribute_Name); cmbAttribute.SelectedIndex = idx; this.BindCmbDatabases(); String dbObject = Business_Layer.BusinessLayer <Attribute_Db_Table_Field> .TrimDatabaseObjectDelimiters(objAttribute_Db_Table_Field.Attribute_Db); idx = cmbDatabases.FindString(dbObject); cmbDatabases.SelectedIndex = idx; this.BindCmbTables(); dbObject = Business_Layer.BusinessLayer <Attribute_Db_Table_Field> .TrimDatabaseObjectDelimiters(objAttribute_Db_Table_Field.Attribute_Table); idx = cmbTables.FindString(dbObject); cmbTables.SelectedIndex = idx; return; }
public static bool DeleteAttributeDbTableField(Attribute_Db_Table_Field objAttribute_Db_Table_Field) { bool deleteSuccessful = false; deleteSuccessful = Attribute_Db_Table_Field_DL.DeleteAttributeDbTableFieldRecord(objAttribute_Db_Table_Field); return(deleteSuccessful); }
void ComboBox_SelectedValueChanged(object sender, EventArgs e) { // int idx = Convert.ToInt32(m_CurrentNode.m_ComboBox.SelectedValue); // List<Attribute_Db_Table_Field> lstAttribute_Db_Table_Field = Attribute_Db_Table_Field_BL.GetAttributeDbTableFieldList(); // Attribute_Db_Table_Field objAttribute_Db_Table_Field = Attribute_Db_Table_Field_BL.GetAttributeDbTableFieldObjectGivenId(idx, lstAttribute_Db_Table_Field); // List<LogicalTreeData> lstLogicalTreeData = Attribute_Db_Table_Field_BL.GenerateAndExecuteQuery(objAttribute_Db_Table_Field); //// this.SelectedNode = m_CurrentNode; // foreach (LogicalTreeData i in lstLogicalTreeData) // { // switch (m_CurrentNode.NodeType) // { // case NodeType.RootNode: // LogicalTreeNode n = new LogicalTreeNode(i.Desc); // n.NodeType = NodeType.PassThroughNode; // this.m_CurrentNode.Nodes.Add(n); // break; // case NodeType.PassThroughNode: // break; // case NodeType.TerminalNode: // break; // } // } int idx = Convert.ToInt32(m_CurrentNode.m_ComboBox.SelectedValue); // List<Attribute_Db_Table_Field> lstAttribute_Db_Table_Field = Attribute_Db_Table_Field_BL.GetAttributeDbTableFieldList(); Attribute_Db_Table_Field objAttribute_Db_Table_Field = Attribute_Db_Table_Field_BL.GetAttributeDbTableFieldObjectGivenId(idx, lstAttribute_Db_Table_Field); List <LogicalTreeData> lstLogicalTreeData = Attribute_Db_Table_Field_BL.GenerateAndExecuteQuery(objAttribute_Db_Table_Field); // mch. 01.04.2018. commented out line below. // this.SelectedNode = m_CurrentNode; // mch. This is, I think, where I am having problems with creating child node for root node. // mch. I think what i need to do here is create the ... // n.Nodes.Add() foreach (LogicalTreeData i in lstLogicalTreeData) { switch (m_CurrentNode.NodeType) { case NodeType.RootNode: LogicalTreeNode c = new LogicalTreeNode(i.Desc); c.NodeType = NodeType.PassThroughNode; // mch. 01.04.2018. changed from m_CurrentNode to n this.n.Nodes.Add(c); break; case NodeType.PassThroughNode: break; case NodeType.TerminalNode: break; } } HideComboBox(); }
public static String ConstructQueryString(Attribute_Db_Table_Field obj) { String selectString = null; if (obj == null) { return(selectString); } selectString = "SELECT DISTINCT " + "i." + obj.Attribute_Field_Id + ", " + "i." + obj.Attribute_Field_Desc + " FROM " + obj.Attribute_Db + ".[dbo].[tblCoins] c "; selectString = selectString + "INNER JOIN " + obj.Attribute_Db + "." + obj.Attribute_Table + " i ON c.issuing_authority_id = i." + obj.Attribute_Field_Id; return(selectString); }
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 List <LogicalTreeData> GenerateAndExecuteQuery(Attribute_Db_Table_Field objAttribute_Db_Table_Field) { List <LogicalTreeData> lstLogicalTreeData = null; if (objAttribute_Db_Table_Field == null) { return(lstLogicalTreeData); } String selectString = "SELECT DISTINCT " + "i.seq_no, i." + objAttribute_Db_Table_Field.Attribute_Field_Id + ", " + "i." + objAttribute_Db_Table_Field.Attribute_Field_Desc + " FROM " + objAttribute_Db_Table_Field.Attribute_Db + ".[dbo].[tblCoins] c "; selectString = selectString + "INNER JOIN " + objAttribute_Db_Table_Field.Attribute_Db + "." + objAttribute_Db_Table_Field.Attribute_Table + " i ON c." + objAttribute_Db_Table_Field.Attribute_Field_Id + " = i." + objAttribute_Db_Table_Field.Attribute_Field_Id + " ORDER BY SEQ_NO"; SqlConnection conn = new SqlConnection(Data_Layer.arcConnectionString); SqlCommand comm = new SqlCommand(selectString, conn); SqlDataReader rdr; LogicalTreeData objLogicalTreeData = null; lstLogicalTreeData = new List <LogicalTreeData>(); try { conn.Open(); rdr = comm.ExecuteReader(); while (rdr.Read()) { objLogicalTreeData = new LogicalTreeData(); objLogicalTreeData.Id = Convert.ToInt32(rdr["issuing_authority_id"]); objLogicalTreeData.Desc = Convert.ToString(rdr["issuing_authority_name"]); lstLogicalTreeData.Add(objLogicalTreeData); } } catch { lstLogicalTreeData = null; } finally { conn.Close(); comm.Dispose(); } return(lstLogicalTreeData); }
public static List <Attribute_Db_Table_Field> GetAttributeDbTableFieldRecordList() { List <Attribute_Db_Table_Field> lstAttribute_Db_Table_Field = (List <Attribute_Db_Table_Field>)null; string selectString = "SELECT attribute_db_table_field_id, attribute_id, attribute_database, attribute_table, attribute_field_id, attribute_field_description, attribute_main_table FROM dbo.tblAttribute_Db_Table_Field"; Attribute_Db_Table_Field objAttribute_Db_Table_Field; lstAttribute_Db_Table_Field = new List <Attribute_Db_Table_Field>(); SqlConnection conn = new SqlConnection(Data_Layer.ltConnectionString); SqlCommand comm = new SqlCommand(selectString, conn); SqlDataReader rdr; try { conn.Open(); rdr = comm.ExecuteReader(); while (rdr.Read()) { objAttribute_Db_Table_Field = new Attribute_Db_Table_Field(); objAttribute_Db_Table_Field.Attribute_Db_Table_Field_Id = Convert.ToInt32(rdr["attribute_db_table_field_id"]); objAttribute_Db_Table_Field.Attribute_Id = Convert.ToInt32(rdr["attribute_id"]); objAttribute_Db_Table_Field.Attribute_Db = Convert.ToString(rdr["attribute_database"]); objAttribute_Db_Table_Field.Attribute_Table = Convert.ToString(rdr["attribute_table"]); objAttribute_Db_Table_Field.Attribute_Field_Id = Convert.ToString(rdr["attribute_field_id"]); objAttribute_Db_Table_Field.Attribute_Field_Desc = Convert.ToString(rdr["attribute_field_description"]); objAttribute_Db_Table_Field.Attribute_Main_Table = Convert.ToString(rdr["attribute_main_table"]); lstAttribute_Db_Table_Field.Add(objAttribute_Db_Table_Field); } } catch (Exception ex) { lstAttribute_Db_Table_Field = (List <Attribute_Db_Table_Field>)null; } finally { conn.Close(); conn.Dispose(); comm.Dispose(); } return(lstAttribute_Db_Table_Field); }
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); }
private void btnsave_Click(object sender, EventArgs e) { switch (BusinessLayer <Attribute_Db_Table_Field> .recordSaveType) { case BusinessLayer <Attribute_Db_Table_Field> .ObjectSaveType.InsertObject: objAttribute_Db_Table_Field.Attribute_Id = (int)cmbAttribute.SelectedValue; // The volume id has not been set. This is where it gets assigned. objAttribute_Db_Table_Field.Attribute_Db = (string)cmbDatabases.SelectedItem; objAttribute_Db_Table_Field.Attribute_Table = (string)cmbTables.SelectedItem; objAttribute_Db_Table_Field.Attribute_Field_Id = (String)cmbFieldIds.SelectedItem; objAttribute_Db_Table_Field.Attribute_Field_Desc = (String)cmbFieldDescs.SelectedItem; Attribute_Db_Table_Field_BL.InsertAttributeDbTableField(objAttribute_Db_Table_Field); break; case BusinessLayer <Attribute_Db_Table_Field> .ObjectSaveType.UpdateObject: objAttribute_Db_Table_Field = (Attribute_Db_Table_Field)bnsAttribute_Db_Table_Field.Current; Attribute_Db_Table_Field_BL.UpdateAttributeDbTableField(objAttribute_Db_Table_Field); break; } lstAttribute_Db_Table_Field = Attribute_Db_Table_Field_BL.GetAttributeDbTableFieldList(); bnsAttribute_Db_Table_Field.DataSource = lstAttribute_Db_Table_Field; bnvAttributeDatabaseTableField.BindingSource = bnsAttribute_Db_Table_Field; }
public static Attribute_Db_Table_Field GetAttributeDbTableFieldObjectGivenId(int id, List <Attribute_Db_Table_Field> lst) { Attribute_Db_Table_Field objAttribute_Db_Table_Field = null; if (lst == null) { return(objAttribute_Db_Table_Field); } objAttribute_Db_Table_Field = new Attribute_Db_Table_Field(); var obj = (from i in lst where i.Attribute_Id == id select i).ToList(); objAttribute_Db_Table_Field.Attribute_Id = obj[0].Attribute_Id; objAttribute_Db_Table_Field.Attribute_Db_Table_Field_Id = obj[0].Attribute_Db_Table_Field_Id; objAttribute_Db_Table_Field.Attribute_Db = obj[0].Attribute_Db; objAttribute_Db_Table_Field.Attribute_Table = obj[0].Attribute_Table; objAttribute_Db_Table_Field.Attribute_Field_Desc = obj[0].Attribute_Field_Desc; objAttribute_Db_Table_Field.Attribute_Field_Id = obj[0].Attribute_Field_Id; return(objAttribute_Db_Table_Field); }
private void bindingNavigatorAddNewItem_Click(object sender, EventArgs e) { BusinessLayer <Attribute_Db_Table_Field> .recordSaveType = BusinessLayer <Attribute_Db_Table_Field> .ObjectSaveType.InsertObject; objAttribute_Db_Table_Field = (Attribute_Db_Table_Field)bnsAttribute_Db_Table_Field.Current; }
public static List <Attribute_Db_Table_Field_Value> GetAttributeDbTableFieldValueList(Attribute_Db_Table_Field objAttribute_Db_Table_Field) { List <Attribute_Db_Table_Field_Value> lstAttribute_Db_Table_Field_Value = null; lstAttribute_Db_Table_Field_Value = Data_Layer.Attribute_Db_Table_Field_Value_DL.GetAttributeDbTableFieldValueRecordList(objAttribute_Db_Table_Field); return(lstAttribute_Db_Table_Field_Value); }
private void bindingNavigatorMoveFirstItem_Click(object sender, EventArgs e) { BusinessLayer <Attribute_Db_Table_Field> .recordSaveType = BusinessLayer <Attribute_Db_Table_Field> .ObjectSaveType.UpdateObject; objAttribute_Db_Table_Field = (Attribute_Db_Table_Field)bnsAttribute_Db_Table_Field.Current; this.SetComboBoxes(); }
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); }
private void bindingNavigatorDeleteItem_Click(object sender, EventArgs e) { BusinessLayer <Attribute_Db_Table_Field> .recordSaveType = BusinessLayer <Attribute_Db_Table_Field> .ObjectSaveType.UpdateObject; Attribute_Db_Table_Field_BL.DeleteAttributeDbTableField(objAttribute_Db_Table_Field); objAttribute_Db_Table_Field = (Attribute_Db_Table_Field)bnsAttribute_Db_Table_Field.Current; }