public Employee GetEmployee(int?id) { Employee employee = new Employee(); employee.EmployeeID = (int)id; DataTable dataTable = new DataTable(); try { using (MySqlCommand command = new MySqlCommand("instest.Proc_GetEmployeeDetails")) { command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@EmpID", employee.EmployeeID); using (DataObjectClass dataObjectClass = new DataObjectClass()) { dataTable = dataObjectClass.GetDataTablefromMySqlCmd(command); } } if (dataTable != null) { if (dataTable.Rows.Count > 0) { employee.EmployeeName = Convert.IsDBNull(dataTable.Rows[0].ItemArray[0].ToString()) ? "" : dataTable.Rows[0].ItemArray[0].ToString(); employee.Gender = Convert.IsDBNull(dataTable.Rows[0].ItemArray[1].ToString()) ? "" : dataTable.Rows[0].ItemArray[1].ToString(); employee.City = Convert.IsDBNull(dataTable.Rows[0].ItemArray[2].ToString()) ? "" : dataTable.Rows[0].ItemArray[2].ToString(); } else { employee.ErrorText = "No Data Found"; } } else { employee.ErrorText = "No Data Found"; } } catch (Exception ex) { employee.ErrorText = ex.Message.ToString(); throw; } finally { if (dataTable != null) { dataTable.Dispose(); dataTable = null; } } return(employee); }
public void RefreshAutocomplete(DataObjectClass obj) { //create autocomplete popup menu if (obj == null) { return; } _popupMenu = new AutocompleteMenu(fctSource) { MinFragmentLength = 2 }; var words = new List <string> { obj.Name, obj.Name + "Class", obj.Name + "Class.TDataClass", obj.Name + "Class.TDataClass.TColumns" }; if (obj.GetType() == typeof(TableClass)) { var tc = (TableClass)obj; foreach (var tcf in tc.Fields) { words.Add(tcf.Value.Name); words.Add(tc.Name + "." + tcf.Value.Name); } } else if (obj.GetType() == typeof(ViewClass)) { var tc = (ViewClass)obj; foreach (var tcf in tc.Fields.Values) { words.Add(tcf.Name); words.Add(tc.Name + "." + tcf.Name); } } _popupMenu.Items.SetAutocompleteItems(words); //size of popupmenu _popupMenu.Items.MaximumSize = new Size(200, 300); _popupMenu.Items.Width = 200; }
protected void btnSelectState_Click(object sender, EventArgs e) { DataObjectClass obj_dataobject = null; List<string> result = new List<string>(); DataTable dt = new DataTable(); lstSourceStates.Items.Clear(); lstDestinationStates.Items.Clear(); try { obj_dataobject = new DataObjectClass(); string qstring = "select Distinct k.txt_state_display_name" + " from workflow_state_master k" + " where k.txt_state_display_name is not null" + " order by k.txt_state_display_name"; dt = obj_dataobject.getSQLDataTable(qstring); if (dt != null || dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { result.Add(dt.Rows[i].ItemArray[0].ToString()); } } lstSourceStates.DataSource = result; lstSourceStates.DataBind(); System.Text.StringBuilder sb = new System.Text.StringBuilder(); sb.Append(@"<script language='javascript' type='text/javascript'>"); sb.Append(@"showSelection();"); sb.Append(@"</script>"); ScriptManager.RegisterClientScriptBlock(this.Page, Page.GetType(), "none", sb.ToString(), false); } catch (Exception) { result.Add("Error occurred"); } }
//Retrieving Start State Name for each activity private string GetStartStateName(string strStateDispName) { string strStartStateName = string.Empty; string strQuery = "select s.txt_state_name Start_State from workflow_state_master s where s.txt_state_name='" + strStateDispName + "' "; DataObjectClass objDataObjectClass = new DataObjectClass(); DataTable dtWorkflow = new DataTable(); try { dtWorkflow = objDataObjectClass.getSQLDataTable(strQuery); if ((dtWorkflow != null) && dtWorkflow.Rows.Count > 0) { strStartStateName = dtWorkflow.Rows[0][0].ToString(); } return strStartStateName; } catch (Exception ex) { return ""; } finally { objDataObjectClass = null; dtWorkflow = null; } }
//Retrieving End State Name for each activity private string GetEndStateName(string strStateDispName) { string strEndStateName = string.Empty; string strQuery = "select t.txt_state_name End_State from workflow_state_master t where t.txt_state_id = (select max(to_number(a.txt_state_id)) " + "from workflow_state_master a where a.txt_start_comp_link_id in (select s.txt_start_comp_link_id from workflow_state_master s " + "where s.txt_state_name = '" + strStateDispName + "'))"; DataObjectClass objDataObjectClass = new DataObjectClass(); DataTable dtWorkflow = new DataTable(); try { dtWorkflow = objDataObjectClass.getSQLDataTable(strQuery); if ((dtWorkflow != null) && dtWorkflow.Rows.Count > 0) { strEndStateName = dtWorkflow.Rows[0][0].ToString(); } return strEndStateName; } catch (Exception ex) { return ""; } finally { objDataObjectClass = null; dtWorkflow = null; } }
protected void btnSaveChanges_Click(object sender, EventArgs e) { string result = ""; try { List<DisplayState> dispstate = (List<DisplayState>)Session["display_states"]; DisplayState temp_state = null; string initState = ""; string filePath = Session["filepath"].ToString().Trim(); List<string> new_states = new List<string>(); DataObjectClass obj_dataobject = new DataObjectClass(); DataTable dtable = new DataTable(); string qstring = ""; if (row2.Visible == true) { foreach (ListItem item in lstDestinationStates.Items) { new_states.Add(item.Value.ToString().Trim()); } foreach (string item in new_states) { temp_state = new DisplayState(); temp_state.disp_state_name = item.ToString().Trim(); temp_state.InitialState = false; qstring = string.Format("select k.txt_state_name state,k.txt_state_display_name from workflow_state_master k" + " where k.txt_start_comp_link_id=(select p.txt_start_comp_link_id from workflow_state_master p where p.txt_state_display_name='{0}')" + " order by k.txt_state_id", temp_state.disp_state_name.ToString().Trim()); dtable = obj_dataobject.getSQLDataTable(qstring); if (dtable != null && dtable.Rows.Count > 0) { temp_state.actual_state_name = dtable.Rows[0][0].ToString().Trim(); temp_state.completed_state_name = dtable.Rows[1][0].ToString().Trim(); } dispstate.Add(temp_state); temp_state = null; } List<string> every_state = new List<string>(); foreach (DisplayState item in dispstate) { every_state.Add(item.disp_state_name.ToString().Trim()); } foreach (DisplayState item in dispstate) { item.all_states = null; item.all_states = new List<string>(); item.all_states = every_state; } Session["display_states"] = dispstate; grdStateModification.DataSource = null; grdStateModification.DataSource = dispstate; grdStateModification.DataBind(); UpdatePanel2.Update(); System.Text.StringBuilder sb = new System.Text.StringBuilder(); sb.Append(@"<script language='javascript' type='text/javascript'>"); string script = "HideAllStates();"; sb.Append(script); sb.Append(@"</script>"); ScriptManager.RegisterClientScriptBlock(this.Page, Page.GetType(), "none", sb.ToString(), false); } else { if (filePath != null) { XDocument doc = XDocument.Load(filePath); XNamespace w = "http://schemas.microsoft.com/winfx/2006/xaml/workflow"; XNamespace x = "http://schemas.microsoft.com/winfx/2006/xaml"; initState = dispstate.Where(state => state.InitialState == true).Select(state => state.actual_state_name).First().ToString().Trim(); foreach (XElement element in doc.Root.Elements(w + "StateActivity")) { if (element.Attribute(x + "Name").Value.ToString().Trim() == "START_WORKFLOW") { foreach (XElement inner_element in element.Elements(w + "EventDrivenActivity")) { inner_element.Attribute(x + "Name").Value = "ON_START_WORKFLOW_" + initState.ToString().Trim(); inner_element.Element(w + "HandleExternalEventActivity").Attribute(x + "Name").Value = "START_WORKFLOW_" + initState.ToString().Trim(); inner_element.Element(w + "HandleExternalEventActivity").Attribute("EventName").Value = initState.ToString().Trim(); inner_element.Element(w + "SetStateActivity").Attribute("TargetStateName").Value = initState.ToString().Trim(); inner_element.Element(w + "SetStateActivity").Attribute(x + "Name").Value = "setStateActivity_START_WORKFLOW_" + initState.ToString().Trim(); } } //else //{ // element.RemoveAll(); //} } doc.Save(filePath); //foreach (XNode node in doc.Root.Nodes()) //{ // node.NodesAfterSelf().Remove(); //} doc.Root.Descendants(w + "StateActivity") .Where(node => node.Attribute(x + "Name").Value.ToString().Trim() != "START_WORKFLOW") .Remove(); doc.Save(filePath); StringBuilder str = new StringBuilder(); List<string> targetStates = new List<string>(); str.Append("<StateMachineWorkflowActivity x:Class=" + "\"" + "WorkflowLibrary1." + Session["filename"].ToString().Trim() + "\"" + " InitialStateName=" + "\"" + "START_WORKFLOW" + "\"" + " x:Name=" + "\"" + Session["filename"].ToString().Trim() + "\"" + " DynamicUpdateCondition=" + "\"" + "{x:Null}" + "\"" + " CompletedStateName=" + "\"" + "{x:Null}" + "\"" + " xmlns:x=" + "\"" + "http://schemas.microsoft.com/winfx/2006/xaml" + "\"" + " xmlns=" + "\"" + "http://schemas.microsoft.com/winfx/2006/xaml/workflow" + "\"" + " > "); foreach (DisplayState state in dispstate) { targetStates.Add(GetEndStateName(state.actual_state_name.ToString().Trim())); str.Append(CreateStateForMarkup(GetStartStateName(state.actual_state_name.ToString().Trim()), targetStates)); str.Append(CreateStateForMarkup(targetStates.First().ToString().Trim(), state.target_states)); targetStates.Clear(); } str.Append("</StateMachineWorkflowActivity>"); XDocument ndoc = XDocument.Parse(str.ToString().Trim()); foreach (XNode node in ndoc.Root.Nodes()) { doc.Root.Add(node); doc.Save(filePath); } doc = null; str.Clear(); result = "success"; } System.Text.StringBuilder sb = new System.Text.StringBuilder(); sb.Append(@"<script language='javascript' type='text/javascript'>"); string script = string.Format(@"SaveConfirmation('{0}')", result.ToString().Trim()); sb.Append(script); sb.Append(@"</script>"); ScriptManager.RegisterClientScriptBlock(this.Page, Page.GetType(), "none", sb.ToString(), false); } } catch (Exception ex) { result = ex.Message.ToString().Trim(); } }
protected void btnModify_Click(object sender, EventArgs e) { string result = ""; List<DisplayState> dispstate = (List<DisplayState>)Session["display_states"]; try { foreach (DisplayState item in dispstate) { item.target_states.Clear(); item.targetstate_displayname.Clear(); } DataObjectClass obj_dataobject = null; List<string> source_states = new List<string>(); DataTable dt = new DataTable(); lstSourceStates.Items.Clear(); lstDestinationStates.Items.Clear(); try { obj_dataobject = new DataObjectClass(); string qstring = "select Distinct k.txt_state_display_name" + " from workflow_state_master k" + " where k.txt_state_display_name is not null" + " order by k.txt_state_display_name"; dt = obj_dataobject.getSQLDataTable(qstring); if (dt != null || dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { source_states.Add(dt.Rows[i].ItemArray[0].ToString()); } } lstSourceStates.DataSource = source_states; lstSourceStates.DataBind(); result = "success"; } catch (Exception ex) { result = ex.Message.ToString().Trim(); } grdStateModification.DataSource = null; grdStateModification.DataSource = dispstate; grdStateModification.DataBind(); } catch (Exception ex) { } System.Text.StringBuilder sb = new System.Text.StringBuilder(); sb.Append(@"<script language='javascript' type='text/javascript'>"); string str = string.Format(@"DisplayStateModification('{0}')", result.ToString().Trim()); sb.Append(str); sb.Append(@"</script>"); ScriptManager.RegisterClientScriptBlock(this.Page, Page.GetType(), "none", sb.ToString(), false); }
protected void btnDisplayStateTransition_Click(object sender, EventArgs e) { string result = ""; try { if (Session["filepath"] != null) { List<StateActivity> actual_states = (List<StateActivity>)Session["actual_states"]; List<DisplayState> dispState = new List<DisplayState>(); DisplayState state = null; List<string> targetStates = null; List<string> targetstate_displayname = null; StateActivity tempstate = null; string completed_state = ""; string qstring = ""; DataRow drow = null; DataObjectClass obj_dataobject = new DataObjectClass(); string state_status = ""; for (int i = 1; i < actual_states.Count; i++) { state = new DisplayState(); qstring = string.Format("select decode(s.txt_state_display_name,'','End_State','Start_State'),s.txt_state_display_name Display_Name" + " from workflow_state_master s where txt_state_name='{0}'", actual_states[i].state_name.ToString().Trim()); drow = obj_dataobject.getSQLDataRow(qstring.Trim()); if (drow != null) { state_status = drow[0].ToString().Trim(); } if (state_status == "Start_State") { state.actual_state_name = actual_states[i].state_name.ToString().Trim(); state.disp_state_name = drow[1].ToString().Trim(); drow = null; state.InitialState = actual_states[i].InitialState; completed_state = actual_states[i].event_driven[0].setState.ToString().Trim(); state.completed_state_name = completed_state.ToString().Trim(); tempstate = (from temp in actual_states where temp.state_name == completed_state select temp).First(); targetStates = new List<string>(); foreach (EventDrivenActivity ediv in tempstate.event_driven) { targetStates.Add(ediv.setState.ToString().Trim()); } state.target_states = targetStates; targetstate_displayname = new List<string>(); foreach (string target in targetStates) { qstring = string.Format("select s.txt_state_display_name Display_Name" + " from workflow_state_master s where txt_state_name='{0}'", target.Trim()); drow = obj_dataobject.getSQLDataRow(qstring.Trim()); if (drow != null) { targetstate_displayname.Add(drow[0].ToString().Trim()); } } state.targetstate_displayname = targetstate_displayname; targetstate_displayname = null; targetStates = null; tempstate = null; dispState.Add(state); state = null; } } List<string> all_states = new List<string>(); foreach (DisplayState item in dispState) { all_states.Add(item.disp_state_name.ToString().Trim()); } foreach (DisplayState item in dispState) { item.all_states = all_states; } Session["display_states"] = dispState; grdStateTransition.DataSource = null; grdStateTransition.DataSource = dispState; grdStateTransition.DataBind(); result = "success"; } else { result = "Please read the file to proceed"; } } catch (Exception ex) { result = ex.Message.ToString().Trim(); } System.Text.StringBuilder sb = new System.Text.StringBuilder(); sb.Append(@"<script language='javascript' type='text/javascript'>"); string str = string.Format(@"DisplayStateTransition('{0}')", result.ToString().Trim()); sb.Append(str); sb.Append(@"</script>"); ScriptManager.RegisterClientScriptBlock(this.Page, Page.GetType(), "none", sb.ToString(), false); }
protected void chk_Transition_CheckedChanged(object sender, EventArgs e) { string strQuery = string.Empty; string strCollSelectedLnks = string.Empty; DataObjectClass objDataObjectClass = new DataObjectClass(); DataTable dtWorkflow = new DataTable(); dicSelectedStateDtls = new Dictionary<string, string>(); List<string> newList = new List<string>(); for (int Count = 0; Count <= lstDestinationStates.Items.Count - 1; Count++) { strCollSelectedLnks += "'" + lstDestinationStates.Items[Count].ToString().Trim() + "',"; } strCollSelectedLnks = strCollSelectedLnks.Trim(','); strQuery = "select P.TXT_STATE_ID,P.TXT_START_COMP_LINK_ID,P.TXT_STATE_NAME,P.TXT_STATE_DISPLAY_NAME FROM WORKFLOW_STATE_MASTER P " + "where P.TXT_START_COMP_LINK_ID IN (SELECT K.TXT_START_COMP_LINK_ID FROM WORKFLOW_STATE_MASTER K WHERE K.TXT_STATE_DISPLAY_NAME IN (" + strCollSelectedLnks + ")) GROUP BY P.TXT_START_COMP_LINK_ID,P.TXT_STATE_ID,P.TXT_STATE_NAME,P.TXT_STATE_DISPLAY_NAME " + "ORDER BY TO_NUMBER(P.TXT_STATE_ID)"; try { string firstArg = string.Empty; dtWorkflow = objDataObjectClass.getSQLDataTable(strQuery); if ((dtWorkflow != null) && dtWorkflow.Rows.Count > 0) { for (int Count = 0; Count <= dtWorkflow.Rows.Count - 1; Count++) { if (Count != 0) { if (dtWorkflow.Rows[Count][3] != System.DBNull.Value) { if (dtWorkflow.Rows[Count][3] == System.DBNull.Value) { firstArg = dtWorkflow.Rows[Count - 1][3].ToString(); } else { firstArg = dtWorkflow.Rows[Count][3].ToString(); } dicSelectedStateDtls.Add(firstArg, (dtWorkflow.Rows[Count][2] + "," + dtWorkflow.Rows[Count + 1][2])); } else { continue; } } else { dicSelectedStateDtls.Add(dtWorkflow.Rows[Count][3].ToString(), dtWorkflow.Rows[Count][2].ToString() + "," + dtWorkflow.Rows[Count + 1][2].ToString()); } } } Session["DICLNKDTLS"] = dicSelectedStateDtls; //if (chk_Transition.Checked) //{ // ddlDisplayLinks.Visible = true; // chkSelectedLinks.Visible = true; // chkSetInitStates.Visible = true; ddlDisplayLinks.Items.Clear(); chkSelectedLinks.Items.Clear(); for (int i = 0; i <= dicSelectedStateDtls.Count - 1; i++) { ddlDisplayLinks.Items.Add(dicSelectedStateDtls.Keys.ElementAt(i).ToString().Trim()); } foreach (object Item_loopVariable in dicSelectedStateDtls.Keys) { chkSelectedLinks.Items.Add(Item_loopVariable.ToString()); } // foreach (object Item_loopVariable in dicSelectedStateDtls.Keys) // { // chkSetInitStates.Items.Add(Item_loopVariable.ToString()); // } //} //else //{ // ddlDisplayLinks.Visible = false; // chkSelectedLinks.Visible = false; // chkSetInitStates.Visible = false; //} rdbSetInitStates.Items.Clear(); foreach (object Item_loopVariable in dicSelectedStateDtls.Keys) { rdbSetInitStates.Items.Add(Item_loopVariable.ToString()); } UpdatePanel3.Update(); System.Text.StringBuilder sb = new System.Text.StringBuilder(); sb.Append(@"<script language='javascript' type='text/javascript'>"); sb.Append(@"ShowStateTransitionPanel();"); sb.Append(@"</script>"); ScriptManager.RegisterClientScriptBlock(this.Page, Page.GetType(), "none", sb.ToString(), false); } catch (Exception ex) { } }
//private bool connection_open = false; //private MySqlConnection connection; public Employee(int arg_id) { //Get_Connection(); EmployeeID = arg_id; DataTable dataTable = new DataTable(); DataSet dataSet = new DataSet(); DataRow dataRow = null; try { int id = 1; MySqlCommand command = new MySqlCommand { CommandText = "select name, gender, city from instest.tblemployee where id = @id" }; command.CommandType = CommandType.Text; command.Parameters.AddWithValue("@id", id); using (DataObjectClass dataObjectClass = new DataObjectClass()) { dataTable = dataObjectClass.GetDataTablefromMySqlCmd(command); dataRow = dataObjectClass.GetDataRowfromMySqlCmd(command); dataSet = dataObjectClass.GetDataSetfromMySqlCmd(command); } if (dataTable != null) { if (dataTable.Rows.Count > 0) { EmployeeName = Convert.IsDBNull(dataTable.Rows[0].ItemArray[0].ToString()) ? "" : dataTable.Rows[0].ItemArray[0].ToString(); Gender = Convert.IsDBNull(dataTable.Rows[0].ItemArray[1].ToString()) ? "" : dataTable.Rows[0].ItemArray[1].ToString(); City = Convert.IsDBNull(dataTable.Rows[0].ItemArray[2].ToString()) ? "" : dataTable.Rows[0].ItemArray[2].ToString(); } else { } } else { } //MySqlCommand cmd = new MySqlCommand //{ // Connection = connection, // CommandText = string.Format("select name, gender, city from instest.tblemployee where id = '{0}'", ID) //}; //MySqlDataReader reader = cmd.ExecuteReader(); //try //{ // reader.Read(); // if (reader.IsDBNull(0) == false) // { // Name = reader.GetString(0); // } // else // { // Name = null; // } // if (reader.IsDBNull(1) == false) // { // Gender = reader.GetString(1); // } // else // { // Gender = null; // } // if (reader.IsDBNull(2) == false) // { // City = reader.GetString(2); // } // else // { // City = null; // } // //if (reader.IsDBNull(3) == false) // //{ // // Photo = new byte[reader.GetInt32(4)]; // // reader.GetBytes(3, 0, Photo, 0, reader.GetInt32(4)); // //} // //else // //{ // // Photo = null; // //} // reader.Close(); //} //catch (MySqlException e) //{ // string MessageString = "Read error occurred / entry not found loading the Column details: " // + e.ErrorCode + " - " + e.Message + "; \n\nPlease Continue"; // //MessageBox.Show(MessageString, "SQL Read Error"); // reader.Close(); // Name = MessageString; // Gender = City = null; //} } catch (MySqlException e) { string MessageString = "The following error occurred loading the Column details: " + e.ErrorCode + " - " + e.Message; EmployeeName = MessageString; Gender = City = null; } //connection.Close(); }