public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
GlobalItemVo inVo = (GlobalItemVo)arg;
GlobalItemVo outVo = new GlobalItemVo();
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Update m_global_item ");
sqlQuery.Append(" Set ");
sqlQuery.Append(" global_item_name = :globalitemname ");
sqlQuery.Append(" Where ");
sqlQuery.Append(" global_item_id = :globalitemid ");
sqlQuery.Append(" and factory_cd = :faccd");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("globalitemid", inVo.GlobalItemId);
sqlParameter.AddParameterString("globalitemname", inVo.GlobalItemName);
sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode);
//execute SQL
outVo.AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter);
return(outVo);
}
/// <summary>
/// Fills all user records to gridview control
/// </summary>
private void GridBind(GlobalItemVo conditionInVo)
{
GlobalItemData_dgv.DataSource = null;
try
{
GlobalItemVo outVo = (GlobalItemVo)base.InvokeCbm(new GetGlobalItemMasterMntCbm(), conditionInVo, false);
GlobalItemData_dgv.AutoGenerateColumns = false;
BindingSource bindingSource1 = new BindingSource(outVo.GlobalItemListVo, null);
if (bindingSource1.Count > 0)
{
GlobalItemData_dgv.DataSource = bindingSource1;
}
else
{
messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
}
GlobalItemData_dgv.ClearSelection();
Update_btn.Enabled = false;
Delete_btn.Enabled = false;
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
}
/// <summary>
/// selects item record for updation and show item form
/// </summary>
private void BindUpdateUserData()
{
int selectedrowindex = GlobalItemData_dgv.SelectedCells[0].RowIndex;
GlobalItemVo selectedData = (GlobalItemVo)GlobalItemData_dgv.Rows[selectedrowindex].DataBoundItem;
AddGlobalItemForm newAddForm = new AddGlobalItemForm();
newAddForm.CreateForm(CommonConstants.MODE_UPDATE, selectedData);
newAddForm.ShowDialog(this);
if (newAddForm.IntSuccess > 0)
{
messageData = new MessageData("mmci00002", Properties.Resources.mmci00002, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
GridBind(FormConditionVo());
}
else if (newAddForm.IntSuccess == 0)
{
messageData = new MessageData("mmci00007", Properties.Resources.mmci00007, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
GridBind(FormConditionVo());
}
}
/// <summary>
/// For setting selected user record into respective controls(textbox and combobox) for update operation
/// passing selected user data as parameter
/// </summary>
/// <param name="dgvData"></param>
private void LoadUserData(GlobalItemVo dgvData)
{
if (dgvData != null)
{
GlobalItemCode_txt.Text = dgvData.GlobalItemCode;
GlobalItemName_txt.Text = dgvData.GlobalItemName;
}
}
/// <summary>
/// inserts/updates item details
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected virtual void Ok_btn_Click(object sender, EventArgs e)
{
if (CheckMandatory())
{
GlobalItemVo inVo = new GlobalItemVo
{
GlobalItemCode = GlobalItemCode_txt.Text,
GlobalItemName = GlobalItemName_txt.Text
};
if (string.Equals(mode, CommonConstants.MODE_ADD))
{
GlobalItemVo checkVo = DuplicateCheck(inVo);
if (checkVo != null && checkVo.AffectedCount > 0)
{
messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, GlobalItemCode_lbl.Text + " : " + GlobalItemCode_txt.Text);
logger.Info(messageData);
popUpMessage.ApplicationError(messageData, Text);
return;
}
}
try
{
if (string.Equals(mode, CommonConstants.MODE_ADD))
{
GlobalItemVo outVo = (GlobalItemVo)base.InvokeCbm(new AddGlobalItemMasterMntCbm(), inVo, false);
IntSuccess = outVo.GlobalItemId;
}
else if (mode.Equals(CommonConstants.MODE_UPDATE))
{
inVo.GlobalItemId = updateData.GlobalItemId;
GlobalItemVo outVo = (GlobalItemVo)base.InvokeCbm(new UpdateGlobalItemMasterMntCbm(), 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();
}
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
GlobalItemVo inVo = (GlobalItemVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Select Count(*) as ItemCount, global_item_id, global_item_cd from m_global_item ");
sqlQuery.Append(" where factory_cd = :faccd ");
if (inVo.GlobalItemCode != null)
{
sqlQuery.Append(" and UPPER(global_item_cd) = UPPER(:globalitemcd)");
}
sqlQuery.Append(" group by global_item_id, global_item_cd ");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode);
if (inVo.GlobalItemCode != null)
{
sqlParameter.AddParameterString("globalitemcd", inVo.GlobalItemCode);
}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
GlobalItemVo outVo = new GlobalItemVo();
while (dataReader.Read())
{
outVo.AffectedCount = Convert.ToInt32(dataReader["ItemCount"]);
GlobalItemVo currOutVo = new GlobalItemVo();
currOutVo.GlobalItemId = ConvertDBNull <Int32>(dataReader, "global_item_id");
currOutVo.GlobalItemCode = ConvertDBNull <string>(dataReader, "global_item_cd");
outVo.GlobalItemListVo.Add(currOutVo);
}
dataReader.Close();
return(outVo);
}
/// <summary>
/// event to delete the selected record
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected virtual void Delete_btn_Click(object sender, EventArgs e)
{
int selectedrowindex = GlobalItemData_dgv.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = GlobalItemData_dgv.Rows[selectedrowindex];
messageData = new MessageData("mmcc00004", Properties.Resources.mmcc00004, selectedRow.Cells["colItemCode"].Value.ToString());
logger.Info(messageData);
DialogResult dialogResult = popUpMessage.ConfirmationOkCancel(messageData, Text);
if (dialogResult == DialogResult.OK)
{
GlobalItemVo inVo = new GlobalItemVo
{
GlobalItemId = Convert.ToInt32(selectedRow.Cells["colItemId"].Value),
};
inVo.GlobalItemCode = selectedRow.Cells["colItemCode"].Value.ToString();
try
{
GlobalItemVo outVo = (GlobalItemVo)base.InvokeCbm(new DeleteGlobalItemMasterMntCbm(), inVo, false);
if (outVo.AffectedCount > 0)
{
messageData = new MessageData("mmci00003", Properties.Resources.mmci00003, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
GridBind(FormConditionVo());
}
else if (outVo.AffectedCount == 0)
{
messageData = new MessageData("mmci00007", Properties.Resources.mmci00007, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
GridBind(FormConditionVo());
}
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
}
else if (dialogResult == DialogResult.Cancel)
{
//do something else
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
GlobalItemVo inVo = (GlobalItemVo)arg;
GlobalItemVo outVo = null;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Insert into m_global_item");
sqlQuery.Append(" ( ");
sqlQuery.Append(" global_item_cd, ");
sqlQuery.Append(" global_item_name, ");
sqlQuery.Append(" registration_user_cd, ");
sqlQuery.Append(" registration_date_time, ");
sqlQuery.Append(" factory_cd ");
sqlQuery.Append(" ) ");
sqlQuery.Append(" VALUES ");
sqlQuery.Append(" ( ");
sqlQuery.Append(" :globalitemcd, ");
sqlQuery.Append(" :globalitemname, ");
sqlQuery.Append(" :registrationusercode, ");
sqlQuery.Append(" :registrationdatetime, ");
sqlQuery.Append(" :factorycode ");
sqlQuery.Append(" ) ");
sqlQuery.Append(" RETURNING global_item_id;");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("globalitemcd", inVo.GlobalItemCode);
sqlParameter.AddParameterString("globalitemname", inVo.GlobalItemName);
sqlParameter.AddParameterString("registrationusercode", UserData.GetUserData().UserCode);
sqlParameter.AddParameterDateTime("registrationdatetime", trxContext.ProcessingDBDateTime);
sqlParameter.AddParameterString("factorycode", UserData.GetUserData().FactoryCode);
//execute SQL
int outId = (int?)sqlCommandAdapter.ExecuteScalar(sqlParameter) ?? 0;
if (outId > 0)
{
outVo = new GlobalItemVo();
outVo.GlobalItemId = outId;
}
return(outVo);
}
/// <summary>
/// Creates seacrh condition as per user inputs
/// </summary>
/// <returns>search condition</returns>
private GlobalItemVo FormConditionVo()
{
GlobalItemVo inVo = new GlobalItemVo();
if (GlobalItemCode_txt.Text != string.Empty)
{
inVo.GlobalItemCode = GlobalItemCode_txt.Text;
}
if (GlobalItemName_txt.Text != string.Empty)
{
inVo.GlobalItemName = GlobalItemName_txt.Text;
}
return(inVo);
}
/// <summary>
/// checks duplicate Item Code
/// </summary>
/// <param name="gItemVo"></param>
/// <returns></returns>
private GlobalItemVo DuplicateCheck(GlobalItemVo gItemVo)
{
GlobalItemVo outVo = new GlobalItemVo();
try
{
outVo = (GlobalItemVo)base.InvokeCbm(new CheckGlobalItemMasterMntCbm(), gItemVo, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
GlobalItemVo inVo = (GlobalItemVo)arg;
StringBuilder sqlQuery = new StringBuilder();
//create SQL
sqlQuery.Append("Select gi.global_item_id, gi.global_item_cd, gi.global_item_name ");
sqlQuery.Append(" from m_global_item gi ");
sqlQuery.Append(" inner join m_global_local_item gl on gl.global_item_id=gi.global_item_id ");
sqlQuery.Append(" where gi.factory_cd = :faccd and gl.local_item_id = :localitemid ");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode);
sqlParameter.AddParameterInteger("localitemid", inVo.LocallItemId);
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
GlobalItemVo outVo = new GlobalItemVo();
while (dataReader.Read())
{
GlobalItemVo currOutVo = new GlobalItemVo();
currOutVo.GlobalItemId = ConvertDBNull <Int32>(dataReader, "global_item_id");
currOutVo.GlobalItemCode = ConvertDBNull <string>(dataReader, "global_item_cd");
currOutVo.GlobalItemName = ConvertDBNull <string>(dataReader, "global_item_name");
outVo.GlobalItemListVo.Add(currOutVo);
}
dataReader.Close();
return(outVo);
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
MoldItemVo inVo = (MoldItemVo)vo;
///global item add
GlobalItemVo checkGlobalItemInVo = new GlobalItemVo();
checkGlobalItemInVo.GlobalItemCode = inVo.GlobalItemCode;
GlobalItemVo checkGlobalItemOutVo = (GlobalItemVo)getGlobalItemMasterMntCbm.Execute(trxContext, checkGlobalItemInVo);
GlobalItemVo globalItemOutVo = null;
if (checkGlobalItemOutVo == null || checkGlobalItemOutVo.GlobalItemListVo == null || checkGlobalItemOutVo.GlobalItemListVo.Count == 0)
{
GlobalItemVo globalItemInVo = new GlobalItemVo();
globalItemInVo.GlobalItemCode = inVo.GlobalItemCode;
globalItemInVo.GlobalItemName = inVo.GlobalItemCode;
globalItemOutVo = (GlobalItemVo)addGlobalItemMasterMntCbm.Execute(trxContext, globalItemInVo);
}
else
{
globalItemOutVo = checkGlobalItemOutVo.GlobalItemListVo[0];
}
///local item add
ItemVo checkLocalItemInVo = new ItemVo();
checkLocalItemInVo.ItemCode = inVo.LocalItemCode;
ItemVo checkLocalItemOutVo = (ItemVo)getItemMasterMntCbm.Execute(trxContext, checkLocalItemInVo);
ItemVo localItemOutVo = null;
if (checkLocalItemOutVo == null || checkLocalItemOutVo.ItemListVo == null || checkLocalItemOutVo.ItemListVo.Count == 0)
{
ItemVo localItemInVo = new ItemVo();
localItemInVo.ItemCode = inVo.LocalItemCode;
localItemInVo.ItemName = inVo.LocalItemCode;
localItemOutVo = (ItemVo)addItemMasterMntCbm.Execute(trxContext, localItemInVo);
}
else
{
localItemOutVo = checkLocalItemOutVo.ItemListVo[0];
}
GlobalLocalItemVo globalLocalItemInVo = new GlobalLocalItemVo();
globalLocalItemInVo.GlobalItemId = globalItemOutVo.GlobalItemId;
globalLocalItemInVo.LocalItemId = localItemOutVo.ItemId;
//check and add globallocalitem link table
ValueObjectList <GlobalLocalItemVo> checkGlobalLocalItemVo = (ValueObjectList <GlobalLocalItemVo>)checkGlobalLocalItemMasterMntCbm.Execute(trxContext, globalLocalItemInVo);
if (checkGlobalLocalItemVo == null || checkGlobalLocalItemVo.GetList() == null || checkGlobalLocalItemVo.GetList().Count == 0)
{
GlobalLocalItemVo moldItemOutVo = (GlobalLocalItemVo)addGlobalLocalItemMasterMntCbm.Execute(trxContext, globalLocalItemInVo);
}
inVo.GlobalItemId = globalItemOutVo.GlobalItemId;
inVo.LocalItemId = localItemOutVo.ItemId;
return(inVo);
}
public void CreateForm(string pmode, GlobalItemVo dataItem = null)
{
mode = pmode;
updateData = dataItem;
}
/// <summary>
/// Loads inspectionformat details to datatable
/// </summary>
private void FormDatatableFromVo()
{
//InspectionformatDatatable
inspectionformatDatatable = new DataTable();
inspectionformatDatatable.Columns.Add("Id");
inspectionformatDatatable.Columns.Add("Name");
ValueObjectList <InspectionFormatVo> inspectionFormatOutVo = null;
try
{
inspectionFormatOutVo = (ValueObjectList <InspectionFormatVo>)base.InvokeCbm(new GetInspectionFormatMasterMntCbm(), new InspectionFormatVo(), false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
if (inspectionFormatOutVo == null || inspectionFormatOutVo.GetList() == null || inspectionFormatOutVo.GetList().Count == 0)
{
messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
return;
}
foreach (InspectionFormatVo fac in inspectionFormatOutVo.GetList())
{
inspectionformatDatatable.Rows.Add(fac.InspectionFormatId, fac.InspectionFormatName);
}
//ItemDatatable
itemDatatable = new DataTable();
itemDatatable.Columns.Add("Id");
itemDatatable.Columns.Add("Name");
GlobalItemVo globalItemVo = null;
try
{
// itemOutVo = (ValueObjectList<ItemVo>)base.InvokeCbm(new GetItemMasterCbm(), new ItemVo(), false);
globalItemVo = (GlobalItemVo)base.InvokeCbm(new GetGlobalItemMasterMntCbm(), new GlobalItemVo(), false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
if (globalItemVo == null || globalItemVo.GlobalItemListVo == null || globalItemVo.GlobalItemListVo.Count == 0)
{
messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
return;
}
foreach (GlobalItemVo fac in globalItemVo.GlobalItemListVo)
{
itemDatatable.Rows.Add(fac.GlobalItemId, fac.GlobalItemCode + "-" + fac.GlobalItemName);
}
//LineDatatable
lineDatatable = new DataTable();
lineDatatable.Columns.Add("Id");
lineDatatable.Columns.Add("Name");
ValueObjectList <LineVo> lineOutVo = null;
try
{
lineOutVo = (ValueObjectList <LineVo>)base.InvokeCbm(new GetLineMasterCbm(), new LineVo(), false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
if (lineOutVo == null || lineOutVo.GetList() == null || lineOutVo.GetList().Count == 0)
{
messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
return;
}
foreach (LineVo fac in lineOutVo.GetList())
{
lineDatatable.Rows.Add(fac.LineId, fac.LineCode + "-" + fac.LineName);
}
}
