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