private void Detail_btn_Click(object sender, EventArgs e)
{
if (InspectionTestInstructionId <= 0)
{
messageData = new MessageData("mmce00010", Properties.Resources.mmce00010, "InspectionTestInstructionId");
popUpMessage.Warning(messageData, Text);
return;
}
//updateData
InspectionTestInstructionVo inVo = new InspectionTestInstructionVo();
inVo.InspectionTestInstructionId = InspectionTestInstructionId;
inVo.InspectionTestInstructionText = InspectionTestInstructionText_txt.Text.Trim();
inVo.InspectionTestInstructionCode = InspectionTestInstructionCode;
InspectionTestInstructionDetailForm frm = new GlobalMasterMaintenance.InspectionTestInstructionDetailForm(inVo);
frm.ShowDialog();
if (frm.InspectionTestInstructionId > 0)
{
InspectionFormatProcessBuzzLogic getprocessid = new InspectionFormatProcessBuzzLogic();
InspectionReturnVo invo = new InspectionReturnVo();
invo.InspectionTestInstructionId = frm.InspectionTestInstructionId;
InspectionTestInstructionId = frm.InspectionTestInstructionId;
InspectionReturnVo getInspectionVo = getprocessid.RefreshAllFormGrid(invo);
if (getInspectionVo != null && getInspectionVo.InspectionItemId > 0)
{
InspectionItemId = getInspectionVo.InspectionItemId;
updateData.InspectionItemId = InspectionItemId;
//FormDatatableFromVo();
//ComboBind(InspectionItem_cmb, inspectionitemDatatable, "Name", "Id");
//InspectionItem_cmb.SelectedValue = InspectionItemId;
}
}
}
private void InspectionTestInstruction_btn_Click(object sender, EventArgs e)
{
int selectedrowindex = InspectionItem_dgv.SelectedCells[0].RowIndex;
InspectionItemVo InspectionAddVo = (InspectionItemVo)InspectionItem_dgv.Rows[selectedrowindex].DataBoundItem;
InspectionTestInstructionVo inVo = new InspectionTestInstructionVo();
inVo.InspectionTestInstructionId = InspectionAddVo.InspectionTestInstructionId;
inVo.InspectionTestInstructionCode = InspectionAddVo.InspectionTestInstructionCode;
inVo.InspectionItemId = InspectionAddVo.InspectionItemId;
inVo.InspectionItemCode = InspectionAddVo.InspectionItemCode;
inVo.InspectionItemName = InspectionAddVo.InspectionItemName;
AddInspectionTestInstructionForItemForm newAddForm = new AddInspectionTestInstructionForItemForm(CommonConstants.MODE_ADD, inVo);
newAddForm.InspectionProcessId = InspectionProcessId;
newAddForm.ShowDialog();
if (newAddForm.InspectionItemId > 0)
{
InspectionFormatProcessBuzzLogic getprocessid = new InspectionFormatProcessBuzzLogic();
InspectionReturnVo invo = new InspectionReturnVo();
invo.InspectionItemId = newAddForm.InspectionItemId;
InspectionReturnVo getInspectionVo = getprocessid.RefreshAllFormGrid(invo);
if (getInspectionVo != null && getInspectionVo.InspectionProcessId > 0)
{
InspectionProcessId = getInspectionVo.InspectionProcessId;
//LoadInspectionProcessCombo();
//InspectionProcess_cmb.SelectedValue = InspectionProcessId;
}
}
GridBind();
if (InspectionItem_dgv.Rows.Count > 0 && InspectionItem_dgv.Columns.Count > 0 && InspectionItem_dgv.Columns["ColInspectionItemId"] != null)
{
int searchItemId;
if (newAddForm.InspectionItemId > 0)
{
searchItemId = newAddForm.InspectionItemId;
}
else
{
searchItemId = InspectionAddVo.InspectionItemId;
}
DataGridViewRow row = InspectionItem_dgv.Rows
.Cast <DataGridViewRow>()
.FirstOrDefault(r => r.Cells["ColInspectionItemId"].Value.ToString().Equals(searchItemId.ToString()));
if (row == null)
{
return;
}
InspectionItem_dgv.Rows[row.Index].Selected = true;
InspectionItem_dgv_CellClick(sender, new DataGridViewCellEventArgs(0, row.Index));
InspectionItem_dgv.FirstDisplayedScrollingRowIndex = row.Index;
}
}
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>
/// To get the Format Id based on Process id
/// </summary>
/// <param name="inspectionprocessid"></param>
/// <returns></returns>
public InspectionReturnVo RefreshAllFormGrid(InspectionReturnVo inVo)
{
InspectionReturnVo outVo = null;
try
{
outVo = (InspectionReturnVo)DefaultCbmInvoker.Invoke(new GetAllInspectionIDMasterMntCbm(), inVo);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), null);
logger.Error(exception.GetMessageData());
}
return(outVo);
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
ValueObjectList <ValueObject> inListVo = (ValueObjectList <ValueObject>)vo;
InspectionReturnVo outVo = null;
if (inListVo == null && inListVo.GetList() == null && inListVo.GetList().Count < 7)
{
return(outVo);
}
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];
//Initialize Vo for Get the new inserted Result
ValueObjectList <ValueObjectList <ValueObject> > inspectionProcessListInVo = null;
ValueObjectList <ValueObjectList <ValueObject> > inspectionItemListInVo = null;
// Only For Process Copy
if (updateprocessVo != null && updateprocessVo.InspectionProcessIdCopy > 0)
{
//Insert inspection process master data
inspectionProcessListInVo = (ValueObjectList <ValueObjectList <ValueObject> >)copyInspectionProcessFromProcessMasterMntCbm.Execute(trxContext, updateprocessVo);
if (inspectionProcessListInVo != null)
{
outVo = new InspectionReturnVo();
outVo.InspectionFormatId = updateprocessVo.InspectionFormatId;
foreach (ValueObjectList <ValueObject> getProcessVo in inspectionProcessListInVo.GetList())
{
outVo.InspectionProcessId = ((InspectionProcessVo)getProcessVo.GetList()[1]).InspectionProcessId;
outVo.AffectedCount = ((InspectionProcessVo)getProcessVo.GetList()[1]).InspectionProcessId;
}
}
}
else if (updateitemVo != null && updateitemVo.InspectionItemIdCopy > 0) // Only For Item Copy
{
//Insert inspection item master data
inspectionItemListInVo = (ValueObjectList <ValueObjectList <ValueObject> >)copyInspectionItemFromItemMasterMntCbm.Execute(trxContext, updateitemVo);
if (inspectionItemListInVo != null)
{
outVo = new InspectionReturnVo();
outVo.InspectionProcessId = updateitemVo.InspectionProcessId;
foreach (ValueObjectList <ValueObject> getItemVo in inspectionItemListInVo.GetList())
{
outVo.InspectionItemId = ((InspectionItemVo)getItemVo.GetList()[1]).InspectionItemId;
outVo.AffectedCount = ((InspectionItemVo)getItemVo.GetList()[1]).InspectionItemId;
}
}
}
else //Format Copy ,update, delete
{
//add inspectionformat based on the copied format
InspectionFormatVo inspectionFormatVo = (InspectionFormatVo)addInspectionFormatAndItemLineFormatCbm.Execute(trxContext, updateFormatVo);
//if inspectionformat data is null return null
if (inspectionFormatVo == null)
{
return(outVo);
}
outVo = new InspectionReturnVo();
outVo.AffectedCount = 1;
outVo.InspectionFormatId = inspectionFormatVo.InspectionFormatId;
//To get the Process Details based on the Copied format id
inspectionFormatVo.InspectionFormatIdCopy = updateFormatVo.InspectionFormatIdCopy;
// To pass the parameter to get and update the Inspection Process
ValueObjectList <ValueObject> inVo = new ValueObjectList <ValueObject>();
inVo.add(inspectionFormatVo);
inVo.add(updateprocessVo);
//Insert inspection process master data
inspectionProcessListInVo = (ValueObjectList <ValueObjectList <ValueObject> >)copyInspectionProcessMasterMntCbm.Execute(trxContext, inVo);
}
if (inspectionItemListInVo == null)
{
if (inspectionProcessListInVo == null || inspectionProcessListInVo.GetList() == null || inspectionProcessListInVo.GetList().Count == 0)
{
return(outVo);
}
if (outVo == null)
{
outVo = new InspectionReturnVo();
outVo.AffectedCount = 1;
}
if (updateprocessVo != null && updateprocessVo.InspectionProcessIdCopy == 0)
{
InspectionProcessVo returnProcessVo = (InspectionProcessVo)inspectionProcessListInVo.GetList()[inspectionProcessListInVo.GetList().Count - 1].GetList()[0];
if (returnProcessVo != null)
{
outVo.InspectionFormatId = returnProcessVo.InspectionFormatId;
outVo.InspectionProcessId = returnProcessVo.InspectionProcessId;
}
//To Remove the ReturnVo
inspectionProcessListInVo.GetList().RemoveAt(inspectionProcessListInVo.GetList().Count - 1);
}
// To pass the parameter to get and update the Inspection Item
ValueObjectList <ValueObject> updateitemVoList = new ValueObjectList <ValueObject>();
updateitemVoList.add(updateitemVo);
inspectionProcessListInVo.add(updateitemVoList);
//Insert inspection Item master data
inspectionItemListInVo = (ValueObjectList <ValueObjectList <ValueObject> >)copyInspectionItemMasterMntCbm.Execute(trxContext, inspectionProcessListInVo);
if (inspectionItemListInVo == null || inspectionItemListInVo.GetList() == null || inspectionItemListInVo.GetList().Count == 0)
{
return(outVo);
}
if (updateitemVo != null)
{
InspectionItemVo returnItemVo = (InspectionItemVo)inspectionItemListInVo.GetList()[inspectionItemListInVo.GetList().Count - 1].GetList()[0];
if (returnItemVo != null)
{
outVo.InspectionProcessId = returnItemVo.InspectionProcessId;
outVo.InspectionItemId = returnItemVo.InspectionItemId;
}
//To Remove the ReturnVo
inspectionItemListInVo.GetList().RemoveAt(inspectionItemListInVo.GetList().Count - 1);
}
// To pass the parameter to get and update the Inspection Selection Value
ValueObjectList <ValueObject> updateSelectionValueVoList = new ValueObjectList <ValueObject>();
updateSelectionValueVoList.add(updateSelectionDataTypeValueVo);
inspectionItemListInVo.add(updateSelectionValueVoList);
//Insert inspection Item Selection DataType Value master data
InspectionReturnVo returnSelectionVo = (InspectionReturnVo)copyInspectionSelectionDataTypeMasterMntCbm.Execute(trxContext, inspectionItemListInVo);
if (updateSelectionDataTypeValueVo != null && returnSelectionVo != null)
{
outVo.InspectionItemId = returnSelectionVo.InspectionItemId;
}
}
// To pass the parameter to get and update the Inspection Specification
ValueObjectList <ValueObject> updateSpecificationVoList = new ValueObjectList <ValueObject>();
updateSpecificationVoList.add(updateSpecificationVo);
inspectionItemListInVo.add(updateSpecificationVoList);
//Insert inspection Specification master data
InspectionReturnVo returnSpecVo = (InspectionReturnVo)copyInspectionSpecificationMasterMntCbm.Execute(trxContext, inspectionItemListInVo);
if (updateSpecificationVo != null && returnSpecVo != null)
{
outVo.InspectionItemId = returnSpecVo.InspectionItemId;
}
// To pass the parameter to get and update the Inspection Test Instruction
ValueObjectList <ValueObject> updateTestInstVoList = new ValueObjectList <ValueObject>();
updateTestInstVoList.add(updateTestInstructionVo);
inspectionItemListInVo.add(updateTestInstVoList);
//Insert inspection Test Instruction master data
ValueObjectList <ValueObjectList <ValueObject> > inspectionTestInstructionOutVo = (ValueObjectList <ValueObjectList <ValueObject> >)copyInspectionTestInstructionMasterMntCbm.Execute(trxContext, inspectionItemListInVo);
if (inspectionTestInstructionOutVo == null || inspectionTestInstructionOutVo.GetList() == null || inspectionTestInstructionOutVo.GetList().Count == 0)
{
return(outVo);
}
if (updateTestInstructionVo != null)
{
InspectionTestInstructionVo returnTestInstVo = (InspectionTestInstructionVo)inspectionTestInstructionOutVo.GetList()[inspectionTestInstructionOutVo.GetList().Count - 1].GetList()[0];
if (returnTestInstVo != null)
{
outVo.InspectionItemId = returnTestInstVo.InspectionItemId;
}
//To Remove the ReturnVo
inspectionTestInstructionOutVo.GetList().RemoveAt(inspectionTestInstructionOutVo.GetList().Count - 1);
}
// To pass the parameter to get and update the Insepection Test Instruction Details
ValueObjectList <ValueObject> updateTestInstDetailVoList = new ValueObjectList <ValueObject>();
updateTestInstDetailVoList.add(updateTestInstructionDetailVo);
inspectionTestInstructionOutVo.add(updateTestInstDetailVoList);
//Insert inspection Test Instruction detail master data
InspectionReturnVo returndetailVo = (InspectionReturnVo)copyInspectionTestInstructionDetailMasterMntCbm.Execute(trxContext, inspectionTestInstructionOutVo);
if (updateTestInstructionDetailVo != null && returndetailVo != null)
{
outVo.InspectionTestInstructionId = returndetailVo.InspectionTestInstructionId;
}
return(outVo);
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
ValueObjectList <ValueObjectList <ValueObject> > inVo = (ValueObjectList <ValueObjectList <ValueObject> >)vo;
if (inVo == null || inVo.GetList() == null || inVo.GetList().Count == 0)
{
return(outVo);
}
ValueObjectList <ValueObject> updateSelectionValueListVo = new ValueObjectList <ValueObject>();
UpdateResultVo returnitemSelectionInsertedVo = null;
updateSelectionValueListVo = inVo.GetList()[inVo.GetList().Count - 1];
if (updateSelectionValueListVo != null && updateSelectionValueListVo.GetList() != null && updateSelectionValueListVo.GetList().Count > 0)
{
UpdateSelectionValueVo = new InspectionItemSelectionDatatypeValueVo();
UpdateSelectionValueVo = (InspectionItemSelectionDatatypeValueVo)updateSelectionValueListVo.GetList()[0];
}
inVo.GetList().RemoveAt(inVo.GetList().Count - 1);
//get inspection Selection Value list for the above fetched itemlist
inspectionSelectionValueListInVo = (ValueObjectList <InspectionItemSelectionDatatypeValueVo>)getInspectionSelectionDataTypeListCbm.Execute(trxContext, inVo);
if (inspectionSelectionValueListInVo == null || inspectionSelectionValueListInVo.GetList() == null || inspectionSelectionValueListInVo.GetList().Count == 0)
{
return(outVo);
}
if (UpdateSelectionValueVo != null && UpdateSelectionValueVo.InspectionItemSelectionDatatypeValueId > 0)
{
if (UpdateSelectionValueVo.DeleteFlag)
{
inspectionSelectionValueListInVo.GetList().Remove(inspectionSelectionValueListInVo.GetList().Single(v => v.InspectionItemSelectionDatatypeValueId == UpdateSelectionValueVo.InspectionItemSelectionDatatypeValueId));
}
else
{
foreach (InspectionItemSelectionDatatypeValueVo ItemVo in inspectionSelectionValueListInVo.GetList().Where(v => v.InspectionItemSelectionDatatypeValueId == UpdateSelectionValueVo.InspectionItemSelectionDatatypeValueId))
{
ItemVo.InspectionItemSelectionDatatypeValueText = UpdateSelectionValueVo.InspectionItemSelectionDatatypeValueText;
ItemVo.DisplayOrder = UpdateSelectionValueVo.DisplayOrder;
}
}
}
int returnProcessId = 0;
foreach (ValueObjectList <ValueObject> getitemVo in inVo.GetList())
{
InspectionItemVo OldInsProcessVo = (InspectionItemVo)getitemVo.GetList()[0];
InspectionItemVo NewInsProcessVo = (InspectionItemVo)getitemVo.GetList()[1];
int ItemSelectionCount = 1;
foreach (InspectionItemSelectionDatatypeValueVo itemVo in inspectionSelectionValueListInVo.GetList().Where(v => v.InspectionItemId == OldInsProcessVo.InspectionItemId).Distinct())
{
itemVo.InspectionItemId = NewInsProcessVo.InspectionItemId;
itemVo.InspectionItemSelectionDatatypeValueCode = NewInsProcessVo.InspectionItemCode +
GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue() +
GlobalMasterDataTypeEnum.SELECTION_VALUE_CODE.GetValue() +
GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue() + ItemSelectionCount;
ItemSelectionCount += 1;
}
if (UpdateSelectionValueVo != null)
{
if (UpdateSelectionValueVo.InspectionItemId == OldInsProcessVo.InspectionItemId)
{
UpdateSelectionValueVo.InspectionItemId = NewInsProcessVo.InspectionItemId; returnProcessId = NewInsProcessVo.InspectionProcessId;
}
}
}
returnitemSelectionInsertedVo = (UpdateResultVo)addInspectionItemSelectionDatatypeValueCopyCbm.Execute(trxContext, inspectionSelectionValueListInVo);
if (UpdateSelectionValueVo != null)
{
if (outVo == null)
{
outVo = new InspectionReturnVo();
}
outVo.InspectionItemId = UpdateSelectionValueVo.InspectionItemId;
outVo.InspectionProcessId = returnProcessId;
}
return(outVo);
}
/// <summary>
/// inserts new record
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Ok_btn_Click(object sender, EventArgs e)
{
InspectionItemSelectionDatatypeValueVo inVo = new InspectionItemSelectionDatatypeValueVo();
var sch = StringCheckHelper.GetInstance();
if (CheckMandatory() == true)
{
inVo.InspectionItemSelectionDatatypeValueText = SelectionDatatypeValueText_txt.Text.Trim();
inVo.DisplayOrder = Convert.ToInt32(InspectionItemDisplayOrder_txt.Text);
if (InspectionItem_cmb.SelectedValue != null && InspectionItem_cmb.SelectedIndex >= 0)
{
inVo.InspectionItemId = Convert.ToInt32(InspectionItem_cmb.SelectedValue.ToString());
}
if (updateData != null)
{
inVo.InspectionItemId = updateData.InspectionItemId;
}
if (mode.Equals(CommonConstants.MODE_UPDATE))
{
inVo.InspectionItemSelectionDatatypeValueId = updateData.InspectionItemSelectionDatatypeValueId;
}
inVo.Mode = mode;
try
{
if (string.Equals(mode, CommonConstants.MODE_ADD) || string.Equals(mode, CommonConstants.MODE_SELECT))
{
InspectionItemSelectionDatatypeValueVo checkVo = DuplicateCheck(inVo);
if (checkVo != null && checkVo.AffectedCount > 0)
{
messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, SelectionDatatypeValueText_lbl.Text + " : " + SelectionDatatypeValueText_txt.Text);
popUpMessage.Information(messageData, Text);
return;
}
InspectionItemSelectionDatatypeValueVo checkDisplayVo = DuplicateDisplayCheck(inVo);
if (checkDisplayVo != null && checkDisplayVo.AffectedCount > 0)
{
messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, InspectionItemDisplayOrder_lbl.Text + " : " + InspectionItemDisplayOrder_txt.Text);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
InspectionItemDisplayOrder_txt.Focus();
return;
}
inVo.InspectionItemSelectionDatatypeValueCode = InspectionItemCode
+ GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue()
+ GlobalMasterDataTypeEnum.SELECTION_VALUE_CODE.GetValue() + GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue() + RunningNumber;
UpdateResultVo outVo = (UpdateResultVo)base.InvokeCbm(new AddInspectionItemSelectionDatatypeValueCbm(), inVo, false);
IntSuccess = outVo.AffectedCount;
}
else if (mode.Equals(CommonConstants.MODE_UPDATE))
{
if (SelectionDatatypeValueText_txt.Text == updateData.InspectionItemSelectionDatatypeValueText && updateData.DisplayOrder == Convert.ToInt32(InspectionItemDisplayOrder_txt.Text))
{
return;
}
if (updateData.InspectionItemSelectionDatatypeValueText != SelectionDatatypeValueText_txt.Text)
{
InspectionItemSelectionDatatypeValueVo checkVo = DuplicateCheck(inVo);
if (checkVo != null && checkVo.AffectedCount > 0)
{
messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, SelectionDatatypeValueText_lbl.Text + " : " + SelectionDatatypeValueText_txt.Text);
popUpMessage.Information(messageData, Text);
return;
}
}
if (updateData.DisplayOrder != Convert.ToInt32(InspectionItemDisplayOrder_txt.Text))
{
InspectionItemSelectionDatatypeValueVo checkDisplayVo = DuplicateDisplayCheck(inVo);
if (checkDisplayVo != null && checkDisplayVo.AffectedCount > 0)
{
messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, InspectionItemDisplayOrder_lbl.Text + " : " + InspectionItemDisplayOrder_txt.Text);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
InspectionItemDisplayOrder_txt.Focus();
return;
}
}
if (updateData == null)
{
UpdateResultVo outResultVo = (UpdateResultVo)base.InvokeCbm(new UpdateInspectionItemSelectionDatatypeValueCbm(), inVo, false);
if (outResultVo == null)
{
return;
}
IntSuccess = outResultVo.AffectedCount;
}
else
{
string message = string.Format(Properties.Resources.mmci00037, "Inspection Item Selection Datatype Value", SelectionDatatypeValueText_txt.Text);
StartProgress(message);
ValueObjectList <ValueObject> inVoList = new ValueObjectList <ValueObject>();
InspectionFormatVo passformatVo = FormFormatVo(updateData.InspectionItemId);
if (passformatVo == null || passformatVo.InspectionFormatId == 0)
{
return;
}
inVoList.add(passformatVo);
inVoList.add(null);
inVoList.add(null);
inVoList.add(inVo);
inVoList.add(null);
inVoList.add(null);
inVoList.add(null);
InspectionReturnVo outVo = null;
try
{
outVo = (InspectionReturnVo)base.InvokeCbm(new UpdateAllInspectionFunctionMasterMntCbm(), inVoList, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
finally
{
CompleteProgress();
}
if (outVo != null && outVo.AffectedCount > 0)
{
IntSuccess = outVo.AffectedCount;
InspectionItemId = outVo.InspectionItemId;
InspectionFormatProcessBuzzLogic getprocessid = new InspectionFormatProcessBuzzLogic();
InspectionReturnVo invo = new InspectionReturnVo();
invo.InspectionItemId = outVo.InspectionItemId;
InspectionReturnVo getInspectionVo = getprocessid.RefreshAllFormGrid(invo);
if (getInspectionVo != null && getInspectionVo.InspectionProcessId > 0)
{
InspectionProcessId = getInspectionVo.InspectionProcessId;
}
}
}
//UpdateInspectionItemSelectionDatatypeValueVo = new InspectionItemSelectionDatatypeValueVo();
//UpdateInspectionItemSelectionDatatypeValueVo = inVo;
//this.Close();
}
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
if ((IntSuccess > 0))
{
//messageData = new MessageData("mmci00001", Properties.Resources.mmci00001, null);
//logger.Info(messageData);
//popUpMessage.Information(messageData, Text);
this.Close();
}
}
}
/// <summary>
/// update data to db
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Ok_btn_Click(object sender, EventArgs e)
{
InspectionFormatVo inVo = new InspectionFormatVo();
if (CheckMandatory())
{
if (LineId_cmb.SelectedIndex > -1)
{
inVo.LineCode = LineId_cmb.SelectedValue.ToString();
inVo.LineId = lineOutVo.GetList().Where(t => t.LineCode == inVo.LineCode).FirstOrDefault().LineId;
}
//if (ItemId_cmb.SelectedIndex > -1)
//{
// inVo.SapItemCode = ItemId_cmb.SelectedValue.ToString();
// // inVo.ItemId = globalItemVo.GlobalItemListVo.Where(t => t.GlobalItemCode == inVo.ItemCode).FirstOrDefault().GlobalItemId;
//}
if (ItemCode_txt.Text.Trim() != string.Empty)
{
inVo.SapItemCode = ItemCode_txt.Text; // sapItemGlobalVo.SapItemCode;
}
string SapitemGroupName = getSapItemGroupId();
if (SapitemGroupName == null)
{
messageData = new MessageData("mmci00041", Properties.Resources.mmci00041, ItemId_cmb.Text);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
return;
}
inVo.InspectionFormatCode = SapitemGroupName + GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue() + inVo.SapItemCode + GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue() + inVo.LineCode;
inVo.InspectionFormatName = inVo.InspectionFormatCode + GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue() + InspectionFormatName_txt.Text.Trim();
if (string.Equals(mode, CommonConstants.MODE_ADD.ToString()))
{
GlobalMasterMaintenance.Vo.InspectionFormatVo checkVo = DuplicateCheck(inVo);
if (checkVo != null && checkVo.AffectedCount > 0)
{
messageData = new MessageData("mmci00040", Properties.Resources.mmci00040, "ITEM LINE", "FORMAT NAME");
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
return;
}
}
if (string.Equals(mode, CommonConstants.MODE_ADD.ToString()))
{
if (InspectionFormatId == 0)
{
GlobalMasterMaintenance.Vo.InspectionFormatVo outVo = null;
try
{
outVo = (InspectionFormatVo)base.InvokeCbm(new AddInspectionFormatAndItemLineFormatCbm(), inVo, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
if (outVo == null)
{
return;
}
IntSuccess = outVo.InspectionFormatId;
}
else
{
inVo.InspectionFormatIdCopy = InspectionFormatId;
string message = string.Format(Properties.Resources.mmci00042, CopyFormat_txt.Text);
base.StartProgress(message);
ValueObjectList <ValueObject> inVoList = new ValueObjectList <ValueObject>();
inVoList.add(inVo);
inVoList.add(null);
inVoList.add(null);
inVoList.add(null);
inVoList.add(null);
inVoList.add(null);
inVoList.add(null);
InspectionReturnVo OutVo = null;
try
{
OutVo = (InspectionReturnVo)base.InvokeCbm(new CopyInspectionFormatMasterMntCbm(), inVoList, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
finally
{
CompleteProgress();
}
if (OutVo == null)
{
return;
}
//IntSuccess = OutVo.AffectedCount;
IntSuccess = OutVo.InspectionFormatId;
}
}
else if (string.Equals(mode, CommonConstants.MODE_UPDATE.ToString()))
{
//if (updateData != null) { inVo.InspectionFormatCode = updateData.InspectionFormatCode; }
if (InspectionFormatName_txt.Text.Trim() == updateData.InspectionFormatName.Replace(updateData.InspectionFormatCode.Substring(0, updateData.InspectionFormatCode.Length - 5), ""))
{
return;
}
GlobalMasterMaintenance.Vo.InspectionFormatVo checkVo = DuplicateCheckForUpdate(inVo);
if (checkVo != null && checkVo.AffectedCount > 0)
{
messageData = new MessageData("mmci00044", Properties.Resources.mmci00044, InspectionFormatName_txt.Text);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
return;
}
//inVo.InspectionFormatId = updateData.InspectionFormatId;
//inVo.InspectionFormatCode = updateData.InspectionFormatCode;
//inVo.InspectionFormatName = inVo.InspectionFormatCode.Substring(0, inVo.InspectionFormatCode.Length - 5)
// + InspectionFormatName_txt.Text.Trim();
inVo.InspectionFormatIdCopy = updateData.InspectionFormatId;
inVo.Mode = GlobalMasterMaintenance.CommonConstants.MODE_UPDATE;
string message = string.Format(Properties.Resources.mmci00043, "Inspection Format", InspectionFormatName_txt.Text);
base.StartProgress(message);
ValueObjectList <ValueObject> inVoList = new ValueObjectList <ValueObject>();
inVoList.add(inVo);
inVoList.add(null);
inVoList.add(null);
inVoList.add(null);
inVoList.add(null);
inVoList.add(null);
inVoList.add(null);
InspectionReturnVo outVo = null;
try
{
outVo = (InspectionReturnVo)base.InvokeCbm(new UpdateAllInspectionFunctionMasterMntCbm(), inVoList, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
finally
{
CompleteProgress();
}
if (outVo == null)
{
return;
}
//IntSuccess = outVo.AffectedCount;
IntSuccess = outVo.InspectionFormatId;
}
if ((IntSuccess > 0))
{
this.Close();
}
}
}
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));
}
/// <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 = InspectionSelectionValue_dgv.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = InspectionSelectionValue_dgv.Rows[selectedrowindex];
messageData = new MessageData("mmcc00004", Properties.Resources.mmcc00004, selectedRow.Cells["colInspectionItemSelectionValueText"].Value.ToString());
// Logger.Info(messageData);
DialogResult dialogResult = popUpMessage.ConfirmationOkCancel(messageData, Text);
if (dialogResult == DialogResult.OK)
{
InspectionItemSelectionDatatypeValueVo inVo = new InspectionItemSelectionDatatypeValueVo();
inVo.InspectionItemSelectionDatatypeValueId = Convert.ToInt32(selectedRow.Cells["colInspectionItemSelectionDatatypeValueId"].Value.ToString());
inVo.DeleteFlag = true;
if (inspectionItemdata != null)
{
inVo.InspectionItemId = inspectionItemdata.InspectionItemId;
}
else
{
inVo.InspectionItemId = InspectionItemId;
}
//UpdateInspectionItemSelectionDatatypeValueVo = inVo;
//this.Close();
try
{
UpdateResultVo deleteVo = null;
if (inspectionItemdata == null)
{
deleteVo = (UpdateResultVo)base.InvokeCbm(new DeleteInspectionItemSelectionDatatypeValueCbm(), inVo, false);
if (deleteVo == null)
{
return;
}
IntSuccess = deleteVo.AffectedCount;
if (deleteVo.AffectedCount > 0)
{
this.messageData = new MessageData("mmci00003", Properties.Resources.mmci00003, null);
logger.Info(this.messageData);
popUpMessage.Information(this.messageData, Text);
}
else if (deleteVo.AffectedCount == 0)
{
messageData = new MessageData("mmci00007", Properties.Resources.mmci00007, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
}
GridBind();
}
else
{
string message = string.Format(Properties.Resources.mmci00038, "Inspection Item Selection Datatype Value", selectedRow.Cells["colInspectionItemSelectionValueText"].Value.ToString());
StartProgress(message);
ValueObjectList <ValueObject> inVoList = new ValueObjectList <ValueObject>();
InspectionFormatVo passformatVo = FormFormatVo(inspectionItemdata.InspectionItemId);
if (passformatVo == null || passformatVo.InspectionFormatId == 0)
{
return;
}
inVoList.add(passformatVo);
inVoList.add(null);
inVoList.add(null);
inVoList.add(inVo);
inVoList.add(null);
inVoList.add(null);
inVoList.add(null);
InspectionReturnVo outVo = null;
try
{
outVo = (InspectionReturnVo)base.InvokeCbm(new UpdateAllInspectionFunctionMasterMntCbm(), inVoList, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
finally
{
CompleteProgress();
}
if (outVo != null && outVo.AffectedCount > 0)
{
IntSuccess = outVo.AffectedCount;
InspectionItemId = outVo.InspectionItemId;
inspectionItemdata.InspectionItemId = outVo.InspectionItemId;
InspectionFormatProcessBuzzLogic getprocessid = new InspectionFormatProcessBuzzLogic();
InspectionReturnVo invo = new InspectionReturnVo();
invo.InspectionItemId = outVo.InspectionItemId;
InspectionReturnVo getInspectionVo = getprocessid.RefreshAllFormGrid(invo);
if (getInspectionVo != null && getInspectionVo.InspectionProcessId > 0)
{
InspectionProcessId = getInspectionVo.InspectionProcessId;
}
this.messageData = new MessageData("mmci00003", Properties.Resources.mmci00003, null);
logger.Info(this.messageData);
popUpMessage.Information(this.messageData, Text);
GridBind();
}
else
{
messageData = new MessageData("mmci00007", Properties.Resources.mmci00007, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
}
}
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
//string message = string.Format(Properties.Resources.mmci00038, "Inspection Selection DataType Value", selectedRow.Cells["colInspectionItemSelectionValueText"].Value.ToString());
//StartProgress(message);
//ValueObjectList<ValueObject> inVoList = new ValueObjectList<ValueObject>();
//InspectionFormatVo passformatVo = FormFormatVo(inspectionItemdata.InspectionItemId);
//if (passformatVo == null || passformatVo.InspectionFormatId == 0) return;
//inVoList.add(passformatVo);
//inVoList.add(null);
//inVoList.add(null);
//inVoList.add(inVo);
//inVoList.add(null);
//inVoList.add(null);
//inVoList.add(null);
//UpdateResultVo outVo = (UpdateResultVo)base.InvokeCbm(new UpdateAllInspectionFunctionMasterMntCbm(), inVoList, false);
//CompleteProgress();
//if (outVo == null) { return; }
//try
//{
// UpdateResultVo outVo = (UpdateResultVo)base.InvokeCbm(new DeleteInspectionItemSelectionDatatypeValueCbm(), inVo, false);
// if (outVo.AffectedCount > 0)
// {
// this.messageData = new MessageData("mmci00003", Properties.Resources.mmci00003, null);
// logger.Info(this.messageData);
// popUpMessage.Information(this.messageData, Text);
// }
// else if (outVo.AffectedCount == 0)
// {
// messageData = new MessageData("mmci00007", Properties.Resources.mmci00007, null);
// logger.Info(messageData);
// popUpMessage.Information(messageData, Text);
// }
// GridBind();
//}
//catch (Framework.ApplicationException exception)
//{
// popUpMessage.ApplicationError(exception.GetMessageData(), Text);
// logger.Error(exception.GetMessageData());
//}
}
else if (dialogResult == DialogResult.Cancel)
{
//do something else
}
}
/// <summary>
/// inserts new record
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Ok_btn_Click(object sender, EventArgs e)
{
InspectionSpecificationVo inVo = new InspectionSpecificationVo();
var sch = StringCheckHelper.GetInstance();
if (!CheckMandatory())
{
return;
}
inVo.InspectionSpecificationText = InspectionSpecificationText_txt.Text.Trim();
if (InspectionItemDataType == Convert.ToInt32(GlobalMasterDataTypeEnum.DATATYPE_DATETIME.GetValue()) && DateTime_pnl.Visible)
{
inVo.ValueFrom = DateFrom_dtp.Value.ToString();
if (!string.IsNullOrEmpty(DateTo_dtp.Text.Trim()))
{
inVo.ValueTo = DateTo_dtp.Value.ToString();
}
}
else
{
inVo.ValueFrom = ValueFrom_txt.Text;
if (!string.IsNullOrWhiteSpace(ValueTo_txt.Text.Trim()))
{
inVo.ValueTo = ValueTo_txt.Text;
}
}
inVo.Unit = Unit_txt.Text.Trim();
if (Operator_cmb.SelectedIndex > -1)
{
inVo.OperatorFrom = Operator_cmb.SelectedValue.ToString();
}
if (!string.IsNullOrWhiteSpace(OperatorTo_txt.Text.Trim()))
{
inVo.OperatorTo = GlobalMasterDataTypeEnum.OPERATOR_LESSTHAN.GetValue();
}
//inVo.InspectionItemId = Convert.ToInt32(InspectionItem_cmb.SelectedValue.ToString());
inVo.InspectionItemId = InspectionItemId;
inVo.SpecificationResultJudgeType = Convert.ToInt32(SpecificationResultJudgeType_cmb.SelectedValue.ToString());
if (mode.Equals(CommonConstants.MODE_UPDATE))
{
inVo.InspectionSpecificationId = inspectionspecificationid;
}
inVo.Mode = mode;
//InspectionSpecificationVo checkVo = DuplicateCheck(inVo);
//if (checkVo != null && checkVo.AffectedCount > 0)
//{
// messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, InspectionSpecificationCode_lbl.Text + " : " + InspectionSpecificationCode_txt.Text +
// Environment.NewLine + " OR " + Environment.NewLine + InspectionItem_lbl.Text + " : " + InspectionItem_cmb.Text);
// logger.Info(messageData);
// popUpMessage.ConfirmationOkCancel(messageData, Text);
// return;
//}
if (string.Equals(mode, CommonConstants.MODE_ADD) || string.Equals(mode, CommonConstants.MODE_SELECT))
{
inVo.InspectionSpecificationCode = InspectionItemCode + GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue() + GlobalMasterDataTypeEnum.SPECIFICATION_CODE.GetValue();
UpdateResultVo outVo = null;
try
{
outVo = (UpdateResultVo)base.InvokeCbm(new AddInspectionSpecificationMasterMntCbm(), inVo, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
if (outVo == null)
{
return;
}
IntSuccess = outVo.AffectedCount;
}
else if (mode.Equals(CommonConstants.MODE_UPDATE))
{
inVo.InspectionSpecificationCode = InspectionSpecificationCode;
//InspectionSpecificationVo outVo = (InspectionSpecificationVo)base.InvokeCbm(new UpdateInspectionSpecificationMasterMntCbm(), inVo, false);
string message = string.Format(Properties.Resources.mmci00037, "Inspection Specification", InspectionSpecificationText_txt.Text);
StartProgress(message);
ValueObjectList <ValueObject> inVoList = new ValueObjectList <ValueObject>();
InspectionFormatVo passformatVo = FormFormatVo(inVo.InspectionItemId);
if (passformatVo == null || passformatVo.InspectionFormatId == 0)
{
return;
}
inVoList.add(passformatVo);
inVoList.add(null);
inVoList.add(null);
inVoList.add(null);
inVoList.add(inVo);
inVoList.add(null);
inVoList.add(null);
InspectionReturnVo outVo = null;
try
{
outVo = (InspectionReturnVo)base.InvokeCbm(new UpdateAllInspectionFunctionMasterMntCbm(), inVoList, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
finally
{
CompleteProgress();
}
if (outVo != null && outVo.AffectedCount > 0)
{
IntSuccess = outVo.AffectedCount;
InspectionItemId = outVo.InspectionItemId;
}
}
if ((IntSuccess > 0))
{
messageData = new MessageData("mmci00001", Properties.Resources.mmci00001, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
this.Close();
}
}
/// <summary>
/// update data to db
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Ok_btn_Click(object sender, EventArgs e)
{
var sch = StringCheckHelper.GetInstance();
InspectionItemVo inVo = new InspectionItemVo();
if (CheckMandatory())
{
inVo.InspectionItemName = InspectionItemName_txt.Text.Trim();
if (ParentItemCode_cmb.SelectedIndex > -1)
{
inVo.ParentInspectionItemId = Convert.ToInt32(ParentItemCode_cmb.SelectedValue.ToString());
}
//if (InspectionProcess_cmb.SelectedIndex > -1)
//{
// inVo.InspectionProcessId = Convert.ToInt32(InspectionProcess_cmb.SelectedValue);
//}
inVo.InspectionProcessId = updateData.InspectionProcessId;
inVo.InspectionItemMandatory = Convert.ToInt32(InspectionItemMandatory_chk.Checked);
inVo.InspectionEmployeeMandatory = Convert.ToInt32(InspectionEmployeeMandatory_chk.Checked);
inVo.InspectionMachineMandatory = Convert.ToInt32(InspectionMachineMandatory_chk.Checked);
inVo.InspectionItemDataType = Convert.ToInt32(InspectionItemDataType_cmb.SelectedValue);
inVo.DisplayOrder = Convert.ToInt32(InspectionItemDisplayOrder_txt.Text);
if (!string.IsNullOrEmpty(ResultItemDecimalDigits_txt.Text))
{
inVo.InspectionResultItemDecimalDigits = Convert.ToInt32(ResultItemDecimalDigits_txt.Text);
}
if (string.Equals(mode, CommonConstants.MODE_ADD))
{
InspectionItemVo checkVo = DuplicateCheck(inVo);
if (checkVo != null && checkVo.AffectedCount > 0)
{
messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, InspectionItemName_lbl.Text + " : " + InspectionItemName_txt.Text);
popUpMessage.Information(messageData, Text);
return;
}
InspectionItemVo checkDisplayVo = DuplicateDisplayCheck(inVo);
if (checkDisplayVo != null && checkDisplayVo.AffectedCount > 0)
{
messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, InspectionItemDisplayOrder_lbl.Text + " : " + InspectionItemDisplayOrder_txt.Text);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
InspectionItemDisplayOrder_txt.Focus();
return;
}
}
else if (string.Equals(mode, CommonConstants.MODE_UPDATE))
{
if (updateData.InspectionItemName != InspectionItemName_txt.Text)
{
InspectionItemVo checkVo = DuplicateCheck(inVo);
if (checkVo != null && checkVo.AffectedCount > 0)
{
messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, InspectionItemName_lbl.Text + " : " + InspectionItemName_txt.Text);
popUpMessage.Information(messageData, Text);
return;
}
}
if (updateData.DisplayOrder != Convert.ToInt32(InspectionItemDisplayOrder_txt.Text))
{
InspectionItemVo checkDisplayVo = DuplicateDisplayCheck(inVo);
if (checkDisplayVo != null && checkDisplayVo.AffectedCount > 0)
{
messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, InspectionItemDisplayOrder_lbl.Text + " : " + InspectionItemDisplayOrder_txt.Text);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
InspectionItemDisplayOrder_txt.Focus();
return;
}
}
}
if (string.Equals(mode, CommonConstants.MODE_ADD))
{
inVo.InspectionItemCode = InspectionItemCode;
if (InspectionItemCopyId == 0)
{
InspectionItemVo outVo = null;
try
{
outVo = (InspectionItemVo)base.InvokeCbm(new AddInspectionItemMasterMntCbm(), inVo, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
if (outVo == null && outVo.InspectionItemId == 0)
{
return;
}
IntSuccess = outVo.InspectionItemId;
//
if (InspectionItemDataType_cmb.SelectedIndex > -1 &&
InspectionItemDataType_cmb.SelectedValue.ToString() == GlobalMasterDataTypeEnum.DATATYPE_SELECTION.GetValue().ToString())
{
InspectionItemSelectionDatatypeValueVo inspectionItemSelectionDatatypeValueVo = new InspectionItemSelectionDatatypeValueVo();
inspectionItemSelectionDatatypeValueVo.InspectionItemCode = InspectionItemCode;
inspectionItemSelectionDatatypeValueVo.InspectionItemId = outVo.InspectionItemId;
try
{
UpdateResultVo updateResultVo = (UpdateResultVo)base.InvokeCbm(new UpdateInspectionItemIdForSelectionValueCbm(), inspectionItemSelectionDatatypeValueVo, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
}
}
else
{
inVo.InspectionItemIdCopy = InspectionItemCopyId;
//InspectionFormatVo getformatvo = inspectionFormatOutVo.GetList().Where(t => t.InspectionFormatId == inVo.InspectionFormatId).FirstOrDefault();
//if (getformatvo == null) return;
if (!CheckDataExist(InspectionItemCopyId))
{
messageData = new MessageData("mmci00048", Properties.Resources.mmci00048.ToString(), CopyItem_txt.Text);
logger.Info(messageData);
DialogResult dialogResult = popUpMessage.ConfirmationOkCancel(messageData, Text);
if (dialogResult != DialogResult.OK)
{
return;
}
}
string message = string.Format(Properties.Resources.mmci00045, CopyItem_txt.Text);
base.StartProgress(message);
inVo.InspectionProcessCode = updateData.InspectionProcessCode; // getformatvo.InspectionFormatCode;
//inVo.SequenceNo = RunningNumber;
ValueObjectList <ValueObject> inVoList = new ValueObjectList <ValueObject>();
inVoList.add(null);
inVoList.add(null);
inVoList.add(inVo);
inVoList.add(null);
inVoList.add(null);
inVoList.add(null);
inVoList.add(null);
InspectionReturnVo OutVo = null;
try
{
OutVo = (InspectionReturnVo)base.InvokeCbm(new CopyInspectionItemFromItemAllCbm(), inVoList, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
finally
{
CompleteProgress();
}
if (OutVo != null && OutVo.AffectedCount > 0)
{
IntSuccess = OutVo.InspectionItemId;
ReturnProcessId = OutVo.InspectionProcessId;
is_Copied = true;
}
}
}
else if (string.Equals(mode, CommonConstants.MODE_UPDATE))
{
inVo.InspectionItemId = updateData.InspectionItemId;
string message = string.Format(Properties.Resources.mmci00037, "Inspection Item", InspectionItemName_txt.Text);
StartProgress(message);
ValueObjectList <ValueObject> inVoList = new ValueObjectList <ValueObject>();
InspectionFormatVo passformatVo = FormFormatVo(updateData.InspectionItemId);
if (passformatVo == null || passformatVo.InspectionFormatId == 0)
{
return;
}
inVoList.add(passformatVo);
inVoList.add(null);
inVoList.add(inVo);
inVoList.add(null);
inVoList.add(null);
inVoList.add(null);
inVoList.add(null);
InspectionReturnVo outVo = null;
try
{
outVo = (InspectionReturnVo)base.InvokeCbm(new UpdateAllInspectionFunctionMasterMntCbm(), inVoList, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
finally
{
CompleteProgress();
}
if (outVo != null && outVo.AffectedCount > 0)
{
IntSuccess = outVo.InspectionItemId;
ReturnProcessId = outVo.InspectionProcessId;
}
//InspectionItemVo outVo = (InspectionItemVo)base.InvokeCbm(new UpdateInspectionItemMasterMntCbm(), inVo, false);
}
if (IntSuccess > 0)
{
this.Close();
}
}
}
/// <summary>
/// inserts new record
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Ok_btn_Click(object sender, EventArgs e)
{
InspectionTestInstructionVo inVo = new InspectionTestInstructionVo();
var sch = StringCheckHelper.GetInstance();
if (!CheckMandatory())
{
return;
}
inVo.InspectionTestInstructionText = InspectionTestInstructionText_txt.Text.Trim();
//inVo.InspectionItemId = Convert.ToInt32(InspectionItem_cmb.SelectedValue.ToString());
inVo.InspectionItemId = updateData.InspectionItemId;
inVo.Mode = mode;
if (string.Equals(mode, CommonConstants.MODE_UPDATE))
{
inVo.InspectionTestInstructionId = InspectionTestInstructionId;
}
//InspectionTestInstructionVo checkVo = DuplicateCheck(inVo);
//if (checkVo != null && checkVo.AffectedCount > 0)
//{
// messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, InspectionTestInstructionCode_lbl.Text + " : " + InspectionTestInstructionCode_txt.Text +
// Environment.NewLine + " OR " + Environment.NewLine + InspectionItem_lbl.Text + " : " + InspectionItem_cmb.Text);
// logger.Info(messageData);
// popUpMessage.ConfirmationOkCancel(messageData, Text);
// return;
//}
if (string.Equals(mode, CommonConstants.MODE_ADD))
{
InspectionTestInstructionCode = updateData.InspectionItemCode + GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue() + GlobalMasterDataTypeEnum.TEST_INST_CODE.GetValue();
inVo.InspectionTestInstructionCode = InspectionTestInstructionCode;
InspectionTestInstructionVo outVo = null;
try
{
outVo = (InspectionTestInstructionVo)base.InvokeCbm(new AddInspectionTestInstructionMasterMntCbm(), inVo, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
if (outVo == null)
{
return;
}
IntSuccess = outVo.InspectionTestInstructionId;
InspectionTestInstructionId = outVo.InspectionTestInstructionId;
mode = CommonConstants.MODE_UPDATE;
}
else if (mode.Equals(CommonConstants.MODE_UPDATE))
{
inVo.InspectionTestInstructionCode = InspectionTestInstructionCode;
// InspectionTestInstructionVo outVo = (InspectionTestInstructionVo)base.InvokeCbm(new UpdateInspectionTestInstructionMasterMntCbm(), inVo, false);
string message = string.Format(Properties.Resources.mmci00037, "Inspection Test Instruction", InspectionTestInstructionText_txt.Text);
StartProgress(message);
ValueObjectList <ValueObject> inVoList = new ValueObjectList <ValueObject>();
InspectionFormatVo passformatVo = FormFormatVo(inVo.InspectionItemId);
if (passformatVo == null || passformatVo.InspectionFormatId == 0)
{
return;
}
inVoList.add(passformatVo);
inVoList.add(null);
inVoList.add(null);
inVoList.add(null);
inVoList.add(null);
inVoList.add(inVo);
inVoList.add(null);
InspectionReturnVo outVo = null;
try
{
outVo = (InspectionReturnVo)base.InvokeCbm(new UpdateAllInspectionFunctionMasterMntCbm(), inVoList, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
finally
{
CompleteProgress();
}
if (outVo != null && outVo.AffectedCount > 0)
{
IntSuccess = outVo.AffectedCount;
InspectionItemId = outVo.InspectionItemId;
updateData.InspectionItemId = InspectionItemId;
InspectionTestInstructionId = outVo.InspectionTestInstructionId;
//FormDatatableFromVo();
//ComboBind(InspectionItem_cmb, inspectionitemDatatable, "Name", "Id");
//InspectionItem_cmb.SelectedValue = InspectionItemId;
}
}
if ((IntSuccess > 0))
{
messageData = new MessageData("mmci00001", Properties.Resources.mmci00001, null);
popUpMessage.Information(messageData, Text);
Detail_btn.Enabled = delete_btn.Enabled = true;
}
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
ValueObjectList <ValueObjectList <ValueObject> > inVo = (ValueObjectList <ValueObjectList <ValueObject> >)vo;
if (inVo == null || inVo.GetList() == null || inVo.GetList().Count == 0)
{
return(outVo);
}
ValueObjectList <ValueObject> updateSpecificationListVo = new ValueObjectList <ValueObject>();
UpdateResultVo returnitemSpecificationInsertedVo = null;
updateSpecificationListVo = inVo.GetList()[inVo.GetList().Count - 1];
if (updateSpecificationListVo != null && updateSpecificationListVo.GetList() != null && updateSpecificationListVo.GetList().Count > 0)
{
UpdateSpecificationVo = new InspectionSpecificationVo();
UpdateSpecificationVo = (InspectionSpecificationVo)updateSpecificationListVo.GetList()[0];
}
inVo.GetList().RemoveAt(inVo.GetList().Count - 1);
//get inspection Specification list for the above fetched itemlist
InspectionSpecificationListInVo = (ValueObjectList <InspectionSpecificationVo>)getInspectionSpecficationListCbm.Execute(trxContext, inVo);
if (InspectionSpecificationListInVo == null || InspectionSpecificationListInVo.GetList() == null || InspectionSpecificationListInVo.GetList().Count == 0)
{
return(outVo);
}
if (UpdateSpecificationVo != null && UpdateSpecificationVo.InspectionSpecificationId > 0)
{
if (UpdateSpecificationVo.DeleteFlag)
{
InspectionSpecificationListInVo.GetList().Remove(InspectionSpecificationListInVo.GetList().Single(v => v.InspectionSpecificationId == UpdateSpecificationVo.InspectionSpecificationId));
}
else
{
foreach (InspectionSpecificationVo ItemVo in InspectionSpecificationListInVo.GetList().Where(v => v.InspectionSpecificationId == UpdateSpecificationVo.InspectionSpecificationId))
{
ItemVo.InspectionSpecificationCode = UpdateSpecificationVo.InspectionSpecificationCode;
ItemVo.InspectionSpecificationText = UpdateSpecificationVo.InspectionSpecificationText;
ItemVo.ValueFrom = UpdateSpecificationVo.ValueFrom;
ItemVo.ValueTo = UpdateSpecificationVo.ValueTo;
ItemVo.Unit = UpdateSpecificationVo.Unit;
ItemVo.OperatorFrom = UpdateSpecificationVo.OperatorFrom;
ItemVo.OperatorTo = UpdateSpecificationVo.OperatorTo;
ItemVo.InspectionItemId = UpdateSpecificationVo.InspectionItemId;
ItemVo.SpecificationResultJudgeType = UpdateSpecificationVo.SpecificationResultJudgeType;
}
}
}
foreach (ValueObjectList <ValueObject> getitemVo in inVo.GetList())
{
InspectionItemVo OldInsProcessVo = (InspectionItemVo)getitemVo.GetList()[0];
InspectionItemVo NewInsProcessVo = (InspectionItemVo)getitemVo.GetList()[1];
foreach (InspectionSpecificationVo inspectionSpecificationVo in InspectionSpecificationListInVo.GetList().Where(v => v.InspectionItemId == OldInsProcessVo.InspectionItemId).Distinct())
{
inspectionSpecificationVo.InspectionItemId = NewInsProcessVo.InspectionItemId;
inspectionSpecificationVo.InspectionSpecificationCode = NewInsProcessVo.InspectionItemCode +
GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue() +
GlobalMasterDataTypeEnum.SPECIFICATION_CODE.GetValue();
}
if (UpdateSpecificationVo != null)
{
if (UpdateSpecificationVo.InspectionItemId == OldInsProcessVo.InspectionItemId)
{
UpdateSpecificationVo.InspectionItemId = NewInsProcessVo.InspectionItemId;
}
}
}
returnitemSpecificationInsertedVo = (UpdateResultVo)addInspectionSpecificationCopyCbm.Execute(trxContext, InspectionSpecificationListInVo);
if (UpdateSpecificationVo != null)
{
if (outVo == null)
{
outVo = new InspectionReturnVo();
}
outVo.InspectionItemId = UpdateSpecificationVo.InspectionItemId;
}
return(outVo);
}
/// <summary>
/// inserts new record
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Ok_btn_Click(object sender, EventArgs e)
{
InspectionProcessVo inVo = new InspectionProcessVo();
var sch = StringCheckHelper.GetInstance();
if (!CheckMandatory())
{
return;
}
inVo.InspectionProcessName = InspectionProcessName_txt.Text.Trim();
inVo.InspectionFormatId = updateData.InspectionFormatId; // Convert.ToInt32(InspectionFormat_cmb.SelectedValue.ToString());
inVo.DisplayOrder = Convert.ToInt32(InspectionProcessDisplayOrder_txt.Text);
if (string.Equals(mode, CommonConstants.MODE_ADD))
{
InspectionProcessVo checkVo = DuplicateCheck(inVo);
if (checkVo != null && checkVo.AffectedCount > 0)
{
messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, InspectionProcessName_lbl.Text + " : " + InspectionProcessName_txt.Text);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
return;
}
InspectionProcessVo checkDisplayVo = DuplicateDisplayCheck(inVo);
if (checkDisplayVo != null && checkDisplayVo.AffectedCount > 0)
{
messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, InspectionProcessDisplayOrder_lbl.Text + " : " + InspectionProcessDisplayOrder_txt.Text);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
InspectionProcessDisplayOrder_txt.Focus();
return;
}
if (InspectionprocessId == 0)
{
inVo.InspectionProcessCode = updateData.InspectionFormatCode + GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue() + GlobalMasterDataTypeEnum.PROCESS_CODE.GetValue() + GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue() + RunningNumber;
InspectionProcessVo outVo = null;
try
{
outVo = (InspectionProcessVo)base.InvokeCbm(new AddInspectionProcessMasterMntCbm(), inVo, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
if (outVo == null)
{
return;
}
IntSuccess = outVo.InspectionProcessId;
}
else
{
inVo.InspectionProcessIdCopy = InspectionprocessId;
//InspectionFormatVo getformatvo = inspectionFormatOutVo.GetList().Where(t => t.InspectionFormatId == inVo.InspectionFormatId).FirstOrDefault();
//if (getformatvo == null) return;
string message = string.Format(Properties.Resources.mmci00036, CopyProcess_txt.Text);
base.StartProgress(message);
inVo.InspectionFormatCode = updateData.InspectionFormatCode; // getformatvo.InspectionFormatCode;
inVo.SequenceNo = RunningNumber;
ValueObjectList <ValueObject> inVoList = new ValueObjectList <ValueObject>();
inVoList.add(null);
inVoList.add(inVo);
inVoList.add(null);
inVoList.add(null);
inVoList.add(null);
inVoList.add(null);
inVoList.add(null);
InspectionReturnVo OutVo = null;
try
{
OutVo = (InspectionReturnVo)base.InvokeCbm(new CopyInspectionFormatMasterMntCbm(), inVoList, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
finally
{
CompleteProgress();
}
if (OutVo != null && OutVo.AffectedCount > 0)
{
IntSuccess = OutVo.InspectionProcessId;
ReturnFormatId = OutVo.InspectionFormatId;
}
}
}
else if (mode.Equals(CommonConstants.MODE_UPDATE))
{
if (InspectionProcessName_txt.Text == updateData.InspectionProcessName && InspectionProcessDisplayOrder_txt.Text == updateData.DisplayOrder.ToString())
{
return;
}
if (InspectionProcessName_txt.Text != updateData.InspectionProcessName)
{
InspectionProcessVo checkVo = DuplicateCheck(inVo);
if (checkVo != null && checkVo.AffectedCount > 0)
{
messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, InspectionProcessName_lbl.Text + " : " + InspectionProcessName_txt.Text);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
return;
}
}
if (InspectionProcessDisplayOrder_txt.Text != updateData.DisplayOrder.ToString())
{
InspectionProcessVo checkDisplayVo = DuplicateDisplayCheck(inVo);
if (checkDisplayVo != null && checkDisplayVo.AffectedCount > 0)
{
messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, InspectionProcessDisplayOrder_lbl.Text + " : " + InspectionProcessDisplayOrder_txt.Text);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
InspectionProcessDisplayOrder_txt.Focus();
return;
}
}
inVo.InspectionProcessId = updateData.InspectionProcessId;
inVo.InspectionProcessCode = updateData.InspectionProcessCode;
string message = string.Format(Properties.Resources.mmci00037, "Inspection Process", InspectionProcessName_txt.Text);
StartProgress(message);
ValueObjectList <ValueObject> inVoList = new ValueObjectList <ValueObject>();
InspectionFormatVo passformatVo = FormFormatVo(updateData.InspectionProcessId);
if (passformatVo == null || passformatVo.InspectionFormatId == 0)
{
return;
}
inVoList.add(passformatVo);
inVoList.add(inVo);
inVoList.add(null);
inVoList.add(null);
inVoList.add(null);
inVoList.add(null);
inVoList.add(null);
InspectionReturnVo outVo = null;
try
{
outVo = (InspectionReturnVo)base.InvokeCbm(new UpdateAllInspectionFunctionMasterMntCbm(), inVoList, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
finally
{
CompleteProgress();
}
if (outVo != null && outVo.AffectedCount > 0)
{
IntSuccess = outVo.InspectionProcessId;
ReturnFormatId = outVo.InspectionFormatId;
}
}
if (IntSuccess > 0)
{
this.Close();
}
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
ValueObjectList <ValueObjectList <ValueObject> > inVo = (ValueObjectList <ValueObjectList <ValueObject> >)vo;
if (inVo == null || inVo.GetList() == null || inVo.GetList().Count == 0)
{
return(outVo);
}
ValueObjectList <ValueObject> UpdateInstTestDetailListVo = new ValueObjectList <ValueObject>();
UpdateResultVo returnInstTestDetailInsertedVo = null;
UpdateInstTestDetailListVo = inVo.GetList()[inVo.GetList().Count - 1];
if (UpdateInstTestDetailListVo != null && UpdateInstTestDetailListVo.GetList() != null && UpdateInstTestDetailListVo.GetList().Count > 0)
{
UpdateTestInstDetailVo = new InspectionTestInstructionVo();
UpdateTestInstDetailVo = (InspectionTestInstructionVo)UpdateInstTestDetailListVo.GetList()[0];
}
inVo.GetList().RemoveAt(inVo.GetList().Count - 1);
//get inspection Selection Value list for the above fetched itemlist
inspectionTestInstructionListInVo = (ValueObjectList <InspectionTestInstructionVo>)getInspectionTestInstructionDetailCbm.Execute(trxContext, inVo);
if (inspectionTestInstructionListInVo == null || inspectionTestInstructionListInVo.GetList() == null || inspectionTestInstructionListInVo.GetList().Count == 0)
{
return(outVo);
}
if (UpdateTestInstDetailVo != null && UpdateTestInstDetailVo.InspectionTestInstructionDetailId > 0)
{
if (UpdateTestInstDetailVo.DeleteFlag)
{
inspectionTestInstructionListInVo.GetList().Remove(inspectionTestInstructionListInVo.GetList().Single(v => v.InspectionTestInstructionDetailId == UpdateTestInstDetailVo.InspectionTestInstructionDetailId));
}
else
{
foreach (InspectionTestInstructionVo ItemVo in inspectionTestInstructionListInVo.GetList().Where(v => v.InspectionTestInstructionDetailId == UpdateTestInstDetailVo.InspectionTestInstructionDetailId))
{
ItemVo.InspectionTestInstructionDetailCode = UpdateTestInstDetailVo.InspectionTestInstructionDetailCode;
ItemVo.InspectionTestInstructionDetailText = UpdateTestInstDetailVo.InspectionTestInstructionDetailText;
ItemVo.InspectionTestInstructionDetailResultCount = UpdateTestInstDetailVo.InspectionTestInstructionDetailResultCount;
ItemVo.InspectionTestInstructionDetailMachine = UpdateTestInstDetailVo.InspectionTestInstructionDetailMachine;
}
}
}
foreach (ValueObjectList <ValueObject> getTestInstructionVo in inVo.GetList())
{
InspectionTestInstructionVo OldTestInstVo = (InspectionTestInstructionVo)getTestInstructionVo.GetList()[0];
InspectionTestInstructionVo NewTestInstVo = (InspectionTestInstructionVo)getTestInstructionVo.GetList()[1];
int InspTestInstructionDetailCount = 1;
foreach (InspectionTestInstructionVo inspectionTestInstructionVo in inspectionTestInstructionListInVo.GetList().Where(v => v.InspectionTestInstructionId == OldTestInstVo.InspectionTestInstructionId).Distinct())
{
inspectionTestInstructionVo.InspectionTestInstructionId = NewTestInstVo.InspectionTestInstructionId;
inspectionTestInstructionVo.InspectionTestInstructionDetailCode = NewTestInstVo.InspectionTestInstructionCode
+ GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue()
+ GlobalMasterDataTypeEnum.DETAIL_CODE.GetValue()
+ GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue()
+ InspTestInstructionDetailCount;
InspTestInstructionDetailCount += 1;
}
if (UpdateTestInstDetailVo != null)
{
if (UpdateTestInstDetailVo.InspectionTestInstructionId == OldTestInstVo.InspectionTestInstructionId)
{
UpdateTestInstDetailVo.InspectionTestInstructionId = NewTestInstVo.InspectionTestInstructionId;
}
}
}
returnInstTestDetailInsertedVo = (UpdateResultVo)addInspectionTestInstructionDetailCopyCbm.Execute(trxContext, inspectionTestInstructionListInVo);
if (UpdateTestInstDetailVo != null)
{
if (outVo == null)
{
outVo = new InspectionReturnVo();
}
outVo.InspectionTestInstructionId = UpdateTestInstDetailVo.InspectionTestInstructionId;
}
return(outVo);
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
InspectionReturnVo outVo = new InspectionReturnVo();
InspectionReturnVo copyChildVo = null;
ValueObjectList <ValueObject> inListVo = (ValueObjectList <ValueObject>)vo;
if (inListVo == null || inListVo.GetList() == null || inListVo.GetList().Count == 0)
{
return(outVo);
}
InspectionItemVo updateitemVo = (InspectionItemVo)inListVo.GetList()[2];
InspectionItemSelectionDatatypeValueVo updateSelectionDataTypeValueVo = (InspectionItemSelectionDatatypeValueVo)inListVo.GetList()[3];
copyInspectionFormatMasterMntCbm = new CopyInspectionFormatMasterMntCbm();
outVo = (InspectionReturnVo)copyInspectionFormatMasterMntCbm.Execute(trxContext, vo);
updateitemVo.InspectionItemId = outVo.InspectionItemId;
//copyChildItemsExist(trxContext, updateitemVo);
InspectionItemVo childInVo = new InspectionItemVo();
childInVo.ParentInspectionItemId = updateitemVo.InspectionItemIdCopy;
ValueObjectList <InspectionItemVo> childOutVo = (ValueObjectList <InspectionItemVo>)getInspectionItemChildCbm.Execute(trxContext, childInVo);
if (childOutVo != null && childOutVo.GetList() != null && childOutVo.GetList().Count > 0)
{
int RunningNumber = 1;
InspectionItemVo inVo = new InspectionItemVo();
//inVo.ParentInspectionItemId = updateitemVo.InspectionItemId;
inVo.InspectionProcessId = updateitemVo.InspectionProcessId;
InspectionItemVo getRunningNoVo = (InspectionItemVo)getInspectionItemSeqCbm.Execute(trxContext, inVo);
if (getRunningNoVo != null && getRunningNoVo.InspectionItemCode != null)
{
string strTemp;
strTemp = getRunningNoVo.InspectionItemCode;
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;
}
}
}
int displyOrd = 0;
foreach (InspectionItemVo itmVo in childOutVo.GetList())
{
displyOrd += 1;
itmVo.ParentInspectionItemId = updateitemVo.InspectionItemId;
itmVo.InspectionItemIdCopy = itmVo.InspectionItemId;
itmVo.InspectionProcessCode = updateitemVo.InspectionProcessCode;
itmVo.DisplayOrder = displyOrd;
itmVo.InspectionItemCode = updateitemVo.InspectionProcessCode + GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue() +
GlobalMasterDataTypeEnum.ITEM_CODE.GetValue() + GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue() + RunningNumber;
inListVo.GetList()[2] = itmVo;
copyInspectionFormatMasterMntCbm = new CopyInspectionFormatMasterMntCbm();
copyChildVo = (InspectionReturnVo)copyInspectionFormatMasterMntCbm.Execute(trxContext, inListVo);
RunningNumber += 1;
}
}
if (copyChildVo != null)
{
return(copyChildVo);
}
return(outVo);
}
private void Delete_btn_Click(object sender, EventArgs e)
{
if (!CheckMandatory())
{
return;
}
if (inspectionspecificationid <= 0)
{
messageData = new MessageData("mmce00010", Properties.Resources.mmce00010, "InspectionSpecificationId");
popUpMessage.Warning(messageData, Text);
return;
}
messageData = new MessageData("mmcc00004", Properties.Resources.mmcc00004, InspectionSpecificationText_txt.Text);
// Logger.Info(messageData);
DialogResult dialogResult = popUpMessage.ConfirmationOkCancel(messageData, Text);
if (dialogResult == DialogResult.OK)
{
InspectionSpecificationVo inVo = new InspectionSpecificationVo();
inVo.InspectionSpecificationId = inspectionspecificationid;
inVo.InspectionItemId = InspectionItemId;
inVo.DeleteFlag = true;
string message = string.Format(Properties.Resources.mmci00038, "Inspection Specification", InspectionSpecificationText_txt.Text);
StartProgress(message);
ValueObjectList <ValueObject> inVoList = new ValueObjectList <ValueObject>();
InspectionFormatVo passformatVo = FormFormatVo(InspectionItemId);
if (passformatVo == null || passformatVo.InspectionFormatId == 0)
{
return;
}
inVoList.add(passformatVo);
inVoList.add(null);
inVoList.add(null);
inVoList.add(null);
inVoList.add(inVo);
inVoList.add(null);
inVoList.add(null);
InspectionReturnVo outVo = new InspectionReturnVo();
try
{
outVo = (InspectionReturnVo)base.InvokeCbm(new UpdateAllInspectionFunctionMasterMntCbm(), inVoList, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
finally
{
CompleteProgress();
}
if (outVo == null)
{
return;
}
InspectionItemId = outVo.InspectionItemId;
this.messageData = new MessageData("mmci00003", Properties.Resources.mmci00003, null);
logger.Info(this.messageData);
popUpMessage.Information(this.messageData, Text);
this.Close();
//try
//{
// InspectionSpecificationVo outVo = (InspectionSpecificationVo)base.InvokeCbm(new DeleteInspectionSpecificationMasterMntCbm(), inVo, false);
// if (outVo.AffectedCount > 0)
// {
// this.messageData = new MessageData("mmci00003", Properties.Resources.mmci00003, null);
// logger.Info(this.messageData);
// popUpMessage.Information(this.messageData, Text);
// }
// else if (outVo.AffectedCount == 0)
// {
// messageData = new MessageData("mmci00007", Properties.Resources.mmci00007, null);
// logger.Info(messageData);
// popUpMessage.Information(messageData, Text);
// }
//}
//catch (Framework.ApplicationException exception)
//{
// popUpMessage.ApplicationError(exception.GetMessageData(), Text);
// logger.Error(exception.GetMessageData());
//}
}
else if (dialogResult == DialogResult.Cancel)
{
//do something else
}
}
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);
}
/// <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 = InspectionItem_dgv.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = InspectionItem_dgv.Rows[selectedrowindex];
messageData = new MessageData("mmcc00004", Properties.Resources.mmcc00004, selectedRow.Cells["colInspectionItemName"].Value.ToString());
DialogResult dialogResult = popUpMessage.ConfirmationOkCancel(messageData, Text);
if (dialogResult == DialogResult.OK)
{
InspectionItemVo inVo = new InspectionItemVo
{
//InspectionItemCode = selectedRow.Cells["colInspectionItemCode"].Value.ToString(),
InspectionItemId = Convert.ToInt32(selectedRow.Cells["ColInspectionItemId"].Value),
InspectionProcessId = Convert.ToInt32(selectedRow.Cells["colInspectionProcessId"].Value),
DeleteFlag = true
};
string message = string.Format(Properties.Resources.mmci00038, "Inspection Item", selectedRow.Cells["colInspectionItemName"].Value.ToString());
StartProgress(message);
ValueObjectList <ValueObject> inVoList = new ValueObjectList <ValueObject>();
InspectionFormatVo passformatVo = FormFormatVo(inVo.InspectionItemId);
if (passformatVo == null || passformatVo.InspectionFormatId == 0)
{
return;
}
inVoList.add(passformatVo);
inVoList.add(null);
inVoList.add(inVo);
inVoList.add(null);
inVoList.add(null);
inVoList.add(null);
inVoList.add(null);
InspectionReturnVo outVo = new InspectionReturnVo();
try
{
outVo = (InspectionReturnVo)base.InvokeCbm(new UpdateAllInspectionFunctionMasterMntCbm(), inVoList, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
finally
{
CompleteProgress();
}
if (outVo == null)
{
return;
}
if (outVo.InspectionProcessId > 0)
{
InspectionProcessId = outVo.InspectionProcessId;
}
//LoadInspectionProcessCombo();
//InspectionProcess_cmb.SelectedValue = InspectionProcessId;
GridBind();
messageData = new MessageData("mmci00003", Properties.Resources.mmci00003, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
//try
//{
// InspectionItemVo checkVo = CheckRelation(inVo);
// if (checkVo != null && (checkVo.InspectionItemId > 0 || checkVo.AffectedCount>0) )
// {
// messageData = new MessageData("mmce00007", Properties.Resources.mmce00007, "[INSPECTION SPECIFICATION, INSPECTION INSTRUCTION, PARENT ITEM ID]");
// popUpMessage.Information(messageData, Text);
// return;
// }
// InspectionItemVo outVo = (InspectionItemVo)base.InvokeCbm(new DeleteInspectionItemMasterMntCbm(), inVo, false);
// if (outVo.AffectedCount > 0)
// {
// messageData = new MessageData("mmci00003", Properties.Resources.mmci00003, null);
// logger.Info(messageData);
// popUpMessage.Information(messageData, Text);
// GridBind();
// }
// else if (outVo.AffectedCount == 0)
// {
// messageData = new MessageData("mmci00007", Properties.Resources.mmci00007, null);
// logger.Info(messageData);
// popUpMessage.Information(messageData, Text);
// GridBind();
// }
//}
//catch (Framework.ApplicationException exception)
//{
// popUpMessage.ApplicationError(exception.GetMessageData(), Text);
// logger.Error(exception.GetMessageData());
//}
}
else if (dialogResult == DialogResult.Cancel)
{
//do something else
}
}
/// <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 = InspectionTestInstructionDetail_dgv.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = InspectionTestInstructionDetail_dgv.Rows[selectedrowindex];
messageData = new MessageData("mmcc00004", Properties.Resources.mmcc00004, selectedRow.Cells["colInspectionTestInstructionDetailText"].Value.ToString());
// Logger.Info(messageData);
DialogResult dialogResult = popUpMessage.ConfirmationOkCancel(messageData, Text);
if (dialogResult == DialogResult.OK)
{
InspectionTestInstructionVo inVo = new InspectionTestInstructionVo();
inVo.InspectionTestInstructionDetailId = Convert.ToInt32(selectedRow.Cells["colInspectionTestInstructionDetailId"].Value.ToString());
inVo.InspectionTestInstructionId = Convert.ToInt32(selectedRow.Cells["colInspectionTestInstructionId"].Value.ToString());
inVo.DeleteFlag = true;
string message = string.Format(Properties.Resources.mmci00038, "Inspection Test Instruction Detail", selectedRow.Cells["colInspectionTestInstructionDetailText"].Value.ToString());
StartProgress(message);
ValueObjectList <ValueObject> inVoList = new ValueObjectList <ValueObject>();
InspectionFormatVo passformatVo = FormFormatVo(updateData.InspectionTestInstructionId);
if (passformatVo == null || passformatVo.InspectionFormatId == 0)
{
return;
}
inVoList.add(passformatVo);
inVoList.add(null);
inVoList.add(null);
inVoList.add(null);
inVoList.add(null);
inVoList.add(null);
inVoList.add(inVo);
InspectionReturnVo outVo = new InspectionReturnVo();
try
{
outVo = (InspectionReturnVo)base.InvokeCbm(new UpdateAllInspectionFunctionMasterMntCbm(), inVoList, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
finally
{
CompleteProgress();
}
if (outVo == null)
{
return;
}
InspectionTestInstructionId = outVo.InspectionTestInstructionId;
updateData.InspectionTestInstructionId = outVo.InspectionTestInstructionId;
GetInspTestCode();
GridBind();
this.messageData = new MessageData("mmci00003", Properties.Resources.mmci00003, null);
logger.Info(this.messageData);
popUpMessage.Information(this.messageData, Text);
//inVo.InspectionTestInstructionDetailCode = selectedRow.Cells["colInspectionTestInstructionDetailCode"].Value.ToString();
//try
//{
// InspectionTestInstructionVo outVo = (InspectionTestInstructionVo)base.InvokeCbm(new DeleteInspectionTestInstructionDetailMasterMntCbm(), 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();
// }
// else if (outVo.AffectedCount == 0)
// {
// messageData = new MessageData("mmci00007", Properties.Resources.mmci00007, null);
// logger.Info(messageData);
// popUpMessage.Information(messageData, Text);
// GridBind();
// }
//}
//catch (Framework.ApplicationException exception)
//{
// popUpMessage.ApplicationError(exception.GetMessageData(), Text);
// logger.Error(exception.GetMessageData());
//}
}
else if (dialogResult == DialogResult.Cancel)
{
//do something else
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
InspectionReturnVo inVo = (InspectionReturnVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append(" select distinct if.inspection_format_id, ");
sqlQuery.Append(" ip.inspection_process_id, ");
sqlQuery.Append(" it.inspection_item_id, ");
sqlQuery.Append(" isn.inspection_specification_id, ");
sqlQuery.Append(" ti.inspection_test_instruction_id, ");
sqlQuery.Append(" sv.inspection_item_selection_datatype_value_id, ");
sqlQuery.Append(" itd.inspection_test_instruction_detail_id ");
sqlQuery.Append(" from m_inspection_format if ");
sqlQuery.Append(" left join ");
sqlQuery.Append(" m_inspection_process ip ");
sqlQuery.Append(" on ip.inspection_format_id = if.inspection_format_id ");
sqlQuery.Append(" left join ");
sqlQuery.Append(" m_inspection_item it ");
sqlQuery.Append(" on it.inspection_process_id = ip.inspection_process_id ");
sqlQuery.Append(" left join ");
sqlQuery.Append(" m_inspection_specification isn ");
sqlQuery.Append(" on isn.inspection_item_id = it.inspection_item_id ");
sqlQuery.Append(" left join ");
sqlQuery.Append(" m_inspection_test_instruction ti on ");
sqlQuery.Append(" ti.inspection_item_id = it.inspection_item_id ");
sqlQuery.Append(" left join ");
sqlQuery.Append(" m_inspection_item_selection_datatype_value sv ");
sqlQuery.Append(" on sv.inspection_item_id = it.inspection_item_id ");
sqlQuery.Append(" left join m_inspection_test_instruction_detail itd ");
sqlQuery.Append(" on itd.inspection_test_instruction_id = ti.inspection_test_instruction_id ");
sqlQuery.Append(" where if.factory_cd = :factorycd ");
if (inVo.InspectionFormatId > 0)
{
sqlQuery.Append(" and if.inspection_format_id = :inspectionformatid ");
}
if (inVo.InspectionProcessId > 0)
{
sqlQuery.Append(" and ip.inspection_process_id = :inspectionprocessid ");
}
if (inVo.InspectionItemId > 0)
{
sqlQuery.Append(" and it.inspection_item_id = :inspectionitemid ");
}
if (inVo.InspectionSelectionValueDataTypeId > 0)
{
sqlQuery.Append(" and sv.inspection_item_selection_datatype_value_id = :selectiondatatypevalueid");
}
if (inVo.InspectionSpecificationId > 0)
{
sqlQuery.Append(" and isn.inspection_specification_id = :inspectionspecificationid ");
}
if (inVo.InspectionTestInstructionId > 0)
{
sqlQuery.Append(" and ti.inspection_test_instruction_id = :inspectiontestinstructionid ");
}
if (inVo.InspectionTestInstructionDetailId > 0)
{
sqlQuery.Append(" and itd.inspection_test_instruction_detail_id = :inspectiontestinstdetailid ");
}
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("inspectionformatid", inVo.InspectionFormatId);
sqlParameter.AddParameterInteger("inspectionprocessid", inVo.InspectionProcessId);
sqlParameter.AddParameterInteger("inspectionitemid", inVo.InspectionItemId);
sqlParameter.AddParameterInteger("selectiondatatypevalueid", inVo.InspectionSelectionValueDataTypeId);
sqlParameter.AddParameterInteger("inspectionspecificationid", inVo.InspectionSpecificationId);
sqlParameter.AddParameterInteger("inspectiontestinstructionid", inVo.InspectionTestInstructionId);
sqlParameter.AddParameterInteger("inspectiontestinstdetailid", inVo.InspectionTestInstructionDetailId);
sqlParameter.AddParameterString("factorycd", trxContext.UserData.FactoryCode);
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
InspectionReturnVo outVo = new InspectionReturnVo();
while (dataReader.Read())
{
outVo = new InspectionReturnVo();
outVo.InspectionFormatId = ConvertDBNull <int>(dataReader, "inspection_format_id");
outVo.InspectionProcessId = ConvertDBNull <int>(dataReader, "inspection_process_id");
outVo.InspectionItemId = ConvertDBNull <int>(dataReader, "inspection_item_id");
outVo.InspectionSpecificationId = ConvertDBNull <int>(dataReader, "inspection_specification_id");
outVo.InspectionSelectionValueDataTypeId = ConvertDBNull <int>(dataReader, "inspection_item_selection_datatype_value_id");
outVo.InspectionTestInstructionId = ConvertDBNull <int>(dataReader, "inspection_test_instruction_id");
outVo.InspectionTestInstructionDetailId = ConvertDBNull <int>(dataReader, "inspection_test_instruction_detail_id");
}
dataReader.Close();
return(outVo);
}
