/// <summary>
/// Creates seacrh condition as per user inputs
/// </summary>
/// <returns>search condition</returns>
private CavityVo FormConditionVo()
{
if (!string.IsNullOrWhiteSpace(Mold_cmb.Text) && Mold_cmb.SelectedIndex < 0)
{
messageData = new MessageData("mmce00013", Properties.Resources.mmce00013);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
return(null);
}
CavityVo inVo = new CavityVo();
if (Mold_cmb.SelectedIndex > -1)
{
inVo.MoldId = Convert.ToInt32(Mold_cmb.SelectedValue);
}
if (CavityCode_txt.Text != string.Empty)
{
inVo.CavityCode = CavityCode_txt.Text;
}
if (CavityName_txt.Text != string.Empty)
{
inVo.CavityName = CavityName_txt.Text;
}
return(inVo);
}
/// <summary>
/// selects user record for updation and show user form
/// </summary>
private void BindUpdateCavityData()
{
int selectedrowindex = Cavity_dgv.SelectedCells[0].RowIndex;
CavityVo cavInVo = (CavityVo)Cavity_dgv.Rows[selectedrowindex].DataBoundItem;
AddCavityForm newAddForm = new AddCavityForm(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.mmci00007, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
GridBind(FormConditionVo());
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
CavityVo inVo = (CavityVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Delete From m_cavity");
sqlQuery.Append(" Where ");
sqlQuery.Append(" cavity_id = :cavityid ");
sqlQuery.Append(" and factory_cd = :faccd ;");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("cavityid", inVo.CavityId);
sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode);
CavityVo outVo = new CavityVo {
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
CavityVo inVo = (CavityVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Update m_cavity");
sqlQuery.Append(" Set ");
sqlQuery.Append(" cavity_name = :cavityname, ");
sqlQuery.Append(" mold_id = :moldid ");
sqlQuery.Append(" Where ");
sqlQuery.Append(" cavity_id = :cavityid ;");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("cavityid", inVo.CavityId);
sqlParameter.AddParameterString("cavityname", inVo.CavityName);
sqlParameter.AddParameterInteger("moldid", inVo.MoldId);
CavityVo outVo = new CavityVo {
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
/// <summary>
/// Fills all user records to gridview control
/// </summary>
private void GridBind(CavityVo conditionInVo)
{
Cavity_dgv.DataSource = null;
try
{
CavityVo outVo = (CavityVo)base.InvokeCbm(new GetCavityMasterMntCbm(), conditionInVo, false);
Cavity_dgv.AutoGenerateColumns = false;
BindingSource bindingSource1 = new BindingSource(outVo.CavityListVo, null);
if (bindingSource1 != null && bindingSource1.Count > 0)
{
Cavity_dgv.DataSource = bindingSource1;
}
else
{
messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null); //"cavity"
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
}
Cavity_dgv.ClearSelection();
Update_btn.Enabled = false;
Delete_btn.Enabled = false;
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
CavityVo inVo = (CavityVo)arg;
StringBuilder sqlQuery = new StringBuilder();
//create SQL
sqlQuery.Append("Select Count(*) as CavityCount from m_cavity ");
sqlQuery.Append(" where factory_cd = :faccd ");
if (inVo.CavityCode != null)
{
sqlQuery.Append(" and UPPER(cavity_cd) = UPPER(:cavitycd) ");
}
if (inVo.MoldId > 0)
{
sqlQuery.Append(" and mold_id = :moldid ");
}
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode);
if (inVo.CavityCode != null)
{
sqlParameter.AddParameterString("cavitycd", inVo.CavityCode);
}
if (inVo.MoldId > 0)
{
sqlParameter.AddParameterInteger("moldid", inVo.MoldId);
}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
CavityVo outVo = new CavityVo {
AffectedCount = 0
};
while (dataReader.Read())
{
outVo.AffectedCount = Convert.ToInt32(dataReader["CavityCount"]);
}
dataReader.Close();
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(CavityVo dgvMoldType)
{
if (dgvMoldType != null)
{
this.CavityCode_txt.Text = dgvMoldType.CavityCode;
this.CavityName_txt.Text = dgvMoldType.CavityName;
this.Mold_cmb.SelectedValue = dgvMoldType.MoldId.ToString();
}
}
public AddCavityForm(string pmode, CavityVo userItem = null)
{
InitializeComponent();
mode = pmode;
updateData = userItem;
if (string.Equals(mode, CommonConstants.MODE_UPDATE))
{
this.Text = UpdateText_lbl.Text;
}
}
/// <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 = Cavity_dgv.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = Cavity_dgv.Rows[selectedrowindex];
messageData = new MessageData("mmcc00004", Properties.Resources.mmcc00004, selectedRow.Cells["colCavityCode"].Value.ToString());
logger.Info(messageData);
DialogResult dialogResult = popUpMessage.ConfirmationOkCancel(messageData, Text);
if (dialogResult == DialogResult.OK)
{
CavityVo inVo = new CavityVo
{
CavityId = Convert.ToInt32(selectedRow.Cells["colCavityId"].Value),
RegistrationDateTime = Convert.ToDateTime(DateTime.Now.ToString(UserData.GetUserData().DateTimeFormat)),
RegistrationUserCode = UserData.GetUserData().UserCode,
};
try
{
CavityVo outVo = (CavityVo)base.InvokeCbm(new DeleteCavityMasterMntCbm(), 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
}
}
/// <summary>
/// checks duplicate mold Code
/// </summary>
/// <returns></returns>
private CavityVo DuplicateCheck(CavityVo cavityVo)
{
CavityVo outVo = new CavityVo();
try
{
outVo = (CavityVo)base.InvokeCbm(new CheckCavityMasterMntCbm(), cavityVo, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
CavityVo inVo = (CavityVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Insert into m_cavity");
sqlQuery.Append(" ( ");
sqlQuery.Append(" cavity_cd, ");
sqlQuery.Append(" cavity_name, ");
sqlQuery.Append(" mold_id, ");
sqlQuery.Append(" registration_user_cd, ");
sqlQuery.Append(" registration_date_time, ");
sqlQuery.Append(" factory_cd ");
sqlQuery.Append(" ) ");
sqlQuery.Append("VALUES ");
sqlQuery.Append(" ( ");
sqlQuery.Append(" :cavitycd ,");
sqlQuery.Append(" :cavityname ,");
sqlQuery.Append(" :moldid ,");
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("cavitycd", inVo.CavityCode);
sqlParameter.AddParameterString("cavityname", inVo.CavityName);
sqlParameter.AddParameterInteger("moldid", inVo.MoldId);
UserData userdata = trxContext.UserData;
sqlParameter.AddParameterString("registrationusercode", userdata.UserCode);
sqlParameter.AddParameterDateTime("regdatetime", trxContext.ProcessingDBDateTime);
sqlParameter.AddParameterString("factorycode", userdata.FactoryCode);
CavityVo outVo = new CavityVo {
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
MoldDetailVo inVo = (MoldDetailVo)vo;
MoldItemVo moldItemInVo = new MoldItemVo();
moldItemInVo.MoldId = inVo.MoldId;
deleteMoldItemCbm.Execute(trxContext, moldItemInVo);
CavityVo cavityInVo = new CavityVo();
cavityInVo.MoldId = inVo.MoldId;
deleteCavityByMoldIdCbm.Execute(trxContext, cavityInVo);
return(deleteMoldDetailMasterMntCbm.Execute(trxContext, inVo));
}
private void AddCavity(TransactionContext trxContext, ValueObjectList <CavityVo> cavityInVo)
{
if (cavityInVo != null && cavityInVo.GetList().Count > 0)
{
foreach (CavityVo cavityVo in cavityInVo.GetList())
{
if (moldList.ContainsKey(cavityVo.MoldCode))
{
cavityVo.MoldId = (int)moldList[cavityVo.MoldCode];
}
CavityVo checkCavityOutVo = (CavityVo)checkCavityMasterMntCbm.Execute(trxContext, cavityVo);
if (checkCavityOutVo == null || checkCavityOutVo.AffectedCount == 0)
{
addCavityMasterMntCbm.Execute(trxContext, cavityVo);
}
}
}
}
/// <summary>
/// Creates seacrh condition as per user inputs
/// </summary>
/// <returns>search condition</returns>
private CavityVo FormConditionVo()
{
CavityVo inVo = new CavityVo();
if (CavityCode_txt.Text != string.Empty)
{
inVo.CavityCode = CavityCode_txt.Text;
}
if (CavityName_txt.Text != string.Empty)
{
inVo.CavityName = CavityName_txt.Text;
}
if (Mold_cmb.SelectedIndex > -1)
{
inVo.MoldId = Convert.ToInt32(Mold_cmb.SelectedValue);
}
return(inVo);
}
/// <summary>
/// update the record to db
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected virtual void Ok_btn_Click(object sender, EventArgs e)
{
CavityVo inVo = new CavityVo();
if (CheckMandatory())
{
var sch = StringCheckHelper.GetInstance();
if (string.IsNullOrEmpty(CavityCode_txt.Text) || string.IsNullOrEmpty(CavityName_txt.Text))
{
messageData = new MessageData("mmce00003", Properties.Resources.mmce00003);
logger.Info(messageData);
popUpMessage.ConfirmationOkCancel(messageData, Text);
if (string.IsNullOrEmpty(CavityCode_txt.Text))
{
CavityCode_txt.Focus();
}
else
{
CavityName_txt.Focus();
}
return;
}
if (CavityCode_txt.Text.Trim().Length < 4)
{
MessageData messageData = new MessageData("mmci00008", Properties.Resources.mmci00008, CavityCode_lbl.Text);
popUpMessage.Warning(messageData, Text);
CavityCode_txt.Focus();
return;
}
inVo.CavityCode = CavityCode_txt.Text.Trim();
inVo.CavityName = CavityName_txt.Text.Trim();
inVo.MoldId = Convert.ToInt32(Mold_cmb.SelectedValue);
//inVo.RegistrationDateTime = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
inVo.RegistrationUserCode = UserData.GetUserData().UserCode;
inVo.FactoryCode = UserData.GetUserData().FactoryCode;
if (string.Equals(mode, CommonConstants.MODE_ADD))
{
CavityVo checkVo = DuplicateCheck(inVo);
if (checkVo != null && checkVo.AffectedCount > 0)
{
messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, CavityCode_lbl.Text + " : " + CavityCode_txt.Text);
logger.Info(messageData);
popUpMessage.ConfirmationOkCancel(messageData, Text);
return;
}
}
try
{
if (string.Equals(mode, CommonConstants.MODE_ADD))
{
CavityVo outVo = (CavityVo)base.InvokeCbm(new AddCavityMasterMntCbm(), inVo, false);
IntSuccess = outVo.AffectedCount;
}
else if (mode.Equals(CommonConstants.MODE_UPDATE))
{
inVo.CavityId = updateData.CavityId;
CavityVo outVo = (CavityVo)base.InvokeCbm(new UpdateCavityMasterMntCbm(), 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)
{
CavityVo inVo = (CavityVo)arg;
StringBuilder sqlQuery = new StringBuilder();
//create SQL
sqlQuery.Append("Select ct.cavity_id, ct.cavity_cd, ct.cavity_name, md.mold_id, md.mold_cd ");
sqlQuery.Append(" from m_cavity ct ");
sqlQuery.Append(" inner join m_mold md on md.mold_id = ct.mold_id ");
sqlQuery.Append(" where ct.factory_cd = :faccd ");
if (inVo.CavityCode != null)
{
sqlQuery.Append(" and ct.cavity_cd like :cavitycd ");
}
if (inVo.CavityName != null)
{
sqlQuery.Append(" and ct.cavity_name like :cavityname ");
}
if (inVo.MoldId != 0)
{
sqlQuery.Append(" and md.mold_id = :moldid ");
}
if (!string.IsNullOrEmpty(inVo.MoldCode))
{
sqlQuery.Append(" and md.mold_cd = :moldcd ");
}
sqlQuery.Append(" order by ct.cavity_cd");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
if (!string.IsNullOrEmpty(inVo.FactoryCode))
{
sqlParameter.AddParameterString("faccd", inVo.FactoryCode);
}
else
{
sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode);
}
if (inVo.CavityCode != null)
{
sqlParameter.AddParameterString("cavitycd", inVo.CavityCode + "%");
}
if (inVo.CavityName != null)
{
sqlParameter.AddParameterString("cavityname", inVo.CavityName + "%");
}
if (inVo.MoldId != 0)
{
sqlParameter.AddParameterInteger("moldid", inVo.MoldId);
}
if (!string.IsNullOrEmpty(inVo.MoldCode))
{
sqlParameter.AddParameterString("moldcd", inVo.MoldCode);
}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
ValueObjectList <CavityVo> outVo = null;
while (dataReader.Read())
{
CavityVo currOutVo = new CavityVo
{
CavityId = ConvertDBNull <Int32>(dataReader, "cavity_id"),
CavityCode = ConvertDBNull <string>(dataReader, "cavity_cd"),
CavityName = ConvertDBNull <string>(dataReader, "cavity_name"),
MoldId = ConvertDBNull <Int32>(dataReader, "mold_id"),
MoldCode = ConvertDBNull <string>(dataReader, "mold_cd")
};
if (outVo == null)
{
outVo = new ValueObjectList <CavityVo>();
}
outVo.add(currOutVo);
}
dataReader.Close();
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
CavityVo inVo = (CavityVo)arg;
StringBuilder sqlQuery = new StringBuilder();
//create SQL
sqlQuery.Append("Select ct.cavity_id, ct.cavity_cd, ct.cavity_name, md.mold_id, md.mold_cd ");
sqlQuery.Append(" from m_cavity ct ");
sqlQuery.Append(" inner join m_mold md on md.mold_id = ct.mold_id ");
sqlQuery.Append(" inner join m_mold_type mdt on mdt.mold_type_id = md.mold_type_id ");
sqlQuery.Append(" inner join m_local_item mli on mli.item_id = mdt.item_id ");
sqlQuery.Append(" where ct.factory_cd = :faccd ");
if (inVo.CavityCode != null)
{
sqlQuery.Append(" and ct.cavity_cd like :cavitycd ");
}
if (inVo.CavityName != null)
{
sqlQuery.Append(" and ct.cavity_name like :cavityname ");
}
if (inVo.ModelCode != null)
{
sqlQuery.Append(" and mli.item_cd = :modelcd ");
}
if (inVo.ModelId > 0)
{
sqlQuery.Append(" and mli.item_id = :modelid ");
}
sqlQuery.Append(" order by cavity_cd");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode);
if (inVo.CavityCode != null)
{
sqlParameter.AddParameterString("cavitycd", inVo.CavityCode + "%");
}
if (inVo.CavityName != null)
{
sqlParameter.AddParameterString("cavityname", inVo.CavityName + "%");
}
if (inVo.ModelCode != null)
{
sqlParameter.AddParameterString("modelcd", inVo.ModelCode);
}
if (inVo.ModelId > 0)
{
sqlParameter.AddParameterInteger("modelid", inVo.ModelId);
}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
ValueObjectList <CavityVo> outVo = null;
while (dataReader.Read())
{
CavityVo currOutVo = new CavityVo();
{
currOutVo.CavityId = Convert.ToInt32(dataReader["cavity_id"]);
currOutVo.CavityCode = dataReader["cavity_cd"].ToString();
currOutVo.CavityName = dataReader["cavity_name"].ToString();
currOutVo.MoldId = Convert.ToInt32(dataReader["mold_id"]);
currOutVo.MoldCode = dataReader["mold_cd"].ToString();
};
if (outVo == null)
{
outVo = new ValueObjectList <CavityVo>();
}
outVo.add(currOutVo);
}
dataReader.Close();
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
CavityVo inVo = (CavityVo)arg;
StringBuilder sqlQuery = new StringBuilder();
//create SQL
sqlQuery.Append("Select ct.cavity_id, ct.cavity_cd, ct.cavity_name, md.mold_id, md.mold_cd ");
sqlQuery.Append(" from m_cavity ct ");
sqlQuery.Append(" inner join m_mold md on md.mold_id = ct.mold_id ");
sqlQuery.Append(" where 1 = 1 ");
if (inVo.CavityCode != null)
{
sqlQuery.Append(" and ct.cavity_cd like :cavitycd ");
}
if (inVo.CavityName != null)
{
sqlQuery.Append(" and ct.cavity_name like :cavityname ");
}
if (inVo.MoldId != 0)
{
sqlQuery.Append(" and md.mold_id = :moldid ");
}
sqlQuery.Append(" order by ct.cavity_cd");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
if (inVo.CavityCode != null)
{
sqlParameter.AddParameterString("cavitycd", inVo.CavityCode + "%");
}
if (inVo.CavityName != null)
{
sqlParameter.AddParameterString("cavityname", inVo.CavityName + "%");
}
if (inVo.MoldId != 0)
{
sqlParameter.AddParameterInteger("moldid", inVo.MoldId);
}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
CavityVo outVo = new CavityVo();
while (dataReader.Read())
{
CavityVo currOutVo = new CavityVo
{
CavityId = Convert.ToInt32(dataReader["cavity_id"]),
CavityCode = dataReader["cavity_cd"].ToString(),
CavityName = dataReader["cavity_name"].ToString(),
MoldId = Convert.ToInt32(dataReader["mold_id"]),
MoldCode = dataReader["mold_cd"].ToString()
};
outVo.CavityListVo.Add(currOutVo);
}
dataReader.Close();
return(outVo);
}
