/// <summary>
/// Fills all user records to gridview control
/// </summary>
private void GridBind(ProcessWorkLocalSupplierVo conditionInVo)
{
ProcessWork_dgv.DataSource = null;
try
{
ProcessWorkLocalSupplierVo outVo = (ProcessWorkLocalSupplierVo)base.InvokeCbm(new GetProcessWorkLocalSupplierMasterMntCbm(), conditionInVo, false);
ProcessWork_dgv.AutoGenerateColumns = false;
outVo.ProcessWorkLocalSupplierListVo.ForEach(t => t.IsExists = t.LocalSupplierId > 0 ? "True" : "False");
BindingSource bindingSource1 = new BindingSource(outVo.ProcessWorkLocalSupplierListVo, null);
if (bindingSource1.Count > 0)
{
ProcessWork_dgv.DataSource = bindingSource1;
}
else
{
messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null); //item process work
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
}
ProcessWork_dgv.ClearSelection();
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
ProcessWorkLocalSupplierVo inVo = (ProcessWorkLocalSupplierVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Delete from m_process_work_local_supplier");
sqlQuery.Append(" Where ");
sqlQuery.Append(" local_supplier_id = :suppid ");
sqlQuery.Append(" and ");
sqlQuery.Append(" process_work_id = :workid ");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("suppid", inVo.LocalSupplierId);
sqlParameter.AddParameterInteger("workid", inVo.ProcessWorkId);
ProcessWorkLocalSupplierVo outVo = new ProcessWorkLocalSupplierVo {
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
ProcessWorkLocalSupplierVo inVo = (ProcessWorkLocalSupplierVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Select");
sqlQuery.Append(" pw.process_work_id,");
sqlQuery.Append(" pw.process_work_name,");
sqlQuery.Append(" t.local_supplier_id");
sqlQuery.Append(" from m_process_work pw ");
sqlQuery.Append(" left join ");
sqlQuery.Append(" (select pws.process_work_id, pws.local_supplier_id from m_process_work_local_supplier pws ");
sqlQuery.Append(" inner join m_local_supplier ls on ls.local_supplier_id = pws.local_supplier_id ");
sqlQuery.Append(" where pws.local_supplier_id = :localsupplierid ) t ");
sqlQuery.Append(" on t.process_work_id = pw.process_work_id ");
//if (inVo.LocalSupplierId > 0)
//{
// sqlQuery.Append(" and pws.local_supplier_id = :localsupplierid");
//}
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
if (inVo.LocalSupplierId > 0)
{
sqlParameter.AddParameterInteger("localsupplierid", inVo.LocalSupplierId);
}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
ProcessWorkLocalSupplierVo outVo = new ProcessWorkLocalSupplierVo();
while (dataReader.Read())
{
ProcessWorkLocalSupplierVo currOutVo = new ProcessWorkLocalSupplierVo
{
LocalSupplierId = Convert.ToInt32(DBDataCheckHelper.ConvertDBNullToStringNull(dataReader["local_supplier_id"])),
ProcessWorkId = Convert.ToInt32(dataReader["process_work_id"]),
ProcessWorkName = dataReader["process_work_name"].ToString(),
};
outVo.ProcessWorkLocalSupplierListVo.Add(currOutVo);
}
dataReader.Close();
return(outVo);
}
/// <summary>
/// updates process work local supplier
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Update_btn_Click(object sender, EventArgs e)
{
try
{
ProcessWorkLocalSupplierVo outVo;
Cursor.Current = Cursors.WaitCursor;
if (CheckMandatory() && ProcessWork_dgv.RowCount > 0)
{
foreach (DataGridViewRow row in ProcessWork_dgv.Rows)
{
outVo = new ProcessWorkLocalSupplierVo();
ProcessWorkLocalSupplierVo checkInVo = new ProcessWorkLocalSupplierVo
{
LocalSupplierId = Convert.ToInt32(Supplier_cmb.SelectedValue.ToString())
};
ProcessWorkLocalSupplierVo checkOutVo = (ProcessWorkLocalSupplierVo)base.InvokeCbm(new GetProcessWorkLocalSupplierMasterMntCbm(), checkInVo, false);
bool isExists = checkOutVo.ProcessWorkLocalSupplierListVo.Any(t => t.LocalSupplierId > 0 && t.ProcessWorkId == Convert.ToInt32(row.Cells["colProcessWorkId"].Value.ToString()));
ProcessWorkLocalSupplierVo processWorkSupInVo = new ProcessWorkLocalSupplierVo
{
LocalSupplierId = Convert.ToInt32(Supplier_cmb.SelectedValue.ToString()),
ProcessWorkId = Convert.ToInt32(row.Cells["colProcessWorkId"].Value.ToString()),
RegistrationUserCode = UserData.GetUserData().UserCode,
FactoryCode = UserData.GetUserData().FactoryCode
};
if (row.Cells["colSelect"].Value.ToString() == "True" && !isExists)
{
outVo = (ProcessWorkLocalSupplierVo)base.InvokeCbm(new AddProcessWorkLocalSupplierMasterMntCbm(), processWorkSupInVo, false);
}
else if (row.Cells["colSelect"].Value.ToString() == "False" && isExists)
{
outVo = (ProcessWorkLocalSupplierVo)base.InvokeCbm(new DeleteProcessWorkLocalSupplierMasterMntCbm(), processWorkSupInVo, false);
}
}
Cursor.Current = Cursors.Default;
messageData = new MessageData("mmci00002", Properties.Resources.mmci00002, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
Cursor.Current = Cursors.WaitCursor;
GridBind(FormConditionVo());
Cursor.Current = Cursors.Default;
}
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
}
/// <summary>
/// Creates seacrh condition as per user inputs
/// </summary>
/// <returns>search condition</returns>
private ProcessWorkLocalSupplierVo FormConditionVo()
{
ProcessWorkLocalSupplierVo inVo = new ProcessWorkLocalSupplierVo();
if (Supplier_cmb.SelectedIndex > -1)
{
inVo.LocalSupplierId = Convert.ToInt32(Supplier_cmb.SelectedValue);
}
return(inVo);
}
/// <summary>
/// Get with processwork
/// </summary>
private void LoadProcessWork()
{
ProcessWorkLocalSupplierVo prWLSInVo = new ProcessWorkLocalSupplierVo();
prWLSInVo.LocalSupplierId = Convert.ToInt32(Supplier_cmb.SelectedValue);
ProcessWorkLocalSupplierVo prWLSOutVo = new ProcessWorkLocalSupplierVo();
try
{
prWLSOutVo = (ProcessWorkLocalSupplierVo)base.InvokeCbm(new GetProcessWorkLocalSupplierMasterMntCbm(), prWLSInVo, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
ProcessWorkLocalSupplierVo inVo = (ProcessWorkLocalSupplierVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Insert into m_process_work_local_supplier");
sqlQuery.Append(" ( ");
sqlQuery.Append(" local_supplier_id, ");
sqlQuery.Append(" process_work_id, ");
sqlQuery.Append(" registration_user_cd, ");
sqlQuery.Append(" registration_date_time, ");
sqlQuery.Append(" factory_cd ");
sqlQuery.Append(" ) ");
sqlQuery.Append("VALUES ");
sqlQuery.Append(" ( ");
sqlQuery.Append(" :localsuppid ,");
sqlQuery.Append(" :processworkid ,");
sqlQuery.Append(" :registrationusercode ,");
sqlQuery.Append(" now() ,");
sqlQuery.Append(" :factorycode ");
sqlQuery.Append(" ); ");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("localsuppid", inVo.LocalSupplierId);
sqlParameter.AddParameterInteger("processworkid", inVo.ProcessWorkId);
sqlParameter.AddParameterString("registrationusercode", inVo.RegistrationUserCode);
sqlParameter.AddParameterString("factorycode", inVo.FactoryCode);
ProcessWorkLocalSupplierVo outVo = new ProcessWorkLocalSupplierVo {
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
