public PersonParamValue GetParamValue(decimal personId, string key, DateTime dateFrom, DateTime dateTo) { PersonParamValue val = ParameterValueList.Where(x => x.Person.ID.Equals(personId) && x.FromDate.Date <= dateFrom.Date && x.ToDate.Date >= dateFrom.Date && x.ParamField.Key.ToUpper().Equals(key.ToUpper())).FirstOrDefault(); return(val); }
protected override void DeleteValidate(PersonParamField obj) { UIValidationExceptions exception = new UIValidationExceptions(); PersonParamValue personParamValueAlias = null; IList <PersonParamValue> personParamValueList = NHibernateSessionManager.Instance.GetSession() .QueryOver <PersonParamValue>(() => personParamValueAlias) .Where(() => personParamValueAlias.ParamField.ID == obj.ID) .List <PersonParamValue>(); if (personParamValueList.Count > 0) { exception.Add(new ValidationException(ExceptionResourceKeys.ParamFieldKeyIsUsed, " پارامتر برای پرسنل دیگر استفاده شده است", ExceptionSrc)); } if (exception.Count > 0) { throw exception; } }
public string[] UpdateDynamicParameterPair_PersonnelDynamicExtraInformationPage(string state, string PersonnelState, string PersonnelID, string SelectedDynamicParameterID, string SelectedDynamicParameterPairID, string DynamicParameterValue, string FromDate, string ToDate) { this.InitializeCulture(); string[] retMessage = new string[4]; try { AttackDefender.CSRFDefender(this.Page); decimal DynamicParameterPairID = 0; decimal personnelID = decimal.Parse(this.StringBuilder.CreateString(PersonnelID), CultureInfo.InvariantCulture); decimal selectedDynamicParameterID = decimal.Parse(this.StringBuilder.CreateString(SelectedDynamicParameterID), CultureInfo.InvariantCulture); decimal selectedDynamicParameterPairID = decimal.Parse(this.StringBuilder.CreateString(SelectedDynamicParameterPairID), CultureInfo.InvariantCulture); DynamicParameterValue = this.StringBuilder.CreateString(DynamicParameterValue); FromDate = this.StringBuilder.CreateString(FromDate); ToDate = this.StringBuilder.CreateString(ToDate); UIActionType uam = (UIActionType)Enum.Parse(typeof(UIActionType), this.StringBuilder.CreateString(state).ToUpper()); UIActionType pls = (UIActionType)Enum.Parse(typeof(UIActionType), this.StringBuilder.CreateString(PersonnelState).ToUpper()); PersonParamValue DynamicParameterPair = new PersonParamValue(); Person person = new Person(); person.ID = personnelID; DynamicParameterPair.Person = person; DynamicParameterPair.ID = selectedDynamicParameterPairID; if (uam != UIActionType.DELETE) { PersonParamField DynamicParameter = new PersonParamField(); DynamicParameter.ID = selectedDynamicParameterID; DynamicParameterPair.ParamField = DynamicParameter; DynamicParameterPair.Value = DynamicParameterValue; DynamicParameterPair.TheFromDate = FromDate; DynamicParameterPair.TheToDate = ToDate; } switch (uam) { case UIActionType.ADD: switch (pls) { case UIActionType.ADD: DynamicParameterPairID = this.DynamicParameterPairsBusiness.InsertPersonParamValue_onPersonnelInsert(DynamicParameterPair, uam); break; case UIActionType.EDIT: DynamicParameterPairID = this.DynamicParameterPairsBusiness.InsertPersonParamValue_onPersonnelUpdate(DynamicParameterPair, uam); break; } break; case UIActionType.EDIT: if (selectedDynamicParameterID == 0) { retMessage = this.exceptionHandler.HandleException(this.Page, ExceptionTypes.UIValidationExceptions, new Exception(GetLocalResourceObject("NoDynamicParameterPairSelectedforEdit").ToString()), retMessage); return(retMessage); } switch (pls) { case UIActionType.ADD: DynamicParameterPairID = this.DynamicParameterPairsBusiness.UpdatePersonParamValue_onPersonnelInsert(DynamicParameterPair, uam); break; case UIActionType.EDIT: DynamicParameterPairID = this.DynamicParameterPairsBusiness.UpdatePersonParamValue_onPersonnelUpdate(DynamicParameterPair, uam); break; } break; case UIActionType.DELETE: if (selectedDynamicParameterID == 0) { retMessage = this.exceptionHandler.HandleException(this.Page, ExceptionTypes.UIValidationExceptions, new Exception(GetLocalResourceObject("NoDynamicParameterPairSelectedforDelete").ToString()), retMessage); return(retMessage); } switch (pls) { case UIActionType.ADD: this.DynamicParameterPairsBusiness.DeletePersonParamValue_onPersonnelInsert(DynamicParameterPair, uam); break; case UIActionType.EDIT: this.DynamicParameterPairsBusiness.DeletePersonParamValue_onPersonnelUpdate(DynamicParameterPair, uam); break; } break; } retMessage[0] = GetLocalResourceObject("RetSuccessType").ToString(); string SuccessMessageBody = string.Empty; switch (uam) { case UIActionType.ADD: SuccessMessageBody = GetLocalResourceObject("AddComplete").ToString(); break; case UIActionType.EDIT: SuccessMessageBody = GetLocalResourceObject("EditComplete").ToString(); break; case UIActionType.DELETE: SuccessMessageBody = GetLocalResourceObject("DeleteComplete").ToString(); break; default: break; } retMessage[1] = SuccessMessageBody; retMessage[2] = "success"; retMessage[3] = DynamicParameterPairID.ToString(); return(retMessage); } catch (UIValidationExceptions ex) { retMessage = this.exceptionHandler.HandleException(this.Page, ExceptionTypes.UIValidationExceptions, ex, retMessage); return(retMessage); } catch (UIBaseException ex) { retMessage = this.exceptionHandler.HandleException(this.Page, ExceptionTypes.UIBaseException, ex, retMessage); return(retMessage); } catch (Exception ex) { retMessage = this.exceptionHandler.HandleException(this.Page, ExceptionTypes.Exception, ex, retMessage); return(retMessage); } }