/// <summary>
/// selects user record for updation and show user form
/// </summary>
private void BindUpdateMoldCategoryData()
{
int selectedrowindex = MoldCategory_dgv.SelectedCells[0].RowIndex;
MoldCategoryVo cavInVo = (MoldCategoryVo)MoldCategory_dgv.Rows[selectedrowindex].DataBoundItem;
AddMoldCategoryForm newAddForm = new AddMoldCategoryForm(CommonConstants.MODE_UPDATE, cavInVo);
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.mmci00004, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
GridBind(FormConditionVo());
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
MoldCategoryVo inVo = (MoldCategoryVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Update m_mold_category");
sqlQuery.Append(" Set ");
sqlQuery.Append(" mold_category_name = :moldcategoryname, ");
sqlQuery.Append(" display_order = :displayorder ");
sqlQuery.Append(" Where ");
sqlQuery.Append(" factory_cd = :factorycode and mold_category_id = :moldcategoryid;");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("factorycode", trxContext.UserData.FactoryCode);
sqlParameter.AddParameterInteger("moldcategoryid", inVo.MoldCategoryId);
sqlParameter.AddParameterString("moldcategoryname", inVo.MoldCategoryName);
sqlParameter.AddParameterInteger("displayorder", inVo.DisplayOrder);
MoldCategoryVo outVo = new MoldCategoryVo {
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
/// <summary>
/// For setting selected user record into respective controls(textbox and combobox) for update operation
/// passing selected user data as parameter
/// </summary>
/// <param name="dgvMoldType"></param>
private void LoadUserData(MoldCategoryVo dgvMoldType)
{
if (dgvMoldType != null)
{
this.MoldCategoryCode_txt.Text = dgvMoldType.MoldCategoryCode;
this.MoldCategoryName_txt.Text = dgvMoldType.MoldCategoryName;
//this.DisplayOrder_txt.Text = dgvMoldType.DisplayOrder.ToString();
}
}
private void LoadMoldCategoryCombo()
{
MoldCategoryVo inVo = new MoldCategoryVo();
ValueObjectList <MoldCategoryVo> outVo = (ValueObjectList <MoldCategoryVo>)DefaultCbmInvoker.Invoke(new GetMoldCategoryMasterMntCbm(), inVo);
MoldCategory_cmb.DataSource = outVo.GetList();
MoldCategory_cmb.DisplayMember = "MoldCategoryName";
MoldCategory_cmb.ValueMember = "MoldCategoryId";
MoldCategory_cmb.SelectedIndex = -1;
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
MoldCategoryVo inVo = (MoldCategoryVo)arg;
StringBuilder sqlQuery = new StringBuilder();
//create SQL
sqlQuery.Append("Select Count(*) as MoldCategoryCount,");
sqlQuery.Append(" mold_category_cd, ");
sqlQuery.Append(" mold_category_id ");
sqlQuery.Append(" from m_mold_category ");
sqlQuery.Append(" where factory_cd = :factorycode ");
if (inVo.MoldCategoryCode != null)
{
sqlQuery.Append(" and UPPER(mold_category_cd) = UPPER(:moldCategorycd) ");
}
sqlQuery.Append(" group by mold_category_cd,mold_category_id ");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("factorycode", trxContext.UserData.FactoryCode);
if (inVo.MoldCategoryCode != null)
{
sqlParameter.AddParameterString("moldCategorycd", inVo.MoldCategoryCode);
}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
ValueObjectList <MoldCategoryVo> outVo = new ValueObjectList <MoldCategoryVo> ();
while (dataReader.Read())
{
MoldCategoryVo currOutVo = new MoldCategoryVo
{
MoldCategoryId = Convert.ToInt32(dataReader["mold_category_id"]),
MoldCategoryCode = dataReader["mold_category_cd"].ToString(),
};
outVo.add(currOutVo);
}
dataReader.Close();
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
MoldCategoryVo inVo = (MoldCategoryVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Insert into m_mold_category");
sqlQuery.Append(" ( ");
sqlQuery.Append(" mold_category_cd, ");
sqlQuery.Append(" mold_category_name, ");
sqlQuery.Append(" display_order, ");
sqlQuery.Append(" registration_user_cd, ");
sqlQuery.Append(" registration_date_time, ");
sqlQuery.Append(" factory_cd ");
sqlQuery.Append(" ) ");
sqlQuery.Append("VALUES ");
sqlQuery.Append(" ( ");
sqlQuery.Append(" :moldcategorycd ,");
sqlQuery.Append(" :moldcategoryname ,");
sqlQuery.Append(" :displayorder ,");
sqlQuery.Append(" :registrationusercode ,");
sqlQuery.Append(" :registrationdatetime ,");
sqlQuery.Append(" :factorycode ");
sqlQuery.Append(" ) ");
sqlQuery.Append("RETURNING mold_category_id;");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("moldcategorycd", inVo.MoldCategoryCode);
sqlParameter.AddParameterString("moldcategoryname", inVo.MoldCategoryName);
sqlParameter.AddParameterInteger("displayorder", inVo.DisplayOrder);
sqlParameter.AddParameterString("registrationusercode", trxContext.UserData.UserCode);
sqlParameter.AddParameterDateTime("registrationdatetime", trxContext.ProcessingDBDateTime);
sqlParameter.AddParameterString("factorycode", trxContext.UserData.FactoryCode);
//execute SQL
int outId = (int?)sqlCommandAdapter.ExecuteScalar(sqlParameter) ?? 0;
MoldCategoryVo outVo = null;
if (outId > 0)
{
outVo = new MoldCategoryVo();
outVo.MoldCategoryId = outId;
}
return(outVo);
}
/// <summary>
/// Constructor for the form
/// </summary>
/// <param name="pmode"></param>
/// <param name="userItem"></param>
public AddMoldCategoryForm(string pmode, MoldCategoryVo userItem = null)
{
InitializeComponent();
mode = pmode;
updateData = userItem;
if (string.Equals(mode, CommonConstants.MODE_UPDATE))
{
this.Text = UpdateText_lbl.Text;
}
}
/// <summary>
/// checks duplicate Display Record
/// </summary>
/// <param name="defectVo"></param>
/// <returns></returns>
private MoldCategoryVo DuplicateDisplayCheck(MoldCategoryVo defectVo)
{
MoldCategoryVo outVo = new MoldCategoryVo();
try
{
outVo = (MoldCategoryVo)base.InvokeCbm(new CheckDisplayRecordMasterMntCbm(), defectVo, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
return(outVo);
}
/// <summary>
/// Creates seacrh condition as per user inputs
/// </summary>
/// <returns>search condition</returns>
private MoldCategoryVo FormConditionVo()
{
MoldCategoryVo inVo = new MoldCategoryVo();
if (MoldCategoryCode_txt.Text != string.Empty)
{
inVo.MoldCategoryCode = MoldCategoryCode_txt.Text;
}
if (MoldCategoryName_txt.Text != string.Empty)
{
inVo.MoldCategoryName = MoldCategoryName_txt.Text;
}
return(inVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
MoldCategoryVo inVo = (MoldCategoryVo)arg;
MoldCategoryVo outVo = new MoldCategoryVo();
StringBuilder sqlQuery = new StringBuilder();
//create SQL query
sqlQuery.Append("Select Count(*) DefRsnCount from m_mold_category ");
sqlQuery.Append(" where factory_cd = :factorycode ");
if (inVo.DisplayOrder != 0)
{
sqlQuery.Append(" and display_order = :displayorder");
}
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("factorycode", trxContext.UserData.FactoryCode);
if (inVo.DisplayOrder != 0)
{
sqlParameter.AddParameterInteger("displayorder", inVo.DisplayOrder);
}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
outVo.AffectedCount = 0;
while (dataReader.Read())
{
outVo.AffectedCount = Convert.ToInt32(dataReader["DefRsnCount"]);
}
dataReader.Close();
return(outVo);
}
/// <summary>
/// form country and factory data for combo
/// </summary>
//private void FormDatatableFromVo()
//{
// moldDatatable = new DataTable();
// moldDatatable.Columns.Add("id");
// moldDatatable.Columns.Add("code");
// try
// {
// MoldVo moldOutVo = (MoldVo)base.InvokeCbm(new GetMoldMasterMntCbm(), new MoldVo (), false);
// foreach (MoldVo mold in moldOutVo.MoldListVo)
// {
// moldDatatable.Rows.Add(mold.MoldId, mold.MoldCode);
// }
// }
// catch (Framework.ApplicationException exception)
// {
// popUpMessage.ApplicationError(exception.GetMessageData(), Text);
// logger.Error(exception.GetMessageData());
// }
//}
/// <summary>
/// checks duplicate mold Code
/// </summary>
/// <returns></returns>
private MoldCategoryVo DuplicateCheck(MoldCategoryVo MoldCategoryVo)
{
MoldCategoryVo outVo = new MoldCategoryVo();
try
{
this.Cursor = Cursors.WaitCursor;
outVo = (MoldCategoryVo)base.InvokeCbm(new CheckMoldCategoryMasterMntCbm(), MoldCategoryVo, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
finally
{
this.Cursor = Cursors.Default;
}
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
MoldCategoryVo inVo = (MoldCategoryVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("select count(mc.mold_category_cd) as CategoryCount from m_mold_detail md");
sqlQuery.Append(" inner join m_mold_category mc on mc.mold_category_id = md.mold_category_id");
sqlQuery.Append(" where mc.factory_cd = :factorycode ");
if (inVo.MoldCategoryCode != null)
{
sqlQuery.Append(" and UPPER(mold_category_cd) = UPPER(:moldcategorycd) ");
}
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("factorycode", trxContext.UserData.FactoryCode);
if (inVo.MoldCategoryCode != null)
{
sqlParameter.AddParameterString("moldcategorycd", inVo.MoldCategoryCode);
}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
MoldCategoryVo outVo = new MoldCategoryVo();
while (dataReader.Read())
{
outVo.AffectedCount = Convert.ToInt32("0" + dataReader["CategoryCount"]);
}
dataReader.Close();
return(outVo);
}
/// <summary>
/// Fills all user records to gridview control
/// </summary>
private void GridBind(MoldCategoryVo conditionInVo)
{
MoldCategory_dgv.DataSource = null;
try
{
this.Cursor = Cursors.WaitCursor;
ValueObjectList <MoldCategoryVo> outVo = (ValueObjectList <MoldCategoryVo>)base.InvokeCbm(new GetMoldCategoryMasterMntCbm(), conditionInVo, false);
MoldCategory_dgv.AutoGenerateColumns = false;
BindingSource bindingSource1 = new BindingSource(outVo.GetList(), null);
if (bindingSource1 != null && bindingSource1.Count > 0)
{
MoldCategory_dgv.DataSource = bindingSource1;
}
else
{
messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null); //"MoldCategory"
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
}
MoldCategory_dgv.ClearSelection();
Update_btn.Enabled = false;
Delete_btn.Enabled = false;
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
finally
{
this.Cursor = Cursors.Default;
}
}
private void AddCategory(TransactionContext trxContext, ValueObjectList <MoldCategoryVo> moldCategoryInVo)
{
foreach (MoldCategoryVo moldCategoryVo in moldCategoryInVo.GetList())
{
// Checking existing data
ValueObjectList <MoldCategoryVo> moldCategoryCheckVo = (ValueObjectList <MoldCategoryVo>)checkMoldCategoryMasterMntCbm.Execute(trxContext, moldCategoryVo);
if (moldCategoryCheckVo != null && moldCategoryCheckVo.GetList().Count > 0)
{
foreach (MoldCategoryVo curVo in moldCategoryCheckVo.GetList())
{
if (!categoryList.ContainsKey(curVo.MoldCategoryCode))
{
categoryList.Add(curVo.MoldCategoryCode, curVo.MoldCategoryId);
}
}
}
else
{
MoldCategoryVo moldCategoryOutVo = (MoldCategoryVo)addMoldCategoryMasterMntCbm.Execute(trxContext, moldCategoryVo);
categoryList.Add(moldCategoryVo.MoldCategoryCode, moldCategoryOutVo.MoldCategoryId);
}
}
}
/// <summary>
/// event to delete the selected record
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Delete_btn_Click(object sender, EventArgs e)
{
int selectedrowindex = MoldCategory_dgv.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = MoldCategory_dgv.Rows[selectedrowindex];
messageData = new MessageData("mmcc00004", Properties.Resources.mmcc00004, selectedRow.Cells["colMoldCategoryCode"].Value.ToString());
logger.Info(messageData);
DialogResult dialogResult = popUpMessage.ConfirmationOkCancel(messageData, Text);
if (dialogResult == DialogResult.OK)
{
MoldCategoryVo inVo = new MoldCategoryVo();
inVo.MoldCategoryId = Convert.ToInt32(selectedRow.Cells["colMoldCategoryId"].Value);
inVo.MoldCategoryCode = selectedRow.Cells["colMoldCategoryCode"].Value.ToString();
try
{
MoldCategoryVo checkVo = CheckRelation(inVo);
if (checkVo != null && checkVo.AffectedCount > 0)
{
messageData = new MessageData("mmce00007", Properties.Resources.mmce00007, "Mold");
popUpMessage.Information(messageData, Text);
return;
}
this.Cursor = Cursors.WaitCursor;
MoldCategoryVo outVo = (MoldCategoryVo)base.InvokeCbm(new DeleteMoldCategoryMasterMntCbm(), 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.mmci00004, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
GridBind(FormConditionVo());
}
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
finally
{
this.Cursor = Cursors.Default;
}
}
else if (dialogResult == DialogResult.Cancel)
{
//do something else
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
MoldCategoryVo inVo = (MoldCategoryVo)arg;
StringBuilder sqlQuery = new StringBuilder();
//create SQL
sqlQuery.Append("Select ct.mold_category_id, ct.mold_category_cd, ct.mold_category_name,ct.display_order ");
sqlQuery.Append(" from m_mold_category ct ");
sqlQuery.Append(" where factory_cd = :factorycode ");
if (inVo.MoldCategoryCode != null)
{
sqlQuery.Append(" and ct.mold_category_cd like :moldcategorycd ");
}
if (inVo.MoldCategoryName != null)
{
sqlQuery.Append(" and ct.mold_category_name like :moldcategoryname ");
}
sqlQuery.Append(" order by ct.display_order");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("factorycode", trxContext.UserData.FactoryCode);
if (inVo.MoldCategoryCode != null)
{
sqlParameter.AddParameterString("moldcategorycd", inVo.MoldCategoryCode + "%");
}
if (inVo.MoldCategoryName != null)
{
sqlParameter.AddParameterString("moldcategoryname", inVo.MoldCategoryName + "%");
}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
ValueObjectList <MoldCategoryVo> outVo = null;
while (dataReader.Read())
{
MoldCategoryVo currOutVo = new MoldCategoryVo
{
MoldCategoryId = Convert.ToInt32(dataReader["mold_category_id"]),
MoldCategoryCode = dataReader["mold_category_cd"].ToString(),
MoldCategoryName = dataReader["mold_category_name"].ToString(),
DisplayOrder = Convert.ToInt32(dataReader["display_order"]),
};
if (outVo == null)
{
outVo = new ValueObjectList <MoldCategoryVo>();
}
outVo.add(currOutVo);
}
dataReader.Close();
return(outVo);
}
/// <summary>
/// update the record to db
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Ok_btn_Click(object sender, EventArgs e)
{
MoldCategoryVo inVo = new MoldCategoryVo();
if (CheckMandatory())
{
var sch = StringCheckHelper.GetInstance();
if (!sch.IsASCII(MoldCategoryCode_txt.Text) || !sch.IsASCII(MoldCategoryName_txt.Text)) //|| !sch.IsASCII(DisplayOrder_txt.Text)
{
messageData = new MessageData("mmce00003", Properties.Resources.mmce00003);
logger.Info(messageData);
popUpMessage.ConfirmationOkCancel(messageData, Text);
if (!sch.IsASCII(MoldCategoryCode_txt.Text))
{
MoldCategoryCode_txt.Focus();
}
else if (!sch.IsASCII(MoldCategoryName_txt.Text))
{
MoldCategoryName_txt.Focus();
}
else
{
DisplayOrder_txt.Focus();
}
return;
}
inVo.MoldCategoryCode = MoldCategoryCode_txt.Text.Trim();
inVo.MoldCategoryName = MoldCategoryName_txt.Text.Trim();
// inVo.DisplayOrder = Convert.ToInt32(DisplayOrder_txt.Text.Trim());
if (string.Equals(mode, CommonConstants.MODE_ADD))
{
MoldCategoryVo checkVo = DuplicateCheck(inVo);
if (checkVo != null && checkVo.AffectedCount > 0)
{
messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, MoldCategoryCode_lbl.Text + " : " + MoldCategoryCode_txt.Text);
logger.Info(messageData);
popUpMessage.ConfirmationOkCancel(messageData, Text);
MoldCategoryCode_txt.Focus();
return;
}
//MoldCategoryVo checkDisplayVo = DuplicateDisplayCheck(inVo);
//if (checkDisplayVo != null && checkDisplayVo.AffectedCount > 0)
//{
// messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, DisplayOrder_lbl.Text + " : " + DisplayOrder_txt.Text);
// logger.Info(messageData);
// popUpMessage.ConfirmationOkCancel(messageData, Text);
// DisplayOrder_txt.Focus();
// return;
//}
}
try
{
this.Cursor = Cursors.WaitCursor;
if (string.Equals(mode, CommonConstants.MODE_ADD))
{
MoldCategoryVo outVo = (MoldCategoryVo)base.InvokeCbm(new AddMoldCategoryMasterMntCbm(), inVo, false);
IntSuccess = outVo.MoldCategoryId;
}
else if (mode.Equals(CommonConstants.MODE_UPDATE))
{
//if (updateData.DisplayOrder != Convert.ToInt32(DisplayOrder_txt.Text))
//{
// MoldCategoryVo checkDisplayVo = DuplicateDisplayCheck(inVo);
// if (checkDisplayVo != null && checkDisplayVo.AffectedCount > 0)
// {
// messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, DisplayOrder_lbl.Text + " : " + DisplayOrder_txt.Text);
// logger.Info(messageData);
// popUpMessage.ConfirmationOkCancel(messageData, Text);
// DisplayOrder_txt.Focus();
// return;
// }
//}
inVo.MoldCategoryId = updateData.MoldCategoryId;
MoldCategoryVo outVo = (MoldCategoryVo)base.InvokeCbm(new UpdateMoldCategoryMasterMntCbm(), inVo, false);
IntSuccess = outVo.AffectedCount;
}
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
finally
{
this.Cursor = Cursors.Default;
}
if ((IntSuccess > 0) || (IntSuccess == 0))
{
this.Close();
}
}
}