Data Validation not working in Edit Mode

» chash » Data Validation not working in Edit Mode

By : ketan

Date : November 22 2020, 10:33 AM

this one helps. It seems that you are following the wrong approach
let us assume we have a class called users like following

code :

public class User: IValidatableObject
{
     public int Id{get; set;}
     public string UserName{get; set;}
     public IEnumerable<ValidationResult> Validate(ValidationContext validationContext)
     {
          if(string.IsNullOrEmpty(UserName))
               yield return new ValidationResult("Username field is required!", new string[]{"UserName"});
          else 
          {
               // check if another User has the same username already
               var db= new YourDbContext();
               var exists=db.Users.FirstOrDefault(t=>t.Id!=Id && t.UserName.ToLower()=UserName.ToLower());
               if(exists!=null)
                   yield return new ValidationResult("Username is already used by another user!", new string[]{"UserName"});
          }
     }
}

Share :

Datagrid Edit mode and data validation via service

By : user3728649

Date : March 29 2020, 07:55 AM

hop of those help? (sorry for my bad english) I would recomend that you do not use the grid event to validate your data - do this on your POCO properties setter - its cleaner, easier to mantain and if you use this POCO with another control your validation will still work.
Since you need to access a service to validate the value, your best bet is to implement the interface INotifyDataErrorInfo, that allows you to make asynchronous validation, look here: http://weblogs.asp.net/fredriknormen/archive/2009/11/22/silverlight-4-and-asynchronous-validation-with-inotifydataerrorinfo.aspx and here http://www.silverlight.net/learn/data-networking/validation/asynchronous-data-validation

Jqgrid custom edit mode and validation

By : Nathanjoshua24

Date : March 29 2020, 07:55 AM

around this issue You can validate the form fields in the beforeSubmit function. In this function you can validate the fields and add the highlight class to the element you want. You can do something like this:

code :

beforeSubmit: function(postdata, formid){ 
       //more validations
       if ($('#exec').val()==""){
                $('#exec').addClass("ui-state-highlight");
                return [false,'ERROR MESSAGE']; //error
      }
      return [true,'']; // no error
 },

How to exclude a perticular field from unique validation in edit mode in cakephp3.0 validation

By : user6349560

Date : March 29 2020, 07:55 AM

like below fixes the issue I want to validate a field called survey_id which is an input from user for uniqueness. It is working properly and giving the correct response when adding the new record, but when I tried to edit this record it is giving an error [unique] => Provided value already exist. So what I want is to exclude the survey_id of the current record from uniqueness check and if user input some other value for survey_id it should check for uniqueness search. , It will work with this validation rule

code :

$validator
        ->requirePresence('survey_id', __('msg_required'))
        ->notEmpty('survey_id', __('msg_required'))
        ->maxlength('survey_id', 32, __('msg_maxlength'))
        ->alphaNumeric('survey_id', __('msg_surveyid_format'))
        ->add('survey_id', 'custom', [
            'rule' => function ($value, $context) {
              if (!empty($context['data']['projectId'])) { $values = array($context['data']['projectId']); } else { $values = array(); }
              $data = $this->getSurveyId($value, $values);
              return (!empty($data)) ? false : true;
            },
              'message' => __('msg_surveyid_exsist')]);

        return $validator;
      }

public function getSurveyId($surveyId = null, $exclude = null) {

        $where = array('p.survey_id' => $surveyId);
        if (!empty($exclude) && is_array($exclude)) {
          $where[] = array('p.id NOT IN' => $exclude);
        }
        return $this->db->newQuery()
                        ->select('*')
                        ->from(['p' => 'projects'])
                        ->where($where)
                        ->execute()
                        ->fetch('assoc');
      }

Kendo validation message in inLine Edit mode kendo grid not working through Data annotation

By : Cuong Phong

Date : March 29 2020, 07:55 AM

I wish did fix the issue. For the validations to work for the columns using Editor Templates you need to add the following in your Editor Templates
.HtmlAttributes(Html.GetUnobtrusiveValidationAttributes("Validation",

code :

    (Html.AthenaTransportDdl("GetPricingPolicyTypes", "Enterprise", HttpVerbs.Post)
        .Name("PricingPolicyType")
        .DataTextField("Label")
        .DataValueField("Id")
        .AutoBind(false)
        .Filter("contains")
        .HtmlAttributes(Html.GetUnobtrusiveValidationAttributes("Validation",     
           ViewData.ModelMetadata))  
.OptionLabel(Html.GetResource(AthenaWeb.Models.Common.XmlResourceNames.CommonXml, "PricingPolicyTypeOptionLabel"))
    )

Excel VBA data validation swap only working in debug mode

By : Mogtan Mog Tan

Date : March 29 2020, 07:55 AM

like below fixes the issue for the input here everyone. It appears that excel 2013 has had an issue with the kind of list name that goes into these combo boxes for data validation. I used the solution here:
http://blog.contextures.com/archives/2014/09/18/worksheet-combo-box-problem-in-excel-2013/