JamesHelper 1.0.1

JamesHelper nuget package guide line

following helper classes are available in James Helper nuget package.

1. DB Command Added parameter for calling an any store procedures.

2. SQL Parameter

• AddSQLParameter: Added parameter for calling an any store procedures.
• CreateCommandAndParameters: We can create a command and adding a parameter to any store procedure for execute that store procedure.

3. Dictionary

• Insert: In that we have added key in the dictionary, it will be used for Insert method and in that we have covered all possible cases, like (already exists, null key, dictionary null etc.), if success then inserts the data in dictionary otherwise not insert data. Returns the true value if successfully insert data in dictionary. Returns the false value if not insert data in dictionary.
• Update: In that we have updated the value in the dictionary then we have used this method and also we have checked the given key exists then the data is updated otherwise not updated any data. Returns the true value if successfully updated data in dictionary. Returns the false value if not updated data in dictionary.
• AddOrUpdate: In that we check whether the given data is already exists then update the dictionary data otherwise it will add new data in the dictionary for that data. Returns the true value if successfully inserted/updated data in the dictionary. Returns the false value if not inserted/updated data in dictionary.
• Contains: In that we have check the given key exists or not in the dictionary.
• GetOrDefault: In that if we get any data in that dictionary then used this method and if the given key data is not exists then it will return default value.
• Delete: In that if we have any data, it is deleting in the dictionary.
• IsNull: check the reference is null or not.

4. String

• IsDefault: return the default value.
• RemoveAllSpecialCharacter: given string remove all special characters. Store only data like (A-Za-z0-9) and it will return as a lower case data and remove all leading and trailing spaces to providing any data.
• SanitizeString: given string value and another parameter for special character for remove the providing special character from the given value.
• StringToBoolean: it will return the string value to the boolean value.
• Truncate: it will return the string as a truncate, if one default parameter suffix is not passed any value then default added at last three dots.
• JFormat: it will work to format the string same like we have used in string.format.

Note: for point #1 and #2 refer this documentation “https://www.c-sharpcorner.com/blogs/execute-store-procedure-in-entity-framework”