/// <summary>
/// Creates seacrh condition as per user inputs
/// </summary>
/// <returns>search condition</returns>
private CastingMachineVo FormConditionVo()
{
CastingMachineVo inVo = new CastingMachineVo();
if (CastingMachineCode_txt.Text != string.Empty)
{
inVo.CastingMachineCode = CastingMachineCode_txt.Text;
}
if (CastingMachineName_txt.Text != string.Empty)
{
inVo.CastingMachineName = CastingMachineName_txt.Text;
}
if (CastingMachineFurnaceId_cmb.SelectedIndex > -1)
{
inVo.CastingMachineFurnaceId = Convert.ToInt32(CastingMachineFurnaceId_cmb.SelectedValue.ToString());
}
if (EquipmentId_cmb.SelectedIndex > -1)
{
inVo.EquipmentId = Convert.ToInt32(EquipmentId_cmb.SelectedValue.ToString());
}
return(inVo);
}
/// <summary>
/// Creates seacrh condition as per user inputs
/// </summary>
/// <returns>search condition</returns>
private StringBuilder FormCondition(CastingMachineVo inVo)
{
StringBuilder searchCondition = new StringBuilder();
searchCondition.Append(" where cm.factory_cd = :faccd ");
if (inVo.CastingMachineCode != null)
{
searchCondition.Append(" and UPPER(cm.casting_machine_cd) like UPPER(:castcode)");
}
if (inVo.CastingMachineName != null)
{
searchCondition.Append(" and UPPER(cm.casting_machine_name) like UPPER(:castname)");
}
if (inVo.CastingMachineFurnaceId > 0)
{
searchCondition.Append(" and cmf.casting_machine_furnace_id = :castfurid");
}
if (inVo.EquipmentId > 0)
{
searchCondition.Append(" and cm.equipment_id = :eqpid");
}
searchCondition.Append(" order by cm.casting_machine_cd");
return(searchCondition);
}
/// <summary>
/// Fills all user records to gridview control
/// </summary>
private void GridBind(CastingMachineVo conditionInVo)
{
CastingMachineDetails_dgv.DataSource = null;
try
{
CastingMachineVo outVo = (CastingMachineVo)base.InvokeCbm(new GetCastingMachineMasterMntCbm(), conditionInVo, false);
CastingMachineDetails_dgv.AutoGenerateColumns = false;
BindingSource bindingSource1 = new BindingSource(outVo.CastingMachineListVo, null);
if (bindingSource1 != null && bindingSource1.Count > 0)
{
CastingMachineDetails_dgv.DataSource = bindingSource1;
}
else
{
messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null); //"casting machine"
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
}
CastingMachineDetails_dgv.ClearSelection();
Update_btn.Enabled = false;
Delete_btn.Enabled = false;
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
}
/// <summary>
/// passing update data to update form
/// </summary>
private void BindUpdateCastingMachineData()
{
int selectedrowindex = CastingMachineDetails_dgv.SelectedCells[0].RowIndex;
CastingMachineVo castInVo = (CastingMachineVo)CastingMachineDetails_dgv.Rows[selectedrowindex].DataBoundItem;
AddCastingMachineForm newAddForm = new AddCastingMachineForm(CommonConstants.MODE_UPDATE, castInVo);
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());
}
}
/// <summary>
/// constructor
/// </summary>
/// <param name="pmode"></param>
/// <param name="userItem"></param>
public AddCastingMachineForm(string pmode, CastingMachineVo userItem = null)
{
InitializeComponent();
mode = pmode;
updateData = userItem;
if (string.Equals(mode, CommonConstants.MODE_UPDATE))
{
this.Text = UpdateText_lbl.Text;
}
}
/// <summary>
/// Loads selected data from data grid
/// </summary>
/// <param name="dgvCastingMachine"></param>
private void LoadCastingMachineData(CastingMachineVo dgvCastingMachine)
{
if (dgvCastingMachine != null)
{
this.CastingMachineCode_txt.Text = dgvCastingMachine.CastingMachineCode;
this.CastingMachineName_txt.Text = dgvCastingMachine.CastingMachineName;
this.CastingMachineFurnaceName_cmb.SelectedValue = dgvCastingMachine.CastingMachineFurnaceId.ToString();
this.Equipment_cmb.SelectedValue = dgvCastingMachine.EquipmentId.ToString();
}
}
/// <summary>
/// delete the selected record
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Delete_btn_Click(object sender, EventArgs e)
{
int selectedrowindex = CastingMachineDetails_dgv.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = CastingMachineDetails_dgv.Rows[selectedrowindex];
messageData = new MessageData("mmcc00004", Properties.Resources.mmcc00004, selectedRow.Cells["colCastingMachineCode"].Value.ToString());
logger.Info(messageData);
DialogResult dialogResult = popUpMessage.ConfirmationOkCancel(messageData, Text);
if (dialogResult == DialogResult.OK)
{
CastingMachineVo inVo = new CastingMachineVo
{
CastingMachineId = Convert.ToInt32(selectedRow.Cells["colCastingMachineId"].Value.ToString()),
};
try
{
CastingMachineVo outVo = (CastingMachineVo)base.InvokeCbm(new DeleteCastingMachineMasterMntCbm(), 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 Casting Machine Code
/// </summary>
/// <param name="castMacVo"></param>
/// <returns></returns>
private CastingMachineVo DuplicateCheck(CastingMachineVo castMacVo)
{
CastingMachineVo outVo = new CastingMachineVo();
try
{
outVo = (CastingMachineVo)base.InvokeCbm(new CheckCastingMachineMasterMntCbm(), castMacVo, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
CastingMachineVo inVo = (CastingMachineVo)arg;
CastingMachineVo outVo = new CastingMachineVo();
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Insert into m_casting_machine");
sqlQuery.Append(" ( ");
sqlQuery.Append(" casting_machine_cd,");
sqlQuery.Append(" casting_machine_name,");
sqlQuery.Append(" casting_machine_furnace_id,");
sqlQuery.Append(" equipment_id,");
sqlQuery.Append(" registration_user_cd,");
sqlQuery.Append(" registration_date_time,");
sqlQuery.Append(" factory_cd");
sqlQuery.Append(" ) ");
sqlQuery.Append("VALUES ");
sqlQuery.Append(" ( ");
sqlQuery.Append(" :castcode,");
sqlQuery.Append(" :castname,");
sqlQuery.Append(" :castfurid,");
sqlQuery.Append(" :eqpid,");
sqlQuery.Append(" :regusercode,");
sqlQuery.Append(" now(),");
sqlQuery.Append(" :factcode");
sqlQuery.Append(" ); ");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("castcode", inVo.CastingMachineCode);
sqlParameter.AddParameterString("castname", inVo.CastingMachineName);
sqlParameter.AddParameterInteger("castfurid", inVo.CastingMachineFurnaceId);
sqlParameter.AddParameterInteger("eqpid", inVo.EquipmentId);
sqlParameter.AddParameterString("regusercode", inVo.RegistrationUserCode);
//sqlParameter.AddParameterDateTime("regdt", inVo.RegistrationDateTime);
sqlParameter.AddParameterString("factcode", inVo.FactoryCode);
outVo.AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter);
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
CastingMachineVo inVo = (CastingMachineVo)arg;
CastingMachineVo outVo = new CastingMachineVo();
StringBuilder sql = new StringBuilder();
//create SQL
sql.Append("Select Count(*) as CastMachCount from m_casting_machine ");
sql.Append(" where factory_cd = :faccd ");
if (inVo.CastingMachineCode != null)
{
sql.Append(" and UPPER(casting_machine_cd) = UPPER(:castcode)");
}
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode);
if (inVo.CastingMachineCode != null)
{
sqlParameter.AddParameterString("castcode", inVo.CastingMachineCode);
}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
outVo.AffectedCount = 0;
while (dataReader.Read())
{
outVo.AffectedCount = Convert.ToInt32(dataReader["CastMachCount"]);
}
dataReader.Close();
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
CastingMachineVo inVo = (CastingMachineVo)arg;
CastingMachineVo outVo = new CastingMachineVo();
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Update m_casting_machine");
sqlQuery.Append(" set ");
sqlQuery.Append(" casting_machine_name = ");
sqlQuery.Append(" :castname, ");
sqlQuery.Append(" casting_machine_furnace_id = ");
sqlQuery.Append(" :castfurid,");
sqlQuery.Append(" equipment_id = ");
sqlQuery.Append(" :eqpid,");
sqlQuery.Append(" factory_cd = ");
sqlQuery.Append(" :factcode");
sqlQuery.Append(" where");
sqlQuery.Append(" casting_machine_id = ");
sqlQuery.Append(" :castid");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("castid", inVo.CastingMachineId);
sqlParameter.AddParameterString("castname", inVo.CastingMachineName);
sqlParameter.AddParameterInteger("castfurid", inVo.CastingMachineFurnaceId);
sqlParameter.AddParameterInteger("eqpid", inVo.EquipmentId);
sqlParameter.AddParameterString("factcode", inVo.FactoryCode);
outVo.AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter);
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
CastingMachineVo inVo = (CastingMachineVo)arg;
CastingMachineVo outVo = new CastingMachineVo();
StringBuilder sql = new StringBuilder();
sql.Append("Delete from m_casting_machine");
sql.Append(" where ");
sql.Append(" casting_machine_id = :castid");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("castid", inVo.CastingMachineId);
outVo.AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter);
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
CastingMachineVo inVo = (CastingMachineVo)arg;
CastingMachineVo outVo = new CastingMachineVo();
StringBuilder sql = new StringBuilder();
//create SQL
sql.Append("select");
sql.Append(" cm.casting_machine_id,");
sql.Append(" cm.casting_machine_cd,");
sql.Append(" cm.casting_machine_name,");
sql.Append(" cmf.casting_machine_furnace_id,");
sql.Append(" cmf.casting_machine_furnace_name,");
sql.Append(" cm.equipment_id,");
sql.Append(" eqp.equipment_name");
sql.Append(" from m_casting_machine cm");
sql.Append(" inner join m_casting_machine_furnace cmf");
sql.Append(" on cm.casting_machine_furnace_id = cmf.casting_machine_furnace_id");
sql.Append(" inner join m_equipment eqp");
sql.Append(" on cm.equipment_id = eqp.equipment_id");
sql.Append(FormCondition(inVo).ToString());
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.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.CastingMachineCode != null)
{
sqlParameter.AddParameterString("castcode", inVo.CastingMachineCode + "%");
}
if (inVo.CastingMachineName != null)
{
sqlParameter.AddParameterString("castname", inVo.CastingMachineName + "%");
}
if (inVo.CastingMachineFurnaceId > 0)
{
sqlParameter.AddParameterInteger("castfurid", inVo.CastingMachineFurnaceId);
}
if (inVo.EquipmentId > 0)
{
sqlParameter.AddParameterInteger("eqpid", inVo.EquipmentId);
}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
CastingMachineVo currOutVo = new CastingMachineVo
{
CastingMachineId = Convert.ToInt32(dataReader["casting_machine_id"].ToString()),
CastingMachineCode = dataReader["casting_machine_cd"].ToString(),
CastingMachineName = dataReader["casting_machine_name"].ToString(),
CastingMachineFurnaceId = Convert.ToInt32(dataReader["casting_machine_furnace_id"].ToString()),
CastingMachineFurnaceName = dataReader["casting_machine_furnace_name"].ToString(),
EquipmentId = Convert.ToInt32(dataReader["equipment_id"].ToString()),
EquipmentName = dataReader["equipment_name"].ToString()
};
outVo.CastingMachineListVo.Add(currOutVo);
}
dataReader.Close();
return(outVo);
}
/// <summary>
/// handles insert/update
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Ok_btn_Click(object sender, EventArgs e)
{
CastingMachineVo inVo = new CastingMachineVo();
var sch = StringCheckHelper.GetInstance();
if (CheckMandatory())
{
if (string.IsNullOrEmpty(CastingMachineCode_txt.Text) || string.IsNullOrEmpty(CastingMachineName_txt.Text))
{
messageData = new MessageData("mmce00003", Properties.Resources.mmce00003);
logger.Info(messageData);
popUpMessage.ConfirmationOkCancel(messageData, Text);
if (string.IsNullOrEmpty(CastingMachineCode_txt.Text))
{
CastingMachineCode_txt.Focus();
}
else if (string.IsNullOrEmpty(CastingMachineName_txt.Text))
{
CastingMachineName_txt.Focus();
}
return;
}
inVo.CastingMachineCode = CastingMachineCode_txt.Text.Trim();
inVo.CastingMachineName = CastingMachineName_txt.Text.Trim();
inVo.EquipmentId = Convert.ToInt32(Equipment_cmb.SelectedValue.ToString());
inVo.CastingMachineFurnaceId = Convert.ToInt32(CastingMachineFurnaceName_cmb.SelectedValue.ToString());
inVo.RegistrationUserCode = UserData.GetUserData().UserCode;
//inVo.RegistrationDateTime = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
inVo.FactoryCode = UserData.GetUserData().FactoryCode;
if (string.Equals(mode, CommonConstants.MODE_ADD))
{
CastingMachineVo checkVo = DuplicateCheck(inVo);
if (checkVo != null && checkVo.AffectedCount > 0)
{
messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, CastingMachineCode_lbl.Text + " : " + CastingMachineCode_txt.Text);
logger.Info(messageData);
popUpMessage.ConfirmationOkCancel(messageData, Text);
return;
}
}
if (updateData != null)
{
inVo.CastingMachineId = updateData.CastingMachineId;
}
try
{
if (string.Equals(mode, CommonConstants.MODE_ADD))
{
CastingMachineVo outVo = (CastingMachineVo)base.InvokeCbm(new AddCastingMachineMasterMntCbm(), inVo, false);
IntSuccess = outVo.AffectedCount;
}
else if (string.Equals(mode, CommonConstants.MODE_UPDATE))
{
CastingMachineVo outVo = (CastingMachineVo)base.InvokeCbm(new UpdateCastingMachineMasterMntCbm(), 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();
}
}
}
