/// <summary>
/// passing update data to update form
/// </summary>
private void BindUpdateInspectionProcessData()
{
int selectedrowindex = InspectionProcessDetails_dgv.SelectedCells[0].RowIndex;
InspectionProcessVo inspProcessVo = (InspectionProcessVo)InspectionProcessDetails_dgv.Rows[selectedrowindex].DataBoundItem;
AddInspectionProcessForm newAddForm = new AddInspectionProcessForm(CommonConstants.MODE_UPDATE, inspProcessVo);
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());
}
}
/// <summary>
/// Load Inspection Process
/// </summary>
private void LoadInspectionProcessCombo()
{
ValueObjectList <InspectionProcessVo> outVo = null;
InspectionProcessVo inVo = new InspectionProcessVo();
//inVo.InspectionFormatId = InspectionFormatId;
try
{
outVo = (ValueObjectList <InspectionProcessVo>)base.InvokeCbm(new GetInsepctionProcessMasterMntCbm(), inVo, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
if (outVo == null || outVo.GetList() == null || outVo.GetList().Count == 0)
{
messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
return;
}
InspectionProcess_cmb.DisplayMember = "InspectionProcessName";
InspectionProcess_cmb.ValueMember = "InspectionProcessId";
InspectionProcess_cmb.DataSource = outVo.GetList();
InspectionProcess_cmb.SelectedValue = InspectionProcessId;
}
private void checkRunningCount(InspectionProcessVo inVo)
{
InspectionProcessVo outVo = new InspectionProcessVo();
try
{
outVo = (InspectionProcessVo)base.InvokeCbm(new GetInspectionProcessSeqCbm(), inVo, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
RunningNumber = 1;
if (outVo != null && outVo.InspectionProcessCode != null)
{
string strTemp;
strTemp = outVo.InspectionProcessCode;
if (strTemp.LastIndexOf(GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue()) > 0)
{
strTemp = strTemp.Substring(strTemp.LastIndexOf(GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue()) + 1);
if (strTemp.All(Char.IsDigit))
{
RunningNumber = Convert.ToInt32(strTemp) + 1;
}
}
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
InspectionProcessVo inVo = (InspectionProcessVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Update m_inspection_process");
sqlQuery.Append(" Set ");
sqlQuery.Append(" inspection_process_cd = :inspectionprocesscd, ");
sqlQuery.Append(" inspection_process_name = :inspectionprocessname, ");
sqlQuery.Append(" inspection_format_id = :inspectionformatid, ");
sqlQuery.Append(" display_order = :displayorder ");
sqlQuery.Append(" Where ");
sqlQuery.Append(" inspection_process_id = :inspectionprocessid ");
sqlQuery.Append(" and factory_cd = :faccd ;");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("inspectionprocessid", inVo.InspectionProcessId);
sqlParameter.AddParameterString("inspectionprocesscd", inVo.InspectionProcessCode);
sqlParameter.AddParameterString("inspectionprocessname", inVo.InspectionProcessName);
sqlParameter.AddParameterInteger("inspectionformatid", inVo.InspectionFormatId);
sqlParameter.AddParameterInteger("displayorder", inVo.DisplayOrder);
sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode);
InspectionProcessVo outVo = new InspectionProcessVo {
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
private void InspectionItem_btn_Click(object sender, EventArgs e)
{
int selectedrowindex = InspectionProcessDetails_dgv.SelectedCells[0].RowIndex;
InspectionProcessVo inspProcessVo = (InspectionProcessVo)InspectionProcessDetails_dgv.Rows[selectedrowindex].DataBoundItem;
InspectionItemForProcessForm frm = new GlobalMasterMaintenance.InspectionItemForProcessForm();
frm.InspectionProcessId = inspProcessVo.InspectionProcessId;
frm.InspectionProcessCode = inspProcessVo.InspectionProcessCode;
frm.InspectionProcessName = inspProcessVo.InspectionProcessName;
frm.InspectionFormatId = FormatId;
frm.ShowDialog();
if (frm.InspectionProcessId > 0)
{
InspectionFormatProcessBuzzLogic getprocessid = new InspectionFormatProcessBuzzLogic();
InspectionReturnVo invo = new InspectionReturnVo();
invo.InspectionProcessId = frm.InspectionProcessId;
InspectionReturnVo getInspectionVo = getprocessid.RefreshAllFormGrid(invo);
if (getInspectionVo != null && getInspectionVo.InspectionFormatId > 0)
{
FormatId = getInspectionVo.InspectionFormatId;
//FormDatatableFromVo();
//ComboBind(InspectionFormatId_cmb, inspectionformatDatatable, "Name", "Id");
//InspectionFormatId_cmb.SelectedValue = FormatId;
}
}
GridBind();
if (InspectionProcessDetails_dgv.Rows.Count > 0 && InspectionProcessDetails_dgv.Columns.Count > 0 &&
InspectionProcessDetails_dgv.Columns["colInspectionProcessId"] != null)
{
int searchProcessId;
if (frm.InspectionProcessId > 0)
{
searchProcessId = frm.InspectionProcessId;
}
else
{
searchProcessId = inspProcessVo.InspectionProcessId;
}
DataGridViewRow row = InspectionProcessDetails_dgv.Rows
.Cast <DataGridViewRow>()
.FirstOrDefault(r => r.Cells["colInspectionProcessId"].Value.ToString().Equals(searchProcessId.ToString()));
if (row == null)
{
return;
}
InspectionProcessDetails_dgv.Rows[row.Index].Selected = true;
InspectionProcessDetails_dgv_CellClick(sender, new DataGridViewCellEventArgs(0, row.Index));
}
}
/// <summary>
/// delete the selected record
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Delete_btn_Click(object sender, EventArgs e)
{
int selectedrowindex = InspectionProcessDetails_dgv.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = InspectionProcessDetails_dgv.Rows[selectedrowindex];
messageData = new MessageData("mmcc00004", Properties.Resources.mmcc00004, selectedRow.Cells["colInspectionProcessCode"].Value.ToString());
// Logger.Info(messageData);
DialogResult dialogResult = popUpMessage.ConfirmationOkCancel(messageData, Text);
if (dialogResult == DialogResult.OK)
{
InspectionProcessVo inVo = new InspectionProcessVo();
inVo.InspectionProcessId = Convert.ToInt32(selectedRow.Cells["colInspectionProcessId"].Value.ToString());
inVo.InspectionProcessCode = selectedRow.Cells["colInspectionProcessCode"].Value.ToString();
try
{
InspectionProcessVo tableCount = CheckInspectionProcessRelationCbm(inVo);
if (tableCount.InspectionProcessId > 0)
{
messageData = new MessageData("mmce00007", Properties.Resources.mmce00007, InspectionItem.ToString());
popUpMessage.Information(messageData, Text);
return;
}
InspectionProcessVo outVo = (InspectionProcessVo)base.InvokeCbm(new DeleteInspectionProcessMasterMntCbm(), inVo, false);
if (outVo.AffectedCount > 0)
{
this.messageData = new MessageData("mmci00003", Properties.Resources.mmci00003, null);
logger.Info(this.messageData);
popUpMessage.Information(this.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>
/// event to delete the selected record
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Ok_btn_Click(object sender, EventArgs e)
{
if (InspectionProcessDetails_dgv.Rows.Count > 0 && InspectionProcessDetails_dgv.SelectedRows.Count > 0)
{
InspectionProcessVo inspectionprocessInVo = (InspectionProcessVo)InspectionProcessDetails_dgv.Rows[InspectionProcessDetails_dgv.CurrentRow.Index].DataBoundItem;
InspectionProcessId = inspectionprocessInVo.InspectionProcessId;
InspectionProcessName = inspectionprocessInVo.InspectionProcessName;
InspectionProcessCode = inspectionprocessInVo.InspectionProcessCode;
}
this.Close();
}
///// <summary>
///// InspectionFormatVo
///// </summary>
//private ValueObjectList<InspectionFormatVo> inspectionFormatOutVo = null;
#endregion
#region Constructor
/// <summary>
/// constructor
/// </summary>
/// <param name="pmode"></param>
/// <param name="userItem"></param>
public AddInspectionProcessForFormatForm(string pmode, InspectionProcessVo userItem = null)
{
InitializeComponent();
mode = pmode;
updateData = userItem;
if (string.Equals(mode, CommonConstants.MODE_UPDATE))
{
this.Text = UpdateText_lbl.Text;
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
InspectionProcessVo inVo = (InspectionProcessVo)arg;
StringBuilder sql = new StringBuilder();
//create SQL
sql.Append("Select Count(*) as InspectionProcessCount from m_inspection_process");
sql.Append(" where factory_cd = :faccd ");
if (inVo.InspectionProcessName != null)
{
sql.Append(" and UPPER(inspection_process_name) = UPPER(:inspectionprocessname)");
}
if (inVo.InspectionFormatId > 0)
{
sql.Append(" and inspection_format_id = :inspectionformatid ");
}
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode);
if (inVo.InspectionProcessName != null)
{
sqlParameter.AddParameterString("inspectionprocessname", inVo.InspectionProcessName);
}
if (inVo.InspectionFormatId > 0)
{
sqlParameter.AddParameterInteger("inspectionformatid", inVo.InspectionFormatId);
}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
InspectionProcessVo outVo = new InspectionProcessVo {
AffectedCount = 0
};
while (dataReader.Read())
{
outVo.AffectedCount = Convert.ToInt32(dataReader["InspectionProcessCount"]);
}
dataReader.Close();
return(outVo);
}
/// <summary>
/// Loads selected data from data grid
/// </summary>
/// <param name="dgvInspectionProcess"></param>
private void LoadInspectionProcessData(InspectionProcessVo dgvInspectionProcess)
{
if (dgvInspectionProcess != null)
{
this.InspectionProcessCode_txt.Text = dgvInspectionProcess.InspectionProcessCode;
this.InspectionProcessName_txt.Text = dgvInspectionProcess.InspectionProcessName;
this.InspectionFormat_cmb.SelectedValue = dgvInspectionProcess.InspectionFormatId.ToString();
}
}
private void ChangeGridDataColorForRelationDataCheck()
{
foreach (DataGridViewRow row in InspectionProcessDetails_dgv.Rows)
{
InspectionProcessVo InspectionUpdateVo = (InspectionProcessVo)row.DataBoundItem;
if (InspectionUpdateVo.InspectionItemId == 0)
{
row.DefaultCellStyle.ForeColor = Color.Red;
row.Cells["Comments"].Value = Properties.Resources.mmci00026;
}
}
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
InspectionProcessVo inVo = (InspectionProcessVo)vo;
ValueObjectList <InspectionProcessVo> inspectionProcessListInVo = new ValueObjectList <InspectionProcessVo>();
ValueObjectList <InspectionItemVo> inspectionItemListInVo = new ValueObjectList <InspectionItemVo>();
ValueObjectList <InspectionItemSelectionDatatypeValueVo> inspectionDataTypeSelectionListInVo = new ValueObjectList <InspectionItemSelectionDatatypeValueVo>();
ValueObjectList <InspectionSpecificationVo> inspectionSpecificationListInVo = new ValueObjectList <InspectionSpecificationVo>();
ValueObjectList <InspectionTestInstructionVo> inspectionTestInstructionListInVo = new ValueObjectList <InspectionTestInstructionVo>();
ValueObjectList <InspectionTestInstructionVo> inspectionTestInstructionDetailListInVo = new ValueObjectList <InspectionTestInstructionVo>();
ValueObjectList <ValueObject> OutVo = new ValueObjectList <ValueObject>();
inspectionProcessListInVo.add(inVo);
// Create the Vo to get the Inspection Process
ValueObjectList <InspectionProcessVo> GetProcessinVoList = new ValueObjectList <InspectionProcessVo>();
InspectionProcessVo ProcessVo = new InspectionProcessVo();
ProcessVo.InspectionProcessId = inVo.InspectionProcessIdCopy;
GetProcessinVoList.add(ProcessVo);
//get inspection item list for the above fetched processlist
inspectionItemListInVo = (ValueObjectList <InspectionItemVo>)getInspectionItemListCbm.Execute(trxContext, GetProcessinVoList);
if (inspectionItemListInVo != null && inspectionItemListInVo.GetList() != null && inspectionItemListInVo.GetList().Count > 0)
{
//get inspectionSelectionDataType for the above fetched itemlist
inspectionDataTypeSelectionListInVo = (ValueObjectList <InspectionItemSelectionDatatypeValueVo>)getInspectionSelectionDataTypeListCbm.Execute(trxContext, inspectionItemListInVo);
//get inspectionspecification for the above fetched itemlist
inspectionSpecificationListInVo = (ValueObjectList <InspectionSpecificationVo>)getInspectionSpecficationListCbm.Execute(trxContext, inspectionItemListInVo);
//get inspectiontestinstruction for the above fetched itemlist
inspectionTestInstructionListInVo = (ValueObjectList <InspectionTestInstructionVo>)getInspectionTestInstructionListCbm.Execute(trxContext, inspectionItemListInVo);
}
if (inspectionTestInstructionListInVo != null && inspectionTestInstructionListInVo.GetList() != null && inspectionTestInstructionListInVo.GetList().Count > 0)
{
//get inspectiontestinstructiondetail for the above fetched inspectiontestinstruction
inspectionTestInstructionDetailListInVo = (ValueObjectList <InspectionTestInstructionVo>)getInspectionTestInstructionDetailListCbm.Execute(trxContext, inspectionTestInstructionListInVo);
}
OutVo.add(null);
OutVo.add(inspectionProcessListInVo);
OutVo.add(inspectionItemListInVo);
OutVo.add(inspectionDataTypeSelectionListInVo);
OutVo.add(inspectionSpecificationListInVo);
OutVo.add(inspectionTestInstructionListInVo);
OutVo.add(inspectionTestInstructionDetailListInVo);
return(OutVo);
}
/// <summary>
/// Fills all user records to gridview control
/// </summary>
protected void GridBind(InspectionProcessVo conditionInVo)
{
if (conditionInVo == null)
{
return;
}
Ok_btn.Enabled = false;
InspectionProcessDetails_dgv.DataSource = null;
ValueObjectList <InspectionProcessVo> outVo = null;
try
{
outVo = (ValueObjectList <InspectionProcessVo>)base.InvokeCbm(new GetInspectionProcessForCopyMasterMntCbm(), conditionInVo, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
if (outVo == null || outVo.GetList() == null || outVo.GetList().Count == 0)
{
messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
return;
}
InspectionFormatName_txt.Text = outVo.GetList()[0].InspectionFormatName;
InspectionProcessDetails_dgv.AutoGenerateColumns = false;
BindingSource bindingSource1 = new BindingSource(outVo.GetList(), null);
if (bindingSource1 != null && bindingSource1.Count > 0)
{
InspectionProcessDetails_dgv.DataSource = bindingSource1;
}
else
{
messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
}
InspectionProcessDetails_dgv.ClearSelection();
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
InspectionProcessVo inVo = (InspectionProcessVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Insert into m_inspection_process");
sqlQuery.Append(" ( ");
sqlQuery.Append(" inspection_process_cd,");
sqlQuery.Append(" inspection_process_name,");
sqlQuery.Append(" inspection_format_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(" :inspectionprocesscd,");
sqlQuery.Append(" :inspectionprocessname,");
sqlQuery.Append(" :inspectionformatid,");
sqlQuery.Append(" :displayorder,");
sqlQuery.Append(" :registrationusercode,");
sqlQuery.Append(" :regdatetime,");
sqlQuery.Append(" :factorycode");
sqlQuery.Append(" ) ");
sqlQuery.Append(" RETURNING inspection_process_id;");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("inspectionprocesscd", inVo.InspectionProcessCode);
sqlParameter.AddParameterString("inspectionprocessname", inVo.InspectionProcessName);
sqlParameter.AddParameterInteger("inspectionformatid", inVo.InspectionFormatId);
sqlParameter.AddParameterInteger("displayorder", inVo.DisplayOrder);
UserData userdata = trxContext.UserData;
sqlParameter.AddParameterString("registrationusercode", userdata.UserCode);
sqlParameter.AddParameterDateTime("regdatetime", trxContext.ProcessingDBDateTime);
sqlParameter.AddParameterString("factorycode", userdata.FactoryCode);
InspectionProcessVo outVo = new InspectionProcessVo();
outVo.InspectionProcessId = (int?)sqlCommandAdapter.ExecuteScalar(sqlParameter) ?? 0;
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
InspectionProcessVo inVo = (InspectionProcessVo)arg;
StringBuilder sqlQuery = new StringBuilder();
//create SQL
sqlQuery.Append(" Select ip.inspection_process_id as inspectionprocessid, ");
sqlQuery.Append(" iitm.inspection_process_id as inspectionitemprocessid from m_inspection_process ip ");
sqlQuery.Append(" left join m_inspection_item iitm on ");
sqlQuery.Append(" iitm.inspection_process_id = ip.inspection_process_id ");
sqlQuery.Append(" where ip.factory_cd = :faccd ");
if (inVo.InspectionProcessCode != null)
{
sqlQuery.Append(" and UPPER(ip.inspection_process_cd) = UPPER(:inspectionprocesscd)");
}
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode);
if (inVo.InspectionProcessCode != null)
{
sqlParameter.AddParameterString("inspectionprocesscd", inVo.InspectionProcessCode);
}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
InspectionProcessVo outVo = new InspectionProcessVo {
AffectedCount = 0
};
while (dataReader.Read())
{
if (outVo == null)
{
outVo = new InspectionProcessVo();
}
outVo.InspectionProcessId = ConvertDBNull <int>(dataReader, "inspectionitemprocessid");
}
dataReader.Close();
return(outVo);
}
/// <summary>
/// checks duplicate Display Record
/// </summary>
/// <param name="defectVo"></param>
/// <returns></returns>
private InspectionProcessVo DuplicateDisplayCheck(InspectionProcessVo defectVo)
{
InspectionProcessVo outVo = new InspectionProcessVo();
try
{
outVo = (InspectionProcessVo)base.InvokeCbm(new CheckInspectionProcessWorkDisplayOrderCbm(), defectVo, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
return(outVo);
}
/// <summary>
/// To idenctify the relation ship with tables
/// </summary>
private InspectionProcessVo CheckInspectionProcessRelationCbm(InspectionProcessVo inVo)
{
InspectionProcessVo outVo = new InspectionProcessVo();
try
{
outVo = (InspectionProcessVo)base.InvokeCbm(new CheckInspectionProcessRelationCbm(), inVo, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
return(outVo);
}
/// <summary>
/// insert the record
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Add_btn_Click(object sender, EventArgs e)
{
InspectionProcessVo inspProcessVo = new InspectionProcessVo();
inspProcessVo.InspectionFormatId = FormatId;
inspProcessVo.InspectionFormatCode = FormatCode;
inspProcessVo.InspectionFormatName = FormatName;
AddInspectionProcessForFormatForm newAddForm = new AddInspectionProcessForFormatForm(CommonConstants.MODE_ADD, inspProcessVo);
newAddForm.ShowDialog();
if (newAddForm.IntSuccess > 0)
{
messageData = new MessageData("mmci00001", Properties.Resources.mmci00001, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
GridBind();
if (InspectionProcessDetails_dgv.Rows.Count > 0 && InspectionProcessDetails_dgv.Columns.Count > 0 &&
InspectionProcessDetails_dgv.Columns["colInspectionProcessId"] != null)
{
int searchProcessId;
if (newAddForm.IntSuccess > 0)
{
searchProcessId = newAddForm.IntSuccess;
}
else
{
return;
}
DataGridViewRow row = InspectionProcessDetails_dgv.Rows
.Cast <DataGridViewRow>()
.FirstOrDefault(r => r.Cells["colInspectionProcessId"].Value.ToString().Equals(searchProcessId.ToString()));
if (row == null)
{
return;
}
InspectionProcessDetails_dgv.Rows[row.Index].Selected = true;
InspectionProcessDetails_dgv_CellClick(sender, new DataGridViewCellEventArgs(0, row.Index));
InspectionProcessDetails_dgv.FirstDisplayedScrollingRowIndex = row.Index;
}
}
}
/// <summary>
/// Loads selected data from data grid
/// </summary>
/// <param name="dgvInspectionProcess"></param>
private void LoadInspectionProcessData(InspectionProcessVo dgvInspectionProcess)
{
if (string.Equals(mode, CommonConstants.MODE_UPDATE))
{
this.InspectionProcessName_txt.Text = dgvInspectionProcess.InspectionProcessName;
//this.InspectionFormat_cmb.SelectedValue = dgvInspectionProcess.InspectionFormatId.ToString();
this.InspectionFormat_cmb.Text = updateData.InspectionFormatName;
this.InspectionProcessDisplayOrder_txt.Text = dgvInspectionProcess.DisplayOrder.ToString();
}
else
{
//this.InspectionFormat_cmb.SelectedValue = dgvInspectionProcess.InspectionFormatId.ToString();
this.InspectionFormat_cmb.Text = updateData.InspectionFormatName;
}
}
/// <summary>
/// Fills all user records to gridview control
/// </summary>
private void GridBind()
{
InspectionItem_btn.Enabled = Update_btn.Enabled = Delete_btn.Enabled = false;
InspectionProcessVo inVo = new InspectionProcessVo();
inVo.InspectionFormatId = FormatId;
InspectionProcessDetails_dgv.DataSource = null;
ValueObjectList <InspectionProcessVo> outVo = null;
try
{
outVo = (ValueObjectList <InspectionProcessVo>)base.InvokeCbm(new GetInspectionProcessMasterMntCbm(), inVo, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
if (outVo == null || outVo.GetList() == null || outVo.GetList().Count == 0)
{
messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null);
logger.Info(messageData);
//popUpMessage.Information(messageData, Text);
return;
}
InspectionProcessDetails_dgv.AutoGenerateColumns = false;
BindingSource bindingSource1 = new BindingSource(outVo.GetList(), null);
if (bindingSource1 != null && bindingSource1.Count > 0)
{
InspectionProcessDetails_dgv.DataSource = bindingSource1;
}
else
{
messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
}
ChangeGridDataColorForRelationDataCheck();
InspectionProcessDetails_dgv.ClearSelection();
}
/// <summary>
/// Get process
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void GetProcess_btn_Click(object sender, EventArgs e)
{
if (!CheckMandatory())
{
return;
}
InspectionProcessVo conditionInVo = FormConditionVo();
InspectionItem_dgv.DataSource = null;
ValueObjectList <InspectionProcessVo> outVo = null;
try
{
outVo = (ValueObjectList <InspectionProcessVo>)base.InvokeCbm(new GetInspectionProcessForCopyMasterMntCbm(), conditionInVo, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
if (outVo == null || outVo.GetList() == null || outVo.GetList().Count == 0)
{
InspectionFormatName_txt.Text = string.Empty;
ItemName_lbl.Text = string.Empty;
ProcessId_cmb.DataSource = null;
ProcessId_cmb.SelectedIndex = -1;
ProcessId_cmb.Enabled = false;
messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
return;
}
InspectionFormatName_txt.Text = outVo.GetList()[0].InspectionFormatName;
ProcessId_cmb.DisplayMember = "InspectionProcessName";
ProcessId_cmb.ValueMember = "InspectionProcessId";
ProcessId_cmb.DataSource = outVo.GetList();
ProcessId_cmb.SelectedIndex = -1;
ProcessId_cmb.Enabled = true;
}
/// <summary>
/// Creates seacrh condition as per user inputs
/// </summary>
/// <returns>search condition</returns>
protected InspectionProcessVo FormConditionVo()
{
InspectionProcessVo inVo = new InspectionProcessVo();
//if (ItemId_cmb.SelectedIndex > -1)
//{
// inVo.ItemCode = ItemId_cmb.SelectedValue.ToString();
//}
if (ItemCode_txt.Text != string.Empty) //&& sapItemGlobalVo != null
{
inVo.ItemCode = ItemCode_txt.Text;
}
if (LineId_cmb.SelectedIndex > -1)
{
inVo.LineCode = LineId_cmb.SelectedValue.ToString();
}
return(inVo);
}
/// <summary>
/// form load
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void AddInspectionProcessForm_Load(object sender, EventArgs e)
{
//FormDatatableFromVo();
//ComboBind(InspectionFormat_cmb, inspectionformatDatatable, "Name", "Id");
if (updateData != null && updateData.InspectionProcessIdCopy > 0)
{
InspectionprocessId = updateData.InspectionProcessIdCopy;
CopyProcess_txt.Text = updateData.InspectionProcessName;
}
InspectionProcessName_txt.Select();
if (updateData != null)
{
LoadInspectionProcessData(updateData);
}
if (string.Equals(mode, CommonConstants.MODE_ADD))
{
InspectionProcessVo outVo = (InspectionProcessVo)base.InvokeCbm(new GetInspectionProcessDisplayOrderNextValCbm(), updateData, false);
if (outVo != null && outVo.DisplayOrder > 0)
{
InspectionProcessDisplayOrder_txt.Text = outVo.DisplayOrder.ToString();
}
else
{
InspectionProcessDisplayOrder_txt.Text = "1";
}
InspectionProcessVo inVo = new InspectionProcessVo();
inVo.InspectionFormatId = updateData.InspectionFormatId;
checkRunningCount(inVo);
}
else
{
CopyProcess_btn.Enabled = false;
CopyProcess_txt.ReadOnly = true;
CopyProcess_txt.Enabled = false;
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
InspectionProcessVo inVo = (InspectionProcessVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Select max(display_order)+1 display_order ");
sqlQuery.Append(" from m_inspection_process ");
sqlQuery.Append(" where factory_cd = :factcd");
if (inVo.InspectionFormatId > 0)
{
sqlQuery.Append(" and inspection_format_id = :inspectionformatid");
}
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("factcd", UserData.GetUserData().FactoryCode);
if (inVo.InspectionFormatId > 0)
{
sqlParameter.AddParameterInteger("inspectionformatid", inVo.InspectionFormatId);
}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
InspectionProcessVo outVo = null;
while (dataReader.Read())
{
outVo = new InspectionProcessVo();
outVo.DisplayOrder = ConvertDBNull <int>(dataReader, "display_order");
}
dataReader.Close();
return(outVo);
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
InspectionProcessVo inVo = (InspectionProcessVo)vo;
ValueObjectList <ValueObjectList <ValueObject> > outVo = null;
//if process data not found return the vo
if (inVo == null || inVo.InspectionProcessIdCopy == 0)
{
return(outVo);
}
InspectionProcessVo returnProcessVo = null;
inVo.InspectionProcessCode = inVo.InspectionFormatCode + GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue() + GlobalMasterDataTypeEnum.PROCESS_CODE.GetValue() + GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue() + inVo.SequenceNo;
returnProcessVo = (InspectionProcessVo)addInspectionProcessMasterMntCbm.Execute(trxContext, inVo);
//To get the old record for InspectionItem Insertion
inVo.InspectionProcessId = inVo.InspectionProcessIdCopy;
//No records Added
if (returnProcessVo == null || returnProcessVo.InspectionProcessId == 0)
{
return(outVo);
}
returnProcessVo.InspectionProcessCode = inVo.InspectionProcessCode;
ValueObjectList <ValueObject> CombinationVo = new ValueObjectList <ValueObject>();
CombinationVo.add(inVo);
CombinationVo.add(returnProcessVo);
if (outVo == null)
{
outVo = new ValueObjectList <ValueObjectList <ValueObject> >();
}
outVo.add(CombinationVo);
return(outVo);
}
/// <summary>
/// Creates seacrh condition as per user inputs
/// </summary>
/// <returns>search condition</returns>
private InspectionProcessVo FormConditionVo()
{
InspectionProcessVo inVo = new InspectionProcessVo();
if (InspectionProcessCode_txt.Text != string.Empty)
{
inVo.InspectionProcessCode = InspectionProcessCode_txt.Text;
}
if (InspectionProcessName_txt.Text != string.Empty)
{
inVo.InspectionProcessName = InspectionProcessName_txt.Text;
}
if (InspectionFormatId_cmb.SelectedIndex > -1)
{
inVo.InspectionFormatId = Convert.ToInt32(InspectionFormatId_cmb.SelectedValue.ToString());
}
return(inVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
InspectionProcessVo inVo = (InspectionProcessVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("select");
sqlQuery.Append(" inspection_process_cd ");
sqlQuery.Append(" from m_inspection_process");
sqlQuery.Append(" where factory_cd = :faccd ");
sqlQuery.Append(" and inspection_format_id = :inspectionformatid ");
sqlQuery.Append(" order by inspection_process_id desc ");
sqlQuery.Append(" limit 1 ");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode);
sqlParameter.AddParameterInteger("inspectionformatid", inVo.InspectionFormatId);
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
InspectionProcessVo currOutVo = new InspectionProcessVo();
while (dataReader.Read())
{
currOutVo.InspectionProcessCode = ConvertDBNull <string>(dataReader, "inspection_process_cd");
}
dataReader.Close();
return(currOutVo);
}
/// <summary>
/// passing update data to update form
/// </summary>
private void BindUpdateInspectionProcessData()
{
int selectedrowindex = InspectionProcessDetails_dgv.SelectedCells[0].RowIndex;
InspectionProcessVo inspProcessVo = (InspectionProcessVo)InspectionProcessDetails_dgv.Rows[selectedrowindex].DataBoundItem;
AddInspectionProcessForFormatForm newAddForm = new AddInspectionProcessForFormatForm(CommonConstants.MODE_UPDATE, inspProcessVo);
newAddForm.ShowDialog(this);
if (newAddForm.IntSuccess > 0)
{
messageData = new MessageData("mmci00002", Properties.Resources.mmci00002, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
if (newAddForm.ReturnFormatId > 0)
{
FormatId = newAddForm.ReturnFormatId;
}
//FormDatatableFromVo();
//ComboBind(InspectionFormatId_cmb, inspectionformatDatatable, "Name", "Id");
//InspectionFormatId_cmb.SelectedValue = FormatId;
GridBind();
}
else if (newAddForm.IntSuccess == 0)
{
messageData = new MessageData("mmci00007", Properties.Resources.mmci00007, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
//GridBind();
}
InspectionProcessDetails_dgv.Rows[selectedrowindex].Selected = true;
InspectionProcessDetails_dgv_CellClick(this, new DataGridViewCellEventArgs(0, selectedrowindex));
InspectionProcessDetails_dgv.FirstDisplayedScrollingRowIndex = selectedrowindex;
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
InspectionFormatVo inVo = new InspectionFormatVo();
ValueObjectList <ValueObject> inListVo = (ValueObjectList <ValueObject>)vo;
InspectionReturnVo outVo = null;
if (inListVo == null && inListVo.GetList() == null && inListVo.GetList().Count == 0)
{
return(null);
}
InspectionFormatVo updateFormatVo = (InspectionFormatVo)inListVo.GetList()[0];
InspectionProcessVo updateprocessVo = (InspectionProcessVo)inListVo.GetList()[1];
InspectionItemVo updateitemVo = (InspectionItemVo)inListVo.GetList()[2];
InspectionItemSelectionDatatypeValueVo updateSelectionDataTypeValueVo = (InspectionItemSelectionDatatypeValueVo)inListVo.GetList()[3];
InspectionSpecificationVo updateSpecificationVo = (InspectionSpecificationVo)inListVo.GetList()[4];
InspectionTestInstructionVo updateTestInstructionVo = (InspectionTestInstructionVo)inListVo.GetList()[5];
InspectionTestInstructionVo updateTestInstructionDetailVo = (InspectionTestInstructionVo)inListVo.GetList()[6];
if (!(updateprocessVo != null && updateprocessVo.InspectionProcessIdCopy > 0 && updateitemVo != null && updateitemVo.InspectionItemIdCopy > 0))
{
InspectionFormatVo inspFormatVo = new InspectionFormatVo();
inspFormatVo.InspectionFormatId = updateFormatVo.InspectionFormatIdCopy;
inspFormatVo.InspectionFormatCode = updateFormatVo.InspectionFormatCode;
inspFormatVo.InspectionFormatName = updateFormatVo.InspectionFormatName;
UpdateResultVo updateResultVo = (UpdateResultVo)checkInspectionFormatExitInTransactionCbm.Execute(trxContext, inspFormatVo);
if (updateResultVo.AffectedCount == 0)
{
outVo = new InspectionReturnVo();
if (updateFormatVo.Mode == CommonConstants.MODE_UPDATE)
{
//update inspectionformat
InspectionFormatVo inspectionFormatVo = (InspectionFormatVo)updateInspectionFormatMasterMntCbm.Execute(trxContext, inspFormatVo);
outVo.AffectedCount = inspectionFormatVo.AffectedCount;
outVo.InspectionFormatId = inspFormatVo.InspectionFormatId;
return(outVo);
}
if (updateprocessVo != null)
{
InspectionProcessVo inspectionProcessVo = new InspectionProcessVo();
if (updateprocessVo.DeleteFlag)
{
//delete inspectionprocess
return((InspectionReturnVo)deleteAllInspectionFunctionMasterMntCbm.Execute(trxContext, vo));
}
else
{
//update inspectionprocess
inspectionProcessVo = (InspectionProcessVo)updateInspectionProcessMasterMntCbm.Execute(trxContext, updateprocessVo);
}
outVo.AffectedCount = inspectionProcessVo.AffectedCount;
outVo.InspectionProcessId = updateprocessVo.InspectionProcessId;
outVo.InspectionFormatId = inspFormatVo.InspectionFormatId;
return(outVo);
}
if (updateSelectionDataTypeValueVo != null)
{
if (updateSelectionDataTypeValueVo.DeleteFlag)
{
//delete inspectionitemselectionvalue
return((InspectionReturnVo)deleteAllInspectionFunctionMasterMntCbm.Execute(trxContext, vo));
}
else
{
//update inspectionitemselectionvalue
UpdateResultVo inspectionItemSelectionDatatypeValueVo = (UpdateResultVo)updateInspectionItemSelectionDatatypeValueCbm.Execute(trxContext, updateSelectionDataTypeValueVo);
outVo.AffectedCount = inspectionItemSelectionDatatypeValueVo.AffectedCount;
outVo.InspectionItemId = updateSelectionDataTypeValueVo.InspectionItemId;
return(outVo);
}
}
if (updateitemVo != null)
{
InspectionItemVo inspectionItemVo = new InspectionItemVo();
if (updateitemVo.DeleteFlag)
{
//delete inspectionitem
return((InspectionReturnVo)deleteAllInspectionFunctionMasterMntCbm.Execute(trxContext, vo));
}
else
{
//update inspectionitem
inspectionItemVo = (InspectionItemVo)updateInspectionItemMasterMntCbm.Execute(trxContext, updateitemVo);
}
outVo.AffectedCount = inspectionItemVo.AffectedCount;
outVo.InspectionItemId = updateitemVo.InspectionItemId;
outVo.InspectionProcessId = updateitemVo.InspectionProcessId;
return(outVo);
}
if (updateSpecificationVo != null)
{
InspectionSpecificationVo inspectionSpecificationVo = new InspectionSpecificationVo();
if (updateSpecificationVo.DeleteFlag)
{
//delete inspectionspecification
return((InspectionReturnVo)deleteAllInspectionFunctionMasterMntCbm.Execute(trxContext, vo));
}
else
{
//update inspectionspecification
inspectionSpecificationVo = (InspectionSpecificationVo)updateInspectionSpecificationMasterMntCbm.Execute(trxContext, updateSpecificationVo);
}
outVo.AffectedCount = inspectionSpecificationVo.AffectedCount;
outVo.InspectionItemId = updateSpecificationVo.InspectionItemId;
return(outVo);
}
if (updateTestInstructionVo != null)
{
InspectionTestInstructionVo inspectionTestInstructionVo = new InspectionTestInstructionVo();
if (updateTestInstructionVo.DeleteFlag)
{
//delete inspectiontestinstruction
return((InspectionReturnVo)deleteAllInspectionFunctionMasterMntCbm.Execute(trxContext, vo));
}
else
{
//update inspectiontestinstruction
inspectionTestInstructionVo = (InspectionTestInstructionVo)updateInspectionTestInstructionMasterMntCbm.Execute(trxContext, updateTestInstructionVo);
}
outVo.AffectedCount = inspectionTestInstructionVo.AffectedCount;
outVo.InspectionItemId = updateTestInstructionVo.InspectionItemId;
outVo.InspectionTestInstructionId = updateTestInstructionVo.InspectionTestInstructionId;
return(outVo);
}
if (updateTestInstructionDetailVo != null)
{
InspectionTestInstructionVo inspectionTestInstructionDetailVo = new InspectionTestInstructionVo();
if (updateTestInstructionDetailVo.DeleteFlag)
{
//delete inspectiontestinstructiondetail
return((InspectionReturnVo)deleteAllInspectionFunctionMasterMntCbm.Execute(trxContext, vo));
}
else
{
//update inspectiontestinstructiondetail
inspectionTestInstructionDetailVo = (InspectionTestInstructionVo)updateInspectionTestInstructionDetailMasterMntCbm.Execute(trxContext, updateTestInstructionDetailVo);
}
outVo.AffectedCount = inspectionTestInstructionDetailVo.AffectedCount;
outVo.InspectionTestInstructionId = updateTestInstructionDetailVo.InspectionTestInstructionId;
return(outVo);
}
}
}
inVo = (InspectionFormatVo)inListVo.GetList()[0];
inVo.InspectionFormatId = inVo.InspectionFormatIdCopy;
updateInspectionFormatDeleteFlagMasterMntCbm.Execute(trxContext, inVo);
return(copyInspectionFormatMasterMntCbm.Execute(trxContext, vo));
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
InspectionFormatVo inVo = new InspectionFormatVo();
ValueObjectList <ValueObject> inListVo = (ValueObjectList <ValueObject>)vo;
InspectionReturnVo outVo = null;
if (inListVo == null && inListVo.GetList() == null && inListVo.GetList().Count == 0)
{
return(null);
}
InspectionFormatVo updateFormatVo = (InspectionFormatVo)inListVo.GetList()[0];
InspectionProcessVo updateprocessVo = (InspectionProcessVo)inListVo.GetList()[1];
InspectionItemVo updateitemVo = (InspectionItemVo)inListVo.GetList()[2];
InspectionItemSelectionDatatypeValueVo updateSelectionDataTypeValueVo = (InspectionItemSelectionDatatypeValueVo)inListVo.GetList()[3];
InspectionSpecificationVo updateSpecificationVo = (InspectionSpecificationVo)inListVo.GetList()[4];
InspectionTestInstructionVo updateTestInstructionVo = (InspectionTestInstructionVo)inListVo.GetList()[5];
InspectionTestInstructionVo updateTestInstructionDetailVo = (InspectionTestInstructionVo)inListVo.GetList()[6];
outVo = new InspectionReturnVo();
if (updateprocessVo != null && updateprocessVo.DeleteFlag)
{
InspectionProcessVo inspectionProcessVo = new InspectionProcessVo();
//delete inspectionprocess
inspectionProcessVo = (InspectionProcessVo)deleteInspectionProcessMasterMntCbm.Execute(trxContext, updateprocessVo);
InspectionItemVo InItemVo = new InspectionItemVo();
InItemVo.InspectionProcessId = updateprocessVo.InspectionProcessId;
//get inspection item id
ValueObjectList <InspectionItemVo> InspectionItemVo = (ValueObjectList <InspectionItemVo>)getInspectionItemMasterCbm.Execute(trxContext, InItemVo);
if (InspectionItemVo == null || InspectionItemVo.GetList() == null || InspectionItemVo.GetList().Count == 0)
{
outVo.AffectedCount = inspectionProcessVo.AffectedCount;
outVo.InspectionFormatId = updateFormatVo.InspectionFormatIdCopy;
return(outVo);
}
foreach (InspectionItemVo getitemVo in InspectionItemVo.GetList())
{
InspectionItemSelectionDatatypeValueVo deleteInspectionItemSelectionDatatypeValueVo = new InspectionItemSelectionDatatypeValueVo();
deleteInspectionItemSelectionDatatypeValueVo.InspectionItemId = getitemVo.InspectionItemId;
//delete inspectionitemselectionvalue
UpdateResultVo inspectionItemSelectionDatatypeValueVo = (UpdateResultVo)deleteInspectionItemSelectionDatatypeValueCbm.Execute(trxContext, deleteInspectionItemSelectionDatatypeValueVo);
InspectionSpecificationVo deleteSpecInVo = new InspectionSpecificationVo();
deleteSpecInVo.InspectionItemId = getitemVo.InspectionItemId;
//delete inspectionspecification
InspectionSpecificationVo inspectionSpecificationVo = (InspectionSpecificationVo)deleteInspectionSpecificationMasterMntCbm.Execute(trxContext, deleteSpecInVo);
InspectionTestInstructionVo inTestVo = new InspectionTestInstructionVo();
inTestVo.InspectionItemId = getitemVo.InspectionItemId;
//get inspectiontestinstruction id
ValueObjectList <InspectionTestInstructionVo> inspectionTestInstructionVo = (ValueObjectList <InspectionTestInstructionVo>)getInspectionTestInstructionMasterMntCbm.Execute(trxContext, inTestVo);
if (inspectionTestInstructionVo != null && inspectionTestInstructionVo.GetList() != null && inspectionTestInstructionVo.GetList().Count > 0)
{
//delete inspectiontestinstruction
InspectionTestInstructionVo deleteInspectionTestInstructionVo = (InspectionTestInstructionVo)deleteInspectionTestInstructionMasterMntNewCbm.Execute(trxContext, inspectionTestInstructionVo.GetList()[0]);
}
//delete inspectionitem
InspectionItemVo deleteinspectionItemVo = (InspectionItemVo)deleteInspectionItemMasterMntCbm.Execute(trxContext, getitemVo);
}
outVo.AffectedCount = inspectionProcessVo.AffectedCount;
outVo.InspectionFormatId = updateFormatVo.InspectionFormatIdCopy;
return(outVo);
}
else if (updateitemVo != null && updateitemVo.DeleteFlag)
{
InspectionItemSelectionDatatypeValueVo deleteInspectionItemSelectionDatatypeValueVo = new InspectionItemSelectionDatatypeValueVo();
deleteInspectionItemSelectionDatatypeValueVo.InspectionItemId = updateitemVo.InspectionItemId;
//delete inspectionitemselectionvalue
UpdateResultVo inspectionItemSelectionDatatypeValueVo = (UpdateResultVo)deleteInspectionItemSelectionDatatypeValueCbm.Execute(trxContext, deleteInspectionItemSelectionDatatypeValueVo);
InspectionSpecificationVo deleteSpecInVo = new InspectionSpecificationVo();
deleteSpecInVo.InspectionItemId = updateitemVo.InspectionItemId;
//delete inspectionspecification
InspectionSpecificationVo inspectionSpecificationVo = (InspectionSpecificationVo)deleteInspectionSpecificationMasterMntCbm.Execute(trxContext, deleteSpecInVo);
InspectionTestInstructionVo inTestVo = new InspectionTestInstructionVo();
inTestVo.InspectionItemId = updateitemVo.InspectionItemId;
//get inspectiontestinstruction id
ValueObjectList <InspectionTestInstructionVo> inspectionTestInstructionVo = (ValueObjectList <InspectionTestInstructionVo>)getInspectionTestInstructionMasterMntCbm.Execute(trxContext, inTestVo);
if (inspectionTestInstructionVo != null && inspectionTestInstructionVo.GetList() != null && inspectionTestInstructionVo.GetList().Count > 0)
{
//delete inspectiontestinstruction
InspectionTestInstructionVo deleteInspectionTestInstructionVo = (InspectionTestInstructionVo)deleteInspectionTestInstructionMasterMntNewCbm.Execute(trxContext, inspectionTestInstructionVo.GetList()[0]);
}
//delete inspectionitem
InspectionItemVo deleteinspectionItemVo = (InspectionItemVo)deleteInspectionItemMasterMntCbm.Execute(trxContext, updateitemVo);
outVo.AffectedCount = deleteinspectionItemVo.AffectedCount;
outVo.InspectionProcessId = updateitemVo.InspectionProcessId;
return(outVo);
}
else if (updateSelectionDataTypeValueVo != null && updateSelectionDataTypeValueVo.DeleteFlag)
{
//delete inspectionitemselectionvalue
UpdateResultVo inspectionItemSelectionDatatypeValueVo = (UpdateResultVo)deleteInspectionItemSelectionDatatypeValueCbm.Execute(trxContext, updateSelectionDataTypeValueVo);
outVo.AffectedCount = inspectionItemSelectionDatatypeValueVo.AffectedCount;
outVo.InspectionItemId = updateSelectionDataTypeValueVo.InspectionItemId;
return(outVo);
}
else if (updateSpecificationVo != null && updateSpecificationVo.DeleteFlag)
{
//delete inspectionspecification
InspectionSpecificationVo deleteinspectionSpecificationVo = (InspectionSpecificationVo)deleteInspectionSpecificationMasterMntCbm.Execute(trxContext, updateSpecificationVo);
outVo.AffectedCount = deleteinspectionSpecificationVo.AffectedCount;
outVo.InspectionItemId = updateSpecificationVo.InspectionItemId;
return(outVo);
}
else if (updateTestInstructionVo != null && updateTestInstructionVo.DeleteFlag)
{
//delete inspectiontestinstruction
InspectionTestInstructionVo deleteinspectionTestInstructionVo = (InspectionTestInstructionVo)deleteInspectionTestInstructionMasterMntNewCbm.Execute(trxContext, updateTestInstructionVo);
outVo.AffectedCount = deleteinspectionTestInstructionVo.AffectedCount;
outVo.InspectionItemId = updateTestInstructionVo.InspectionItemId;
outVo.InspectionTestInstructionId = updateTestInstructionVo.InspectionTestInstructionId;
return(outVo);
}
else if (updateTestInstructionDetailVo != null && updateTestInstructionDetailVo.DeleteFlag)
{
//delete inspectiontestinstructiondetail
InspectionTestInstructionVo deleteInspectionTestInstructionDetailVo = (InspectionTestInstructionVo)deleteInspectionTestInstructionDetailMasterMntCbm.Execute(trxContext, updateTestInstructionDetailVo);
outVo.AffectedCount = deleteInspectionTestInstructionDetailVo.AffectedCount;
outVo.InspectionTestInstructionId = updateTestInstructionDetailVo.InspectionTestInstructionId;
return(outVo);
}
return(outVo);
}
