public string SearchProcessSubByProcessMainId(ProcessSubProperty dataItem)
{
sql = @"SELECT * FROM `process_sub`
WHERE PROCESS_ID = '" + dataItem.PROCESS_ID + "'";
return(sql);
}
public string InsertProcessSub(ProcessSubProperty dataItem)
{
sql = @"INSERT INTO `process_sub` (
PROCESS_SUB_ID
, PROCESS_ID
, SUB_PROCESS_NAME
, INUSE
, DESCRIPTION
, CREATE_USER
)
(
SELECT 1 + coalesce((SELECT max(PROCESS_SUB_ID) FROM process_sub), 0)
, 'dataItem.PROCESS_ID'
, 'dataItem.SUB_PROCESS_NAME'
, 1
, 'dataItem.DESCRIPTION'
, 'dataItem.CREATE_USER'
);";
sql = sql.Replace("dataItem.PROCESS_SUB_ID", dataItem.PROCESS_SUB_ID);
sql = sql.Replace("dataItem.PROCESS_ID", dataItem.PROCESS_ID);
sql = sql.Replace("dataItem.SUB_PROCESS_NAME", dataItem.SUB_PROCESS_NAME);
sql = sql.Replace("dataItem.INUSE", dataItem.INUSE);
sql = sql.Replace("dataItem.DESCRIPTION", dataItem.DESCRIPTION);
sql = sql.Replace("dataItem.CREATE_USER", dataItem.CREATE_USER);
sql = sql.Replace("dataItem.LAST_USER", dataItem.LAST_USER);
sql = sql.Replace("dataItem.CREATE_DATE", dataItem.CREATE_DATE);
sql = sql.Replace("dataItem.LAST_DATE", dataItem.LAST_DATE);
return(sql);
}
public List <ProcessSubProperty> SearchProcessSubByFlowName(FlowProperty dataItem)
{
List <ProcessSubProperty> _result = new List <ProcessSubProperty>();
try
{
_resultData = _models.SearchProcessSubByFlowName(dataItem);
if (_resultData.StatusOnDb == true)
{
if (_resultData.ResultOnDb.Rows.Count > 0)
{
for (int i = 0; i < _resultData.ResultOnDb.Rows.Count; i++)
{
ProcessSubProperty _Process = new ProcessSubProperty
{
SUB_PROCESS_NAME = _resultData.ResultOnDb.Rows[i]["SUB_PROCESS_NAME"].ToString(),
PROCESS_ID = _resultData.ResultOnDb.Rows[i]["PROCESS_ID"].ToString(),
};
_result.Add(_Process);
}
}
}
else
{
MessageBox.Show(_resultData.MessageOnDb, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(_result);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(_result);
}
}
public string UpdateProccessStatus(ProcessSubProperty dataItem)
{
sql = @"UPDATE `process_sub`
SET INUSE = '" + dataItem.INUSE + @"' , LAST_USER = '******' , LAST_DATE = NOW()
WHERE SUB_PROCESS_NAME = '" + dataItem.SUB_PROCESS_NAME + @"'
AND PROCESS_ID = '" + dataItem.PROCESS_ID + @"'";
return(sql);
}
//public List<ProcessSubProperty> SearchProcessSubAll()
//{
// List<ProcessSubProperty> _result = new List<ProcessSubProperty>();
// try
// {
// _resultData = _models.SearchProcessSubAll();
// if (_resultData.StatusOnDb == true)
// {
// if (_resultData.ResultOnDb.Rows.Count > 0)
// {
// for (int i = 0; i < _resultData.ResultOnDb.Rows.Count; i++)
// {
// ProcessSubProperty _ProcessSub = new ProcessSubProperty()
// {
// ID = _resultData.ResultOnDb.Rows[i]["ID"].ToString(),
// ProcessSub_NAME = _resultData.ResultOnDb.Rows[i]["ProcessSub_NAME"].ToString(),
// INUSE = _resultData.ResultOnDb.Rows[i]["INUSE"].ToString()
// };
// _result.Add(_ProcessSub);
// }
// }
// }
// else
// {
// MessageBox.Show(_resultData.MessageOnDb, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
// }
// return _result;
// }
// catch (Exception ex)
// {
// MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
// return _result;
// }
//}
public List <ProcessSubProperty> SearchProcessSubByProcessMainId(ProcessSubProperty dataItem)
{
List <ProcessSubProperty> _result = new List <ProcessSubProperty>();
try
{
_resultData = _models.SearchProcessSubByProcessMainId(dataItem);
if (_resultData.StatusOnDb == true)
{
if (_resultData.ResultOnDb.Rows.Count > 0)
{
for (int i = 0; i < _resultData.ResultOnDb.Rows.Count; i++)
{
ProcessSubProperty _ProcessSub = new ProcessSubProperty()
{
PROCESS_SUB_ID = _resultData.ResultOnDb.Rows[i]["PROCESS_SUB_ID"].ToString(),
PROCESS_ID = _resultData.ResultOnDb.Rows[i]["PROCESS_ID"].ToString(),
SUB_PROCESS_NAME = _resultData.ResultOnDb.Rows[i]["SUB_PROCESS_NAME"].ToString(),
INUSE = _resultData.ResultOnDb.Rows[i]["INUSE"].ToString(),
DESCRIPTION = _resultData.ResultOnDb.Rows[i]["DESCRIPTION"].ToString(),
CREATE_USER = _resultData.ResultOnDb.Rows[i]["CREATE_USER"].ToString(),
LAST_USER = _resultData.ResultOnDb.Rows[i]["LAST_USER"].ToString(),
CREATE_DATE = _resultData.ResultOnDb.Rows[i]["CREATE_DATE"].ToString(),
LAST_DATE = _resultData.ResultOnDb.Rows[i]["LAST_DATE"].ToString(),
};
_result.Add(_ProcessSub);
}
}
}
else
{
MessageBox.Show(_resultData.MessageOnDb, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(_result);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(_result);
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (this.txtInsertProcess.Text.Trim() == "")
{
MessageBox.Show("Plaease Input Process name", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
bool status = true;
string processName = this.txtInsertProcess.Text.Trim();
foreach (ProcessSubProperty _process in _listProcess)
{
if (processName == _process.SUB_PROCESS_NAME.Trim())
{
status = false;
}
}
if (status == true)
{
ProcessSubProperty _addProcess = new ProcessSubProperty {
SUB_PROCESS_NAME = processName, PROCESS_ID = (cmbMainProcess.SelectedItem as ComboboxItem).Value.ToString(), CREATE_USER = _frmMain._empLogin.code
};
//Insert Process.
if (_processSubController.InsertProcessSub(_addProcess))
{
this.SetPage();
//this.ResetInsertProcess();
this.LoadProcess();
this.SearchProcess();
this.groupBoxProcess.Enabled = false;
}
}
else
{
MessageBox.Show("Duplicate Process Sub Name.", "Stop", MessageBoxButtons.OK, MessageBoxIcon.Stop);
return;
}
}
public bool UpdateProccessStatus(ProcessSubProperty dataItem)
{
bool _result = false;
try
{
_resultData = _models.UpdateProccessStatus(dataItem);
if (_resultData.StatusOnDb == true)
{
MessageBox.Show(_resultData.MessageOnDb, "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
_result = true;
}
else
{
MessageBox.Show(_resultData.MessageOnDb, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(_result);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(_result);
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (this.txtUpdate.Text == "")
{
MessageBox.Show("Please Select Process", "Stop", MessageBoxButtons.OK, MessageBoxIcon.Stop);
return;
}
if (this.cmbStatus.Text == "")
{
MessageBox.Show("Please Select Status", "Stop", MessageBoxButtons.OK, MessageBoxIcon.Stop);
return;
}
_processUpdateStatus = new ProcessSubProperty()
{
SUB_PROCESS_NAME = this.txtUpdate.Text
,
INUSE = this.cmbStatus.Text
};
if (_processUpdateStatus.SUB_PROCESS_NAME == "" || _processUpdateStatus.SUB_PROCESS_NAME == null ||
_processUpdateStatus.INUSE == "" || _processUpdateStatus.INUSE == null)
{
MessageBox.Show("Not found Process ", "Stop", MessageBoxButtons.OK, MessageBoxIcon.Stop);
return;
}
string oldStatus = _processUpdateStatus.INUSE == "Use" ? "1" : "0";
string newStatus = this.cmbStatus.Text == "Cancel" ? "1" : "0";
if (oldStatus == newStatus)
{
MessageBox.Show("Current status", "Stop", MessageBoxButtons.OK, MessageBoxIcon.Stop);
return;
}
string _textStatus = this.cmbStatus.Text;
int _indexStatus = this.cmbStatus.FindString(_textStatus);
if (_indexStatus >= 0)
{
_processUpdateStatus.INUSE = this.cmbStatus.Text == "Use" ? "1" : "0";
_processUpdateStatus.PROCESS_ID = (cmbMainProcess.SelectedItem as ComboboxItem).Value.ToString();
_processUpdateStatus.LAST_USER = _frmMain._empLogin.code;
// _currentCondition.EMP = frmMain._empLogin;
if (_processSubController.UpdateProccessStatus(_processUpdateStatus))
{
this.SetPage();
//this.ResetUpdateStatusProcess();
this.LoadProcess();
this.SearchProcess();
this.groupBoxProcess.Enabled = false;
}
}
else
{
MessageBox.Show("Not found Status", "Stop", MessageBoxButtons.OK, MessageBoxIcon.Stop);
return;
}
}
public OutputOnDbProperty SearchProcessSubByProcessMainId(ProcessSubProperty dataItem)
{
_resultData = _services.SearchProcessSubByProcessMainId(dataItem);
return(_resultData);
}
public OutputOnDbProperty UpdateProccessStatus(ProcessSubProperty dataItem)
{
_resultData = _services.UpdateProccessStatus(dataItem);
return(_resultData);
}
public OutputOnDbProperty InsertProcessSub(ProcessSubProperty dataItem)
{
_resultData = _services.InsertProcessSub(dataItem);
return(_resultData);
}
