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