/// <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
}
}
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);
}
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);
}
/// <summary>
/// updates Line Machine
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Update_btn_Click(object sender, EventArgs e)
{
if (LineItem_dgv.RowCount == 0) // || LineItem_dgv.SelectedRows.Count == 0
{
return;
}
if (Line_cmb.Text == string.Empty || Line_cmb.SelectedIndex < 0)
{
messageData = new MessageData("mmce00002", Properties.Resources.mmce00002, LineId_lbl.Text);
popUpMessage.Warning(messageData, Text);
Line_cmb.Focus();
return;
}
ValueObjectList <ValueObject> inVoList = new ValueObjectList <ValueObject>();
LineItemCycleTimeVo deleteInVo = new LineItemCycleTimeVo();
deleteInVo.LineId = Convert.ToInt32(Line_cmb.SelectedValue);
ValueObjectList <LineItemCycleTimeVo> addInVo = new ValueObjectList <LineItemCycleTimeVo>();
foreach (DataGridViewRow row in LineItem_dgv.Rows)
{
if (row.Cells["clmstdcycletime"].Value != null && !row.Cells["clmstdcycletime"].Value.ToString().Equals(string.Empty))
{
decimal cycleTime = Convert.ToDecimal(row.Cells["clmstdcycletime"].Value);
if (cycleTime > 0)
{
LineItemCycleTimeVo selectedItem = (LineItemCycleTimeVo)row.DataBoundItem;
LineItemCycleTimeVo addVo = new LineItemCycleTimeVo();
addVo.LineId = Convert.ToInt32(Line_cmb.SelectedValue);
addVo.StdCycleTime = cycleTime;
addVo.SapItemCode = row.Cells["colSapItemCode"].Value.ToString();
addInVo.add(addVo);
}
}
}
inVoList.add(deleteInVo);
inVoList.add(addInVo);
//if (inVo == null || inVo.GetList() == null || inVo.GetList().Count == 0)
//{
// messageData = new MessageData("mmci00047", Properties.Resources.mmci00047, LineId_lbl.Text);
// popUpMessage.Information(messageData, Text);
// LineItem_dgv.Focus();
// return;
//}
UpdateResultVo outVo = null;
try
{
Cursor.Current = Cursors.WaitCursor;
outVo = (UpdateResultVo)base.InvokeCbm(new AddUpdateLineItemCycleTimeMasterMntCbm(), inVoList, false);
Cursor.Current = Cursors.Default;
}
catch (Framework.ApplicationException exception)
{
Cursor.Current = Cursors.Default;
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
if (outVo == null)
{
return;
}
messageData = new MessageData("mmci00002", Properties.Resources.mmci00002, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
GridBind(FormConditionVo());
}
/// <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();
}
}
}
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/updates process on ok click
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Ok_btn_Click(object sender, EventArgs e)
{
if (CheckMandatory())
{
ProcessStockLocationVo inVo = new ProcessStockLocationVo();
inVo.ProcessId = Convert.ToInt32(Process_lst.SelectedValue);
ValueObjectList <ProcessStockLocationVo> outDeleteCheckVo = null;
try
{
outDeleteCheckVo = (ValueObjectList <ProcessStockLocationVo>)base.InvokeCbm(new GetProcessStockLocationMasterMntCbm(), inVo, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
if (outDeleteCheckVo != null && outDeleteCheckVo.GetList() != null && outDeleteCheckVo.GetList().Count > 0)
{
UpdateResultVo outDeleteVo = null;
try
{
outDeleteVo = (UpdateResultVo)base.InvokeCbm(new DeleteProcessStockLocationMasterMntCbm(), inVo, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
IntDelSuccess = outDeleteVo.AffectedCount;
}
foreach (var item in StockLocation_chlst.CheckedItems)
{
var stocklocation = (StockLocationVo)item;
inVo.StockLocationId = stocklocation.StockLocationId;
UpdateResultVo outVo = null;
try
{
outVo = (UpdateResultVo)base.InvokeCbm(new AddProcessStockLocationMasterMntCbm(), inVo, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
IntSuccess = outVo.AffectedCount;
}
if ((IntSuccess > 0) || (IntDelSuccess > 0))
{
messageData = new MessageData("mmci00002", Properties.Resources.mmci00002, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
}
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
ValueObjectList <InspectionTestInstructionVo> inVo = (ValueObjectList <InspectionTestInstructionVo>)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Insert into m_inspection_test_instruction");
sqlQuery.Append(" ( ");
sqlQuery.Append(" inspection_test_instruction_cd,");
sqlQuery.Append(" inspection_test_instruction_text,");
sqlQuery.Append(" inspection_item_id,");
sqlQuery.Append(" registration_user_cd,");
sqlQuery.Append(" registration_date_time,");
sqlQuery.Append(" factory_cd");
sqlQuery.Append(" ) ");
sqlQuery.Append("VALUES ");
StringBuilder sqlValues = new StringBuilder();
UserData userdata = trxContext.UserData;
foreach (InspectionTestInstructionVo getTestInstructionVo in inVo.GetList())
{
if (sqlValues.Length > 0)
{
sqlValues.Append(" , ");
}
sqlValues.Append(" (");
sqlValues.Append("'" + getTestInstructionVo.InspectionTestInstructionCode + "' ,");
sqlValues.Append("'" + getTestInstructionVo.InspectionTestInstructionText + "' ,");
sqlValues.Append(getTestInstructionVo.InspectionItemId + ",");
sqlValues.Append("'" + userdata.UserCode + "' ,");
sqlValues.Append("'" + trxContext.ProcessingDBDateTime + "' ,");
sqlValues.Append("'" + userdata.FactoryCode + "'");
sqlValues.Append(" ) ");
}
sqlQuery.Append(sqlValues.ToString());
//sqlQuery.Append(" ( ");
//sqlQuery.Append(" :inspectiontestinstructioncd,");
//sqlQuery.Append(" :inspectiontestinstructiontext,");
//sqlQuery.Append(" :inspectionitemid,");
//sqlQuery.Append(" :registrationusercode,");
//sqlQuery.Append(" :regdatetime,");
//sqlQuery.Append(" :factorycode");
//sqlQuery.Append(" ) ");
//sqlQuery.Append(" RETURNING inspection_test_instruction_id;");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
//sqlParameter.AddParameterString("inspectiontestinstructioncd", inVo.InspectionTestInstructionCode);
//sqlParameter.AddParameterString("inspectiontestinstructiontext", inVo.InspectionTestInstructionText);
//sqlParameter.AddParameterInteger("inspectionitemid", inVo.InspectionItemId);
//UserData userdata = trxContext.UserData;
//sqlParameter.AddParameterString("registrationusercode", userdata.UserCode);
//sqlParameter.AddParameterDateTime("regdatetime", trxContext.ProcessingDBDateTime);
//sqlParameter.AddParameterString("factorycode", userdata.FactoryCode);
UpdateResultVo outVo = new UpdateResultVo {
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
/// <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)
{
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();
}
}
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);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
ValueObjectList <InspectionSpecificationVo> inVo = (ValueObjectList <InspectionSpecificationVo>)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Insert into m_inspection_specification");
sqlQuery.Append(" ( ");
sqlQuery.Append(" inspection_specification_cd,");
sqlQuery.Append(" inspection_specification_text,");
sqlQuery.Append(" value_from,");
sqlQuery.Append(" value_to,");
sqlQuery.Append(" unit,");
sqlQuery.Append(" operator_from,");
sqlQuery.Append(" operator_to,");
sqlQuery.Append(" inspection_item_id,");
sqlQuery.Append(" specification_result_judge_type,");
sqlQuery.Append(" registration_user_cd,");
sqlQuery.Append(" registration_date_time,");
sqlQuery.Append(" factory_cd");
sqlQuery.Append(" ) ");
sqlQuery.Append("VALUES ");
StringBuilder sqlValues = new StringBuilder();
UserData userdata = trxContext.UserData;
foreach (InspectionSpecificationVo getItemSpecificationVo in inVo.GetList())
{
if (sqlValues.Length > 0)
{
sqlValues.Append(" , ");
}
sqlValues.Append(" (");
sqlValues.Append("'" + getItemSpecificationVo.InspectionSpecificationCode + "' ,");
sqlValues.Append("'" + getItemSpecificationVo.InspectionSpecificationText + "' ,");
sqlValues.Append("'" + getItemSpecificationVo.ValueFrom + "' ,");
if (getItemSpecificationVo.ValueTo == null)
{
sqlValues.Append("NULL,");
}
else
{
sqlValues.Append(getItemSpecificationVo.ValueTo + ",");
}
sqlValues.Append("'" + getItemSpecificationVo.Unit + "' ,");
sqlValues.Append("'" + getItemSpecificationVo.OperatorFrom + "' ,");
sqlValues.Append("'" + getItemSpecificationVo.OperatorTo + "' ,");
sqlValues.Append(getItemSpecificationVo.InspectionItemId + ",");
sqlValues.Append(getItemSpecificationVo.SpecificationResultJudgeType + ",");
sqlValues.Append("'" + userdata.UserCode + "' ,");
sqlValues.Append("'" + trxContext.ProcessingDBDateTime + "' ,");
sqlValues.Append("'" + userdata.FactoryCode + "'");
sqlValues.Append(" ) ");
}
sqlQuery.Append(sqlValues.ToString());
//sqlQuery.Append(" ( ");
//sqlQuery.Append(" :inspectionspecificationcd,");
//sqlQuery.Append(" :inspectionspecificationtext,");
//sqlQuery.Append(" :valuefrom,");
//sqlQuery.Append(" :valueto,");
//sqlQuery.Append(" :unit,");
//sqlQuery.Append(" :operatorfrom,");
//sqlQuery.Append(" :operatorto,");
//sqlQuery.Append(" :inspectionitemid,");
//sqlQuery.Append(" :specificationresultjudgetype,");
//sqlQuery.Append(" :registrationusercode,");
//sqlQuery.Append(" :regdatetime,");
//sqlQuery.Append(" :factorycode");
//sqlQuery.Append(" ); ");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
//sqlParameter.AddParameterString("inspectionspecificationcd", inVo.InspectionSpecificationCode);
//sqlParameter.AddParameterString("inspectionspecificationtext", inVo.InspectionSpecificationText);
//sqlParameter.AddParameterString("valuefrom", inVo.ValueFrom);
//sqlParameter.AddParameter("valueto", inVo.ValueTo);
//sqlParameter.AddParameterString("unit", inVo.Unit);
//sqlParameter.AddParameterString("operatorfrom", inVo.OperatorFrom);
//sqlParameter.AddParameterString("operatorto", inVo.OperatorTo);
//sqlParameter.AddParameterInteger("inspectionitemid", inVo.InspectionItemId);
//sqlParameter.AddParameterInteger("specificationresultjudgetype", inVo.SpecificationResultJudgeType);
//UserData userdata = trxContext.UserData;
//sqlParameter.AddParameterString("registrationusercode", userdata.UserCode);
//sqlParameter.AddParameterDateTime("regdatetime", trxContext.ProcessingDBDateTime);
//sqlParameter.AddParameterString("factorycode", userdata.FactoryCode);
UpdateResultVo outVo = new UpdateResultVo {
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
/// <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() == true)
{
if (string.IsNullOrEmpty(InspectionSpecificationCode_txt.Text) || string.IsNullOrEmpty(InspectionSpecificationText_txt.Text))
{
messageData = new MessageData("mmce00003", Properties.Resources.mmce00003);
logger.Info(messageData);
popUpMessage.ConfirmationOkCancel(messageData, Text);
if (string.IsNullOrEmpty(InspectionSpecificationCode_txt.Text))
{
InspectionSpecificationCode_txt.Focus();
}
else if (string.IsNullOrEmpty(InspectionSpecificationText_txt.Text))
{
InspectionSpecificationText_txt.Focus();
}
return;
}
if (string.Equals(mode, CommonConstants.MODE_SELECT))
{
if (InspectionSpecificationCode_txt.Text == updateData.InspectionSpecificationCode)
{
messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, InspectionSpecificationCode_lbl.Text + " : " + InspectionSpecificationCode_txt.Text);
logger.Info(messageData);
popUpMessage.ConfirmationOkCancel(messageData, Text);
return;
}
if (InspectionSpecificationText_txt.Text == updateData.InspectionSpecificationText)
{
messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, InspectionSpecificationText_lbl.Text + " : " + InspectionSpecificationText_txt.Text);
logger.Info(messageData);
popUpMessage.ConfirmationOkCancel(messageData, Text);
return;
}
}
inVo.InspectionSpecificationCode = InspectionSpecificationCode_txt.Text.Trim();
inVo.InspectionSpecificationText = InspectionSpecificationText_txt.Text.Trim();
// inVo.ValueFrom = Convert.ToDecimal(ValueFrom_txt.Text.Trim());
if (!string.IsNullOrWhiteSpace(ValueTo_txt.Text.Trim()))
{
// inVo.ValueTo = Convert.ToDecimal(ValueTo_txt.Text.Trim());
}
if (!string.IsNullOrWhiteSpace(Unit_txt.Text.Trim()))
{
inVo.Unit = Unit_txt.Text.Trim();
}
if (!string.IsNullOrWhiteSpace(OperatorFrom_txt.Text.Trim()))
{
inVo.OperatorFrom = OperatorFrom_txt.Text.Trim();
}
if (!string.IsNullOrWhiteSpace(OperatorTo_txt.Text.Trim()))
{
inVo.OperatorTo = OperatorTo_txt.Text.Trim();
}
inVo.InspectionItemId = Convert.ToInt32(InspectionItem_cmb.SelectedValue.ToString());
inVo.SpecificationResultJudgeType = Convert.ToInt32(SpecificationResultJudgeType_cmb.SelectedValue.ToString());
if (mode.Equals(CommonConstants.MODE_UPDATE))
{
inVo.InspectionSpecificationId = updateData.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;
}
try
{
if (string.Equals(mode, CommonConstants.MODE_ADD) || string.Equals(mode, CommonConstants.MODE_SELECT))
{
UpdateResultVo outVo = (UpdateResultVo)base.InvokeCbm(new AddInspectionSpecificationMasterMntCbm(), inVo, false);
IntSuccess = outVo.AffectedCount;
}
else if (mode.Equals(CommonConstants.MODE_UPDATE))
{
InspectionSpecificationVo outVo = (InspectionSpecificationVo)base.InvokeCbm(new UpdateInspectionSpecificationMasterMntCbm(), inVo, false);
IntSuccess = outVo.AffectedCount;
}
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
if ((IntSuccess > 0) || (IntSuccess == 0))
{
this.Close();
}
}
}
/// <summary>
/// inserts/updates process on ok click
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Update_btn_Click(object sender, EventArgs e)
{
if (!CheckMandatory() || LineBuildingMasterVo == null || LineBuildingMasterVo.GetList() == null)
{
return;
}
UserLineBuildingVo inVo = new UserLineBuildingVo();
inVo.UserCode = User_cmb.SelectedValue.ToString();
inVo.LineBuildingidList = LineBuildingMasterVo.GetList().Where(t => t.BuildingId == Convert.ToInt32(Building_lst.SelectedValue)).Select(s => s.LineBuildingId).ToList();
try
{
UpdateResultVo outDeleteVo = (UpdateResultVo)base.InvokeCbm(new DeleteUserLineBuildingMasterMntCbm(), inVo, false);
IntDelSuccess = outDeleteVo.AffectedCount;
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
inVo.BuildingId = Convert.ToInt32(Building_lst.SelectedValue);
UpdateResultVo outVo = new UpdateResultVo();
foreach (UserLineBuildingVo item in Line_chlst.CheckedItems)
{
inVo.LineId = item.LineId;
UserLineBuildingVo currentVo = LineBuildingMasterVo.GetList().Where(t => t.BuildingId == inVo.BuildingId && t.LineId == inVo.LineId).FirstOrDefault();
if (currentVo == null || currentVo.LineBuildingId == 0)
{
messageData = new MessageData("mmce00010", Properties.Resources.mmce00010, "LineBuildingId");
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
return;
}
inVo.LineBuildingId = currentVo.LineBuildingId;
try
{
outVo = (UpdateResultVo)base.InvokeCbm(new AddUserLineBuildingMasterMntCbm(), inVo, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
}
IntSuccess = outVo.AffectedCount;
if ((IntSuccess > 0) || (IntDelSuccess > 0))
{
messageData = new MessageData("mmci00002", Properties.Resources.mmci00002, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
}
}
//private int intSerial = 0;
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> updateTestInstListVo = new ValueObjectList <ValueObject>();
string InspTestInstCode = string.Empty;
UpdateResultVo returnTestInstInsertedVo = null;
updateTestInstListVo = inVo.GetList()[inVo.GetList().Count - 1];
if (updateTestInstListVo != null && updateTestInstListVo.GetList() != null && updateTestInstListVo.GetList().Count > 0)
{
UpdateTestInstructionVo = new InspectionTestInstructionVo();
UpdateTestInstructionVo = (InspectionTestInstructionVo)updateTestInstListVo.GetList()[0];
}
inVo.GetList().RemoveAt(inVo.GetList().Count - 1);
//get inspection Specification list for the above fetched itemlist
InspectionTestInstructionListInVo = (ValueObjectList <InspectionTestInstructionVo>)getInspectionTestInstructionListCbm.Execute(trxContext, inVo);
if (InspectionTestInstructionListInVo == null || InspectionTestInstructionListInVo.GetList() == null || InspectionTestInstructionListInVo.GetList().Count == 0)
{
return(outVo);
}
if (UpdateTestInstructionVo != null && UpdateTestInstructionVo.InspectionTestInstructionId > 0)
{
if (UpdateTestInstructionVo.DeleteFlag)
{
InspectionTestInstructionListInVo.GetList().Remove(InspectionTestInstructionListInVo.GetList().Single(v => v.InspectionTestInstructionId == UpdateTestInstructionVo.InspectionTestInstructionId));
}
else
{
foreach (InspectionTestInstructionVo ItemVo in InspectionTestInstructionListInVo.GetList().Where(v => v.InspectionTestInstructionId == UpdateTestInstructionVo.InspectionTestInstructionId))
{
ItemVo.InspectionTestInstructionCode = UpdateTestInstructionVo.InspectionTestInstructionCode;
ItemVo.InspectionTestInstructionText = UpdateTestInstructionVo.InspectionTestInstructionText;
}
}
}
foreach (ValueObjectList <ValueObject> getitemVo in inVo.GetList())
{
InspectionItemVo OldInsProcessVo = (InspectionItemVo)getitemVo.GetList()[0];
InspectionItemVo NewInsProcessVo = (InspectionItemVo)getitemVo.GetList()[1];
if (InspTestInstCode.Equals(string.Empty))
{
InspTestInstCode = NewInsProcessVo.InspectionItemCode;
}
foreach (InspectionTestInstructionVo inspectionSpecificationVo in InspectionTestInstructionListInVo.GetList().Where(v => v.InspectionItemId == OldInsProcessVo.InspectionItemId).Distinct())
{
inspectionSpecificationVo.InspectionItemId = NewInsProcessVo.InspectionItemId;
inspectionSpecificationVo.InspectionTestInstructionCode = NewInsProcessVo.InspectionItemCode +
GlobalMasterDataTypeEnum.CODE_SEPARATOR.GetValue() +
GlobalMasterDataTypeEnum.TEST_INST_CODE.GetValue();
}
if (UpdateTestInstructionVo != null)
{
if (UpdateTestInstructionVo.InspectionItemId == OldInsProcessVo.InspectionItemId)
{
UpdateTestInstructionVo.InspectionItemId = NewInsProcessVo.InspectionItemId;
}
}
}
returnTestInstInsertedVo = (UpdateResultVo)addInspectionTestInstructionCopyCbm.Execute(trxContext, InspectionTestInstructionListInVo);
InspectionTestInstructionInsertedListInVo = (ValueObjectList <InspectionTestInstructionVo>)getInspectionTestInstructionInsertedListCbm.Execute(trxContext, InspectionTestInstructionListInVo);
foreach (InspectionTestInstructionVo OldInspectionTestInstructioVo in InspectionTestInstructionListInVo.GetList())
{
InspectionTestInstructionVo NewInspectionTestInstructioVo = null;
ValueObjectList <ValueObject> CombinationVo = new ValueObjectList <ValueObject>();
foreach (InspectionTestInstructionVo ItemVo in InspectionTestInstructionInsertedListInVo.GetList().Where(v => v.InspectionTestInstructionCode == OldInspectionTestInstructioVo.InspectionTestInstructionCode && v.InspectionItemId == OldInspectionTestInstructioVo.InspectionItemId))
{
NewInspectionTestInstructioVo = ItemVo;
}
CombinationVo.add(OldInspectionTestInstructioVo);
CombinationVo.add(NewInspectionTestInstructioVo);
if (outVo == null)
{
outVo = new ValueObjectList <ValueObjectList <ValueObject> >();
}
outVo.add(CombinationVo);
}
if (UpdateTestInstructionVo != null)
{
ValueObjectList <ValueObject> returnOutListVo = new ValueObjectList <ValueObject>();
returnOutListVo.add(UpdateTestInstructionVo);
outVo.add(returnOutListVo);
}
return(outVo);
}
