/// <summary>
/// Fills all user records to gridview control
/// </summary>
private void GridBind(SapItemSearchVo conditionInVo)
{
Item_dgv.DataSource = null;
try
{
ValueObjectList <SapItemSearchVo> outVo = (ValueObjectList <SapItemSearchVo>)base.InvokeCbm(new GetSapItemSearchCbm(), conditionInVo, false);
Item_dgv.AutoGenerateColumns = false;
if (outVo != null && outVo.GetList() != null && outVo.GetList().Count > 0)
{
BindingSource buildingSource = new BindingSource(outVo.GetList(), null);
Item_dgv.DataSource = buildingSource;
}
else
{
messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
}
Item_dgv.ClearSelection();
Ok_btn.Enabled = false;
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
}
/// <summary>
/// Clear
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Clear_btn_Click(object sender, EventArgs e)
{
InspectionFormatDetails_dgv.DataSource = null;
LineId_cmb.SelectedIndex = -1;
//ItemId_cmb.SelectedIndex = -1;
ItemCode_txt.Text = string.Empty;
sapItemSearchVo = null;
}
/// <summary>
/// Clear data
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Clear_btn_Click(object sender, EventArgs e)
{
InspectionItem_dgv.DataSource = null;
LineId_cmb.SelectedIndex = -1;
//ItemId_cmb.SelectedIndex = -1;
ItemCode_txt.Text = string.Empty;
sapItemSearchVo = null;
InspectionFormatName_txt.Text = string.Empty;
ItemName_lbl.Text = string.Empty;
ProcessId_cmb.DataSource = null;
ProcessId_cmb.Enabled = false;
}
/// <summary>
/// event to clear the controls of search criteria
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Clear_btn_Click(object sender, EventArgs e)
{
InspectionFormatCode_txt.Text = string.Empty;
InspectionFormatName_txt.Text = string.Empty;
//ItemId_cmb.SelectedIndex = LineId_cmb.SelectedIndex = -1;
LineId_cmb.SelectedIndex = -1;
InspectionFormatDetails_dgv.DataSource = null;
//ItemId_cmb.Select();
sapItemSearchVo = null;
ItemCode_txt.Text = string.Empty;
ItemCode_txt.Select();
Process_btn.Enabled = Update_btn.Enabled = Delete_btn.Enabled = false;
}
/// <summary>
/// Item search
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void ItemSearch_btn_Click(object sender, EventArgs e)
{
ItemSearchForm newAddForm = new ItemSearchForm();
newAddForm.ShowDialog();
sapItemSearchVo = newAddForm.sapItemSearchVo;
if (sapItemSearchVo != null)
{
ItemCode_txt.Text = sapItemSearchVo.SapItemCode; // + " - " + sapItemGlobalVo.SapItemName;
}
else
{
ItemCode_txt.Text = string.Empty;
}
}
/// <summary>
/// Creates seacrh condition as per user inputs
/// </summary>
/// <returns>search condition</returns>
private SapItemSearchVo FormConditionVo()
{
SapItemSearchVo inVo = new SapItemSearchVo();
if (ItemCode_txt.Text != string.Empty)
{
inVo.SapItemCode = ItemCode_txt.Text;
}
if (ItemName_txt.Text != string.Empty)
{
inVo.SapItemName = ItemName_txt.Text;
}
return(inVo);
}
/// <summary>
/// constructor
/// </summary>
/// <param name="pmode"></param>
/// <param name="factoryItem"></param>
public AddInspectionFormatMasterForm(string pmode, InspectionFormatVo InspectionFormatItem = null)
{
InitializeComponent();
mode = pmode;
updateData = InspectionFormatItem;
if (string.Equals(mode, CommonConstants.MODE_UPDATE))
{
this.Text = UpdateText_lbl.Text;
sapItemSearchVo = new SapItemSearchVo();
sapItemSearchVo.SapItemCode = updateData.SapItemCode;
sapItemSearchVo.SapItemName = updateData.SapItemName;
sapItemSearchVo.SapMaterialGroupId = updateData.SapMaterialGroupId;
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
SapItemSearchVo inVo = (SapItemSearchVo)arg;
StringBuilder sqlQuery = new StringBuilder();
//create SQL
sqlQuery.Append("SELECT ");
sqlQuery.Append(" si.sap_matnr_item_cd, ");
sqlQuery.Append(" CONCAT(si.sap_matnr_item_cd, ' - ', si.sap_maktx_item_name) as sap_maktx_item_name");
sqlQuery.Append(" FROM sap_item si");
sqlQuery.Append(" WHERE si.factory_cd = :factorycode ORDER BY si.sap_matnr_item_cd ");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("factorycode", trxContext.UserData.FactoryCode);
//execute SQL
ValueObjectList <SapItemSearchVo> outVo = null;
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
SapItemSearchVo currVo = new SapItemSearchVo();
currVo.SapItemCode = ConvertDBNull <string>(dataReader, "sap_matnr_item_cd");
currVo.SapItemName = ConvertDBNull <string>(dataReader, "sap_maktx_item_name");
if (outVo == null)
{
outVo = new ValueObjectList <SapItemSearchVo>();
}
outVo.add(currVo);
}
dataReader.Close();
return(outVo);
}
/// <summary>
/// get sap group id
/// </summary>
/// <returns></returns>
private string getSapItemGroupId()
{
Dictionary <string, string> getSapItemGroupName = new Dictionary <string, string>();
getSapItemGroupName.Add(GlobalMasterDataTypeEnum.CODE_COMMON.GetValue(), GlobalMasterDataTypeEnum.CODE_COMMON.ToString());
getSapItemGroupName.Add(GlobalMasterDataTypeEnum.CODE_MMC.GetValue(), GlobalMasterDataTypeEnum.CODE_MMC.ToString());
getSapItemGroupName.Add(GlobalMasterDataTypeEnum.CODE_MDCM.GetValue(), GlobalMasterDataTypeEnum.CODE_MDCM.ToString());
getSapItemGroupName.Add(GlobalMasterDataTypeEnum.CODE_CMC.GetValue(), GlobalMasterDataTypeEnum.CODE_CMC.ToString());
getSapItemGroupName.Add(GlobalMasterDataTypeEnum.CODE_FAN.GetValue(), GlobalMasterDataTypeEnum.CODE_FAN.ToString());
getSapItemGroupName.Add(GlobalMasterDataTypeEnum.CODE_PSC.GetValue(), GlobalMasterDataTypeEnum.CODE_PSC.ToString());
if (sapItemSearchVo != null && !string.IsNullOrEmpty(sapItemSearchVo.SapMaterialGroupId))
{
return(getSapItemGroupName[sapItemSearchVo.SapMaterialGroupId]);
}
else
{
ValueObjectList <SapItemSearchVo> outVo = new ValueObjectList <SapItemSearchVo>();
SapItemSearchVo ItemInVo = new SapItemSearchVo();
ItemInVo.SapItemCode = ItemCode_txt.Text;
try
{
outVo = (ValueObjectList <SapItemSearchVo>)DefaultCbmInvoker.Invoke(new GetSapItemSearchCbm(), ItemInVo);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
if (outVo != null && outVo.GetList() != null && outVo.GetList().Count > 0 && !string.IsNullOrEmpty(outVo.GetList()[0].SapMaterialGroupId))
{
return(getSapItemGroupName[outVo.GetList()[0].SapMaterialGroupId]);
}
}
return(null);
}
/// <summary>
/// Fills all user records to gridview control
/// </summary>
private void GridBind()
{
Item_dgv.DataSource = null;
SapItemSearchVo inVo = new SapItemSearchVo();
//List<SapItemSearchVo> outNewVo = null;
if (!string.IsNullOrWhiteSpace(ItemCode_txt.Text))
{
inVo.SapItemCode = ItemCode_txt.Text;
}
if (!string.IsNullOrWhiteSpace(ItemName_txt.Text))
{
inVo.SapItemName = ItemName_txt.Text;
}
try
{
ValueObjectList <SapItemSearchVo> outVo = (ValueObjectList <SapItemSearchVo>)DefaultCbmInvoker.Invoke(new GetSapItemSearchCbm(), inVo);
Item_dgv.AutoGenerateColumns = false;
if (outVo == null || outVo.GetList() == null || outVo.GetList().Count == 0)
{
messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
return;
}
BindingSource buildingSource;
//if (sapItemSearchVo != null && sapItemSearchVo.GetList() != null && sapItemSearchVo.GetList().Count > 0)
//{
// outVo.GetList().AddRange(sapItemSearchVo.GetList());
// outNewVo = outVo.GetList().Where(x => !String.IsNullOrWhiteSpace(x.SapItemCode))
// .Select(x => new SapItemSearchVo { SapItemCode = x.SapItemCode, SapItemName = x.SapItemName })
// .GroupBy(x => x.SapItemCode).Select(x => x.FirstOrDefault()).Distinct().ToList();
// buildingSource = new BindingSource(outNewVo, null);
//}
//else
//{
// buildingSource = new BindingSource(outVo.GetList(), null);
//}
buildingSource = new BindingSource(outVo.GetList(), null);
Item_dgv.DataSource = buildingSource;
Item_dgv.ClearSelection();
if (sapItemSearchVo != null && sapItemSearchVo.GetList() != null && sapItemSearchVo.GetList().Count > 0)
{
checkComboItems();
}
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
}
private void Item_dgv_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
sapItemSearchVo = (SapItemSearchVo)Item_dgv.Rows[Item_dgv.CurrentCell.RowIndex].DataBoundItem;
this.Close();
}
/// <summary>
/// Selected the record
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Ok_btn_Click(object sender, EventArgs e)
{
sapItemSearchVo = (SapItemSearchVo)Item_dgv.Rows[Item_dgv.CurrentCell.RowIndex].DataBoundItem;
this.Close();
}
