/// <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 <ValueObjectList <ValueObject> > inVo = (ValueObjectList <ValueObjectList <ValueObject> >)arg;
List <int> ItemList = new List <int>();
foreach (ValueObjectList <ValueObject> getItemVo in inVo.GetList())
{
if ((((InspectionItemVo)getItemVo.GetList()[0]).InspectionItemId) != 0)
{
ItemList.Add(((InspectionItemVo)getItemVo.GetList()[0]).InspectionItemId);
}
}
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("select * ");
sqlQuery.Append(" from m_inspection_specification");
sqlQuery.Append(" where factory_cd = :faccd ");
sqlQuery.Append(" and inspection_item_id = ANY (:inspectionItemId) ");
sqlQuery.Append(" order by inspection_specification_id ");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode);
sqlParameter.AddParameter("inspectionItemId", ItemList);
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
ValueObjectList <InspectionSpecificationVo> outVo = null;
while (dataReader.Read())
{
InspectionSpecificationVo currOutVo = new InspectionSpecificationVo();
currOutVo.InspectionSpecificationId = ConvertDBNull <int>(dataReader, "inspection_specification_id");
currOutVo.InspectionSpecificationCode = ConvertDBNull <string>(dataReader, "inspection_specification_cd");
currOutVo.InspectionSpecificationText = ConvertDBNull <string>(dataReader, "inspection_specification_text");
currOutVo.ValueFrom = ConvertDBNull <string>(dataReader, "value_from");
currOutVo.ValueTo = ConvertDBNull <string>(dataReader, "value_to");
currOutVo.Unit = ConvertDBNull <string>(dataReader, "unit");
currOutVo.OperatorFrom = ConvertDBNull <string>(dataReader, "operator_from");
currOutVo.OperatorTo = ConvertDBNull <string>(dataReader, "operator_to");
currOutVo.InspectionItemId = ConvertDBNull <int>(dataReader, "inspection_item_id");
currOutVo.SpecificationResultJudgeType = ConvertDBNull <int>(dataReader, "specification_result_judge_type");
if (outVo == null)
{
outVo = new ValueObjectList <InspectionSpecificationVo>();
}
outVo.add(currOutVo);
}
dataReader.Close();
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();
}
}
}
