protected void btnSave_Click2(object sender, EventArgs e)
{
WorkflowsDTO workflowsDTO = new WorkflowsDTO(txtboxLanguage.Text.Trim(), txtboxCode.Text.Trim(), txtboxWFName.Text.Trim(),
chkboxInactive.Checked);
WorkflowsService workflowsService = new WorkflowsService();
bool workflowExists = false;
try
{
workflowsService.SaveWorkflow(workflowsDTO);
}catch (DuplicateNameException ex) {
workflowExists = true;
}
if (workflowExists)
{
lblResult.Text = "Workflow name already exists. Try using a different name";
btnAdd.Enabled = true;
txtboxWFName.Focus();
}
else
{
lblResult.Text = "Your Workflow is being Saved";
btnAdd.Enabled = true;
txtboxCode.Text = "";
txtboxWFName.Text = "";
}
}
public void UpdateWorkflow(WorkflowsDTO workflowsDTO)
{
SqlCommand cmd = new SqlCommand();
//Specify that the SqlCommand is a stored procedure
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "WorkflowName_Update";
//Add the input parameters to the command object
cmd.Parameters.Add("@Code", SqlDbType.VarChar).Value = workflowsDTO.Code;
cmd.Parameters.Add("@Workflow_Name", SqlDbType.VarChar).Value = workflowsDTO.Workflow_Name;
cmd.Parameters.Add("@Language", SqlDbType.VarChar).Value = workflowsDTO.Language;
cmd.Parameters.Add("@Inactive", SqlDbType.Bit).Value = workflowsDTO.Inactive;
SqlHelper sqlHelper = new SqlHelper();
int result = sqlHelper.executeUpdate(cmd);
if (result == -1)
{
throw new DuplicateNameException();
}
}
public void UpdateWorkflow(WorkflowsDTO workflowsDTO)
{
WorkflowsDAO workflowsDAO = new WorkflowsDAO();
workflowsDAO.UpdateWorkflow(workflowsDTO);
}
public void SaveWorkflow(WorkflowsDTO workflowsDTO)
{
WorkflowsDAO workflowsDAO = new WorkflowsDAO();
workflowsDAO.SaveWorkflow(workflowsDTO);
}
