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;
}
}
