/// <summary> /// Fills all user records to gridview control /// </summary> private void GridBind(EmployeeVo conditionInVo) { EmployeeDetails_dgv.DataSource = null; try { EmployeeVo outVo = (EmployeeVo)base.InvokeCbm(new GetEmployeeMasterMntCbm(), conditionInVo, false); EmployeeDetails_dgv.AutoGenerateColumns = false; BindingSource lineBindingSource = new BindingSource(outVo.EmployeeListVo, null); if (lineBindingSource.Count > 0) { EmployeeDetails_dgv.DataSource = lineBindingSource; } else { messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null); logger.Info(messageData); popUpMessage.Information(messageData, Text); } EmployeeDetails_dgv.ClearSelection(); Update_btn.Enabled = false; Delete_btn.Enabled = false; } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } }
/// <summary> /// selects user record for updation and show Employee form /// </summary> private void BindUpdateEmployeeData() { int selectedrowindex = EmployeeDetails_dgv.SelectedCells[0].RowIndex; EmployeeVo selectedEmployee = (EmployeeVo)EmployeeDetails_dgv.Rows[selectedrowindex].DataBoundItem; AddEmployeeMasterForm newAddForm = new AddEmployeeMasterForm(CommonConstants.MODE_UPDATE, selectedEmployee); 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) { EmployeeVo inVo = (EmployeeVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Update m_employee"); sqlQuery.Append(" Set "); sqlQuery.Append(" employee_name = :empname, "); sqlQuery.Append(" department = :department, "); sqlQuery.Append(" is_active = :isactive "); sqlQuery.Append(" Where "); sqlQuery.Append(" employee_cd = :empcd ;"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("empname", inVo.EmployeeName); sqlParameter.AddParameterString("empcd", inVo.EmployeeCode); sqlParameter.AddParameterString("department", inVo.Department); sqlParameter.AddParameterInteger("isactive", inVo.IsActive); EmployeeVo outVo = new EmployeeVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { EmployeeVo inVo = (EmployeeVo)arg; StringBuilder sqlQuery = new StringBuilder(); //create SQL sqlQuery.Append("Select em.employee_cd, em.employee_name, em.department, em.is_active "); sqlQuery.Append(" from m_employee em "); sqlQuery.Append(" where 1 = 1 "); if (inVo.EmployeeCode != null) { sqlQuery.Append(" and employee_cd like :empcd "); } if (inVo.EmployeeName != null) { sqlQuery.Append(" and employee_name like :empname "); } sqlQuery.Append(" order by em.employee_cd"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); if (inVo.EmployeeCode != null) { sqlParameter.AddParameterString("empcd", inVo.EmployeeCode + "%"); } if (inVo.EmployeeName != null) { sqlParameter.AddParameterString("empname", inVo.EmployeeName + "%"); } //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); EmployeeVo outVo = new EmployeeVo(); while (dataReader.Read()) { EmployeeVo currOutVo = new EmployeeVo(); currOutVo.EmployeeCode = ConvertDBNull <string>(dataReader, "employee_cd"); currOutVo.EmployeeName = ConvertDBNull <string>(dataReader, "employee_name"); currOutVo.Department = ConvertDBNull <string>(dataReader, "department"); currOutVo.IsActive = ConvertDBNull <int>(dataReader, "is_active"); outVo.EmployeeListVo.Add(currOutVo); } dataReader.Close(); return(outVo); }
/// <summary> /// For setting selected Line record into respective controls(textbox and combobox) for update operation /// passing selected Line data as parameter /// </summary> /// <param name="dgvEmployee"></param> private void LoadEmployeeData(EmployeeVo dgvLine) { if (dgvLine != null) { this.EmployeeCode_txt.Text = dgvLine.EmployeeCode; this.EmployeeName_txt.Text = dgvLine.EmployeeName; } }
/// <summary> /// constructor /// </summary> /// <param name="pmode"></param> /// <param name="EmployeeItem"></param> public AddEmployeeMasterForm(string pmode, EmployeeVo EmployeeItem = null) { InitializeComponent(); mode = pmode; updateData = EmployeeItem; if (string.Equals(mode, CommonConstants.MODE_UPDATE)) { this.Text = UpdateText_lbl.Text; } }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { EmployeeVo inVo = (EmployeeVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Insert into m_employee"); sqlQuery.Append(" ( "); sqlQuery.Append(" employee_cd, "); sqlQuery.Append(" employee_name, "); sqlQuery.Append(" department, "); sqlQuery.Append(" is_active, "); sqlQuery.Append(" registration_user_cd, "); sqlQuery.Append(" registration_date_time, "); sqlQuery.Append(" factory_cd "); sqlQuery.Append(" ) "); sqlQuery.Append("VALUES "); sqlQuery.Append(" ( "); sqlQuery.Append(" :empcd ,"); sqlQuery.Append(" :empname ,"); sqlQuery.Append(" :department ,"); sqlQuery.Append(" :isactive ,"); 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("empcd", inVo.EmployeeCode); sqlParameter.AddParameterString("empname", inVo.EmployeeName); sqlParameter.AddParameterString("department", inVo.Department); sqlParameter.AddParameterInteger("isactive", inVo.IsActive); sqlParameter.AddParameterString("registrationusercode", inVo.RegistrationUserCode); sqlParameter.AddParameterDateTime("registrationdatetime", trxContext.ProcessingDBDateTime); sqlParameter.AddParameterString("factorycode", inVo.FactoryCode); EmployeeVo outVo = new EmployeeVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
/// <summary> /// checks duplicate FactoryCode /// </summary> /// <param name="EmployeeVo"></param> /// <returns></returns> private EmployeeVo DuplicateCheck(EmployeeVo EmployeeVo) { EmployeeVo outVo = new EmployeeVo(); try { outVo = (EmployeeVo)base.InvokeCbm(new CheckEmployeeMasterMntCbm(), EmployeeVo, false); } catch (Framework.ApplicationException exception) { popUpMessage.ApplicationError(exception.GetMessageData(), Text); logger.Error(exception.GetMessageData()); } return(outVo); }
/// <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 = EmployeeDetails_dgv.SelectedCells[0].RowIndex; DataGridViewRow selectedRow = EmployeeDetails_dgv.Rows[selectedrowindex]; messageData = new MessageData("mmcc00004", Properties.Resources.mmcc00004, selectedRow.Cells["colEmployeeName"].Value.ToString()); DialogResult dialogResult = popUpMessage.ConfirmationOkCancel(messageData, Text); if (dialogResult == DialogResult.OK) { EmployeeVo inVo = new EmployeeVo { EmployeeCode = selectedRow.Cells["colEmployeeCode"].Value.ToString() }; try { EmployeeVo outVo = (EmployeeVo)base.InvokeCbm(new DeleteEmployeeMasterMntCbm(), 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> /// Creates seacrh condition as per user inputs /// </summary> /// <returns>search condition</returns> private EmployeeVo FormConditionVo() { EmployeeVo inVo = new EmployeeVo(); if (EmployeeCode_txt.Text != string.Empty) { inVo.EmployeeCode = EmployeeCode_txt.Text; } if (EmployeeName_txt.Text != string.Empty) { inVo.EmployeeName = EmployeeName_txt.Text; } return(inVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { EmployeeVo inVo = (EmployeeVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Select Count(*) as EmpCount from m_employee "); sqlQuery.Append(" where 1 = 1 "); if (inVo.EmployeeCode != null) { sqlQuery.Append(" and UPPER(employee_cd) = UPPER(:empcd)"); } //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); if (inVo.EmployeeCode != null) { sqlParameter.AddParameterString("empcd", inVo.EmployeeCode); } //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); EmployeeVo outVo = new EmployeeVo(); while (dataReader.Read()) { outVo.AffectedCount = Convert.ToInt32(dataReader["EmpCount"]); } dataReader.Close(); return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { EmployeeVo inVo = (EmployeeVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Delete From m_employee"); sqlQuery.Append(" Where "); sqlQuery.Append(" employee_cd = :empcd;"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("empcd", inVo.EmployeeCode); EmployeeVo outVo = new EmployeeVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; 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) { EmployeeVo inVo = new EmployeeVo(); if (CheckMandatory()) { var sch = StringCheckHelper.GetInstance(); if (!sch.IsASCII(EmployeeCode_txt.Text) || !sch.IsASCII(EmployeeName_txt.Text)) { messageData = new MessageData("mmce00003", Properties.Resources.mmce00003); logger.Info(messageData); popUpMessage.ConfirmationOkCancel(messageData, Text); if (!sch.IsASCII(EmployeeCode_txt.Text)) { EmployeeCode_txt.Focus(); } else { EmployeeName_txt.Focus(); } return; } inVo.EmployeeCode = EmployeeCode_txt.Text.Trim(); inVo.EmployeeName = EmployeeName_txt.Text.Trim(); //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)) { EmployeeVo checkVo = DuplicateCheck(inVo); if (checkVo != null && checkVo.AffectedCount > 0) { messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, EmployeeCode_lbl.Text + " : " + EmployeeCode_txt.Text); logger.Info(messageData); popUpMessage.ApplicationError(messageData, Text); return; } } try { if (string.Equals(mode, CommonConstants.MODE_ADD)) { EmployeeVo outVo = (EmployeeVo)base.InvokeCbm(new AddEmployeeMasterMntCbm(), inVo, false); IntSuccess = outVo.AffectedCount; } else if (string.Equals(mode, CommonConstants.MODE_UPDATE)) { inVo.EmployeeCode = updateData.EmployeeCode; EmployeeVo outVo = (EmployeeVo)base.InvokeCbm(new UpdateEmployeeMasterMntCbm(), 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(); } } }