/// <summary>
/// Creates seacrh condition as per user inputs
/// </summary>
/// <returns>search condition</returns>
private LocalSupplierCavityVo FormConditionVo()
{
LocalSupplierCavityVo inVo = new LocalSupplierCavityVo();
if (LocalSupplierCavityCode_txt.Text != string.Empty)
{
inVo.LocalSupplierCavityCode = LocalSupplierCavityCode_txt.Text;
}
if (LocalSupplierCavityName_txt.Text != string.Empty)
{
inVo.LocalSupplierCavityName = LocalSupplierCavityName_txt.Text;
}
if (LocalSupplier_cmb.SelectedIndex > -1)
{
inVo.LocalSupplierId = Convert.ToInt32(LocalSupplier_cmb.SelectedValue);
}
if (Item_cmb.SelectedIndex > -1)
{
inVo.ItemId = Convert.ToInt32(Item_cmb.SelectedValue);
}
return(inVo);
}
/// <summary>
/// Fills all user records to gridview control
/// </summary>
private void GridBind(LocalSupplierCavityVo conditionInVo)
{
LocalSupplierCavity_dgv.DataSource = null;
try
{
LocalSupplierCavityVo outVo = (LocalSupplierCavityVo)base.InvokeCbm(new GetLocalSupplierCavityMasterMntCbm(), conditionInVo, false);
LocalSupplierCavity_dgv.AutoGenerateColumns = false;
BindingSource bindingSource1 = new BindingSource(outVo.LocalSupplierCavityListVo, null);
if (bindingSource1.Count > 0)
{
LocalSupplierCavity_dgv.DataSource = bindingSource1;
}
else
{
messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null); //"mold"
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
}
LocalSupplierCavity_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)
{
LocalSupplierCavityVo inVo = (LocalSupplierCavityVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Update m_local_supplier_cavity");
sqlQuery.Append(" Set ");
sqlQuery.Append(" cavity_name = :cavityname, ");
sqlQuery.Append(" local_supplier_id = :localsupplierid ");
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.LocalSupplierCavityId);
sqlParameter.AddParameterString("cavityname", inVo.LocalSupplierCavityName);
sqlParameter.AddParameterInteger("localsupplierid", inVo.LocalSupplierId);
LocalSupplierCavityVo outVo = new LocalSupplierCavityVo {
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(LocalSupplierCavityVo dgvLocalSupplierCavity)
{
if (dgvLocalSupplierCavity != null)
{
this.LocalSupplierCavityCode_txt.Text = dgvLocalSupplierCavity.LocalSupplierCavityCode;
this.LocalSupplierCavityName_txt.Text = dgvLocalSupplierCavity.LocalSupplierCavityName;
this.LocalSupplier_cmb.SelectedValue = dgvLocalSupplierCavity.LocalSupplierId.ToString();
}
}
/// <summary>
/// Constructor for the form
/// </summary>
/// <param name="pmode"></param>
/// <param name="userItem"></param>
public AddLocalSupplierCavityForm(string pmode, LocalSupplierCavityVo 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>
private void Delete_btn_Click(object sender, EventArgs e)
{
int selectedrowindex = LocalSupplierCavity_dgv.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = LocalSupplierCavity_dgv.Rows[selectedrowindex];
messageData = new MessageData("mmcc00004", Properties.Resources.mmcc00004, selectedRow.Cells["colLocalSupplierCavityCode"].Value.ToString());
logger.Info(messageData);
DialogResult dialogResult = popUpMessage.ConfirmationOkCancel(messageData, Text);
if (dialogResult == DialogResult.OK)
{
LocalSupplierCavityVo inVo = new LocalSupplierCavityVo
{
LocalSupplierCavityId = Convert.ToInt32(selectedRow.Cells["colLocalSupplierCavityId"].Value),
RegistrationDateTime = Convert.ToDateTime(DateTime.Now.ToString(UserData.GetUserData().DateTimeFormat)),
RegistrationUserCode = UserData.GetUserData().UserCode,
};
try
{
LocalSupplierCavityVo outVo = (LocalSupplierCavityVo)base.InvokeCbm(new DeleteLocalSupplierCavityMasterMntCbm(), 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>
/// <param name="moldVo"></param>
/// <returns></returns>
private LocalSupplierCavityVo DuplicateCheck(LocalSupplierCavityVo localSupplierCavityVo)
{
LocalSupplierCavityVo outVo = new LocalSupplierCavityVo();
try
{
outVo = (LocalSupplierCavityVo)base.InvokeCbm(new CheckLocalSupplierCavityMasterMntCbm(), localSupplierCavityVo, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
LocalSupplierCavityVo inVo = (LocalSupplierCavityVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append(" INSERT INTO m_local_supplier_cavity ");
sqlQuery.Append(" ( ");
sqlQuery.Append(" cavity_cd, ");
sqlQuery.Append(" cavity_name, ");
sqlQuery.Append(" local_supplier_id, ");
sqlQuery.Append(" item_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(" :localsupplierid, ");
sqlQuery.Append(" :itemid, ");
sqlQuery.Append(" :registrationusercode, ");
sqlQuery.Append(" now(), ");
sqlQuery.Append(" :factorycode ");
sqlQuery.Append(" ) ; ");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("cavitycd", inVo.LocalSupplierCavityCode);
sqlParameter.AddParameterString("cavityname", inVo.LocalSupplierCavityName);
sqlParameter.AddParameterInteger("localsupplierid", inVo.LocalSupplierId);
sqlParameter.AddParameterInteger("itemid", inVo.ItemId);
sqlParameter.AddParameterString("registrationusercode", inVo.RegistrationUserCode);
sqlParameter.AddParameterString("factorycode", inVo.FactoryCode);
LocalSupplierCavityVo outVo = new LocalSupplierCavityVo {
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
/// <summary>
/// selects user record for updation and show user form
/// </summary>
private void BindUpdateUserData()
{
int selectedrowindex = LocalSupplierCavity_dgv.SelectedCells[0].RowIndex;
LocalSupplierCavityVo selectedMold = (LocalSupplierCavityVo)LocalSupplierCavity_dgv.Rows[selectedrowindex].DataBoundItem;
AddLocalSupplierCavityForm newAddForm = new AddLocalSupplierCavityForm(CommonConstants.MODE_UPDATE, selectedMold);
newAddForm.ShowDialog(this);
if (newAddForm.IntSuccess > 0)
{
messageData = new MessageData("mmci00002", Properties.Resources.mmci00002, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
GridBind(FormConditionVo());
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
LocalSupplierCavityVo inVo = (LocalSupplierCavityVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Select Count(*) as supplierCavityCount from m_local_supplier_cavity ");
sqlQuery.Append(" where 1 = 1 ");
if (inVo.LocalSupplierCavityCode != null)
{
sqlQuery.Append(" and UPPER(cavity_cd) = UPPER(:cavitycd) ");
}
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
if (inVo.LocalSupplierCavityCode != null)
{
sqlParameter.AddParameterString("cavitycd", inVo.LocalSupplierCavityCode);
}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
LocalSupplierCavityVo outVo = new LocalSupplierCavityVo();
while (dataReader.Read())
{
outVo.AffectedCount = Convert.ToInt32(dataReader["supplierCavityCount"]);
}
dataReader.Close();
return(outVo);
}
/// <summary>
/// update data to db
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Ok_btn_Click(object sender, EventArgs e)
{
if (CheckMandatory())
{
var sch = StringCheckHelper.GetInstance();
if (string.IsNullOrEmpty(LocalSupplierCavityCode_txt.Text) || string.IsNullOrEmpty(LocalSupplierCavityName_txt.Text))
{
messageData = new MessageData("mmce00003", Properties.Resources.mmce00003);
logger.Info(messageData);
popUpMessage.ConfirmationOkCancel(messageData, Text);
if (string.IsNullOrEmpty(LocalSupplierCavityCode_txt.Text))
{
LocalSupplierCavityCode_txt.Focus();
}
else
{
LocalSupplierCavityName_txt.Focus();
}
return;
}
LocalSupplierCavityVo inVo = new LocalSupplierCavityVo
{
LocalSupplierCavityCode = LocalSupplierCavityCode_txt.Text.Trim(),
LocalSupplierCavityName = LocalSupplierCavityName_txt.Text.Trim(),
LocalSupplierId = Convert.ToInt32(LocalSupplier_cmb.SelectedValue),
//RegistrationDateTime = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"),
RegistrationUserCode = UserData.GetUserData().UserCode,
FactoryCode = UserData.GetUserData().FactoryCode
};
if (string.Equals(mode, CommonConstants.MODE_ADD))
{
LocalSupplierCavityVo checkVo = DuplicateCheck(inVo);
if (checkVo != null && checkVo.AffectedCount > 0)
{
messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, LocalSupplierCavityCode_lbl.Text + " : " + LocalSupplierCavityCode_txt.Text);
logger.Info(messageData);
popUpMessage.ApplicationError(messageData, Text);
return;
}
}
try
{
if (string.Equals(mode, CommonConstants.MODE_ADD))
{
LocalSupplierCavityVo outVo = (LocalSupplierCavityVo)base.InvokeCbm(new AddLocalSupplierCavityMasterMntCbm(), inVo, false);
IntSuccess = outVo.AffectedCount;
}
else if (mode.Equals(CommonConstants.MODE_UPDATE))
{
inVo.LocalSupplierCavityId = updateData.LocalSupplierCavityId;
LocalSupplierCavityVo outVo = (LocalSupplierCavityVo)base.InvokeCbm(new UpdateLocalSupplierCavityMasterMntCbm(), 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)
{
LocalSupplierCavityVo inVo = (LocalSupplierCavityVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Select lsc.cavity_id, lsc.cavity_cd, lsc.cavity_name, ls.local_supplier_id, ls.local_supplier_cd, ls.local_supplier_name ");
sqlQuery.Append("from m_local_supplier_cavity lsc ");
sqlQuery.Append("inner join m_local_supplier ls on ls.local_supplier_id = lsc.local_supplier_id ");
sqlQuery.Append(" where 1 = 1 ");
if (inVo.LocalSupplierCavityCode != null)
{
sqlQuery.Append(" and lsc.cavity_cd like :cavitycd ");
}
if (inVo.LocalSupplierCavityName != null)
{
sqlQuery.Append(" and lsc.cavity_name like :cavityname ");
}
if (inVo.LocalSupplierId != 0)
{
sqlQuery.Append(" and ls.local_supplier_id = :localsupplierid ");
}
sqlQuery.Append(" order by lsc.cavity_cd");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
if (inVo.LocalSupplierCavityCode != null)
{
sqlParameter.AddParameterString("cavitycd", inVo.LocalSupplierCavityCode + "%");
}
if (inVo.LocalSupplierCavityName != null)
{
sqlParameter.AddParameterString("cavityname", inVo.LocalSupplierCavityName + "%");
}
if (inVo.LocalSupplierId != 0)
{
sqlParameter.AddParameterInteger("localsupplierid", inVo.LocalSupplierId);
}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
LocalSupplierCavityVo outVo = new LocalSupplierCavityVo();
while (dataReader.Read())
{
LocalSupplierCavityVo currOutVo = new LocalSupplierCavityVo
{
LocalSupplierCavityId = Convert.ToInt32(dataReader["cavity_id"]),
LocalSupplierCavityCode = dataReader["cavity_cd"].ToString(),
LocalSupplierCavityName = dataReader["cavity_name"].ToString(),
LocalSupplierId = Convert.ToInt32(dataReader["local_supplier_id"]),
LocalSupplierName = dataReader["local_supplier_name"].ToString()
};
outVo.LocalSupplierCavityListVo.Add(currOutVo);
}
dataReader.Close();
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
LocalSupplierCavityVo inVo = (LocalSupplierCavityVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append(" SELECT ");
sqlQuery.Append(" lsc.cavity_id, ");
sqlQuery.Append(" lsc.cavity_cd, ");
sqlQuery.Append(" lsc.cavity_name, ");
sqlQuery.Append(" lsc.item_id, ");
sqlQuery.Append(" ls.local_supplier_id, ");
sqlQuery.Append(" ls.local_supplier_cd, ");
sqlQuery.Append(" ls.local_supplier_name, ");
sqlQuery.Append(" l.item_cd ");
sqlQuery.Append(" FROM ");
sqlQuery.Append(" m_local_supplier_cavity lsc ");
sqlQuery.Append(" INNER JOIN m_local_supplier ls ON ls.local_supplier_id = lsc.local_supplier_id ");
sqlQuery.Append(" LEFT JOIN m_local_item l ON l.item_id = lsc.item_id ");
sqlQuery.Append(" WHERE 1 = 1 ");
if (inVo.LocalSupplierCavityCode != null)
{
sqlQuery.Append(" AND lsc.cavity_cd like :cavitycd ");
}
if (inVo.LocalSupplierCavityName != null)
{
sqlQuery.Append(" AND lsc.cavity_name like :cavityname ");
}
if (inVo.LocalSupplierId != 0)
{
sqlQuery.Append(" AND ls.local_supplier_id = :localsupplierid ");
}
if (inVo.ItemId != 0)
{
sqlQuery.Append(" AND lsc.item_id = :itemid ");
}
sqlQuery.Append(" ORDER BY lsc.cavity_cd ");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
if (inVo.LocalSupplierCavityCode != null)
{
sqlParameter.AddParameterString("cavitycd", inVo.LocalSupplierCavityCode + "%");
}
if (inVo.LocalSupplierCavityName != null)
{
sqlParameter.AddParameterString("cavityname", inVo.LocalSupplierCavityName + "%");
}
if (inVo.LocalSupplierId != 0)
{
sqlParameter.AddParameterInteger("localsupplierid", inVo.LocalSupplierId);
}
if (inVo.ItemId != 0)
{
sqlParameter.AddParameterInteger("itemid", inVo.ItemId);
}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
LocalSupplierCavityVo outVo = new LocalSupplierCavityVo();
while (dataReader.Read())
{
LocalSupplierCavityVo currOutVo = new LocalSupplierCavityVo
{
LocalSupplierCavityId = Convert.ToInt32(dataReader["cavity_id"]),
LocalSupplierCavityCode = dataReader["cavity_cd"].ToString(),
LocalSupplierCavityName = dataReader["cavity_name"].ToString(),
LocalSupplierId = Convert.ToInt32(dataReader["local_supplier_id"]),
LocalSupplierName = dataReader["local_supplier_name"].ToString(),
ItemId = Convert.ToInt32(dataReader["item_id"]),
ItemCode = dataReader["item_cd"].ToString()
};
outVo.LocalSupplierCavityListVo.Add(currOutVo);
}
dataReader.Close();
return(outVo);
}
