/// <summary>
/// selects user record for updation and show user form
/// </summary>
private void BindUpdatePaletteData()
{
int selectedrowindex = Palette_dgv.SelectedCells[0].RowIndex;
PaletteVo cavInVo = (PaletteVo)Palette_dgv.Rows[selectedrowindex].DataBoundItem;
AddPaletteForm newAddForm = new AddPaletteForm(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)
{
PaletteVo inVo = (PaletteVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Update m_palette");
sqlQuery.Append(" Set ");
sqlQuery.Append(" palette_name = :palettename, ");
sqlQuery.Append(" area_id = :areaid ");
sqlQuery.Append(" Where ");
sqlQuery.Append(" palette_id = :paletteid ;");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("paletteid", inVo.PaletteId);
sqlParameter.AddParameterString("palettename", inVo.PaletteName);
sqlParameter.AddParameterInteger("areaid", inVo.AreaId);
PaletteVo outVo = new PaletteVo {
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
/// <summary>
/// Fills all user records to gridview control
/// </summary>
private void GridBind(PaletteVo conditionInVo)
{
Palette_dgv.DataSource = null;
try
{
PaletteVo outVo = (PaletteVo)base.InvokeCbm(new GetPaletteMasterMntCbm(), conditionInVo, false);
Palette_dgv.AutoGenerateColumns = false;
BindingSource bindingSource1 = new BindingSource(outVo.PaletteListVo, null);
if (bindingSource1 != null && bindingSource1.Count > 0)
{
Palette_dgv.DataSource = bindingSource1;
}
else
{
messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
}
Palette_dgv.ClearSelection();
Update_btn.Enabled = false;
Delete_btn.Enabled = false;
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
}
/// <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(PaletteVo dgvMoldType)
{
if (dgvMoldType != null)
{
this.PaletteCode_txt.Text = dgvMoldType.PaletteCode;
this.PaletteName_txt.Text = dgvMoldType.PaletteName;
this.Area_cmb.SelectedValue = dgvMoldType.AreaId.ToString();
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
PaletteVo inVo = (PaletteVo)arg;
StringBuilder sqlQuery = new StringBuilder();
//create SQL
sqlQuery.Append("Select Count(*) as paletteCount from m_palette ");
sqlQuery.Append(" where 1 = 1 ");
if (inVo.PaletteCode != null)
{
sqlQuery.Append(" and UPPER(palette_cd) = UPPER(:palettecd) ");
}
//if (inVo.AreaId > 0)
//{
// sqlQuery.Append(" and area_id = :areaid ");
//}
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
if (inVo.PaletteCode != null)
{
sqlParameter.AddParameterString("palettecd", inVo.PaletteCode);
}
//if (inVo.AreaId > 0)
//{
// sqlParameter.AddParameterInteger("areaid", inVo.AreaId);
//}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
PaletteVo outVo = new PaletteVo {
AffectedCount = 0
};
while (dataReader.Read())
{
outVo.AffectedCount = Convert.ToInt32(dataReader["paletteCount"]);
}
dataReader.Close();
return(outVo);
}
/// <summary>
/// Constructor for the form
/// </summary>
/// <param name="pmode"></param>
/// <param name="userItem"></param>
public AddPaletteForm(string pmode, PaletteVo 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 = Palette_dgv.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = Palette_dgv.Rows[selectedrowindex];
messageData = new MessageData("mmcc00004", Properties.Resources.mmcc00004, selectedRow.Cells["colPaletteCode"].Value.ToString());
logger.Info(messageData);
DialogResult dialogResult = popUpMessage.ConfirmationOkCancel(messageData, Text);
if (dialogResult == DialogResult.OK)
{
PaletteVo inVo = new PaletteVo();
inVo.PaletteId = Convert.ToInt32(selectedRow.Cells["colPaletteId"].Value);
try
{
PaletteVo outVo = (PaletteVo)base.InvokeCbm(new DeletePaletteMasterMntCbm(), 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 PaletteVo DuplicateCheck(PaletteVo PaletteVo)
{
PaletteVo outVo = new PaletteVo();
try
{
outVo = (PaletteVo)base.InvokeCbm(new CheckPaletteMasterMntCbm(), PaletteVo, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
PaletteVo inVo = (PaletteVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Insert into m_palette");
sqlQuery.Append(" ( ");
sqlQuery.Append(" palette_cd, ");
sqlQuery.Append(" palette_name, ");
sqlQuery.Append(" area_id, ");
sqlQuery.Append(" registration_user_cd, ");
sqlQuery.Append(" registration_date_time, ");
sqlQuery.Append(" factory_cd ");
sqlQuery.Append(" ) ");
sqlQuery.Append("VALUES ");
sqlQuery.Append(" ( ");
sqlQuery.Append(" :palettecd ,");
sqlQuery.Append(" :palettename ,");
sqlQuery.Append(" :areaid ,");
sqlQuery.Append(" :registrationusercode ,");
sqlQuery.Append(" :registrationdatetime ,");
sqlQuery.Append(" :factorycode ");
sqlQuery.Append(" ); ");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("palettecd", inVo.PaletteCode);
sqlParameter.AddParameterString("palettename", inVo.PaletteName);
sqlParameter.AddParameterInteger("areaid", inVo.AreaId);
sqlParameter.AddParameterString("registrationusercode", trxContext.UserData.UserCode);
sqlParameter.AddParameterDateTime("registrationdatetime", trxContext.ProcessingDBDateTime);
sqlParameter.AddParameterString("factorycode", trxContext.UserData.FactoryCode);
PaletteVo outVo = new PaletteVo {
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
/// <summary>
/// Creates seacrh condition as per user inputs
/// </summary>
/// <returns>search condition</returns>
private PaletteVo FormConditionVo()
{
PaletteVo inVo = new PaletteVo();
if (PaletteCode_txt.Text != string.Empty)
{
inVo.PaletteCode = PaletteCode_txt.Text;
}
if (PaletteName_txt.Text != string.Empty)
{
inVo.PaletteName = PaletteName_txt.Text;
}
if (Area_cmb.SelectedIndex > -1)
{
inVo.AreaId = Convert.ToInt32(Area_cmb.SelectedValue);
}
return(inVo);
}
/// <summary>
/// update the record to db
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Ok_btn_Click(object sender, EventArgs e)
{
PaletteVo inVo = new PaletteVo();
if (CheckMandatory())
{
var sch = StringCheckHelper.GetInstance();
if (!sch.IsASCII(PaletteCode_txt.Text) || !sch.IsASCII(PaletteName_txt.Text))
{
messageData = new MessageData("mmce00003", Properties.Resources.mmce00003);
logger.Info(messageData);
popUpMessage.ConfirmationOkCancel(messageData, Text);
if (!sch.IsASCII(PaletteCode_txt.Text))
{
PaletteCode_txt.Focus();
}
else
{
PaletteName_txt.Focus();
}
return;
}
//if(PaletteCode_txt.Text.Trim().Length < 4)
//{
// MessageData messageData = new MessageData("mmci00008", Properties.Resources.mmci00008, PaletteCode_lbl.Text);
// popUpMessage.Warning(messageData, Text);
// PaletteCode_txt.Focus();
// return;
//}
inVo.PaletteCode = PaletteCode_txt.Text.Trim();
inVo.PaletteName = PaletteName_txt.Text.Trim();
inVo.AreaId = Convert.ToInt32(Area_cmb.SelectedValue);
if (string.Equals(mode, CommonConstants.MODE_ADD))
{
PaletteVo checkVo = DuplicateCheck(inVo);
if (checkVo != null && checkVo.AffectedCount > 0)
{
messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, PaletteCode_lbl.Text + " : " + PaletteCode_txt.Text);
logger.Info(messageData);
popUpMessage.ConfirmationOkCancel(messageData, Text);
PaletteCode_txt.Focus();
return;
}
}
try
{
if (string.Equals(mode, CommonConstants.MODE_ADD))
{
PaletteVo outVo = (PaletteVo)base.InvokeCbm(new AddPaletteMasterMntCbm(), inVo, false);
IntSuccess = outVo.AffectedCount;
}
else if (mode.Equals(CommonConstants.MODE_UPDATE))
{
inVo.PaletteId = updateData.PaletteId;
PaletteVo outVo = (PaletteVo)base.InvokeCbm(new UpdatePaletteMasterMntCbm(), 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)
{
PaletteVo inVo = (PaletteVo)arg;
StringBuilder sqlQuery = new StringBuilder();
//create SQL
sqlQuery.Append("Select ct.palette_id, ct.palette_cd, ct.palette_name, md.area_id, md.area_name ");
sqlQuery.Append(" from m_palette ct ");
sqlQuery.Append(" inner join m_area md on md.area_id = ct.area_id ");
sqlQuery.Append(" where 1 = 1 ");
if (inVo.PaletteCode != null)
{
sqlQuery.Append(" and ct.palette_cd like :palettecd ");
}
if (inVo.PaletteName != null)
{
sqlQuery.Append(" and ct.palette_name like :palettename ");
}
if (inVo.AreaId != 0)
{
sqlQuery.Append(" and md.area_id = :areaid ");
}
sqlQuery.Append(" order by ct.palette_cd");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
if (inVo.PaletteCode != null)
{
sqlParameter.AddParameterString("palettecd", inVo.PaletteCode + "%");
}
if (inVo.PaletteName != null)
{
sqlParameter.AddParameterString("palettename", inVo.PaletteName + "%");
}
if (inVo.AreaId != 0)
{
sqlParameter.AddParameterInteger("areaid", inVo.AreaId);
}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
PaletteVo outVo = new PaletteVo();
while (dataReader.Read())
{
PaletteVo currOutVo = new PaletteVo
{
PaletteId = Convert.ToInt32(dataReader["palette_id"]),
PaletteCode = dataReader["palette_cd"].ToString(),
PaletteName = dataReader["palette_name"].ToString(),
AreaId = Convert.ToInt32(dataReader["area_id"]),
AreaName = dataReader["area_name"].ToString()
};
outVo.PaletteListVo.Add(currOutVo);
}
dataReader.Close();
return(outVo);
}
