public void HienThiTreeviewJobShare()
{
string UserID = (string)Session["UserID"].ToString();
//string UserID = "27276";
string UserShare = DropDownUserName.SelectedValue;
string CongTy = "LTY";
RadTreeNode roott = new RadTreeNode("Job Share");
RadTreeView2.Nodes.Add(roott);
DataTable dt = dalProjects.LayDanhSachTheoAuditor_TreeView(UserShare, UserID, CongTy);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
string jobID = dr["jobid"].ToString();
string jobName = dr["jobname"].ToString();
RadTreeNode childNode = new RadTreeNode("");
childNode.Value = jobID;
childNode.Text = jobName;
roott.Nodes.Add(childNode);
roott.ExpandChildNodes();
}
}
RadTreeView2.ExpandAllNodes();
}
public void Initialize()
{
var categories = _categoryService.GetAll();
var nodes = RecursivelySetTreeNode(categories, null);
var rootNode = new RadTreeNode("Root", "-1");
rootNode.Nodes.AddRange(nodes);
rootNode.ExpandChildNodes();
_categoryListingView.Categories.Nodes.Add(rootNode);
_categoryListingView.Categories.ExpandAllNodes();
_categoryListingView.Categories.DataBind();
}
protected void RefreshCommandsView()
{
Hashtable State = (Hashtable)HttpRuntime.Cache[Session.SessionID];
ArrayList DBCommands = (ArrayList)State["DBCommands"];
RadTreeNode DatabaseCommandRoot = CreateSpreadsheetRootNode();
if (DBCommands == null)
return;
//re add the previous controls
int command_index = 0;
Hashtable prev_CommandEntry = null;
foreach (Hashtable CommandEntry in DBCommands)
{
int sub_command_index = 0;
RadTreeNode command_node = new RadTreeNode();
command_node.CssClass = "RadTreeView";
command_node.Category = "command";
command_node.PostBack = false;
string orig_command = CommandEntry["command"].ToString();
string command = orig_command.ToLower();
State["SelectedSqlCommand"] = command;
Control CommandControl = null;
string selected_table = null;
if (CommandEntry["table"] != null && CommandEntry["table"].ToString().Length > 0)
{
State["SelectedDatabaseTable"] = selected_table = CommandEntry["table"].ToString();
DataSources DS = new DataSources();
State["DataSourceDatabaseTableFields"] = DS.GetDataSourceDatabaseTableFields(State);
if (State["DataSourceDatabaseTableFields"] == null)
{
ResetDatabaseConfig_Click(null, null);
Message.Text = "Internal Error: All commands have been cleared.";
State["SpreadsheetError"] = null;
State["DBCommands"] = null;
State["SelectedDatabaseTable"] = null;
State["SelectedSqlCommand"] = null;
return ;
}
}
if (command == "if")
{
CommandControl = LoadControl("Controls/IfDeviceFieldThenDoCommand.ascx");
}
else if(command.EndsWith("go to page"))
{
string selected_page = null;
if (CommandEntry["page"] != null && CommandEntry["page"].ToString().Length > 0)
{
State["SelectedGoToPage"] = selected_page = CommandEntry["page"].ToString();
}
CommandControl = LoadControl("Controls/GoToPage.ascx", selected_page);
if (command.StartsWith("then "))
{
command = command.Remove(0, 5);
((RadComboBox)CommandControl.FindControl("command")).SelectedValue = command;
((Label)CommandControl.FindControl("command_prefix")).Text = "Then ";
}
else if (command.StartsWith("else "))
{
command = command.Remove(0, 5);
((RadComboBox)CommandControl.FindControl("command")).SelectedValue = command;
((Label)CommandControl.FindControl("command_prefix")).Text = "Else ";
}
else
((RadComboBox)CommandControl.FindControl("command")).SelectedValue = command;
}
else
{
CommandControl = LoadControl("Controls/DatabaseCommand.ascx", selected_table);
if (command.StartsWith("then "))
{
command = command.Remove(0, 5);
((RadComboBox)CommandControl.FindControl("command")).SelectedValue = command;
((Label)CommandControl.FindControl("command_prefix")).Text = "Then ";
}
else if (command.StartsWith("else "))
{
command = command.Remove(0, 5);
((RadComboBox)CommandControl.FindControl("command")).SelectedValue = command;
((Label)CommandControl.FindControl("command_prefix")).Text = "Else ";
}
else
((RadComboBox)CommandControl.FindControl("command")).SelectedValue = command;
}
prev_CommandEntry = CommandEntry;
command_node.Controls.Add(CommandControl);
DatabaseCommandRoot.Nodes.Add(command_node);
string field_control_type = null;
if (command == "if")
{
if (CommandEntry["command_condition_device_field1"] != null && CommandEntry["command_condition_device_field1"].ToString().Length > 0)
{
string command_condition_device_field1 = CommandEntry["command_condition_device_field1"].ToString();
((HtmlInputText)CommandControl.FindControl("command_condition_device_field1")).Value = command_condition_device_field1;
}
else
{
CommandEntry["command_condition_device_field1"] = ((HtmlInputText)CommandControl.FindControl("command_condition_device_field1")).Value;
}
if (CommandEntry["command_condition_operation"] != null && CommandEntry["command_condition_operation"].ToString().Length > 0)
{
string command_condition_operation = CommandEntry["command_condition_operation"].ToString();
((RadComboBox)CommandControl.FindControl("command_condition_operation")).SelectedValue = command_condition_operation;
}
else
{
CommandEntry["command_condition_operation"] = ((RadComboBox)CommandControl.FindControl("command_condition_operation")).SelectedValue;
}
if (CommandEntry["command_condition_device_field2"] != null && CommandEntry["command_condition_device_field2"].ToString().Length > 0)
{
string command_condition_device_field2 = CommandEntry["command_condition_device_field2"].ToString();
HtmlInputText command_condition_device_field2_input = ((HtmlInputText)CommandControl.FindControl("command_condition_device_field2"));
command_condition_device_field2_input.Value = command_condition_device_field2;
}
else
{
CommandEntry["command_condition_device_field2"] = ((HtmlInputText)CommandControl.FindControl("command_condition_device_field2")).Value;
}
continue;
}
else if (command == "insert into")
{
((ImageButton)CommandControl.FindControl("add_condition")).Visible = false;
((ImageButton)CommandControl.FindControl("add_order_by")).Visible = false;
field_control_type = "from_phone_to_database";
}
else if (command == "update")
{
((ImageButton)CommandControl.FindControl("add_order_by")).Visible = false;
field_control_type = "from_phone_to_database";
}
else if (command == "select from")
{
field_control_type = "from_database_to_phone";
}
else if (command == "delete from")
{
((ImageButton)CommandControl.FindControl("add_field")).Visible = false;
((ImageButton)CommandControl.FindControl("add_order_by")).Visible = false;
}
ArrayList DBFields = (ArrayList)CommandEntry["database_fields"];
if (DBFields != null && field_control_type != null)
{
foreach (Hashtable FieldEntry in DBFields)
{
RadTreeNode field_node = new RadTreeNode();
field_node.CssClass = "RadTreeView";
field_node.Category = "field";
field_node.PostBack = false;
State["SelectedDatabaseTable"] = selected_table;
string control_file = (field_control_type == "from_database_to_phone") ? "DatabaseToDeviceField.ascx" : "DeviceToDatabaseField.ascx";
string selected_database_field = null;
if (FieldEntry["database_field"] != null && FieldEntry["database_field"].ToString().Length > 0)
{
selected_database_field = FieldEntry["database_field"].ToString();
}
else
{
ArrayList DataSourceDatabaseTableFields = (ArrayList)State["DataSourceDatabaseTableFields"];
selected_database_field = DataSourceDatabaseTableFields[0].ToString();
}
Control FieldControl = LoadControl("Controls/" + control_file, selected_database_field);
if (State["SpreadsheetError"] != null)
{
ResetDatabaseConfig_Click(null, null);
Message.Text = State["SpreadsheetError"].ToString();
State["SpreadsheetError"] = null;
State["DBCommands"] = null;
State["SelectedDatabaseTable"] = null;
State["SelectedSqlCommand"] = null;
return;
}
field_node.Controls.Add(FieldControl);
command_node.Nodes.Add(field_node);
if (FieldEntry["device_field"] != null && FieldEntry["device_field"].ToString().Length > 0)
{
string phone_field = FieldEntry["device_field"].ToString();
HtmlInputText phone_field_input = (HtmlInputText)FieldControl.FindControl("device_field");
phone_field_input.Value = phone_field;
}
sub_command_index++;
}
}
ArrayList DBWhere = (ArrayList)CommandEntry["conditions"];
if (DBWhere != null)
{
int i_condition = 0;
// Hashtable uniqueConditionIDs = new Hashtable();
foreach (Hashtable ConditionEntry in DBWhere)
{
if (i_condition == 0)
State["IsFirstCommandCondition"] = true;
else
State["IsFirstCommandCondition"] = false;
RadTreeNode where_node = new RadTreeNode();
where_node.CssClass = "RadTreeView";
where_node.Category = "condition";
where_node.PostBack = false;
State["SelectedDatabaseTable"] = selected_table;
string selected_condition_1st_field = null;
if (ConditionEntry["condition_1st_field"] != null && ConditionEntry["condition_1st_field"].ToString().Length > 0)
{
selected_condition_1st_field = ConditionEntry["condition_1st_field"].ToString();
}
else
{
ArrayList DataSourceDatabaseTableFields = (ArrayList)State["DataSourceDatabaseTableFields"];
selected_condition_1st_field = DataSourceDatabaseTableFields[0].ToString();
}
Control WhereControl = LoadControl("Controls/SpreadsheetWhere.ascx", selected_condition_1st_field);
if (State["SpreadsheetError"] != null)
{
ResetDatabaseConfig_Click(null, null);
Message.Text = State["SpreadsheetError"].ToString();
State["SpreadsheetError"] = null;
State["DBCommands"] = null;
State["SelectedDatabaseTable"] = null;
State["SelectedSqlCommand"] = null;
return;
}
where_node.Controls.Add(WhereControl);
command_node.Nodes.Add(where_node);
if (ConditionEntry["condition_operation"] != null && ConditionEntry["condition_operation"].ToString().Length > 0)
{
string condition_operation = ConditionEntry["condition_operation"].ToString();
((RadComboBox)WhereControl.FindControl("condition_operation")).SelectedValue = condition_operation;
}
else
{
ConditionEntry["condition_operation"] = ((RadComboBox)WhereControl.FindControl("condition_operation")).SelectedValue;
}
if (ConditionEntry["field_operation"] != null && ConditionEntry["field_operation"].ToString().Length > 0)
{
string field_operation = ConditionEntry["field_operation"].ToString();
((RadComboBox)WhereControl.FindControl("field_operation")).SelectedValue = field_operation;
}
else
{
ConditionEntry["field_operation"] = ((RadComboBox)WhereControl.FindControl("field_operation")).SelectedValue;
}
if (ConditionEntry["condition_2nd_field"] != null && ConditionEntry["condition_2nd_field"].ToString().Length > 0)
{
string condition_2nd_field = ConditionEntry["condition_2nd_field"].ToString();
HtmlInputText condition_2nd_field_input = (HtmlInputText)WhereControl.FindControl("condition_2nd_field");
condition_2nd_field_input.Value = condition_2nd_field;
}
i_condition++;
sub_command_index++;
}
}
Hashtable DBOrderBy = (Hashtable)CommandEntry["order_by"];
if (DBOrderBy != null)
{
RadTreeNode orderBy_node = new RadTreeNode();
orderBy_node.CssClass = "RadTreeView";
orderBy_node.Category = "order_by";
orderBy_node.PostBack = false;
State["SelectedDatabaseTable"] = selected_table;
string selected_sort_field = null;
if (DBOrderBy["sort_field"] != null && DBOrderBy["sort_field"].ToString().Length > 0)
{
selected_sort_field = DBOrderBy["sort_field"].ToString();
}
else
{
ArrayList DataSourceDatabaseTableFields = (ArrayList)State["DataSourceDatabaseTableFields"];
selected_sort_field = DataSourceDatabaseTableFields[0].ToString();
}
Control OrderByControl = LoadControl("Controls/DatabaseOrderBy.ascx", selected_sort_field);
if (State["SpreadsheetError"] != null)
{
ResetDatabaseConfig_Click(null, null);
Message.Text = State["SpreadsheetError"].ToString();
State["SpreadsheetError"] = null;
State["DBCommands"] = null;
State["SelectedDatabaseTable"] = null;
State["SelectedSqlCommand"] = null;
return;
}
orderBy_node.Controls.Add(OrderByControl);
command_node.Nodes.Add(orderBy_node);
if (DBOrderBy["sort_direction"] != null && DBOrderBy["sort_direction"].ToString().Length > 0)
{
string sort_direction = DBOrderBy["sort_direction"].ToString();
((RadComboBox)OrderByControl.FindControl("sort_direction")).SelectedValue = sort_direction;
}
sub_command_index++;
}
command_node.ExpandChildNodes();
command_index++;
}
SpreadsheetCommandsView.ExpandAllNodes();
}
public void AjaxManager1_AjaxRequest(object sender, AjaxRequestEventArgs e)
{
string[] args = e.Argument.Replace("\r\n", "\n").Split('\n');
RadTreeView srcTree = null;
RadTreeView dstTree = null;
if (TreeResources.ClientID.Equals(args[0]))
{
srcTree = TreeResources;
}
else if (TreeResources.ClientID.Equals(args[0]))
{
srcTree = TreeResources;
}
if (TreeResources.ClientID.Equals(args[1]))
{
dstTree = TreeResources;
}
else if (TreeResources.ClientID.Equals(args[1]))
{
dstTree = TreeResources;
}
RadTreeNode sourceNode = srcTree.FindNodeByText(args[2]);
RadTreeNode destNode = dstTree.FindNodeByText(args[3]);
//if (sourceNode.Parent == null)
//{
// RadAjaxManager1.Alert("گره اصلی قابل حذف نیست");
// return;
//}
RadTreeNode tempNode = destNode;
while (tempNode != null)
{
if (!tempNode.Equals(sourceNode))
{
tempNode = tempNode.ParentNode;
}
else
{
break;
}
}
if (tempNode != null)
{
//RadAjaxManager1.Alert("نمیتوان یک گره را به فرزندانش منتقل کرد");
return;
}
BOLResources ResourcesBOl = new BOLResources();
ResourcesBOl.Code = Convert.ToInt32(sourceNode.Value);
ResourcesBOl.MasterCode = Convert.ToInt32(destNode.Value);
ResourcesBOl.Name = sourceNode.Text;
ResourcesBOl.SaveChanges(false);
RadTreeNode newNode = new RadTreeNode(sourceNode.Text, sourceNode.Value);
AddChilds(newNode, sourceNode);
destNode.Nodes.Add(newNode);
destNode.ExpandChildNodes();
if (!sourceNode.Equals(srcTree.Nodes[0]))
{
sourceNode.Remove();
}
}
protected void RefreshCommandsView()
{
Hashtable State = (Hashtable)HttpRuntime.Cache[Session.SessionID];
ArrayList DBCommands = (ArrayList)State["DBCommands"];
if (DBCommands == null)
return;
RadTreeNode DatabaseCommandRoot = CreateDatabaseRootNode(DatabaseEvents.SelectedValue);
//re add the previous controls
int command_index = 0;
Hashtable prev_CommandEntry = null;
foreach (Hashtable CommandEntry in DBCommands)
{
int sub_command_index = 0;
RadTreeNode command_node = new RadTreeNode();
command_node.CssClass = "RadTreeView";
command_node.Category = "command";
command_node.PostBack = false;
string orig_command = CommandEntry["command"].ToString();
string command = orig_command.ToLower();
State["SelectedSqlCommand"] = command;
Control CommandControl = null;
if (command == "if")
{
CommandControl = LoadControl("Controls/IfDeviceFieldThenDoCommand.ascx");
}
else
{
CommandControl = LoadControl("Controls/DatabaseCommand.ascx");
if (command.StartsWith("then "))
{
command = command.Remove(0, 5);
((RadComboBox)CommandControl.FindControl("command")).SelectedValue = command;
((Label)CommandControl.FindControl("command_prefix")).Text = "Then ";
}
else if (command.StartsWith("else "))
{
command = command.Remove(0, 5);
((RadComboBox)CommandControl.FindControl("command")).SelectedValue = command;
((Label)CommandControl.FindControl("command_prefix")).Text = "Else ";
}
else
((RadComboBox)CommandControl.FindControl("command")).SelectedValue = command;
}
prev_CommandEntry = CommandEntry;
command_node.Controls.Add(CommandControl);
DatabaseCommandRoot.Nodes.Add(command_node);
string field_control_type = null;
if (command == "if")
{
if (CommandEntry["command_condition_device_field1"] != null && CommandEntry["command_condition_device_field1"].ToString().Length > 0)
{
string command_condition_device_field1 = CommandEntry["command_condition_device_field1"].ToString();
((RadComboBox)CommandControl.FindControl("command_condition_device_field1")).SelectedValue = command_condition_device_field1;
}
else
{
CommandEntry["command_condition_device_field1"] = ((RadComboBox)CommandControl.FindControl("command_condition_device_field1")).SelectedValue;
}
if (CommandEntry["command_condition_operation"] != null && CommandEntry["command_condition_operation"].ToString().Length > 0)
{
string command_condition_operation = CommandEntry["command_condition_operation"].ToString();
((RadComboBox)CommandControl.FindControl("command_condition_operation")).SelectedValue = command_condition_operation;
}
else
{
CommandEntry["command_condition_operation"] = ((RadComboBox)CommandControl.FindControl("command_condition_operation")).SelectedValue;
}
if (CommandEntry["command_condition_device_field2"] != null && CommandEntry["command_condition_device_field2"].ToString().Length > 0)
{
string command_condition_device_field2 = CommandEntry["command_condition_device_field2"].ToString();
RadComboBox command_condition_device_field2_combo = ((RadComboBox)CommandControl.FindControl("command_condition_device_field2"));
command_condition_device_field2_combo.SelectedIndex = -1;
command_condition_device_field2_combo.Text = command_condition_device_field2;
}
else
{
CommandEntry["command_condition_device_field2"] = ((RadComboBox)CommandControl.FindControl("command_condition_device_field2")).SelectedValue;
}
continue;
}
else if (command == "insert into")
{
((ImageButton)CommandControl.FindControl("add_condition")).Visible = false;
((ImageButton)CommandControl.FindControl("add_order_by")).Visible = false;
field_control_type = "from_phone_to_database";
}
else if (command == "update")
{
((ImageButton)CommandControl.FindControl("add_order_by")).Visible = false;
field_control_type = "from_phone_to_database";
}
else if (command == "select from")
{
field_control_type = "from_database_to_phone";
}
else if (command == "delete from")
{
((ImageButton)CommandControl.FindControl("add_field")).Visible = false;
((ImageButton)CommandControl.FindControl("add_order_by")).Visible = false;
}
string table = CommandEntry["table"].ToString();
//check if database_field is in combobox
RadComboBox table_select = (RadComboBox)CommandControl.FindControl("table");
ArrayList DBFields = null;
if (table_select.Items.FindItemByValue(table) != null)
{
table_select.SelectedValue = table;
DBFields = (ArrayList)CommandEntry["database_fields"];
}
else
{
table_select.Items.Insert(0, new RadComboBoxItem("Select ->", "no_value"));
table_select.SelectedIndex = 0;
GoogleDocsConfigMessage.Text = "The saved table name is no longer valid. All fields have been cleared.";
CommandEntry["conditions"] = null;
CommandEntry["order_by"] = null;
}
if (DBFields != null && field_control_type != null)
{
foreach (Hashtable FieldEntry in DBFields)
{
RadTreeNode field_node = new RadTreeNode();
field_node.CssClass = "RadTreeView";
field_node.Category = "field";
field_node.PostBack = false;
State["SelectedDatabaseTable"] = table;
string control_file = (field_control_type == "from_database_to_phone") ? "DatabaseToDeviceField.ascx" : "DeviceToDatabaseField.ascx";
Control FieldControl = LoadControl("Controls/" +control_file);
if ( State["SpreadsheetError"] != null)
{
GoogleDocsConfigMessage.Text = State["SpreadsheetError"].ToString();
return;
}
field_node.Controls.Add(FieldControl);
command_node.Nodes.Add(field_node);
if (FieldEntry["database_field"] != null && FieldEntry["database_field"].ToString().Length > 0)
{
string database_field = FieldEntry["database_field"].ToString();
//check if database_field is in combobox
RadComboBox database_field_select = (RadComboBox)FieldControl.FindControl("database_field");
if (database_field_select.Items.FindItemByValue(database_field) != null)
database_field_select.SelectedValue = database_field;
else //add select item
{
database_field_select.Items.Insert(0,new RadComboBoxItem("Select ->","no_value"));
database_field_select.SelectedIndex = 0;
}
}
else
{
FieldEntry["database_field"] = ((RadComboBox)FieldControl.FindControl("database_field")).SelectedValue;
}
if (FieldEntry["device_field"] != null && FieldEntry["device_field"].ToString().Length > 0)
{
string phone_field = FieldEntry["device_field"].ToString();
RadComboBox phone_field_combo = (RadComboBox)FieldControl.FindControl("device_field");
phone_field_combo.SelectedIndex = -1;
phone_field_combo.Text = phone_field;
}
else
{
string phone_field_text = ((RadComboBox)FieldControl.FindControl("device_field")).Text;
if (phone_field_text.Length > 0)
FieldEntry["device_field"] = phone_field_text;
else
FieldEntry["device_field"] = ((RadComboBox)FieldControl.FindControl("device_field")).SelectedValue;
}
sub_command_index++;
}
}
ArrayList DBWhere = (ArrayList)CommandEntry["conditions"];
if (DBWhere != null)
{
int i_condition = 0;
// Hashtable uniqueConditionIDs = new Hashtable();
foreach (Hashtable ConditionEntry in DBWhere)
{
if (i_condition == 0)
State["IsFirstCommandCondition"] = true;
else
State["IsFirstCommandCondition"] = false;
RadTreeNode where_node = new RadTreeNode();
where_node.CssClass = "RadTreeView";
where_node.Category = "condition";
where_node.PostBack = false;
State["SelectedDatabaseTable"] = table;
Control WhereControl = LoadControl("Controls/DatabaseWhere.ascx");
if ( State["SpreadsheetError"] != null)
{
GoogleDocsConfigMessage.Text = State["SpreadsheetError"].ToString();
return;
}
where_node.Controls.Add(WhereControl);
command_node.Nodes.Add(where_node);
if (ConditionEntry["condition_operation"] != null && ConditionEntry["condition_operation"].ToString().Length > 0)
{
string condition_operation = ConditionEntry["condition_operation"].ToString();
((RadComboBox)WhereControl.FindControl("condition_operation")).SelectedValue = condition_operation;
}
else
{
ConditionEntry["condition_operation"] = ((RadComboBox)WhereControl.FindControl("condition_operation")).SelectedValue;
}
if (ConditionEntry["condition_1st_field"] != null && ConditionEntry["condition_1st_field"].ToString().Length > 0)
{
string condition_1st_field = ConditionEntry["condition_1st_field"].ToString();
//check if database field is in combobox
RadComboBox condition_1st_field_select = (RadComboBox)WhereControl.FindControl("condition_1st_field");
if (condition_1st_field_select.Items.FindItemByValue(condition_1st_field) != null)
condition_1st_field_select.SelectedValue = condition_1st_field;
else //add select item
{
condition_1st_field_select.Items.Insert(0,new RadComboBoxItem("Select ->","no_value"));
condition_1st_field_select.SelectedIndex = 0;
}
}
else
{
ConditionEntry["condition_1st_field"] = ((RadComboBox)WhereControl.FindControl("condition_1st_field")).SelectedValue;
}
if (ConditionEntry["field_operation"] != null && ConditionEntry["field_operation"].ToString().Length > 0)
{
string field_operation = ConditionEntry["field_operation"].ToString();
((RadComboBox)WhereControl.FindControl("field_operation")).SelectedValue = field_operation;
}
else
{
ConditionEntry["field_operation"] = ((RadComboBox)WhereControl.FindControl("field_operation")).SelectedValue;
}
if (ConditionEntry["condition_2nd_field"] != null && ConditionEntry["condition_2nd_field"].ToString().Length > 0)
{
string condition_2nd_field = ConditionEntry["condition_2nd_field"].ToString();
RadComboBox condition_2nd_field_combo = (RadComboBox)WhereControl.FindControl("condition_2nd_field");
condition_2nd_field_combo.SelectedIndex = -1;
condition_2nd_field_combo.Text = condition_2nd_field;
}
else
{
ConditionEntry["condition_2nd_field"] = ((RadComboBox)WhereControl.FindControl("condition_2nd_field")).Text;
}
i_condition++;
sub_command_index++;
}
}
Hashtable DBOrderBy = (Hashtable)CommandEntry["order_by"];
if (DBOrderBy != null)
{
RadTreeNode orderBy_node = new RadTreeNode();
orderBy_node.CssClass = "RadTreeView";
orderBy_node.Category = "order_by";
orderBy_node.PostBack = false;
State["SelectedDatabaseTable"] = table;
Control OrderByControl = LoadControl("Controls/DatabaseOrderBy.ascx");
if ( State["SpreadsheetError"] != null)
{
GoogleDocsConfigMessage.Text = State["SpreadsheetError"].ToString();
return;
}
orderBy_node.Controls.Add(OrderByControl);
command_node.Nodes.Add(orderBy_node);
if (DBOrderBy["sort_field"] != null && DBOrderBy["sort_field"].ToString().Length > 0)
{
string sort_field = DBOrderBy["sort_field"].ToString();
//check if database_field is in combobox
RadComboBox sort_field_select = (RadComboBox)OrderByControl.FindControl("sort_field");
if (sort_field_select.Items.FindItemByValue(sort_field) != null)
sort_field_select.SelectedValue = sort_field;
else //add select item
{
sort_field_select.Items.Insert(0, new RadComboBoxItem("Select ->", "no_value"));
sort_field_select.SelectedIndex = 0;
}
}
else
{
DBOrderBy["sort_field"] = ((RadComboBox)OrderByControl.FindControl("sort_field")).SelectedValue;
}
if (DBOrderBy["sort_direction"] != null && DBOrderBy["sort_direction"].ToString().Length > 0)
{
string sort_direction = DBOrderBy["sort_direction"].ToString();
((RadComboBox)OrderByControl.FindControl("sort_direction")).SelectedValue = sort_direction;
}
else
{
DBOrderBy["sort_direction"] = ((RadComboBox)OrderByControl.FindControl("sort_direction")).SelectedValue;
}
sub_command_index++;
}
command_node.ExpandChildNodes();
command_index++;
}
if ( State["ManageDataType"].ToString() == "database")
DatabaseCommandsView.ExpandAllNodes();
else
SpreadsheetCommandsView.ExpandAllNodes();
}
protected void InitWebServiceNodes(XmlDocument doc, string event_field, RadTreeNode url_node,
RadTreeNode WebServiceResponseRoot, XmlNode phone_data_requests)
{
string url = url_node.Text;
url_node.ExpandParentNodes();
url_node.CollapseChildNodes();
Hashtable WebServiceMethodInputs = new Hashtable();
Hashtable State = (Hashtable)HttpRuntime.Cache[Session.SessionID];
State["WebServiceMethodInputs"] = WebServiceMethodInputs;
RadTreeNode out_url = new RadTreeNode(url);
out_url.CssClass = "RadTreeView";
out_url.ImageUrl = "~/images/dialog.gif";
WebServiceResponseRoot.Nodes.Add(out_url);
Util util = new Util();
if (!url.EndsWith("?WSDL"))
url += "?WSDL";
string xml = util.GetWebPage(url);
if (xml == null)
{
SaveRequestMessage.Text = "Accessing " + url + " resulted in an error";
return;
}
XmlDocument WebDoc = new XmlDocument();
WebDoc.LoadXml(xml);
XmlNamespaceManager nsmgr = new XmlNamespaceManager(WebDoc.NameTable);
nsmgr.AddNamespace("s", "http://www.w3.org/2001/XMLSchema");
XmlNodeList web_methods = WebDoc.SelectNodes("//s:schema/s:element", nsmgr);
if (web_methods.Count == 0)
{
nsmgr.AddNamespace("wsdl", "http://schemas.xmlsoap.org/wsdl/");
web_methods = WebDoc.SelectNodes("//wsdl:operation", nsmgr);
if (web_methods.Count == 0)
{
SaveRequestMessage.Text = "Could not find any methods with URL: " + url;
return;
}
}
Hashtable used_names = new Hashtable();
foreach (XmlNode web_method in web_methods)
{
//throw out certain methods with <s:any />
if (web_method.InnerXml.Contains("s:any"))
continue;
string web_method_name = web_method.Attributes["name"].Value;
if (used_names.ContainsKey(web_method_name))
continue;
used_names[web_method_name] = true;
ArrayList MethodInputs = new ArrayList();
string service_url = out_url.Text;
if (out_url.Text.ToLower().EndsWith("?wsdl"))
service_url = service_url.Remove(url.Length - 5);
WebServiceMethodInputs[service_url + "/" + web_method_name] = MethodInputs;
RadTreeNode in_method_node = new RadTreeNode(web_method_name);
in_method_node.CssClass = "RadTreeView";
in_method_node.ImageUrl = "~/images/forward_nav.gif";
url_node.Nodes.Add(in_method_node);
//response web methods
XmlNode mapped_node = phone_data_requests.SelectSingleNode("//event_field[.='" + event_field + "']");
RadTreeNode out_method_node = null;
if (mapped_node != null && State["WebServiceTestDoc"] != null && State["WebServiceResponseTreeViewNodeText"] != null &&
State["WebServiceResponseTreeViewNodeText"].ToString() == web_method_name)
{
//make sure we are in the right event
XmlNode method_node = mapped_node.ParentNode.SelectSingleNode("method");
if (method_node != null && method_node.InnerText == web_method_name)
{
XmlDocument TestDoc = (XmlDocument) State["WebServiceTestDoc"];
out_method_node = new RadTreeNode(web_method_name);
State["WebServiceResponseTreeViewMethodText"] = web_method_name;
out_method_node.CssClass = "RadTreeView";
out_method_node.ImageUrl = "~/images/backward_nav.gif";
out_method_node.Category = "method";
out_method_node.Value = service_url + ";" + web_method_name + ";";
out_url.Nodes.Add(out_method_node);
out_method_node.Value.Remove(out_method_node.Value.Length - 1, 1);
WebServiceResponseTreeView.ExpandAllNodes();
XmlToTreeViewNode(TestDoc.FirstChild.NextSibling, out_method_node, web_method_name);
out_method_node.ExpandParentNodes();
Session.Remove("WebServiceTestDoc");
}
}
else if (mapped_node != null)
{
XmlNode web_service_node = mapped_node.ParentNode.SelectSingleNode("web_service[.='" + service_url + "']");
XmlNode method_node = mapped_node.ParentNode.SelectSingleNode("method[.='" + web_method_name + "']");
if (web_service_node != null && method_node != null)
{
in_method_node.BackColor = Color.LightCoral;
out_method_node = new RadTreeNode(web_method_name);
out_method_node.CssClass = "RadTreeView";
out_method_node.ImageUrl = "~/images/backward_nav.gif";
out_method_node.Category = "method";
out_method_node.Value = service_url + ";" + web_method_name + ";";
out_url.Nodes.Add(out_method_node);
out_method_node.Value.Remove(out_method_node.Value.Length - 1, 1);
WebServiceResponseTreeView.ExpandAllNodes();
}
}
XmlNodeList parms = web_method.SelectNodes("s:complexType/s:sequence/s:element", nsmgr);
foreach (XmlNode parm in parms)
{
string parm_name = parm.Attributes["name"].Value;
MethodInputs.Add(parm_name);
if (out_method_node != null)
out_method_node.Value += parm_name + ",";
RadTreeNode parm_node = new RadTreeNode(parm_name);
parm_node.CssClass = "RadTreeView";
parm_node.ImageUrl = "~/images/dot.gif";
parm_node.Category = "input";
parm_node.BackColor = Color.FromArgb(250, 252, 156);
in_method_node.Nodes.Add(parm_node);
if (mapped_node != null)
{
XmlNode web_service_node = mapped_node.ParentNode.SelectSingleNode("web_service[.='" + service_url + "']");
XmlNode method_node = mapped_node.ParentNode.SelectSingleNode("method[.='" + web_method_name + "']");
if (web_service_node != null && method_node != null)
{
XmlNode web_service_method_input_node = mapped_node.ParentNode.SelectSingleNode("input_mapping/web_service_method_input[.='" + parm_name + "']");
if (web_service_method_input_node != null)
{
XmlNode input_field_node = web_service_method_input_node.ParentNode.SelectSingleNode("input_field");
if (input_field_node != null)
{
string request_name = input_field_node.InnerText;
XmlNode field_node = doc.SelectSingleNode("//id[.='" + request_name + "']");
RadTreeNode request_node = null;
if (field_node == null)
request_node = util.CreateFieldNode(parm_node, request_name, "");
else
request_node = util.CreateFieldNode(parm_node, request_name, field_node.ParentNode.Name);
request_node.Text = request_name;
request_node.Category = "request";
request_node.BackColor = Color.FromArgb(153, 255, 185); //LIGHT GREEN
}
}
}
}
}
RadTreeNode save_method_node = new RadTreeNode("Save calling this method with 0 or more inputs mapped");
save_method_node.CssClass = "RadTreeView";
save_method_node.ImageUrl = "~/images/save.gif";
save_method_node.Category = "save";
in_method_node.Nodes.Add(save_method_node);
RadTreeNode undo_method_inputs_node = new RadTreeNode("Undo mapping of device fields to this method");
undo_method_inputs_node.CssClass = "RadTreeView";
undo_method_inputs_node.ImageUrl = "~/images/cancel.png";
undo_method_inputs_node.Category = "delete";
in_method_node.Nodes.Add(undo_method_inputs_node);
in_method_node.ExpandChildNodes();
}
}
public void HienThiTreeview()
{
string UserID = (string)Session["UserID"].ToString();
//string UserID = "27276";
string CongTy = "LTY";
RadTreeNode roottree = new RadTreeNode("System");
RadTreeView1.Nodes.Add(roottree);
DataTable dtSystem = dalSystem.QryProjectTheoUserID(UserID, CongTy);
if (dtSystem.Rows.Count > 0)
{
foreach (DataRow row in dtSystem.Rows)
{
string SysID = row["jsysid"].ToString();
string SysName = row["sysname"].ToString();
RadTreeNode nootcha = new RadTreeNode("");
nootcha.Text = SysName;
nootcha.Value = SysID;
roottree.Nodes.Add(nootcha);
roottree.ExpandChildNodes();
DataTable dtProjectm = dalProjectm.QryProjectTheoUserID1(UserID, CongTy, SysID);
if (dtProjectm.Rows.Count > 0)
{
foreach (DataRow dr in dtProjectm.Rows)
{
string SystemID = dr["jsysid"].ToString();
string subSystemID = dr["jsubid"].ToString();
string subName = dr["jsubname"].ToString();
RadTreeNode parentNode = new RadTreeNode("Sub System");
parentNode.Text = subName;
parentNode.ToolTip = subSystemID;
parentNode.Value = SystemID.ToString();
nootcha.Nodes.Add(parentNode);
nootcha.ExpandChildNodes();
DataTable dtProjects = dalProjects.HienThiDanhSachTheoHeThong(UserID, CongTy, SystemID, subSystemID);
if (dtProjects.Rows.Count > 0)
{
foreach (DataRow drs in dtProjects.Rows)
{
string systemID = drs["jsysid"].ToString();
string subSystem = drs["jsubid"].ToString();
string jobID = drs["jobid"].ToString();
string jobName = drs["jobname"].ToString();
RadTreeNode childNode = new RadTreeNode("");
childNode.Value = jobID;
childNode.ToolTip = subSystem;
childNode.Target = systemID.ToString();
childNode.Text = jobName;
parentNode.Nodes.Add(childNode);
parentNode.ExpandChildNodes();
}
}
}
}
}
}
RadTreeView1.ExpandAllNodes();
}
protected void RefreshCommandsView(int command_index)
{
Hashtable State = (Hashtable)HttpRuntime.Cache[Session.SessionID];
ArrayList DBCommands = (ArrayList)State["DBCommands"];
RadTreeNode DatabaseCommandRoot = CreateSpreadsheetRootNode();
if (DBCommands == null)
return;
//re add the previous controls
Hashtable prev_CommandEntry = null;
Hashtable CommandEntry = (Hashtable)DBCommands[command_index];
State["TestCommandEntry"] = CommandEntry;
int sub_command_index = 0;
RadTreeNode command_node = new RadTreeNode();
command_node.CssClass = "RadTreeView";
command_node.Category = "command";
command_node.PostBack = false;
string orig_command = CommandEntry["command"].ToString();
string command = orig_command.ToLower();
State["SelectedSqlCommand"] = command;
Control CommandControl = null;
string selected_table = null;
if (CommandEntry["table"] != null && CommandEntry["table"].ToString().Length > 0)
{
State["SelectedDatabaseTable"] = selected_table = CommandEntry["table"].ToString();
}
CommandControl = LoadControl("../Controls/DatabaseCommandTest.ascx", selected_table);
if (command.StartsWith("then "))
{
command = command.Remove(0, 5);
((HtmlInputText)CommandControl.FindControl("command")).Value = command;
((Label)CommandControl.FindControl("command_prefix")).Text = "Then ";
}
else if (command.StartsWith("else "))
{
command = command.Remove(0, 5);
((HtmlInputText)CommandControl.FindControl("command")).Value = command;
((Label)CommandControl.FindControl("command_prefix")).Text = "Else ";
}
else
((HtmlInputText)CommandControl.FindControl("command")).Value = command;
prev_CommandEntry = CommandEntry;
command_node.Controls.Add(CommandControl);
DatabaseCommandRoot.Nodes.Add(command_node);
string field_control_type = null;
if (command == "insert into")
{
field_control_type = "from_phone_to_database";
}
else if (command == "update")
{
field_control_type = "from_phone_to_database";
}
else if (command == "select from")
{
field_control_type = "from_database_to_phone";
}
ArrayList DBFields = (ArrayList)CommandEntry["database_fields"];
if (DBFields != null && field_control_type != null)
{
Hashtable TestInputValueMap = new Hashtable();
State["TestInputValueMap"] = TestInputValueMap;
foreach (Hashtable FieldEntry in DBFields)
{
RadTreeNode field_node = new RadTreeNode();
field_node.CssClass = "RadTreeView";
field_node.Category = "field";
field_node.PostBack = false;
State["SelectedDatabaseTable"] = selected_table;
string control_file = (field_control_type == "from_database_to_phone") ? "DatabaseToDeviceFieldTest.ascx" : "DeviceToDatabaseFieldTest.ascx";
string selected_database_field = "";
if (FieldEntry["database_field"] != null && FieldEntry["database_field"].ToString().Length > 0)
{
selected_database_field = FieldEntry["database_field"].ToString();
}
Control FieldControl = LoadControl("../Controls/" + control_file, selected_database_field);
if (State["SpreadsheetError"] != null)
{
Message.Text = State["SpreadsheetError"].ToString();
State["SpreadsheetError"] = null;
State["DBCommands"] = null;
State["SelectedDatabaseTable"] = null;
State["SelectedSqlCommand"] = null;
return;
}
field_node.Controls.Add(FieldControl);
command_node.Nodes.Add(field_node);
if (field_control_type == "from_database_to_phone")
{
if (FieldEntry["device_field"] != null && FieldEntry["device_field"].ToString().Length > 0)
{
string device_field = FieldEntry["device_field"].ToString();
HtmlInputText device_field_input = (HtmlInputText)FieldControl.FindControl("device_field");
device_field_input.Value = device_field;
}
}
else
{
TestInputValueMap[FieldEntry["database_field"].ToString()] = (HtmlInputText)FieldControl.FindControl("device_field");
}
sub_command_index++;
}
}
ArrayList DBWhere = (ArrayList)CommandEntry["conditions"];
if (DBWhere != null)
{
int i_condition = 0;
// Hashtable uniqueConditionIDs = new Hashtable();
Hashtable TestWhereValueMap = new Hashtable();
State["TestWhereValueMap"] = TestWhereValueMap;
foreach (Hashtable ConditionEntry in DBWhere)
{
if (i_condition == 0)
State["IsFirstCommandCondition"] = true;
else
State["IsFirstCommandCondition"] = false;
RadTreeNode where_node = new RadTreeNode();
where_node.CssClass = "RadTreeView";
where_node.Category = "condition";
where_node.PostBack = false;
State["SelectedDatabaseTable"] = selected_table;
string selected_condition_1st_field = null;
if (ConditionEntry["condition_1st_field"] != null && ConditionEntry["condition_1st_field"].ToString().Length > 0)
{
selected_condition_1st_field = ConditionEntry["condition_1st_field"].ToString();
}
Control WhereControl = LoadControl("../Controls/SpreadsheetWhereTest.ascx", selected_condition_1st_field);
if (State["SpreadsheetError"] != null)
{
Message.Text = State["SpreadsheetError"].ToString();
State["SpreadsheetError"] = null;
State["DBCommands"] = null;
State["SelectedDatabaseTable"] = null;
State["SelectedSqlCommand"] = null;
return;
}
where_node.Controls.Add(WhereControl);
command_node.Nodes.Add(where_node);
if (ConditionEntry["condition_operation"] != null && ConditionEntry["condition_operation"].ToString().Length > 0)
{
string condition_operation = ConditionEntry["condition_operation"].ToString();
((HtmlInputText)WhereControl.FindControl("condition_operation")).Value = condition_operation;
}
if (ConditionEntry["field_operation"] != null && ConditionEntry["field_operation"].ToString().Length > 0)
{
string field_operation = ConditionEntry["field_operation"].ToString();
((HtmlInputText)WhereControl.FindControl("field_operation")).Value = field_operation;
}
TestWhereValueMap[i_condition] = (HtmlInputText)WhereControl.FindControl("condition_2nd_field");
i_condition++;
sub_command_index++;
}
}
Hashtable DBOrderBy = (Hashtable)CommandEntry["order_by"];
if (DBOrderBy != null)
{
RadTreeNode orderBy_node = new RadTreeNode();
orderBy_node.CssClass = "RadTreeView";
orderBy_node.Category = "order_by";
orderBy_node.PostBack = false;
State["SelectedDatabaseTable"] = selected_table;
string selected_sort_field = null;
if (DBOrderBy["sort_field"] != null && DBOrderBy["sort_field"].ToString().Length > 0)
{
selected_sort_field = DBOrderBy["sort_field"].ToString();
}
Control OrderByControl = LoadControl("../Controls/DatabaseOrderByTest.ascx", selected_sort_field);
if (State["SpreadsheetError"] != null)
{
Message.Text = State["SpreadsheetError"].ToString();
State["SpreadsheetError"] = null;
State["DBCommands"] = null;
State["SelectedDatabaseTable"] = null;
State["SelectedSqlCommand"] = null;
return;
}
orderBy_node.Controls.Add(OrderByControl);
command_node.Nodes.Add(orderBy_node);
if (DBOrderBy["sort_direction"] != null && DBOrderBy["sort_direction"].ToString().Length > 0)
{
string sort_direction = DBOrderBy["sort_direction"].ToString();
((HtmlInputText)OrderByControl.FindControl("sort_direction")).Value = sort_direction;
}
sub_command_index++;
}
command_node.ExpandChildNodes();
SpreadsheetCommandView.ExpandAllNodes();
}
