public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
TranferRequestVo inVo = (TranferRequestVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <TranferRequestVo> voList = new ValueObjectList <TranferRequestVo>();
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, string.Empty);
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"select distinct vcb_functiondept_name
from vcb_functiondept order by vcb_functiondept_name " );
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
TranferRequestVo outVo = new TranferRequestVo
{
FunctionDeptName = dataReader["vcb_functiondept_name"].ToString()
};
voList.add(outVo);
}
dataReader.Close();
return(voList);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
TranferRequestVo inVo = (TranferRequestVo)vo;
StringBuilder sql = new StringBuilder();
sql.Append("insert into vcb_trasfer_request(vcb_code_request, vcb_functiondept_id_request, vcb_datetime_request,vcb_header_request, vcb_contents_request,vcb_statuscheck_process,vcb_comments_process,vcb_datetime_process ) ");
sql.Append(" select :vcb_code_request, (select vcb_functiondept_id from vcb_functiondept where user_name = :user_name), now(), :vcb_header_request, :vcb_contents_request, :vcb_statuscheck_process, :vcb_comments_process, now() ");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("vcb_code_request", inVo.RequestCode);
sqlParameter.AddParameterString("user_name", inVo.UserNameRequest);
// sqlParameter.AddParameterInteger("vcb_functiondept_id_request", inVo.FunctionDeptRequestId);
sqlParameter.AddParameterString("vcb_header_request", inVo.RequestHeader);
sqlParameter.AddParameterString("vcb_contents_request", inVo.RequestContents);
sqlParameter.AddParameter("vcb_statuscheck_process", inVo.ProcessStatusCheck);
sqlParameter.AddParameterString("vcb_comments_process", inVo.ProcessComments);
//execute SQL
TranferRequestVo outVo = new TranferRequestVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
TranferRequestVo inVo = (TranferRequestVo)vo;
StringBuilder sql = new StringBuilder();
sql.Append("update vcb_trasfer_request set vcb_statuscheck_process =:vcb_statuscheck_process, vcb_comments_process =:vcb_comments_process, vcb_datetime_process = now() ");
sql.Append(" where vcb_id_request =:vcb_id_request");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameter("vcb_statuscheck_process", inVo.ProcessStatusCheck);
sqlParameter.AddParameterString("vcb_comments_process", inVo.ProcessComments);
sqlParameter.AddParameterInteger("vcb_id_request", inVo.RequestId);
//execute SQL
TranferRequestVo outVo = new TranferRequestVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
private void Delete_btn_Click(object sender, EventArgs e)
{
if (TranferRequest_dgv.RowCount > 0 && TranferRequest_dgv.DataSource != null)
{
try
{
int rowIndex = TranferRequest_dgv.CurrentCell.RowIndex;
string user = TranferRequest_dgv.Rows[rowIndex].Cells["colUserNameRequest"].Value.ToString();
if (user == UserData.GetUserData().UserName)
{
if (MessageBox.Show("Do you want to delete this rows !", "Thông báo", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
{
TranferRequestVo transfervo = (TranferRequestVo)TranferRequest_dgv.CurrentRow.DataBoundItem;
TranferRequestVo outVo = (TranferRequestVo)DefaultCbmInvoker.Invoke(new DeleteTransferRequestCbm(), transfervo);
if (outVo.AffectedCount > 0)
{
messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, "Error");
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
}
Search_btn_Click(sender, e);
}
}
else
{
MessageBox.Show("Bạn không có quyền xóa dòng này !", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
TranferRequestVo inVo = (TranferRequestVo)vo;
StringBuilder sql = new StringBuilder();
TranferRequestVo voList = new TranferRequestVo();
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, string.Empty);
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"select Case when Max(vcb_code_request) is null then 1 else Max(vcb_code_request) + 1 end maxcode from vcb_tranfer_list ");
//create command
//DbCommandAdaptor
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
TranferRequestVo outVo = new TranferRequestVo
{
RequestCode = int.Parse(dataReader["maxcode"].ToString())
};
voList.RequestCode = outVo.RequestCode;
}
dataReader.Close();
return(voList);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
TranferRequestVo inVo = (TranferRequestVo)vo;
StringBuilder sql = new StringBuilder();
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append("delete from vcb_tranfer_list where 1=1 ");
if (inVo.RequestCode > 0)
{
sql.Append(" and vcb_code_request = :vcb_code_request ");
sqlParameter.AddParameter("vcb_code_request", inVo.RequestCode);
}
//create command
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
int t = sqlCommandAdapter.ExecuteNonQuery(sqlParameter);
TranferRequestVo outVo = new TranferRequestVo();
if (t > 0)//thuc hiên delete trong transfer khi đã delete trong list
{
StringBuilder sql_delete_transfer = new StringBuilder();
DbCommandAdaptor sqlCommandAdapter2 = base.GetDbCommandAdaptor(trxContext, sql_delete_transfer.ToString());
DbParameterList sqlParameter2 = sqlCommandAdapter2.CreateParameterList();
sql_delete_transfer.Append("delete from vcb_trasfer_request where 1=1");
sql_delete_transfer.Append(" and vcb_code_request = :vcb_code_request ");
sqlParameter2.AddParameter("vcb_code_request", inVo.RequestCode);
sqlCommandAdapter2 = base.GetDbCommandAdaptor(trxContext, sql_delete_transfer.ToString());
outVo.AffectedCount = sqlCommandAdapter2.ExecuteNonQuery(sqlParameter2);
}
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
TranferRequestVo inVo = (TranferRequestVo)vo;
StringBuilder sql = new StringBuilder();
sql.Append("insert into vcb_tranfer_list(vcb_functiondept_id, vcb_code_request, vcb_type_list) ");
sql.Append("values(:vcb_functiondept_id, :vcb_code_request, :vcb_type_list)");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("vcb_functiondept_id", inVo.FunctionDeptId);
sqlParameter.AddParameterInteger("vcb_code_request", inVo.RequestCode);
sqlParameter.AddParameterString("vcb_type_list", inVo.TypeList);
//execute SQL
TranferRequestVo outVo = new TranferRequestVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
private void Ok_btn_Click(object sender, EventArgs e)
{
for (int i = 0; i < ListUser_dgv.RowCount; i++)
{
if (ListUser_dgv.Rows[i].Cells["colType"].Value.ToString() == "To")
{
checkTo = checkTo + 1;
}
}
tranfertrquestVo = (TranferRequestVo)DefaultCbmInvoker.Invoke(new Cbm.GetMaxCodeTranferRequestCbm(), new TranferRequestVo());
if (checkdata())
{
for (int i = 0; i < ListUser_dgv.RowCount; i++)
{
TranferRequestVo outvoList = new TranferRequestVo();
TranferRequestVo invoList = new TranferRequestVo()
{
RequestCode = tranfertrquestVo.RequestCode,
FunctionDeptId = int.Parse(ListUser_dgv.Rows[i].Cells["colIdfunctiondept"].Value.ToString()),
TypeList = ListUser_dgv.Rows[i].Cells["colType"].Value.ToString(),
};
outvoList = (TranferRequestVo)DefaultCbmInvoker.Invoke(new Cbm.AddTranferListCbm(), invoList);
}
TranferRequestVo outvoTranfer = new TranferRequestVo();
TranferRequestVo invoTranfer = new TranferRequestVo()
{
RequestCode = tranfertrquestVo.RequestCode,
UserNameRequest = UserData.GetUserData().UserName,
//FunctionDeptRequestId = 0 ,
RequestHeader = headerinfo_txt.Text,
RequestContents = contentinfo_txt.Text,
ProcessStatusCheck = false,
ProcessComments = "",
};
outvoTranfer = (TranferRequestVo)DefaultCbmInvoker.Invoke(new Cbm.AddTranferRequestCbm(), invoTranfer);
if (outvoTranfer.AffectedCount > 0)
{
messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, " Header Mail: " + headerinfo_txt.Text);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
DeptCode_cmb.Text = "";
FunctionCode_cmb.Text = "";
UserName_cmb.Text = "";
headerinfo_txt.Text = "";
contentinfo_txt.Text = "";
}
}
}
private void Update_btn_Click(object sender, EventArgs e)
{
if (TranferRequest_dgv.RowCount > 0 && sent_rei_cmb.Text == "Received")
{
TranferRequestVo updatevo = (TranferRequestVo)TranferRequest_dgv.CurrentRow.DataBoundItem;
if (updatevo.TypeList == "To")
{
TranferRequestVo update = (TranferRequestVo)DefaultCbmInvoker.Invoke(new UpdateTransferVCBCbm(), updatevo);
}
}
else
{
MessageBox.Show("Bạn không có quyền Update dòng này !", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void GridBind()
{
try
{
TranferRequestVo invo = new TranferRequestVo()
{
FunctionDeptName = function_cmb.Text,
DepartmentName = department_cbm.Text,
SentReceive = sent_rei_cmb.Text,
};
ValueObjectList <TranferRequestVo> listvo = (ValueObjectList <TranferRequestVo>)DefaultCbmInvoker.Invoke(new Cbm.SearchTranferRequestVCBCbm(), invo);
TranferRequest_dgv.DataSource = listvo.GetList();
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
}
void requestcode()
{
tranfertrquestVo = (TranferRequestVo)DefaultCbmInvoker.Invoke(new Cbm.GetMaxCodeTranferRequestCbm(), new TranferRequestVo());
string datetime = DateTime.Now.ToString("yyMMdd");
string requestcodefull = DeptCode_cmb.Text + "_" + datetime + "_" + (tranfertrquestVo.RequestCode).ToString();
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
TranferRequestVo inVo = (TranferRequestVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <TranferRequestVo> voList = new ValueObjectList <TranferRequestVo>();
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, string.Empty);
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"select a.vcb_id_request,a.vcb_code_request, b.user_name, c.vcb_department_name, a.vcb_datetime_request, e.user_name user_process,e.vcb_functiondept_name, d.vcb_type_list, a.vcb_header_request, a.vcb_contents_request, a.vcb_statuscheck_process, a.vcb_comments_process, a.vcb_datetime_process
from vcb_trasfer_request a
left join vcb_functiondept b on a.vcb_functiondept_id_request = b.vcb_functiondept_id
left join vcb_department c on b.vcb_department_id = c.vcb_department_id
left join vcb_tranfer_list d on d.vcb_code_request = a.vcb_code_request
left join vcb_functiondept e on e.vcb_functiondept_id = d.vcb_functiondept_id where 1=1 " );
if (!string.IsNullOrEmpty(inVo.FunctionDeptName))
{
sql.Append(" and e.vcb_functiondept_name = :vcb_functiondept_name ");
sqlParameter.AddParameterString("vcb_functiondept_name", inVo.FunctionDeptName);
}
if (!string.IsNullOrEmpty(inVo.DepartmentName))
{
sql.Append(" and c.vcb_department_name = :vcb_department_name ");
sqlParameter.AddParameterString("vcb_department_name", inVo.DepartmentName);
}
if (!string.IsNullOrEmpty(inVo.SentReceive))
{
if (inVo.SentReceive == "Sent")//sent
{
sql.Append(" and b.user_name = '" + UserData.GetUserData().UserName + "'");
}
else if (inVo.SentReceive == "Received")//receive
{
sql.Append(" and e.user_name = '" + UserData.GetUserData().UserName + "'");
}
}
sql.Append(" order by a.vcb_code_request desc, d.vcb_type_list !='To' ");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
TranferRequestVo outVo = new TranferRequestVo
{
RequestId = int.Parse(dataReader["vcb_id_request"].ToString()),
RequestCode = int.Parse(dataReader["vcb_code_request"].ToString()),
UserNameRequest = dataReader["user_name"].ToString(),
DepartmentName = dataReader["vcb_department_name"].ToString(),
RequestDateTime = DateTime.Parse(dataReader["vcb_datetime_request"].ToString()),
UserNameProcess = dataReader["user_process"].ToString(),
FunctionDeptName = dataReader["vcb_functiondept_name"].ToString(),
TypeList = dataReader["vcb_type_list"].ToString(),
RequestHeader = dataReader["vcb_header_request"].ToString(),
RequestContents = dataReader["vcb_contents_request"].ToString(),
ProcessStatusCheck = Convert.ToBoolean(dataReader["vcb_statuscheck_process"]),
ProcessComments = dataReader["vcb_comments_process"].ToString(),
ProcessDateTime = DateTime.Parse(dataReader["vcb_datetime_process"].ToString())
};
voList.add(outVo);
}
dataReader.Close();
return(voList);
}
