Can you please give me a small sample of load response error status code and can you please give me small sample of how to refactor the repeated if else blocks. A sample or even a link helps please - thank you very much for your suggestion buddy. Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."

Hi, I have code as below, which loads a partial view in which I have a Grid, but for some reason when one of the load doesn't happen because some failure or missing View etc, the previous partial view remaining unchanged, can somebody please help me how can I clear the previous page load when loading the current Page. Any help a code snippet, a link or a suggestion anything helps thanks a lot in advance my friends.

function GetLookupTableValue(e)
{        
    if ($("#drpLookup").data("kendoDropDownList").text() != 'Select')
        myHeader.innerText = "List of " + $("#drpLookup").data("kendoDropDownList").text();
    else
        myHeader.innerText = "";

    var noCodeFilter = containsAny($("#drpLookup").data("kendoDropDownList").text(), \['Address Type', 'Gender', 'NPI Status', 'Rendering Provider Status', 'Rendering Provider Classification'\]);       
    
    if (noCodeFilter)
    {
        var url = '../Admin/GetLookupTableNoCode';
        $("#divLookupTable").load(url, { LookupTableId: $("#drpLookup").data("kendoDropDownList").value(), \_\_RequestVerificationToken: $('input\[name=\_\_RequestVerificationToken\]').val() });
    }
    else if ($("#drpLookup").data("kendoDropDownList").text() == 'Medi-Cal - Mode of Service - Service Function')
    {
        var url = '../Admin/GetMCMSSFCrosswalkList';
        $("#divLookupTable").load(url, { LookupTableId: $("#drpLookup").data("kendoDropDownList").value(), \_\_RequestVerificationToken: $('input\[name=\_\_RequestVerificationToken\]').val() });
    }
    else if ($("#drpLookup").data("kendoDropDownList").text() == 'Service Function Category')
    {
        var url = '../Admin/GetServiceFunctionCategoryLKPList';
        $("#divLookupTable").load(url, { LookupTableId: $("#drpLookup").data("kendoDropDownList").value(), \_\_RequestVerificationToken: $('input\[name=\_\_RequestVerificationToken\]').val() });
    }
    else
    {
        var url = '../Admin/GetLookupTableCode';
        $("#divLookupTable").load(url, { LookupTableId: $("#drpLookup").data("kendoDropDownList").value(), \_\_RequestVerificationToken: $('input\[name=\_\_RequestVerificationToken\]').val() });
    }
}

Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."

Hi, I am getting the following error in my Production Server, the application is working fine in Dev environment, so if I have to keep Logging etc and deploy the application, and Web Service, it takes a bit of time like Code Review etc, is there any way to find out where is the Exception happening etc? Without another deployment? Thanks in advance. Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."

Hi, I am trying to use Elmah for my ASP.Net MVC application, in which I was somewhat successful, I could able to see errors like if I try to access url without action method like 404 etc. But I have questions how Elmah works like 1. If I have multiple layers like one Web Service and another one is UI layer, then is it better to include Elmah in both projects separately or just adding it on one Project UI is fine? 2. Elmah to Work do I need to log the Errors into Elmah Database explicitly or is the Elmah going to catch the exceptions and write it in the Elmah Database, I have included the Connection string and details in the Web Config of both the Service and UI and included the DLLs as well in both the applications. Is it enough or do I need to write the Exceptions into the Elmah Db 3. If I have multiple layers of application, one in that is UI layer and another one is Web Service Layer, then how would I know if any error happened in Data access layer within Web Serice or Business layer within Web Service, do I need to log it into Database of Elmah or how can I do that? 4. Which is better way to log errors using Elmah, file or Database, I am using Database, it it ok? 5. My most important Concern is how to secure my application? When I have Elma, it shows that we can directly access the errors, I want to make sure only the Developers should be able to access the Errors or Exceptions information, not even Admin users of the Application, can you please give me some suggestions. I have these questions, can anybody please help me with these, thanks in advance. Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."

Yes I did it thanks a lot Rich Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."

Hi all friends, I have a textbox like below, I want call jquery function on its onblur or onkeyup or onfocus etc. @Html.Kendo().TextBoxFor(model => model.Code).HtmlAttributes(new { autocomplete = "off", id = "idTxtForCodeLookupCode" }) when I set it as $("#idTxtForCodeLookupCode").on('input', function () { debugger; SetLookupTableValue(); }); function SetLookupTableValue() { $("#txtLookupTableId").val($("#drpLookup").data("kendoDropDownList").value()); $("#txtLookupTableId").val(); } The SetLookupTableValue() function is not being called. I don't know the reason, maybe because TextBox is in Popup and the functions are in the main page. But I want to try it it works it I can set this onblur event or keyup or even onfocus events using HtmlAttributes, it might work. Can anybody please help me how to set those events using HtmlAttributes property. Any help would be very helpful, thanks in advance. Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."

I am not sure but its calling the SP in the following way:

    public virtual int Usp\_Add\_LookupRecord(Nullable lookupTableId, string type, string description, Nullable foreignKeyId, string createdBy, string modifiedBy, Nullable isValid)
    {
        var lookupTableIdParameter = lookupTableId.HasValue ?
            new ObjectParameter("LookupTableId", lookupTableId) :
            new ObjectParameter("LookupTableId", typeof(int));

        var typeParameter = type != null ?
            new ObjectParameter("Type", type) :
            new ObjectParameter("Type", typeof(string));

        var descriptionParameter = description != null ?
            new ObjectParameter("Description", description) :
            new ObjectParameter("Description", typeof(string));

        var foreignKeyIdParameter = foreignKeyId.HasValue ?
            new ObjectParameter("ForeignKeyId", foreignKeyId) :
            new ObjectParameter("ForeignKeyId", typeof(int));

        var createdByParameter = createdBy != null ?
            new ObjectParameter("CreatedBy", createdBy) :
            new ObjectParameter("CreatedBy", typeof(string));

        var modifiedByParameter = modifiedBy != null ?
            new ObjectParameter("ModifiedBy", modifiedBy) :
            new ObjectParameter("ModifiedBy", typeof(string));

        var isValidParameter = isValid.HasValue ?
            new ObjectParameter("IsValid", isValid) :
            new ObjectParameter("IsValid", typeof(bool));

        return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("Usp\_Add\_LookupRecord", lookupTableIdParameter, typeParameter, descriptionParameter, foreignKeyIdParameter, createdByParameter, modifiedByParameter, isValidParameter);
    }

And when I changed the stored procedure to return -3 is record exists, it is returning me -1, here is my SP:

ALTER PROCEDURE [dbo].[Usp_Add_LookupRecord] (@LookupTableId int,
@Type varchar(100), @Description varchar(500), @ForeignKeyId int, @CreatedBy varchar(500), @ModifiedBy varchar(500), @IsValid bit
)
AS
BEGIN
declare @LookupTableName varchar(100)=(select top 1 LookupTableName FROM [dbo].[ListOfLookupTables] WHERE PkListOfLookupTablesId=@LookupTableId)
declare @InsertedId int=0, @FKProgramTypeLKPId int = (select top 1 PKProgramTypeLKPId from ProgramTypeLKP where Type='Mental Health')

IF (@Lookup

Yes I can understand that, but there are 25 tables with same Columns Code and Description, one table is selected with Dropdown to add, update or delete, so I have written just one stored procedure instead of writing multiple ones. That's why I used LookupTableId, Because I have listed all those tables into one LookupTable and the LookupTableId comes from that table. I think it better suited for this scenario, but yes in general its not a good practice. About Program Type, its always the same Program Type that's why I just took the id and used it. Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."

Yes I mean in the JavaScript function but I am not sure if something else is happening between the RequestEnd javascript function call and opening the Popup. I want to write a text changed event for the Kendo Textbox, idTxtForCodeLookupCode, can you please help me how to write it using jquery, maybe if I assign value to the HiddenField: txtLookupTableId, it would be good. Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."

I tried it as below but still in the duplicate situation also it was returning me value 1, I didn't really get it why?

ALTER PROCEDURE [dbo].[Usp_Add_LookupRecord] (@LookupTableId int,
@Type varchar(100), @Description varchar(500), @ForeignKeyId int, @CreatedBy varchar(500), @ModifiedBy varchar(500), @IsValid bit
)
AS
BEGIN
declare @LookupTableName varchar(100)=(select top 1 LookupTableName FROM [dbo].[ListOfLookupTables] WHERE PkListOfLookupTablesId=@LookupTableId)
declare @InsertedId int=0, @FKProgramTypeLKPId int = (select top 1 PKProgramTypeLKPId from ProgramTypeLKP where Type='Mental Health')

IF (@LookupTableName='ProgramTypeLKP')
BEGIN
	IF NOT EXISTS(SELECT Top 1 1 FROM dbo.ProgramTypeLKP WHERE \[Type\]=@Type AND ISNULL(IsValid, 1)=1)
	BEGIN
		INSERT INTO dbo.ProgramTypeLKP (\[Type\], \[Description\], CreatedDate, CreatedBy, ModifiedDate, ModifiedBy, IsValid)
		VALUES(LEFT(@Type, 15), LEFT(@Description, 500), GETDATE(), LEFT(@CreatedBy, 500), GETDATE(), LEFT(@ModifiedBy, 500), @IsValid)
		SET @InsertedId=SCOPE\_IDENTITY()
	END
	ELSE
	BEGIN
		RETURN 0
	END
END
ELSE IF (@LookupTableName='AddressTypeLKP')
BEGIN
	IF NOT EXISTS(SELECT Top 1 1 FROM dbo.AddressTypeLKP WHERE \[Description\]=@Type AND ISNULL(IsValid, 1)=1)
	BEGIN
		INSERT INTO dbo.AddressTypeLKP (\[Description\], FKProgramTypeLKPId, CreatedDate, CreatedBy, ModifiedDate, ModifiedBy, IsValid)
		VALUES(LEFT(@Description, 20), @FKProgramTypeLKPId, GETDATE(), LEFT(@CreatedBy, 30), GETDATE(), LEFT(@ModifiedBy, 30), @IsValid)
		SET @InsertedId=SCOPE\_IDENTITY()
	END
	ELSE
	BEGIN
		RETURN 0
	END
END

RETURN @InsertedId

END

Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."

Hi all, I have a stored procedure below:

ALTER PROCEDURE [dbo].[Usp_Add_ProgramType] (@Type varchar(15), @Description varchar(15), @IsValid bit
, @CreatedBy varchar(500), @ModifiedBy varchar(500))
AS
BEGIN
if not exists(select top 1 1 from [dbo].[ProgramTypeLKP] where [Type]=@Type)
begin
INSERT INTO [dbo].[ProgramTypeLKP] ([Type], [Description], IsValid, CreatedDate, CreatedBy, ModifiedDate, ModifiedBy)
values(@Type, @Description, @IsValid, getdate(), @CreatedBy, GETDATE(), @ModifiedBy)
end
--else
--begin
----Want to return some thing here that makes EF funnction to return 0 or -1 or some value so that I can show user a message that its a duplicate record.
--end
END

Even if the Condition fails the EF method is returning value as 1, but I want to get a value on which I will show the end user a message that he is trying to attempt to insert a duplicate record. Like in the below script, I am checking for the result or errors, I have to get error in the response, or at least in the result some where so that I can show the user a message, I am using Kendo Grid, Create and Update with Popup (just a foot-note):

function onRequestEnd(e)
{
//Check request type
if (e.type == "create")
{
if ((e.response != null) && ((e.response.Errors != null) || (e.response.data["0"].Result <= 1)))
{
//Set some label value in red only when to say attempt to insert duplicate record
}
}
else if (e.type == "update")
{
if ((e.response != null) && ((e.response.Errors != null) || (e.response.data["0"].Result <= 1)))
{
//Set some label value in red only when to say attempt to insert duplicate record
}
}
}

Can anybody please help me in this regards, thanks in advance. Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."

Hi all, I have overridden GetValidators method of CustomModelValidatorProvider in class CustomModelValidatorProvider, when a Post is happening, this Validator is getting all the values that I have input on the screen but I have Hidden field that I want to pass into this method is not coming in.

public class CustomModelValidatorProvider : System.Web.Mvc.DataAnnotationsModelValidatorProvider
{
    protected override IEnumerable GetValidators(System.Web.Mvc.ModelMetadata metadata, ControllerContext context, IEnumerable attributes)
    {
        var z = metadata.PropertyName;
        if ((metadata.PropertyName == "Code") 
            && (metadata.ContainerType.FullName == "DHCS.BH.Provider.Models.LookupTable"))
        {
            LookupTable model = metadata.Container as LookupTable;

            var newAttributes = new List(attributes);
            var stringLength = newAttributes.OfType().FirstOrDefault();
            if (stringLength != null)
            {
                newAttributes.Remove(stringLength);

                if (model.CodeLength != 0)
                {
                    newAttributes.Add(new StringLengthAttribute(model.CodeLength)
                    {
                        MinimumLength = model.CodeLength,
                        ErrorMessage = @"The field {{0}} length must be at least {model.CodeLength}."
                    });
                }

                attributes = newAttributes;
            }
        }
        return base.GetValidators(metadata, context, attributes);
    }

    public string GetPropertyName(Expression\> propertyLambda)
    {
        var me = propertyLambda.Body as MemberExpression;

        if (me == null)
        {
            throw new ArgumentException("You must pass a lambda of the form: '() => Class.Property' or '() => object.Property'");
        }

        return me.Member.Name;
    }
}

My cshtml file is as below, it is a Popup that's being generated for Create and Edit buttons of Kendo Grid.

@model DHCS.BH.Provider.Models.LookupTable

@{
ViewBag.Title = "EditLookup";
}

@using (Html.BeginForm())
{
@Html.AntiForgeryToken()

    @\*

        @Html.Kendo().TextBoxFor

No I have not done this: unobtrusive validation, can you please let me know how to do it only on one particular class and property that I want. Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."

But still the attributes value in IEnumerable attributes coming as null when I already have one Attribute on that class and when I try to expan the attributes collection object, it shows me "Enumeration yielded no results" in the end.

public class LookupTable
{
    public int Id { get; set; }

    \[Required(ErrorMessage = "Code is required.")\]        
    public string Code { get; set; }

    \[Required(ErrorMessage = "Description is required.")\]
    public string Description { get; set; }
    public int? ForeignKeyId { get; set; }
    public string ForeignKeyValue { get; set; }
    public DateTime? CreatedDate {get;set;} 
    public string CreatedBy {get;set;}       
    public int CodeLength { get; set; }
}

Do I need to add anymore Attributes to the Code Property?, what am I missing here my friend? Even after I changed my function to have Container instead of Model, still I get null at metadata.PropertyName Always metadata.PropertyName is coming as null irrespective of any changes I do at if (metadata.PropertyName == GetPropertyName(() => model.Code) && (model.CodeLength > 0)) in the below function and attributes is also coming as null.

    protected override IEnumerable GetValidators(System.Web.Mvc.ModelMetadata metadata, ControllerContext context, IEnumerable attributes)
    { 
        if (metadata.Model is LookupTable)
        {
            LookupTable model = metadata.Container as LookupTable;                

            if (metadata.PropertyName == GetPropertyName(() => model.Code) && (model.CodeLength > 0))
            {
                var newAttributes = new List(attributes);
                var stringLength = newAttributes.OfType().FirstOrDefault();
                if (stringLength != null)
                {
                    newAttributes.Remove(stringLength);

                    if (model.CodeLength != 0)
                    {
                        newAttributes.Add(new StringLengthAttribute(model.CodeLength)
                        {
                            MinimumLength = model.CodeLength,
                            ErrorMessage = @"The field {{0}} length must be at least {model.CodeLength}."
                        });
                    }

                    attributes = newAttributes;

ModelValidatorProviders.Providers.Clear(); ModelValidatorProviders.Providers.Add( new CustomValidatorProvider() ); I did this registration in the Global.asax.cs file, in the Application_Start() event. And even if I changed the Condition to:

if (metadata.PropertyName == GetPropertyName(() => model.Code) && (model.CodeLength > 0))

Still I am getting the metadata.PropertyName null always, can you please suggest me what am I missing? Just asking am I using any wrong namespace in references?, Because it was saying there is an ambiguous class names and those classes present in both the following namespaces using System.Web.ModelBinding; using System.Web.Mvc; Am I using any wrong namespace or something like that kind of error, I am not understanding why is it giving metadata.PropertyName as null in all the cases? Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."

Hi Richard, One last thing, I have created the method in the following way:

public class CustomModelValidatorProvider : System.Web.Mvc.DataAnnotationsModelValidatorProvider
{
    protected override IEnumerable GetValidators(System.Web.Mvc.ModelMetadata metadata, ControllerContext context, IEnumerable attributes)
    { 
        if (metadata.Model is LookupTable)
        {
            LookupTable model = metadata.Model as LookupTable;

            if (metadata.PropertyName == GetPropertyName(() => model.CodeLength) && (model.CodeLength > 0))
            {
                var newAttributes = new List(attributes);
                var stringLength = newAttributes.OfType().FirstOrDefault();
                if (stringLength != null)
                {
                    newAttributes.Remove(stringLength);

                    if (model.CodeLength != 0)
                    {
                        newAttributes.Add(new StringLengthAttribute(model.CodeLength)
                        {
                            MinimumLength = model.CodeLength,
                            ErrorMessage = @"The field {{0}} length must be at least {model.CodeLength}."
                        });
                    }

                    attributes = newAttributes;
                }
            }
        }            

        return base.GetValidators(metadata, context, attributes);
    }

    public string GetPropertyName(Expression\> propertyLambda)
    {
        var me = propertyLambda.Body as MemberExpression;

        if (me == null)
        {
            throw new ArgumentException("You must pass a lambda of the form: '() => Class.Property' or '() => object.Property'");
        }

        return me.Member.Name;
    }
}

can you please let me know how can I decorate or use it on my Model class, can you please give me that example, I am asking this question because this value is coming as null: metadata.PropertyName, so I am not able to compare with property name. So any help please? thank you very very much buddy - as I said earlier have a Wonderful weekend with family and friends buddy. Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."

OK Got it, and you are saying that there is just one risk in it that it can be overridden in the derived classes, understandable, thanks a lot Richard for giving me the information. Thank you very much have a wonderful weekend buddy. Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."

Just checking, is it going to remove all the other Validations that I have put on other classes? Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."

can you please give me some example or something please? Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."

Hi all friends, I have a Model which is needed to have different validation attributes assigned to it in different Conditions, I don't have to create multiple classes for different attributes, because the same model class is being used in multiple post methods. Following is my class:

public class ServiceFunctionCategoryLKP
{
    public int Id { get; set; }

    \[Required(ErrorMessage = "Code is required.")\]
    \[StringLength(2, MinimumLength = 2, ErrorMessage = "The field {0} length must be at least 2.")\]
    public string Code { get; set; }

    \[Required(ErrorMessage = "Description is required.")\]
    public string Description { get; set; }
    
    public string ServiceFunctionCategoryCode { get; set; }

    \[Required(ErrorMessage = "ModeOfServiceCode is required.")\]
    public string ModeOfServiceCode { get; set; }
    public string ModeOfServiceDescription { get; set; }
    public int CodeLenth {get; set;}
}

StringLength attribute should be different for different calls, is there any way I can have set it differently or dynamically depending upon the input object of the action method. Means I have a field in my input object as above called CodeLength, depending upon this field I have to change the StringLength attributes MinimumLength and Error message properties dynamically, it means in every different Post call, it could be different depending upon the CodeLength field value. If I have tried in the following way, with IsValid method, problem is how would I know CodeLength field (that is coming as a property of Object in action method) within IsValid method to compare the length of the field with CodeLength field.

public override bool IsValid(object value)
{
int num = (value == null) ? 0 : ((string)value).Length;
return value == null || (num >= this.MinimumLength && num <= this.MaximumLength);
}

Any help would be greatly greatly helpful, thanks in advance friends. Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."