public List<DelegationValueEntity> FindDelegationValueEntity(DelegationSearchCriteria objDelegationSearchCriteria) { int showActive = objDelegationSearchCriteria.IsShowActive ?1:0; List<DelegationValueEntity> lstDelegationValueEntity = new List<DelegationValueEntity>(); DataTable dt = new DataTable(); DbHelper helper = new DbHelper(); DbCommand command = helper.BuildDbCommand("P_SS_DelegationValue_SEARCH"); helper.AssignParameterValues( command, objDelegationSearchCriteria.DelegationFunctionId, objDelegationSearchCriteria.AdminNotes, showActive ); Helper.Fill(dt, command); foreach (DataRow dr in dt.Rows) { DelegationValueEntity objDelegationValueEntity = new DelegationValueEntity(); objDelegationValueEntity.DelegationValueId = Convert.ToInt32(dr["DelegationValueID"].ToString()); objDelegationValueEntity.DelegationFunctionId = Convert.ToInt32(dr["DelegationFunctionID"].ToString()); objDelegationValueEntity.DelegationFunctionName = dr["DelegationName"].ToString(); objDelegationValueEntity.Branch = dr["Branch"].ToString(); objDelegationValueEntity.Unit = dr["Unit"].ToString(); objDelegationValueEntity.Subunit = dr["Subunit"].ToString(); objDelegationValueEntity.Grade = dr["Grade"].ToString(); objDelegationValueEntity.Act = dr["Act"].ToString(); objDelegationValueEntity.DelegationValue = dr["DelegationValue"].ToString(); objDelegationValueEntity.OperationalCondition = dr["OperationalConditions"].ToString(); objDelegationValueEntity.PolicyValue = dr["PolicyValue"].ToString(); objDelegationValueEntity.DelegationReference = dr["DelegationReference"].ToString(); objDelegationValueEntity.StartDate = Convert.ToDateTime(dr["EffectiveStartDate"].ToString()); objDelegationValueEntity.EndDate = Convert.ToDateTime(dr["EffectiveEndDate"].ToString()); lstDelegationValueEntity.Add(objDelegationValueEntity); } return lstDelegationValueEntity; }
public void UpdateDelegationValue(DelegationValueEntity objDelegationValueEntity) { _delegationServiceDA.UpdateDelegationValue(objDelegationValueEntity); }
public void InsertDelegationValue(DelegationValueEntity objDelegationValueEntity) { _delegationServiceDA.InsertDelegationValue(objDelegationValueEntity); }
public List<DelegationValueEntity> GetAllDelegationValueEntity() { List<DelegationValueEntity> lstDelegationValueEntity = new List<DelegationValueEntity>(); DataTable dtDelegationValueEntity = new DataTable(); DbHelper helper = new DbHelper(); DbCommand command = helper.BuildDbCommand("P_SS_DelegationValue_S"); helper.AssignParameterValues(command); Helper.Fill(dtDelegationValueEntity, command); foreach (DataRow dr in dtDelegationValueEntity.Rows) { DelegationValueEntity objDelegationValueEntity = new DelegationValueEntity(); objDelegationValueEntity.DelegationValueId = Convert.ToInt32(dr["DelegationValueID"].ToString()); objDelegationValueEntity.DelegationFunctionId = Convert.ToInt32(dr["DelegationFunctionID"].ToString()); objDelegationValueEntity.DelegationFunctionName = dr["DelegationName"].ToString(); objDelegationValueEntity.Branch = dr["Branch"].ToString(); objDelegationValueEntity.Unit = dr["Unit"].ToString(); objDelegationValueEntity.Subunit = dr["Subunit"].ToString(); objDelegationValueEntity.Grade = dr["Grade"].ToString(); objDelegationValueEntity.Act = dr["Act"].ToString(); objDelegationValueEntity.DelegationValue = dr["DelegationValue"].ToString(); objDelegationValueEntity.PolicyValue = dr["PolicyValue"].ToString(); objDelegationValueEntity.DelegationReference = dr["DelegationReference"].ToString(); objDelegationValueEntity.StartDate = Convert.ToDateTime(dr["EffectiveStartDate"].ToString()); objDelegationValueEntity.EndDate = Convert.ToDateTime(dr["EffectiveEndDate"].ToString()); lstDelegationValueEntity.Add(objDelegationValueEntity); } return lstDelegationValueEntity; }
public void UpdateDelegationValue(DelegationValueEntity objDelegationValueEntity) { DbHelper helper = new DbHelper(); DbCommand command = helper.BuildDbCommand("P_SS_DelegationValue_U"); helper.AssignParameterValues( command, objDelegationValueEntity.DelegationValueId, objDelegationValueEntity.DelegationFunctionId, objDelegationValueEntity.Branch, objDelegationValueEntity.Unit, objDelegationValueEntity.Subunit, objDelegationValueEntity.Grade, objDelegationValueEntity.Act, objDelegationValueEntity.DelegationValue, objDelegationValueEntity.PolicyValue, objDelegationValueEntity.OperationalCondition, objDelegationValueEntity.DelegationReference, objDelegationValueEntity.StartDate, objDelegationValueEntity.EndDate, objDelegationValueEntity.VersionNo, NCS.IConnect.ApplicationContexts.ApplicationContextFactory.GetApplicationContext().TransactionId, AppContext.Current.UserName ); Helper.ExecuteNonQuery(command); }
public DelegationValueEntity SearchDelegationValueByID(int DelegationValueID) { DelegationValueEntity objDelegationValueEntity = new DelegationValueEntity(); DataTable dt = new DataTable(); DbHelper helper = new DbHelper(); DbCommand command = helper.BuildDbCommand("P_SS_DelegationValue_S_ByDelegationValueID"); helper.AssignParameterValues( command, DelegationValueID ); Helper.Fill(dt, command); foreach (DataRow dr in dt.Rows) { objDelegationValueEntity.DelegationValueId = Convert.ToInt32(dr["DelegationValueID"].ToString()); objDelegationValueEntity.DelegationFunctionId = Convert.ToInt32(dr["DelegationFunctionID"].ToString()); objDelegationValueEntity.DelegationFunctionName = dr["DelegationName"].ToString(); objDelegationValueEntity.Branch = dr["Branch"].ToString(); objDelegationValueEntity.Unit = dr["Unit"].ToString(); objDelegationValueEntity.Subunit = dr["Subunit"].ToString(); objDelegationValueEntity.Grade = dr["Grade"].ToString(); objDelegationValueEntity.Act = dr["Act"].ToString(); objDelegationValueEntity.DelegationValue = dr["DelegationValue"].ToString(); objDelegationValueEntity.PolicyValue = dr["PolicyValue"].ToString(); objDelegationValueEntity.DelegationReference = dr["DelegationReference"].ToString(); objDelegationValueEntity.OperationalCondition = dr["OperationalConditions"].ToString(); objDelegationValueEntity.StartDate = Convert.ToDateTime(dr["EffectiveStartDate"].ToString()); objDelegationValueEntity.EndDate = Convert.ToDateTime(dr["EffectiveEndDate"].ToString()); objDelegationValueEntity.VersionNo = Convert.ToInt32(dr["VersionNo"].ToString()); } return objDelegationValueEntity; }
private void btnSave_Click(object sender, EventArgs e) { try { this.Cursor = Cursors.WaitCursor; if (ValidateRequiredFields()) { //UPDATE DelegationValueEntity objDelValueEntity = new DelegationValueEntity(); objDelValueEntity.DelegationFunctionId = Convert.ToInt32(ddlDelegationFunction.Value); objDelValueEntity.DelegationValue = txtValue.Text.Trim() == string.Empty ? null : txtValue.Text.Trim(); objDelValueEntity.PolicyValue = txtPolicyValue.Text.Trim() == string.Empty ? null : txtPolicyValue.Text.Trim(); objDelValueEntity.OperationalCondition = txtOperationConditions.Text; objDelValueEntity.DelegationReference = txtReferenceNo.Text; objDelValueEntity.Act = ultraComboAct.Value.ToString(); objDelValueEntity.Branch = ultraComboBranch.Value.ToString(); objDelValueEntity.Unit = ultraComboUnit.Value == null || ultraComboUnit.Value.ToString() == cbdDefaultValue || ultraComboUnit.Value.ToString() == string.Empty ? null : ultraComboUnit.Value.ToString(); objDelValueEntity.Subunit = ultraComboSubUnit.Value == null || ultraComboSubUnit.Value.ToString() == cbdDefaultValue || ultraComboSubUnit.Value.ToString() == string.Empty ? null : ultraComboSubUnit.Value.ToString(); objDelValueEntity.Grade = ultraComboGrade.Value.ToString(); objDelValueEntity.StartDate = ultraDateTimeEditorStartDate.DateTime; objDelValueEntity.EndDate = ultraDateTimeEditorEndDate.DateTime; objDelValueEntity.VersionNo = _versionNo; var existingDelegations = _presenter.FindDelegationDetailEntity(); bool hasExistingDelegationSettings = false; foreach (var delegationValueEntity in existingDelegations) { if (delegationValueEntity.DelegationFunctionId == Convert.ToInt32(ddlDelegationFunction.Value)) { if (delegationValueEntity.Branch.Equals(ultraComboBranch.Text)) { if (delegationValueEntity.Unit.Equals((ultraComboUnit.Value == null || ultraComboUnit.Value.ToString() == cbdDefaultValue)?string.Empty:ultraComboUnit.Text)) { if (delegationValueEntity.Subunit.Equals((ultraComboSubUnit.Value == null || ultraComboSubUnit.Value.ToString() == cbdDefaultValue) ? string.Empty : ultraComboSubUnit.Text)) { if (delegationValueEntity.Grade.Equals(ultraComboGrade.Text)) { if(delegationValueEntity.Act.Equals(ultraComboAct.Text)) { if (Convert.ToInt32(string.IsNullOrEmpty(lblDelegationValueID.Text)?"0":lblDelegationValueID.Text) != delegationValueEntity.DelegationValueId) { hasExistingDelegationSettings = true; break; } } } } } } } } if(hasExistingDelegationSettings) { MessageBox.Show("There was already one existing record with the same delegation setting.","Message"); return; } if (_presenter.parameter.EventFunction == HiiP.Infrastructure.Interface.Constants.EventTopicNames.EventFunctions.UpdateDelegation) { objDelValueEntity.DelegationValueId = Convert.ToInt32(lblDelegationValueID.Text); //objDelValueEntity.DelegationFunctionId = Convert.ToInt32(ddlDelegationFunction.Value); //objDelValueEntity.DelegationValue = txtValue.Text.Trim() == string.Empty ? null : txtValue.Text.Trim(); //objDelValueEntity.PolicyValue = txtPolicyValue.Text.Trim() == string.Empty ? null : txtPolicyValue.Text.Trim(); //objDelValueEntity.OperationalCondition = txtOperationConditions.Text; //objDelValueEntity.DelegationReference = txtReferenceNo.Text; //objDelValueEntity.Act = ultraComboAct.Value.ToString(); //objDelValueEntity.Branch = ultraComboBranch.Value.ToString(); //objDelValueEntity.Unit = ultraComboUnit.Value == null || ultraComboUnit.Value.ToString() == cbdDefaultValue || ultraComboUnit.Value.ToString() == string.Empty ? null : ultraComboUnit.Value.ToString(); //objDelValueEntity.Subunit = ultraComboSubUnit.Value == null || ultraComboSubUnit.Value.ToString() == cbdDefaultValue || ultraComboSubUnit.Value.ToString() == string.Empty ? null : ultraComboSubUnit.Value.ToString(); //objDelValueEntity.Grade = ultraComboGrade.Value.ToString(); //objDelValueEntity.StartDate = ultraDateTimeEditorStartDate.DateTime; //objDelValueEntity.EndDate = ultraDateTimeEditorEndDate.DateTime; //objDelValueEntity.VersionNo = _versionNo; _presenter.UpdateDelegationValue(objDelValueEntity); } else {//INSERT // DelegationValueEntity objDelValueEntity = new DelegationValueEntity(); //objDelValueEntity.DelegationFunctionId = Convert.ToInt32(ddlDelegationFunction.Value); //objDelValueEntity.DelegationValue = txtValue.Text.Trim() == string.Empty ? null : txtValue.Text.Trim(); //objDelValueEntity.PolicyValue = txtPolicyValue.Text.Trim() == string.Empty ? null : txtPolicyValue.Text.Trim(); //objDelValueEntity.OperationalCondition = txtOperationConditions.Text; //objDelValueEntity.DelegationReference = txtReferenceNo.Text; //objDelValueEntity.Act = ultraComboAct.Value.ToString(); //objDelValueEntity.Branch = ultraComboBranch.Value.ToString(); //objDelValueEntity.Unit = ultraComboUnit.Value == null || ultraComboUnit.Value.ToString() == cbdDefaultValue || ultraComboUnit.Value.ToString() == string.Empty ? null : ultraComboUnit.Value.ToString(); //objDelValueEntity.Subunit = ultraComboSubUnit.Value == null || ultraComboSubUnit.Value.ToString() == cbdDefaultValue || ultraComboSubUnit.Value.ToString() == string.Empty ? null : ultraComboSubUnit.Value.ToString(); //objDelValueEntity.Grade = ultraComboGrade.Value.ToString(); //objDelValueEntity.StartDate = ultraDateTimeEditorStartDate.DateTime; //objDelValueEntity.EndDate = ultraDateTimeEditorEndDate.DateTime; //objDelValueEntity.VersionNo = _versionNo; _presenter.InsertDelegationValue(objDelValueEntity); } this.SetDirtyStatus(false); _presenter.OnCloseView(); } } catch (Exception ex) { if (ExceptionManager.Handle(ex)) throw; } finally { this.Cursor = Cursors.Default; } }