/// <summary>
/// passing update data to update form
/// </summary>
private void BindUpdateCastingMachineFurnaceData()
{
int selectedrowindex = CastingMachineFurnaceDetails_dgv.SelectedCells[0].RowIndex;
CastingMachineFurnaceVo castFurVo = (CastingMachineFurnaceVo)CastingMachineFurnaceDetails_dgv.Rows[selectedrowindex].DataBoundItem;
AddCastingMachineFurnaceForm newAddForm = new AddCastingMachineFurnaceForm(CommonConstants.MODE_UPDATE, castFurVo);
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>
/// Creates seacrh condition as per user inputs
/// </summary>
/// <returns>search condition</returns>
private StringBuilder FormCondition(CastingMachineFurnaceVo inVo)
{
StringBuilder searchCondition = new StringBuilder();
searchCondition.Append(" where cmf.factory_cd = :faccd ");
if (inVo.CastingMachineFurnaceCode != null)
{
searchCondition.Append(" and UPPER(cmf.casting_machine_furnace_cd) like UPPER(:castfurcode)");
}
if (inVo.CastingMachineFurnaceName != null)
{
searchCondition.Append(" and UPPER(cmf.casting_machine_furnace_name) like UPPER(:castfurname)");
}
if (inVo.EquipmentId > 0)
{
searchCondition.Append(" and cmf.equipment_id = :eqpid");
}
searchCondition.Append(" order by cmf.casting_machine_furnace_cd");
return(searchCondition);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
CastingMachineFurnaceVo inVo = (CastingMachineFurnaceVo)arg;
CastingMachineFurnaceVo outVo = new CastingMachineFurnaceVo();
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Delete from m_casting_machine_furnace");
sqlQuery.Append(" where ");
sqlQuery.Append(" casting_machine_furnace_id = :castfurid ");
sqlQuery.Append(" and factory_cd = :faccd ;");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("castfurid", inVo.CastingMachineFurnaceId);
sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode);
outVo.AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter);
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
CastingMachineFurnaceVo inVo = (CastingMachineFurnaceVo)arg;
CastingMachineFurnaceVo outVo = new CastingMachineFurnaceVo();
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Update m_casting_machine_furnace");
sqlQuery.Append(" set ");
sqlQuery.Append(" casting_machine_furnace_name = ");
sqlQuery.Append(" :castfurname, ");
sqlQuery.Append(" equipment_id = ");
sqlQuery.Append(" :eqpid,");
sqlQuery.Append(" factory_cd = ");
sqlQuery.Append(" :factcode");
sqlQuery.Append(" where");
sqlQuery.Append(" casting_machine_furnace_id = ");
sqlQuery.Append(" :castfurid");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("castfurid", inVo.CastingMachineFurnaceId);
sqlParameter.AddParameterString("castfurname", inVo.CastingMachineFurnaceName);
sqlParameter.AddParameterInteger("eqpid", inVo.EquipmentId);
sqlParameter.AddParameterString("factcode", inVo.FactoryCode);
outVo.AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter);
return(outVo);
}
/// <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 = CastingMachineFurnaceDetails_dgv.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = CastingMachineFurnaceDetails_dgv.Rows[selectedrowindex];
messageData = new MessageData("mmcc00004", Properties.Resources.mmcc00004, selectedRow.Cells["colCastingMachineFurnaceCode"].Value.ToString());
// Logger.Info(messageData);
DialogResult dialogResult = popUpMessage.ConfirmationOkCancel(messageData, Text);
if (dialogResult == DialogResult.OK)
{
CastingMachineFurnaceVo inVo = new CastingMachineFurnaceVo();
inVo.CastingMachineFurnaceId = Convert.ToInt32(selectedRow.Cells["colCastingMachineFurnaceId"].Value.ToString());
inVo.CastingMachineFurnaceCode = selectedRow.Cells["colCastingMachineFurnaceCode"].Value.ToString();
try
{
CastingMachineFurnaceVo tableCount = CheckFurnaceRelationCbm(inVo);
if (tableCount.AffectedCount > 0)
{
messageData = new MessageData("mmce00007", Properties.Resources.mmce00007, CastingMachine.ToString());
popUpMessage.Information(messageData, Text);
return;
}
CastingMachineFurnaceVo outVo = (CastingMachineFurnaceVo)base.InvokeCbm(new DeleteCastingMachineFurnaceMasterMntCbm(), inVo, false);
if (outVo.AffectedCount > 0)
{
this.messageData = new MessageData("mmci00003", Properties.Resources.mmci00003, null);
logger.Info(this.messageData);
popUpMessage.Information(this.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>
/// constructor
/// </summary>
/// <param name="pmode"></param>
/// <param name="userItem"></param>
public AddCastingMachineFurnaceForm(string pmode, CastingMachineFurnaceVo 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="dgvCastingMachineFurnace"></param>
private void LoadCastingMachineFurnaceData(CastingMachineFurnaceVo dgvCastingMachineFurnace)
{
if (dgvCastingMachineFurnace != null)
{
//this.CastingMachineFurnaceId_lbl.Text = dgvCastingMachineFurnace.Cells["colCastingMachineFurnaceId"].Value.ToString();
this.CastingMachineFurnaceCode_txt.Text = dgvCastingMachineFurnace.CastingMachineFurnaceCode;
this.CastingMachineFurnaceName_txt.Text = dgvCastingMachineFurnace.CastingMachineFurnaceName;
this.Equipment_cmb.SelectedValue = dgvCastingMachineFurnace.EquipmentId.ToString();
}
}
/// <summary>
/// To idenctify the relation ship with tables
/// </summary>
private CastingMachineFurnaceVo CheckFurnaceRelationCbm(CastingMachineFurnaceVo inVo)
{
CastingMachineFurnaceVo outVo = new CastingMachineFurnaceVo();
try
{
outVo = (CastingMachineFurnaceVo)base.InvokeCbm(new CheckCastingMachineFurnaceRelationCbm(), inVo, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
CastingMachineFurnaceVo inVo = (CastingMachineFurnaceVo)arg;
CastingMachineFurnaceVo outVo = new CastingMachineFurnaceVo();
StringBuilder sqlQuery = new StringBuilder();
//create SQL
sqlQuery.Append(" select Count(cmf.casting_machine_furnace_cd) as CastFurCode from m_casting_machine_furnace as cmf");
sqlQuery.Append(" inner join m_casting_machine as cm on ");
sqlQuery.Append(" cmf.casting_machine_furnace_id = cm.casting_machine_furnace_id ");
sqlQuery.Append(" where cmf.factory_cd = :faccd ");
if (inVo.CastingMachineFurnaceCode != null)
{
sqlQuery.Append(" and UPPER(casting_machine_furnace_cd) = UPPER(:castfurcode)");
}
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode);
if (inVo.CastingMachineFurnaceCode != null)
{
sqlParameter.AddParameterString("castfurcode", inVo.CastingMachineFurnaceCode);
}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
outVo.AffectedCount = 0;
while (dataReader.Read())
{
outVo.AffectedCount = Convert.ToInt32(dataReader["CastFurCode"]);
}
dataReader.Close();
return(outVo);
}
/// <summary>
/// Loads equipment details to datatable
/// </summary>
private void FormDatatableFromVo()
{
equipmentDatatable = new DataTable();
equipmentDatatable.Columns.Add("Id");
equipmentDatatable.Columns.Add("Name");
try
{
EquipmentVo equipmentOutVo = (EquipmentVo)base.InvokeCbm(new GetEquipmentMasterMntCbm(), new EquipmentVo(), false);
foreach (EquipmentVo fac in equipmentOutVo.EquipmentListVo)
{
equipmentDatatable.Rows.Add(fac.EquipmentId, fac.EquipmentName);
}
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
//CastingMachineFurnaceDatatable
castingMachineFurnaceDatatable = new DataTable();
castingMachineFurnaceDatatable.Columns.Add("Id");
castingMachineFurnaceDatatable.Columns.Add("Name");
try
{
CastingMachineFurnaceVo castingMachineFurnaceOutVo =
(CastingMachineFurnaceVo)base.InvokeCbm(new GetCastingMachineFurnaceMasterMntCbm(), new CastingMachineFurnaceVo(), false);
foreach (CastingMachineFurnaceVo castfur in castingMachineFurnaceOutVo.CastingMachineFurnaceListVo)
{
castingMachineFurnaceDatatable.Rows.Add(castfur.CastingMachineFurnaceId, castfur.CastingMachineFurnaceName);
}
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
CastingMachineFurnaceVo inVo = (CastingMachineFurnaceVo)arg;
CastingMachineFurnaceVo outVo = new CastingMachineFurnaceVo();
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Insert into m_casting_machine_furnace");
sqlQuery.Append(" ( ");
sqlQuery.Append(" casting_machine_furnace_cd,");
sqlQuery.Append(" casting_machine_furnace_name,");
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(" :castfurcode,");
sqlQuery.Append(" :castfurname,");
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("castfurcode", inVo.CastingMachineFurnaceCode);
sqlParameter.AddParameterString("castfurname", inVo.CastingMachineFurnaceName);
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);
}
/// <summary>
/// Creates seacrh condition as per user inputs
/// </summary>
/// <returns>search condition</returns>
private CastingMachineFurnaceVo FormConditionVo()
{
CastingMachineFurnaceVo inVo = new CastingMachineFurnaceVo();
if (CastingMachineFurnaceCode_txt.Text != string.Empty)
{
inVo.CastingMachineFurnaceCode = CastingMachineFurnaceCode_txt.Text;
}
if (CastingMachineFurnaceName_txt.Text != string.Empty)
{
inVo.CastingMachineFurnaceName = CastingMachineFurnaceName_txt.Text;
}
if (EquipmentId_cmb.SelectedIndex > -1)
{
inVo.EquipmentId = Convert.ToInt32(EquipmentId_cmb.SelectedValue.ToString());
}
return(inVo);
}
/// <summary>
/// Fills all user records to gridview control
/// </summary>
private void GridBind(CastingMachineFurnaceVo conditionInVo)
{
CastingMachineFurnaceDetails_dgv.DataSource = null;
try
{
CastingMachineFurnaceVo outVo = (CastingMachineFurnaceVo)base.InvokeCbm(new GetCastingMachineFurnaceMasterMntCbm(), conditionInVo, false);
BindingList <List <CastingMachineFurnaceVo> > userBind = new BindingList <List <CastingMachineFurnaceVo> >();
CastingMachineFurnaceDetails_dgv.AutoGenerateColumns = false;
BindingSource bindingSource1 = new BindingSource(outVo.CastingMachineFurnaceListVo, null);
if (bindingSource1 != null && bindingSource1.Count > 0)
{
CastingMachineFurnaceDetails_dgv.DataSource = bindingSource1;
}
else
{
messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null); //"casting machine furnace"
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
}
CastingMachineFurnaceDetails_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)
{
CastingMachineFurnaceVo inVo = (CastingMachineFurnaceVo)arg;
CastingMachineFurnaceVo outVo = new CastingMachineFurnaceVo();
StringBuilder sqlQuery = new StringBuilder();
//create SQL
sqlQuery.Append("select");
sqlQuery.Append(" cmf.casting_machine_furnace_id,");
sqlQuery.Append(" cmf.casting_machine_furnace_cd,");
sqlQuery.Append(" cmf.casting_machine_furnace_name,");
sqlQuery.Append(" cmf.equipment_id,");
sqlQuery.Append(" eqp.equipment_name");
sqlQuery.Append(" from m_casting_machine_furnace cmf");
sqlQuery.Append(" inner join m_equipment eqp on cmf.equipment_id = eqp.equipment_id");
sqlQuery.Append(FormCondition(inVo));
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode);
if (inVo.CastingMachineFurnaceCode != null)
{
sqlParameter.AddParameterString("castfurcode", inVo.CastingMachineFurnaceCode + "%");
}
if (inVo.CastingMachineFurnaceName != null)
{
sqlParameter.AddParameterString("castfurname", inVo.CastingMachineFurnaceName + "%");
}
if (inVo.EquipmentId > 0)
{
sqlParameter.AddParameterInteger("eqpid", inVo.EquipmentId);
}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
CastingMachineFurnaceVo currOutVo = new CastingMachineFurnaceVo
{
CastingMachineFurnaceId = Convert.ToInt32(dataReader["casting_machine_furnace_id"].ToString()),
CastingMachineFurnaceCode = dataReader["casting_machine_furnace_cd"].ToString(),
CastingMachineFurnaceName = dataReader["casting_machine_furnace_name"].ToString(),
EquipmentId = Convert.ToInt32(dataReader["equipment_id"].ToString()),
EquipmentName = dataReader["equipment_name"].ToString()
};
outVo.CastingMachineFurnaceListVo.Add(currOutVo);
}
dataReader.Close();
return(outVo);
}
/// <summary>
/// inserts new record
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Ok_btn_Click(object sender, EventArgs e)
{
CastingMachineFurnaceVo inVo = new CastingMachineFurnaceVo();
var sch = StringCheckHelper.GetInstance();
if (CheckMandatory() == true)
{
if (string.IsNullOrEmpty(CastingMachineFurnaceCode_txt.Text) || string.IsNullOrEmpty(CastingMachineFurnaceName_txt.Text))
{
messageData = new MessageData("mmce00003", Properties.Resources.mmce00003);
logger.Info(messageData);
popUpMessage.ConfirmationOkCancel(messageData, Text);
if (string.IsNullOrEmpty(CastingMachineFurnaceCode_txt.Text))
{
CastingMachineFurnaceCode_txt.Focus();
}
else if (string.IsNullOrEmpty(CastingMachineFurnaceName_txt.Text))
{
CastingMachineFurnaceName_txt.Focus();
}
return;
}
inVo.CastingMachineFurnaceCode = CastingMachineFurnaceCode_txt.Text.Trim();
inVo.CastingMachineFurnaceName = CastingMachineFurnaceName_txt.Text.Trim();
inVo.EquipmentId = Convert.ToInt32(Equipment_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))
{
CastingMachineFurnaceVo checkVo = DuplicateCheck(inVo);
if (checkVo != null && checkVo.AffectedCount > 0)
{
messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, CastingMachineFurnaceCode_lbl.Text + " : " + CastingMachineFurnaceCode_txt.Text);
logger.Info(messageData);
popUpMessage.ConfirmationOkCancel(messageData, Text);
return;
}
}
try
{
if (string.Equals(mode, CommonConstants.MODE_ADD))
{
CastingMachineFurnaceVo outVo = (CastingMachineFurnaceVo)base.InvokeCbm(new AddCastingMachineFurnaceMasterMntCbm(), inVo, false);
IntSuccess = outVo.AffectedCount;
}
else if (mode.Equals(CommonConstants.MODE_UPDATE))
{
inVo.CastingMachineFurnaceId = updateData.CastingMachineFurnaceId;
CastingMachineFurnaceVo outVo = (CastingMachineFurnaceVo)base.InvokeCbm(new UpdateCastingMachineFurnaceMasterMntCbm(), 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();
}
}
}
