public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
DefectiveReasonVo inVo = (DefectiveReasonVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Update m_defective_reason");
sqlQuery.Append(" Set ");
sqlQuery.Append(" defective_reason_name = :defectivereasonname, ");
sqlQuery.Append(" defective_category_id = :defectivecategoryid, ");
sqlQuery.Append(" display_order = :displayorder");
sqlQuery.Append(" Where ");
sqlQuery.Append(" defective_reason_id = :defectivereasonid ");
sqlQuery.Append(" and factory_cd = :faccd ;");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("defectivereasonid", inVo.DefectiveReasonId);
sqlParameter.AddParameterString("defectivereasonname", inVo.DefectiveReasonName);
sqlParameter.AddParameterInteger("defectivecategoryid", inVo.DefectiveCategoryId);
sqlParameter.AddParameterInteger("displayorder", inVo.DisplayOrder);
sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode);
DefectiveReasonVo outVo = new DefectiveReasonVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
DefectiveReasonVo inVo = (DefectiveReasonVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Delete From m_defective_reason");
sqlQuery.Append(" Where ");
sqlQuery.Append(" defective_reason_id = :defectivereasonid ;");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("defectivereasonid", inVo.DefectiveReasonId);
DefectiveReasonVo outVo = new DefectiveReasonVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
DefectiveReasonVo inVo = (DefectiveReasonVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <DefectiveReasonVo> voList = new ValueObjectList <DefectiveReasonVo>();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append("SELECT a.defective_reason_id, a.defective_reason_name FROM m_defective_reason a LEFT JOIN m_cause b ON b.defective_reason_id = a.defective_reason_id LEFT JOIN m_machine c ON c.machine_id = b.machine_id WHERE machine_name = :machine_name ORDER BY defective_reason_id");
sqlParameter.AddParameterString("machine_name", inVo.DefectiveReasonCode);
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
DefectiveReasonVo outVo = new DefectiveReasonVo
{
DefectiveReasonId = int.Parse(dataReader["defective_reason_id"].ToString()),
DefectiveReasonName = dataReader["defective_reason_name"].ToString()
};
voList.add(outVo);
}
dataReader.Close();
return(voList);
}
/// <summary>
/// selects user record for updation and show user form
/// </summary>
private void BindUpdateUserData()
{
int selectedrowindex = DefectiveReason_dgv.SelectedCells[0].RowIndex;
DefectiveReasonVo selectedData = (DefectiveReasonVo)DefectiveReason_dgv.Rows[selectedrowindex].DataBoundItem;
AddDefectiveReasonNewForm newAddForm = new AddDefectiveReasonNewForm(CommonConstants.MODE_UPDATE, selectedData);
newAddForm.ShowDialog(this);
if (newAddForm.IntSuccess > 0)
{
messageData = new MessageData("mmci00002", Properties.Resources.mmci00002, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
GridBind(FormConditionVo());
}
else if (newAddForm.IntSuccess == 0)
{
messageData = new MessageData("mmci00007", Properties.Resources.mmci00007, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
GridBind(FormConditionVo());
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
DefectiveReasonVo inVo = (DefectiveReasonVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <DefectiveReasonVo> voList = new ValueObjectList <DefectiveReasonVo>();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"SELECT b.defective_reason_id, b.defective_reason_name from m_defective_reason b, m_ncvp_cause a where a.defective_reason_id = b.defective_reason_id and machine_id = :machine_id order by display_order");
sqlParameter.AddParameterInteger("machine_id", inVo.DefectiveReasonId);
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
DefectiveReasonVo outVo = new DefectiveReasonVo
{
DefectiveReasonId = int.Parse(dataReader["defective_reason_id"].ToString()),
DefectiveReasonName = dataReader["defective_reason_name"].ToString()
};
voList.add(outVo);
}
dataReader.Close();
return(voList);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Select max(display_order)+1 display_order ");
sqlQuery.Append(" from m_defective_reason dr ");
sqlQuery.Append(" Where dr.factory_cd = :faccd ;");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode);
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
DefectiveReasonVo outVo = null;
while (dataReader.Read())
{
outVo = new DefectiveReasonVo();
outVo.DisplayOrder = ConvertDBNull <int>(dataReader, "display_order");
}
dataReader.Close();
return(outVo);
}
/// <summary>
/// event to delete the selected record
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Delete_btn_Click(object sender, EventArgs e)
{
int selectedrowindex = DefectiveReason_dgv.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = DefectiveReason_dgv.Rows[selectedrowindex];
messageData = new MessageData("mmcc00004", Properties.Resources.mmcc00004, selectedRow.Cells["colDefectiveReasonCode"].Value.ToString());
logger.Info(messageData);
DialogResult dialogResult = popUpMessage.ConfirmationOkCancel(messageData, Text);
if (dialogResult == DialogResult.OK)
{
DefectiveReasonVo inVo = new DefectiveReasonVo();
inVo.DefectiveReasonId = Convert.ToInt32(selectedRow.Cells["colDefectiveReasonId"].Value);
try
{
inVo.DefectiveReasonCode = selectedRow.Cells["colDefectiveReasonCode"].Value.ToString();
DefectiveReasonVo tableCount = CheckDefectiveRelation(inVo);
if (tableCount.AffectedCount > 0)
{
messageData = new MessageData("mmce00007", Properties.Resources.mmce00007, DefectiveReason.ToString());
popUpMessage.Information(messageData, Text);
return;
}
DefectiveReasonVo outVo = (DefectiveReasonVo)base.InvokeCbm(new DeleteDefectiveReasonMasterMntCbm(), inVo, false);
if (outVo.AffectedCount > 0)
{
messageData = new MessageData("mmci00003", Properties.Resources.mmci00003, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
GridBind(FormConditionVo());
}
else if (outVo.AffectedCount == 0)
{
messageData = new MessageData("mmci00007", Properties.Resources.mmci00007, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
GridBind(FormConditionVo());
}
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
}
else if (dialogResult == DialogResult.Cancel)
{
//do something else
}
}
/// <summary>
/// For setting selected user record into respective controls(textbox and combobox) for update operation
/// passing selected user data as parameter
/// </summary>
/// <param name="dgvData"></param>
private void LoadUserData(DefectiveReasonVo dgvData)
{
if (dgvData != null)
{
DefectiveReasonCode_txt.Text = dgvData.DefectiveReasonCode;
DefectiveReasonName_txt.Text = dgvData.DefectiveReasonName;
DefectiveCategory_cmb.SelectedValue = dgvData.DefectiveCategoryId.ToString();
DisplayOrder_txt.Text = dgvData.DisplayOrder.ToString();
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
DefectiveReasonVo inVo = (DefectiveReasonVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Insert into m_defective_reason");
sqlQuery.Append(" ( ");
sqlQuery.Append(" defective_reason_cd, ");
sqlQuery.Append(" defective_reason_name, ");
sqlQuery.Append(" defective_category_id, ");
sqlQuery.Append(" display_order, ");
sqlQuery.Append(" registration_user_cd, ");
sqlQuery.Append(" registration_date_time, ");
sqlQuery.Append(" factory_cd ");
sqlQuery.Append(" ) ");
sqlQuery.Append("VALUES ");
sqlQuery.Append(" ( ");
sqlQuery.Append(" :defectivereasoncd ,");
sqlQuery.Append(" :defectivereasonname ,");
sqlQuery.Append(" :defectivecategoryid ,");
sqlQuery.Append(" :displayorder,");
sqlQuery.Append(" :registrationusercode ,");
sqlQuery.Append(" :registrationdatetime ,");
sqlQuery.Append(" :factorycode ");
sqlQuery.Append(" ) ");
sqlQuery.Append(" RETURNING defective_reason_id;");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("defectivereasoncd", inVo.DefectiveReasonCode);
sqlParameter.AddParameterString("defectivereasonname", inVo.DefectiveReasonName);
sqlParameter.AddParameterInteger("defectivecategoryid", inVo.DefectiveCategoryId);
sqlParameter.AddParameterInteger("displayorder", inVo.DisplayOrder);
sqlParameter.AddParameterString("registrationusercode", UserData.GetUserData().UserCode);
sqlParameter.AddParameterDateTime("registrationdatetime", trxContext.ProcessingDBDateTime);
sqlParameter.AddParameterString("factorycode", UserData.GetUserData().FactoryCode);
//return outVo;
DefectiveReasonVo outVo = new DefectiveReasonVo();
outVo.DefectiveReasonId = (int?)sqlCommandAdapter.ExecuteScalar(sqlParameter) ?? 0;
if (outVo != null && outVo.DefectiveReasonId > 0)
{
outVo.AffectedCount = 1;
}
return(outVo);
}
/// <summary>
/// constructor for the form
/// </summary>
/// <param name="pmode"></param>
/// <param name="dataItem"></param>
public AddDefectiveReasonNewForm(string pmode, DefectiveReasonVo dataItem = null)
{
InitializeComponent();
mode = pmode;
updateData = dataItem;
if (string.Equals(mode, CommonConstants.MODE_UPDATE))
{
this.Text = UpdateText_lbl.Text;
}
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
DefectiveReasonVo deleteOutVo = (DefectiveReasonVo)deleteDefectiveReasonMasterMntCbm.Execute(trxContext, vo);
if (deleteOutVo.AffectedCount > 0)
{
ProcessDefectiveReasonVo inVo = new ProcessDefectiveReasonVo();
inVo.DefectiveReasonId = ((DefectiveReasonVo)vo).DefectiveReasonId;
ProcessDefectiveReasonVo deleteProcessDefectiveReasonOutVo = (ProcessDefectiveReasonVo)deleteProcessDefectiveReasonMasterMntCbm.Execute(trxContext, inVo);
}
return(deleteOutVo);
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void AddDefectiveReasonNewForm_Load(object sender, EventArgs e)
{
FormDatatableFromVo();
if (defectiveCategoryDatatable.Rows.Count > 0)
{
ComboBind(DefectiveCategory_cmb, defectiveCategoryDatatable, "name", "id");
}
else
{
DefectiveCategory_cmb.Enabled = false;
}
DefectiveReasonCode_txt.Select();
int defectRsnId = 0;
if (string.Equals(mode, CommonConstants.MODE_UPDATE))
{
LoadUserData(updateData);
defectRsnId = updateData.DefectiveReasonId;
DefectiveReasonCode_txt.Enabled = false;
DefectiveReasonName_txt.Select();
}
else
{
DefectiveReasonVo outVo = null;
try
{
outVo = (DefectiveReasonVo)base.InvokeCbm(new GetDefectiveReasonDisplayOrderCbm(), null, false);
}
catch (Framework.ApplicationException ex)
{
popUpMessage.ApplicationError(ex.GetMessageData(), this.TitleText);
}
if (outVo != null)
{
DisplayOrder_txt.Text = outVo.DisplayOrder.ToString();
}
else
{
DisplayOrder_txt.Text = "1";
}
}
BindGrid(defectRsnId);
}
/// <summary>
/// checks duplicate Defective reason Code
/// </summary>
/// <param name="defectVo"></param>
/// <returns></returns>
private DefectiveReasonVo DuplicateCheck(DefectiveReasonVo defectVo)
{
DefectiveReasonVo outVo = new DefectiveReasonVo();
try
{
outVo = (DefectiveReasonVo)base.InvokeCbm(new CheckDefectiveReasonMasterMntCbm(), defectVo, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
DefectiveReasonVo inVo = (DefectiveReasonVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Insert into m_defective_reason");
sqlQuery.Append(" ( ");
sqlQuery.Append(" defective_reason_cd, ");
sqlQuery.Append(" defective_reason_name, ");
sqlQuery.Append(" defective_category_id, ");
sqlQuery.Append(" display_order, ");
sqlQuery.Append(" registration_user_cd, ");
sqlQuery.Append(" registration_date_time, ");
sqlQuery.Append(" factory_cd ");
sqlQuery.Append(" ) ");
sqlQuery.Append("VALUES ");
sqlQuery.Append(" ( ");
sqlQuery.Append(" :defectivereasoncd ,");
sqlQuery.Append(" :defectivereasonname ,");
sqlQuery.Append(" :defectivecategoryid ,");
sqlQuery.Append(" :displayorder,");
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.AddParameterString("defectivereasoncd", inVo.DefectiveReasonCode);
sqlParameter.AddParameterString("defectivereasonname", inVo.DefectiveReasonName);
sqlParameter.AddParameterInteger("defectivecategoryid", inVo.DefectiveCategoryId);
sqlParameter.AddParameterInteger("displayorder", inVo.DisplayOrder);
sqlParameter.AddParameterString("registrationusercode", inVo.RegistrationUserCode);
sqlParameter.AddParameterString("factorycode", inVo.FactoryCode);
DefectiveReasonVo outVo = new DefectiveReasonVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
DefectiveReasonVo inVo = (DefectiveReasonVo)arg;
DefectiveReasonVo outVo = new DefectiveReasonVo();
StringBuilder sqlQuery = new StringBuilder();
//create SQL
sqlQuery.Append("select Count(dfr.defective_reason_cd) as DefRsnCount from m_defective_reason as dfr ");
sqlQuery.Append(" inner join m_process_work_defective_reason as pwdr on dfr.defective_reason_id = pwdr.defective_reason_id ");
sqlQuery.Append(" where dfr.factory_cd = :faccd ");
if (inVo.DefectiveReasonCode != null)
{
sqlQuery.Append(" and UPPER(defective_reason_cd) = UPPER(:defectivereasoncd)");
}
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode);
if (inVo.DefectiveReasonCode != null)
{
sqlParameter.AddParameterString("defectivereasoncd", inVo.DefectiveReasonCode);
}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
outVo.AffectedCount = 0;
while (dataReader.Read())
{
outVo.AffectedCount = Convert.ToInt32(dataReader["DefRsnCount"]);
}
dataReader.Close();
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
DefectiveReasonVo inVo = (DefectiveReasonVo)arg;
DefectiveReasonVo outVo = new DefectiveReasonVo();
StringBuilder sqlQuery = new StringBuilder();
//create SQL query
sqlQuery.Append("Select Count(*) DefRsnCount from m_defective_reason ");
sqlQuery.Append(" where factory_cd = :faccd ");
if (inVo.DisplayOrder != 0)
{
sqlQuery.Append(" and display_order = :displayorder");
}
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode);
if (inVo.DisplayOrder != 0)
{
sqlParameter.AddParameterInteger("displayorder", inVo.DisplayOrder);
}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
outVo.AffectedCount = 0;
while (dataReader.Read())
{
outVo.AffectedCount = Convert.ToInt32(dataReader["DefRsnCount"]);
}
dataReader.Close();
return(outVo);
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
List <ValueObject> inList = ((ValueObjectList <ValueObject>)vo).GetList();
DefectiveReasonVo defectiveReasonVoInVo = (DefectiveReasonVo)inList.FirstOrDefault();
ProcessDefectiveReasonVo processDefectiveReasonInVo = (ProcessDefectiveReasonVo)inList.Skip(1).FirstOrDefault();
DefectiveReasonVo defectiveReasonVoOutVo = (DefectiveReasonVo)addDefectiveReasonMasterMntCbm.Execute(trxContext, defectiveReasonVoInVo);
if (defectiveReasonVoOutVo != null && defectiveReasonVoOutVo.DefectiveReasonId > 0)
{
processDefectiveReasonInVo.DefectiveReasonId = defectiveReasonVoOutVo.DefectiveReasonId;
ProcessDefectiveReasonVo processDefectiveReasonoutVo = (ProcessDefectiveReasonVo)addProcessDefectiveReasonMasterMntNewCbm.Execute(trxContext, processDefectiveReasonInVo);
}
return(defectiveReasonVoOutVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
DefectiveReasonVo inVo = (DefectiveReasonVo)arg;
DefectiveReasonVo outVo = new DefectiveReasonVo();
StringBuilder sqlQuery = new StringBuilder();
//create SQL
sqlQuery.Append("Select Count(*) DefRsnCount from m_defective_reason ");
sqlQuery.Append(" where 1 = 1 ");
if (inVo.DefectiveReasonCode != null)
{
sqlQuery.Append(" and UPPER(defective_reason_cd) = UPPER(:defectivereasoncd)");
}
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
if (inVo.DefectiveReasonCode != null)
{
sqlParameter.AddParameterString("defectivereasoncd", inVo.DefectiveReasonCode);
}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
outVo.AffectedCount = 0;
while (dataReader.Read())
{
outVo.AffectedCount = Convert.ToInt32(dataReader["DefRsnCount"]);
}
dataReader.Close();
return(outVo);
}
/// <summary>
/// Creates seacrh condition as per user inputs
/// </summary>
/// <returns>search condition</returns>
private DefectiveReasonVo FormConditionVo()
{
DefectiveReasonVo inVo = new DefectiveReasonVo();
if (DefectiveReasonCode_txt.Text != string.Empty)
{
inVo.DefectiveReasonCode = DefectiveReasonCode_txt.Text;
}
if (DefectiveReasonName_txt.Text != string.Empty)
{
inVo.DefectiveReasonName = DefectiveReasonName_txt.Text;
}
if (DefectiveCategory_cmb.SelectedIndex > -1)
{
inVo.DefectiveCategoryId = Convert.ToInt32(DefectiveCategory_cmb.SelectedValue);
}
return(inVo);
}
private void CauseMasterForm_Load(object sender, EventArgs e)
{
try
{
DefectiveReasonVo defectiveReasonvo = (DefectiveReasonVo)DefaultCbmInvoker.Invoke(getDefectiveReasonMasterMntCmb, new DefectiveReasonVo());
foreach (DefectiveReasonVo vo in defectiveReasonvo.DefectiveReasonListVo)
{
cause.Add(new Cause {
dvo = vo, Selected = false, CauseId = 0
});
}
BindingSource bds = new BindingSource(cause, null);
Cause_dgv.DataSource = bds;
MachineVo machinelist = (MachineVo)DefaultCbmInvoker.Invoke(getMachineMasterMntCbm, new MachineVo());
MachineName_cmb.DisplayMember = "MachineName";
MachineName_cmb.DataSource = machinelist.MachineListVo;
MachineName_cmb.SelectedIndex = -1;
}
catch { } //gfg
}
/// <summary>
/// Fills all user records to gridview control
/// </summary>
private void GridBind(DefectiveReasonVo conditionInVo)
{
DefectiveReason_dgv.DataSource = null;
isExcelUpload = false;
try
{
DefectiveReasonVo outVo = (DefectiveReasonVo)base.InvokeCbm(new GetDefectiveReasonMasterMntCbm(), conditionInVo, false);
DefectiveReason_dgv.AutoGenerateColumns = false;
BindingSource bindingSource1 = new BindingSource(outVo.DefectiveReasonListVo, null);
if (bindingSource1 != null && bindingSource1.Count > 0)
{
DefectiveReason_dgv.DataSource = bindingSource1;
}
else
{
messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null); //"defective reason"
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
}
DefectiveReason_dgv.ClearSelection();
DefectiveReason_dgv.Columns["colRemarks"].Visible = false;
Update_btn.Enabled = false;
Delete_btn.Enabled = false;
AddExcel_btn.Enabled = false;
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
List <ValueObject> inList = ((ValueObjectList <ValueObject>)vo).GetList();
DefectiveReasonVo defectiveReasonVoInVo = (DefectiveReasonVo)inList.FirstOrDefault();
ProcessDefectiveReasonVo processDefectiveReasonVoInVo = (ProcessDefectiveReasonVo)inList.Skip(1).FirstOrDefault();
DefectiveReasonVo defectiveReasonVoOutVo = (DefectiveReasonVo)updateDefectiveReasonMasterMntCbm.Execute(trxContext, defectiveReasonVoInVo);
if (defectiveReasonVoOutVo.AffectedCount > 0)
{
processDefectiveReasonVoInVo.DefectiveReasonId = defectiveReasonVoInVo.DefectiveReasonId;
ProcessDefectiveReasonVo deleteInVo = new ProcessDefectiveReasonVo();
deleteInVo.DefectiveReasonId = defectiveReasonVoInVo.DefectiveReasonId;
ProcessDefectiveReasonVo deleteOutVo = (ProcessDefectiveReasonVo)deleteProcessDefectiveReasonMasterMntCbm.Execute(trxContext, deleteInVo);
ProcessDefectiveReasonVo ProcessDefectiveReasonoutVo = (ProcessDefectiveReasonVo)addProcessDefectiveReasonMasterMntNewCbm.Execute(trxContext, processDefectiveReasonVoInVo);
}
return(defectiveReasonVoOutVo);
}
/// <summary>
/// inserts/updates def reason
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Ok_btn_Click(object sender, EventArgs e)
{
DefectiveReasonVo inVo = new DefectiveReasonVo();
if (CheckMandatory())
{
//var sch = StringCheckHelper.GetInstance();
//if (string.IsNullOrEmpty(DefectiveReasonCode_txt.Text) || string.IsNullOrEmpty(DefectiveReasonName_txt.Text))
//{
// messageData = new MessageData("mmce00003", Properties.Resources.mmce00003);
// logger.Info(messageData);
// popUpMessage.ConfirmationOkCancel(messageData, Text);
// if (string.IsNullOrEmpty(DefectiveReasonCode_txt.Text))
// {
// DefectiveReasonCode_txt.Focus();
// }
// else
// {
// DefectiveReasonName_txt.Focus();
// }
// return;
//}
inVo.DefectiveReasonCode = DefectiveReasonCode_txt.Text.Trim();
inVo.DefectiveReasonName = DefectiveReasonName_txt.Text.Trim();
inVo.DefectiveCategoryId = Convert.ToInt32(DefectiveCategory_cmb.SelectedValue);
inVo.DisplayOrder = Convert.ToInt32(DisplayOrder_txt.Text);
inVo.RegistrationUserCode = UserData.GetUserData().UserCode;
inVo.FactoryCode = UserData.GetUserData().FactoryCode;
if (string.Equals(mode, CommonConstants.MODE_ADD))
{
DefectiveReasonVo checkVo = DuplicateCheck(inVo);
if (checkVo != null && checkVo.AffectedCount > 0)
{
messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, DefectiveReasonCode_lbl.Text + " : " + DefectiveReasonCode_txt.Text);
logger.Info(messageData);
popUpMessage.ConfirmationOkCancel(messageData, Text);
DefectiveReasonCode_txt.Focus();
return;
}
DefectiveReasonVo checkDisplayVo = DuplicateDisplayCheck(inVo);
if (checkDisplayVo != null && checkDisplayVo.AffectedCount > 0)
{
messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, DisplayOrder_lbl.Text + " : " + DisplayOrder_txt.Text);
logger.Info(messageData);
popUpMessage.ConfirmationOkCancel(messageData, Text);
DisplayOrder_txt.Focus();
return;
}
}
if (string.Equals(mode, CommonConstants.MODE_UPDATE))
{
//if (updateData.DisplayOrder != Convert.ToInt32(DisplayOrder_txt.Text))
// {
// DefectiveReasonVo checkDisplayVo = DuplicateDisplayCheck(inVo);
// if (checkDisplayVo != null && checkDisplayVo.AffectedCount > 0)
// {
// messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, DisplayOrder_lbl.Text + " : " + DisplayOrder_txt.Text);
// logger.Info(messageData);
// popUpMessage.ConfirmationOkCancel(messageData, Text);
// DisplayOrder_txt.Focus();
// return;
// }
//}
}
try
{
if (string.Equals(mode, CommonConstants.MODE_ADD))
{
DefectiveReasonVo outVo = (DefectiveReasonVo)base.InvokeCbm(new AddDefectiveReasonMasterMntCbm(), inVo, false);
IntSuccess = outVo.AffectedCount;
}
else if (mode.Equals(CommonConstants.MODE_UPDATE))
{
inVo.DefectiveReasonId = updateData.DefectiveReasonId;
DefectiveReasonVo outVo = (DefectiveReasonVo)base.InvokeCbm(new UpdateDefectiveReasonMasterMntCbm(), inVo, false);
IntSuccess = outVo.AffectedCount;
}
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
if ((IntSuccess > 0) || (IntSuccess == 0))
{
this.Close();
}
}
}
/// <summary>
/// save excel data to DB
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void AddExcel_btn_Click(object sender, EventArgs e)
{
if (DefectiveReason_dgv.RowCount > 0 && DefectiveReason_dgv.Columns["colRemarks"].Visible == true)
{
bool isRemarksNG = false;
foreach (DataGridViewRow row in DefectiveReason_dgv.Rows)
{
if (DefectiveReason_dgv["colRemarks", row.Index].Value != null &&
!string.IsNullOrWhiteSpace(DefectiveReason_dgv["colRemarks", row.Index].Value.ToString()))
{
row.Cells["colRemarks"].Style.ForeColor = Color.Red;
isRemarksNG = true;
}
}
if (isRemarksNG)
{
messageData = new MessageData("mmci00015", Properties.Resources.mmci00015, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
return;
}
string previousReasonCode = string.Empty;
int uploadedCount = 0;
int insertedCount = 0;
DefectiveReasonVo defectiveReasonInVo = new DefectiveReasonVo();
ProcessDefectiveReasonVo processDefectiveReasonInVo = new ProcessDefectiveReasonVo();
if (processWorkList.Count == 0)
{
GetProcessWork();
}
this.StartProgress(Properties.Resources.mmci00009);
foreach (DataRow row in excelUploadDt.Rows)
{
if (!string.IsNullOrEmpty(row["DefectiveReasonCode"].ToString()) && previousReasonCode != row["DefectiveReasonCode"].ToString())
{
defectiveReasonInVo = new DefectiveReasonVo();
processDefectiveReasonInVo = new ProcessDefectiveReasonVo();
defectiveReasonInVo.DefectiveReasonCode = row["DefectiveReasonCode"].ToString();
defectiveReasonInVo.DefectiveReasonName = row["DefectiveReasonName"].ToString();
defectiveReasonInVo.DefectiveCategoryId = 0;
defectiveReasonInVo.DisplayOrder = Convert.ToInt32(row["DisplayOrder"].ToString());
uploadedCount += 1;
DataRow[] processWorkCodeList = excelUploadDt.Select("DefectiveReasonCode = '" + defectiveReasonInVo.DefectiveReasonCode + "'");
foreach (DataRow item in processWorkCodeList)
{
ProcessDefectiveReasonVo addVo = new ProcessDefectiveReasonVo();
ProcessWorkVo processWorkVo = processWorkList.Where(t => t.ProcessWorkCode == item["ProcessWorkCode"].ToString()).FirstOrDefault();
if (processWorkVo != null && processWorkVo.ProcessWorkId > 0)
{
addVo.ProcessWorkId = processWorkList.Where(t => t.ProcessWorkCode == item["ProcessWorkCode"].ToString()).FirstOrDefault().ProcessWorkId;
processDefectiveReasonInVo.ProcessDefectiveReasonListVo.Add(addVo);
}
}
ValueObjectList <ValueObject> inVoList = new ValueObjectList <ValueObject>();
inVoList.add(defectiveReasonInVo);
inVoList.add(processDefectiveReasonInVo);
DefectiveReasonVo outVo = null;
try
{
outVo = (DefectiveReasonVo)base.InvokeCbm(new AddDefectiveReasonMasterMntNewCbm(), inVoList, false);
}
catch (Framework.ApplicationException exception)
{
this.CompleteProgress();
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
if (outVo != null && outVo.AffectedCount > 0)
{
insertedCount += outVo.AffectedCount;
}
}
previousReasonCode = row["DefectiveReasonCode"].ToString();
}
this.CompleteProgress();
if (insertedCount > 0 && uploadedCount > 0 && insertedCount == uploadedCount)
{
messageData = new MessageData("mmci00010", Properties.Resources.mmci00010, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
GridBind(FormConditionVo());
}
}
else
{
messageData = new MessageData("mmci00016", Properties.Resources.mmci00016, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
}
}
/// <summary>
/// upload excel and insert to DB
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void ExcelUpload_btn_Click(object sender, EventArgs e)
{
OpenFileDialog openDialog_dlg = new OpenFileDialog();
openDialog_dlg.Filter = "Excel Files(*.xls) |*.xls";
if (openDialog_dlg.ShowDialog() == DialogResult.OK)
{
this.StartProgress(Properties.Resources.mmci00009);
try
{
excelUploadDt = new ExcelUpload().ReadExcel(openDialog_dlg.FileName, Properties.Settings.Default.EXCEL_SHEET_DEFECTIVE_REASON);
}
catch (Framework.ApplicationException exception)
{
this.CompleteProgress();
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
DefectiveReasonVo defectiveReasonInVo = new DefectiveReasonVo();
ProcessDefectiveReasonVo processDefectiveReasonInVo = new ProcessDefectiveReasonVo();
int displayOrder = 0;
DefectiveReason_dgv.DataSource = null;
excelUploadDt.Columns.Add("Remarks");
var sch = StringCheckHelper.GetInstance();
bool inputDataNG = false;
foreach (DataRow row in excelUploadDt.Rows)
{
if (row["DefectiveReasonCode"] == null || string.IsNullOrWhiteSpace(row["DefectiveReasonCode"].ToString()))
{
row["Remarks"] = string.Format(Properties.Resources.mmce00011, DefectiveReasonCode_lbl.Text);
inputDataNG = true;
continue;
}
if (!sch.IsASCII(row["DefectiveReasonCode"].ToString()))
{
row["Remarks"] = string.Format(Properties.Resources.mmci00017, DefectiveReasonCode_lbl.Text);
inputDataNG = true;
continue;
}
var duplicates = excelUploadDt.AsEnumerable().GroupBy(r => r["DefectiveReasonCode"]).Where(gr => gr.Count() > 1).ToList();
if (duplicates.Any() && duplicates.Select(dupl => dupl.Key).ToList().FirstOrDefault().ToString() == row["DefectiveReasonCode"].ToString())
{
row["Remarks"] = string.Format(Properties.Resources.mmce00009, DefectiveReasonCode_lbl.Text + " : " + row["DefectiveReasonCode"].ToString());
inputDataNG = true;
continue;
}
if (row["DefectiveReasonName"] == null || string.IsNullOrWhiteSpace(row["DefectiveReasonName"].ToString()))
{
row["Remarks"] = string.Format(Properties.Resources.mmce00011, DefectiveReasonName_lbl.Text);
inputDataNG = true;
continue;
}
if (row["DisplayOrder"] == null || string.IsNullOrWhiteSpace(row["DisplayOrder"].ToString()))
{
row["Remarks"] = string.Format(Properties.Resources.mmce00011, colDisplayOrder.HeaderText);
inputDataNG = true;
continue;
}
if (!int.TryParse(row["DisplayOrder"].ToString(), out displayOrder) || displayOrder <= 0)
{
row["Remarks"] = string.Format(Properties.Resources.mmci00018, colDisplayOrder.HeaderText);
inputDataNG = true;
continue;
}
var duplicateDisplayOrder = excelUploadDt.AsEnumerable().GroupBy(r => r["DisplayOrder"]).Where(gr => gr.Count() > 1).ToList();
if (duplicateDisplayOrder.Any() && duplicateDisplayOrder.Select(dupl => dupl.Key).ToList().FirstOrDefault().ToString() == row["DisplayOrder"].ToString())
{
row["Remarks"] = string.Format(Properties.Resources.mmce00009, colDisplayOrder.HeaderText + " : " + row["DisplayOrder"].ToString());
inputDataNG = true;
continue;
}
defectiveReasonInVo = new DefectiveReasonVo();
processDefectiveReasonInVo = new ProcessDefectiveReasonVo();
defectiveReasonInVo.DefectiveReasonCode = row["DefectiveReasonCode"].ToString();
defectiveReasonInVo.DefectiveReasonName = row["DefectiveReasonName"].ToString();
defectiveReasonInVo.DefectiveCategoryId = 0;
defectiveReasonInVo.DisplayOrder = Convert.ToInt32(row["DisplayOrder"].ToString());
if (!ValidateProcessWorkCodeInExcel(excelUploadDt, defectiveReasonInVo.DefectiveReasonCode))
{
row["Remarks"] = string.Format(Properties.Resources.mmci00019);
inputDataNG = true;
continue;
}
DefectiveReasonVo checkVo = DuplicateCheck(defectiveReasonInVo);
if (checkVo != null && checkVo.AffectedCount > 0)
{
row["Remarks"] = string.Format(Properties.Resources.mmce00012, DefectiveReasonCode_lbl.Text + " : " + defectiveReasonInVo.DefectiveReasonCode);
inputDataNG = true;
continue;
}
DefectiveReasonVo checkDisplayVo = DuplicateDisplayCheck(defectiveReasonInVo);
if (checkDisplayVo != null && checkDisplayVo.AffectedCount > 0)
{
row["Remarks"] = string.Format(Properties.Resources.mmce00012, colDisplayOrder.HeaderText + " : " + defectiveReasonInVo.DisplayOrder.ToString());
inputDataNG = true;
continue;
}
}
DefectiveReason_dgv.AutoGenerateColumns = false;
isExcelUpload = true;
DefectiveReason_dgv.Columns["colRemarks"].Visible = true;
DefectiveReason_dgv.DataSource = excelUploadDt;
if (inputDataNG)
{
AddExcel_btn.Enabled = false;
}
else
{
AddExcel_btn.Enabled = true;
}
this.CompleteProgress();
}
}
/// <summary>
/// Binds tree view
/// </summary>
/// <param name="Linelist"></param>
private void PopulateTreeView(List <LineVo> Linelist)
{
DefectiveReasonVo defOutVo = new DefectiveReasonVo();
try
{
defOutVo = (DefectiveReasonVo)base.InvokeCbm(new GetDefectiveReasonMasterMntCbm(), defInVo, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
Logger.Error(exception.GetMessageData());
return;
}
LineDefectiveReasonDetails_tv.Nodes.Clear();
TreeNode[] headerNode = new TreeNode[Linelist.Count];
int i = 0;
foreach (LineVo lin in Linelist)
{
TreeNode child = new TreeNode
{
Text = lin.LineCode + " " + lin.LineName,
Tag = lin.LineId
};
headerNode[i] = child;
int childNodes = defOutVo.DefectiveReasonListVo.Count;
TreeNode[] rootNodes = new TreeNode[childNodes];
int node = 0;
ValueObjectList <LineDefectiveReasonVo> linDefRsnOutVo = new ValueObjectList <LineDefectiveReasonVo>();
try
{
linDefRsnOutVo = (ValueObjectList <LineDefectiveReasonVo>)base.InvokeCbm(new GetLineDefectiveReasonMasterMntCbm(), new LineDefectiveReasonVo(), false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
Logger.Error(exception.GetMessageData());
return;
}
foreach (DefectiveReasonVo dfrVo in defOutVo.DefectiveReasonListVo)
{
TreeNode rootChild = new TreeNode
{
Text = dfrVo.DefectiveReasonCode + " " + dfrVo.DefectiveReasonName,
Tag = dfrVo.DefectiveReasonId
};
if (linDefRsnOutVo != null && linDefRsnOutVo.GetList() != null && linDefRsnOutVo.GetList().Count > 0)
{
List <LineDefectiveReasonVo> linDefRsnList = linDefRsnOutVo.GetList().Where(t => t.LineId == Convert.ToInt32(child.Tag)).ToList();
foreach (LineDefectiveReasonVo lnDfRsnVo in linDefRsnList)
{
if (lnDfRsnVo.DefectiveReasonId == Convert.ToInt32(rootChild.Tag))
{
rootChild.Checked = true;
}
}
}
rootNodes[node] = rootChild;
headerNode[i].Nodes.Add(rootNodes[node]);
node += 1;
}
LineDefectiveReasonDetails_tv.Nodes.Add(headerNode[i]);
i += 1;
}
if (LineDefectiveReasonDetails_tv.Nodes.Count > 0)
{
Update_btn.Enabled = true;
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
DefectiveReasonVo inVo = (DefectiveReasonVo)arg;
DefectiveReasonVo outVo = new DefectiveReasonVo();
StringBuilder sqlQuery = new StringBuilder();
//create SQL
sqlQuery.Append("Select distinct dr.*, dc.defective_category_name from m_defective_reason dr ");
if (inVo.ProcessId > 0)
{
sqlQuery.Append(" inner join m_process_work_defective_reason pwdr on pwdr.defective_reason_id = dr.defective_reason_id ");
sqlQuery.Append(" inner join m_process_work pw on pw.process_work_id = pwdr.process_work_id");
}
sqlQuery.Append(" left join m_defective_category dc on dc.defective_category_id = dr.defective_category_id ");
sqlQuery.Append(" where dr.factory_cd = :faccd ");
if (inVo.DefectiveReasonCode != null)
{
sqlQuery.Append(" and defective_reason_cd like :defectivereasoncd ");
}
if (inVo.DefectiveReasonName != null)
{
sqlQuery.Append(" and defective_reason_name like :defectivereasonname ");
}
if (inVo.DefectiveCategoryId > 0)
{
sqlQuery.Append(" and dr.defective_category_id = :defectivecategoryid ");
}
if (inVo.ProcessId > 0)
{
sqlQuery.Append(" and pw.process_id = :processid ");
}
sqlQuery.Append(" order by dr.display_order ");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode);
if (inVo.DefectiveReasonCode != null)
{
sqlParameter.AddParameterString("defectivereasoncd", inVo.DefectiveReasonCode + "%");
}
if (inVo.DefectiveReasonName != null)
{
sqlParameter.AddParameterString("defectivereasonname", inVo.DefectiveReasonName + "%");
}
if (inVo.DefectiveCategoryId != 0)
{
sqlParameter.AddParameterInteger("defectivecategoryid", inVo.DefectiveCategoryId);
}
if (inVo.ProcessId > 0)
{
sqlParameter.AddParameterInteger("processid ", inVo.ProcessId);
}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
DefectiveReasonVo currOutVo = new DefectiveReasonVo
{
DefectiveReasonId = Convert.ToInt32(dataReader["defective_reason_id"]),
DefectiveReasonCode = dataReader["defective_reason_cd"].ToString(),
DefectiveReasonName = dataReader["defective_reason_name"].ToString(),
DefectiveCategoryId = ConvertDBNull <Int32>(dataReader, "defective_category_id"),
DefectiveCategoryName = ConvertDBNull <string>(dataReader, "defective_category_name"),
DisplayOrder = Convert.ToInt32(dataReader["display_order"].ToString())
};
outVo.DefectiveReasonListVo.Add(currOutVo);
}
dataReader.Close();
return(outVo);
}
/// <summary>
/// inserts/updates def reason
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Ok_btn_Click(object sender, EventArgs e)
{
DefectiveReasonVo inVo = new DefectiveReasonVo();
if (CheckMandatory())
{
var sch = StringCheckHelper.GetInstance();
if (!sch.IsASCII(DefectiveReasonCode_txt.Text))
{
messageData = new MessageData("mmce00003", Properties.Resources.mmce00003);
logger.Info(messageData);
popUpMessage.ConfirmationOkCancel(messageData, Text);
DefectiveReasonCode_txt.Focus();
return;
}
ValueObjectList <ValueObject> inVoList = new ValueObjectList <ValueObject>();
inVo.DefectiveReasonCode = DefectiveReasonCode_txt.Text.Trim();
inVo.DefectiveReasonName = DefectiveReasonName_txt.Text.Trim();
inVo.DefectiveCategoryId = Convert.ToInt32(DefectiveCategory_cmb.SelectedValue);
inVo.DisplayOrder = Convert.ToInt32(DisplayOrder_txt.Text);
inVo.RegistrationUserCode = UserData.GetUserData().UserCode;
inVo.FactoryCode = UserData.GetUserData().FactoryCode;
if (string.Equals(mode, CommonConstants.MODE_ADD))
{
DefectiveReasonVo checkVo = DuplicateCheck(inVo);
if (checkVo != null && checkVo.AffectedCount > 0)
{
messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, DefectiveReasonCode_lbl.Text + " : " + DefectiveReasonCode_txt.Text);
logger.Info(messageData);
popUpMessage.ConfirmationOkCancel(messageData, Text);
DefectiveReasonCode_txt.Focus();
return;
}
DefectiveReasonVo checkDisplayVo = DuplicateDisplayCheck(inVo);
if (checkDisplayVo != null && checkDisplayVo.AffectedCount > 0)
{
messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, DisplayOrder_lbl.Text + " : " + DisplayOrder_txt.Text);
logger.Info(messageData);
popUpMessage.ConfirmationOkCancel(messageData, Text);
DisplayOrder_txt.Focus();
return;
}
}
try
{
this.StartProgress(Properties.Resources.mmci00009);
if (string.Equals(mode, CommonConstants.MODE_ADD))
{
inVoList.add(inVo);
inVoList.add(GetSelectedProcessWork());
DefectiveReasonVo outVo = (DefectiveReasonVo)base.InvokeCbm(new AddDefectiveReasonMasterMntNewCbm(), inVoList, false);
IntSuccess = outVo.AffectedCount;
}
else if (mode.Equals(CommonConstants.MODE_UPDATE))
{
inVo.DefectiveReasonId = updateData.DefectiveReasonId;
inVoList.add(inVo);
inVoList.add(GetSelectedProcessWork());
DefectiveReasonVo outVo = (DefectiveReasonVo)base.InvokeCbm(new UpdateDefectiveReasonMasterMntNewCbm(), inVoList, false);
IntSuccess = outVo.AffectedCount;
}
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
finally
{
this.CompleteProgress();
}
if ((IntSuccess > 0) || (IntSuccess == 0))
{
this.Close();
}
}
}
/// <summary>
/// Binds tree view
/// </summary>
/// <param name="prcWrkList"></param>
private void PopulateTreeView(List <ProcessWorkVo> prcWrkList)
{
DefectiveReasonVo defOutVo = new DefectiveReasonVo();
try
{
defOutVo = (DefectiveReasonVo)base.InvokeCbm(new GetDefectiveReasonMasterMntCbm(), defInVo, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
Logger.Error(exception.GetMessageData());
return;
}
ProcessDefectiveReasonDetails_tv.Nodes.Clear();
TreeNode[] headerNode = new TreeNode[prcWrkList.Count];
int i = 0;
foreach (ProcessWorkVo prcW in prcWrkList)
{
TreeNode child = new TreeNode
{
Text = prcW.ProcessWorkCode + " " + prcW.ProcessWorkName,
Tag = prcW.ProcessWorkId
};
headerNode[i] = child;
int childNodes = defOutVo.DefectiveReasonListVo.Count;
TreeNode[] rootNodes = new TreeNode[childNodes];
int node = 0;
ProcessDefectiveReasonVo prcDefRsnOutVo = new ProcessDefectiveReasonVo();
try
{
prcDefRsnOutVo = (ProcessDefectiveReasonVo)base.InvokeCbm(new GetProcessDefectiveReasonMasterMntCbm(), new ProcessDefectiveReasonVo(), false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
Logger.Error(exception.GetMessageData());
return;
}
foreach (DefectiveReasonVo dfrVo in defOutVo.DefectiveReasonListVo)
{
TreeNode rootChild = new TreeNode
{
Text = dfrVo.DefectiveReasonName,
Tag = dfrVo.DefectiveReasonId
};
List <ProcessDefectiveReasonVo> prcDefRsnList = prcDefRsnOutVo.ProcessDefectiveReasonListVo.Where(t => t.ProcessWorkId == Convert.ToInt32(child.Tag)).ToList();
foreach (ProcessDefectiveReasonVo prDfRsnVo in prcDefRsnList)
{
if (prDfRsnVo.DefectiveReasonId == Convert.ToInt32(rootChild.Tag))
{
rootChild.Checked = true;
}
}
rootNodes[node] = rootChild;
headerNode[i].Nodes.Add(rootNodes[node]);
node += 1;
}
ProcessDefectiveReasonDetails_tv.Nodes.Add(headerNode[i]);
i += 1;
}
}
