C# and Asp.net, MVC Professional Code

SQL Optimization

2023-01-27T07:57:00.004-08:00

SQL Optimization

1. Add where on your query

2. If you remove some data after the data return then remove the remove condition in the select statement where the clause

3. Most important is to Add an Index on the column where you use the where clause.

4. Remove multiple call databases from code and call once and find all data at once to reduce the number of roundtrips.

5. Remove the index on the temp table if the data is in limit.

6. Remove subquery use Join.

7. Remove the query that returns the subset of results, instead use a query that can return full results.

Kendo Cascade dropdown

2016-09-08T04:49:00.002-07:00

It is easy to make dropdownlist cascade. You just have to add ".CascadeFrom()" function and need to pass the control name in it's parameter. Please follow the below example.

EX :
Parent control is Country:-

@(Html.Kendo().DropDownListFor(m => m.Customer)

.Name("Country") .DataTextField("Text") .DataValueField("Value")

.OptionLabel("All") .MinLength(0) .HtmlAttributes(new { @class = "", id = "Country" })

.BindTo(Model.Country)

.Filter(FilterType.StartsWith)

.Value(Model.SelectedCountry??"")

)

And cascade control is State:-

@(Html.Kendo().DropDownList()

.Name("State")

.DataSource(source => source.Read(read =>

{

read.Action("GetState", "Common")

.Data("CountryFetch");

}).ServerFiltering(true);

})

.OptionLabel("All")

.HtmlAttributes(new { @class = "", id = "state" })

.Filter(FilterType.StartsWith)

.DataValueField("Value")

.DataTextField("Text")

.AutoBind(false)

.CascadeFrom("Country")

)

function CountryFetch () {

return {

Country: $("#Country").val(),

text: $('input[aria-owns="state_listbox"]').val()

};

}

</script>

Here we can see 'ServerFiltering(true)' extend function which denote filtration parameter will pass to api and data which need to pass is mention by Data('CountryFetch') function.

CountryFetch is a js model which is written below the code in script tag.

Bind Kendo Grid With Dynamic Column

2015-08-26T03:12:00.002-07:00

We are bind dynamic columns and there values as a rows to Kendo UI grid,

To do this we are using a Json file as a data and column list.

The only restriction is that column name has to be same as Data Column name.

Please Click to Download the Application

Json format like :

[["Id","Name","BranchName","RateBase","RateBaseDate"], {"CrrierId":"1","CarrierName":"AAA COOPER TRANSPORTATION","BranchName":"ALL","RateBase":"ABF50401","RateBaseDate":"06-25-2012","PricingFromDate":"01-01-2014" ,"PricingToDate":"09-02-2015","Currency":"USD","CargoTypeId":"1","OriginCode":"1111","DestinationCode":"1101"}]

Control code :

public class HomeController : Controller

{

[HttpGet]

public ActionResult CarrierSelection()

{

List<string> HeaderList = new List<string>();

List<dynamic> CustomerList = new List<dynamic>();

List<dynamic> CarrierList = new List<dynamic>();

ArrayList proList = new ArrayList();

dynamic Obj;

try

{

StreamReader sr1 = new StreamReader(Server.MapPath("~/Content/JesonDataCarrierNew.json"));

string JsonStr = sr1.ReadLine();

JToken tokenObj = JRaw.Parse(JsonStr);

if (tokenObj is JArray)

{

JArray JarrayObj = JArray.Parse(JsonStr);

if (JarrayObj.Count > 0)

{

// If column want hide then user may add column list in array

if (JarrayObj[0].Type == JTokenType.Array)

{

foreach (string objMemberInfo in JarrayObj[0])

{

proList.Add(objMemberInfo);

}

JarrayObj.RemoveAt(0);

//Grid Data Data Source

JsonStr = JarrayObj.ToString(Newtonsoft.Json.Formatting.None);

}

else if (JarrayObj[0].Type == JTokenType.Object)

{

JObject obj = (JObject)JarrayObj[0];

foreach (KeyValuePair<string, JToken> objMemberInfo in obj)

{

proList.Add(objMemberInfo.Key);

}

else if (tokenObj is JObject)

{

// Process JObject

}

CarrierList = JsonConvert.DeserializeObject<List<dynamic>>(JsonStr);

CarrierList = CarrierList.ToList();

ViewBag.ColumnNames = proList.ToArray();

ViewBag.HeaderListValues = HeaderList;

return View(CarrierList);

}

catch (Exception ex)

{

throw;

}

View Page :

@(Html.Kendo().Grid(Model)

.Name("Grid")

.Columns(col =>

{

foreach (var name in ViewBag.ColumnNames)

{

col.Bound(name).Visible(true);

}

)

.Pageable(pageable => pageable

.PageSizes(true)

.ButtonCount(5))

.Groupable()

.Sortable()

.Resizable(resize => resize.Columns(true))

.BindTo(Model)

.Reorderable(reorder => reorder.Columns(true))

.Filterable(filterable => filterable

.Extra(true)

.Operators(operators => operators

.ForString(str => str.Clear()

.StartsWith("Starts with")

.IsEqualTo("Is equal to")

.IsNotEqualTo("Is not equal to")

))

)

.DataSource(dataSource => dataSource

.Ajax().PageSize(15)

)

Remove Duplicate Records From Table

2015-05-06T02:29:00.002-07:00

WITH TempEmp (class_id,user_id,Counter)

(

SELECT class_id,user_id,ROW_NUMBER() OVER(PARTITION by class_id, user_id ORDER BY user_id)

AS Counter

FROM user_class

)

--Now Delete Duplicate Records

--select * from TempEmp where Counter > 1

DELETE FROM TempEmp

WHERE Counter > 1

Image From Web URL to Base64 String

2014-12-17T12:01:00.001-08:00

Image are Download using Web Client and byte code pass for base64 conversion.

using System;

using System.Collections.Generic;

using System.IO;

using System.Net;

using System.Web;

using System.Web.UI;

public partial class _Default : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

}

protected void convert_Click(object sender, EventArgs e)

{

byte[] raw;

raw = new WebClient().DownloadData(txturl.Text);

Context.Response.Write(CreateBase64Image(raw));

}

private string CreateBase64Image(byte[] fileBytes)

{

System.Drawing.Image streamImage;

/* Ensure we've streamed the document out correctly before we commit to the conversion */

using (MemoryStream ms = new MemoryStream(fileBytes))

{

/* Create a new image, saved as a scaled version of the original */

streamImage = (System.Drawing.Image.FromStream(ms));

}

using (MemoryStream ms = new MemoryStream())

{

/* Convert this image back to a base64 string */

streamImage.Save(ms, System.Drawing.Imaging.ImageFormat.Png);

return Convert.ToBase64String(ms.ToArray());

}

Return Like :

MySQL XML Querying

2014-07-24T07:01:00.000-07:00

DROP PROCEDURE IF EXISTS `test223`$$ CALL test223()
DELIMITER $$

CREATE DEFINER=`root`@`localhost` PROCEDURE `test223`()
BEGIN
 DECLARE xmlDoc TEXT;
 DECLARE i INT ;
 DECLARE coun INT;
 DECLARE child1 VARCHAR(400);
 DECLARE child2 VARCHAR(400);

 SET i =1;

 SET xmlDoc = '<Data><parent><child1>Example 1</child1><child2>Example 2</child2></parent><parent><child1>Example 3</child1><child2>Example 5</child2></parent><parent><child1>Example 5</child1><child2>Example 6</child2></parent></Data>';

 SET coun = ExtractValue(xmlDoc, 'count(/Data/parent/child1)');

 DROP TEMPORARY TABLE  IF EXISTS `parent`; 
 CREATE TEMPORARY TABLE parent (     child1 VARCHAR(400),   
                                                                              child2 VARCHAR(400) ); 


 WHILE i <= coun DO


     INSERT INTO parent
    SELECT ExtractValue(xmlDoc, '//parent[$i]/child1'), ExtractValue(xmlDoc,   '//parent[$i]/child2');

    SET i = i+1;

 END WHILE;

   SELECT * FROM  parent; 

END$$

DELIMITER ;

Response Table :

+---------------------+
| Child1      | Child2     |
|-----------|-----------|
|Example 1 |Example 2|
|-----------|-----------|
|Example 3 |Example 5|
|-----------|-----------|
|Example 5 |Example 6|
|-----------|-----------|

How to create, alter and Drop a Constraints in SQL SERVER

2013-12-01T22:40:00.003-08:00

To alter a constraints we need to drop that constraints first.

then recreate that constraints.

Follow this syntax, to Drop Constraints.

ALTER TABLE [dbo].[TableName] DROP CONSTRAINT [FK_Config_ConstraintsName]

Follow this syntax, to Create a new Constraints.

ALTER TABLE [dbo].[TableName] WITH CHECK ADD CONSTRAINT [FK_Config_ConstraintsName] FOREIGN KEY([Company_Mapping_ID])

REFERENCES [dbo].[Template_Company_Table] ([Template_Company_Mapping_ID])

ALTER TABLE [dbo].[TableName] CHECK CONSTRAINT [FK_Config_ConstraintsName]

How to check a constraint is exist or not ?

2013-12-01T22:28:00.001-08:00

REFERENTIAL constraints are saved in REFERENTIAL_CONSTRAINTS table.

SELECT

FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS

WHERE CONSTRAINT_NAME ='FK_EVENT_CONFIGURATION_SCREEN_MASTER'

How To Encript and Decript Web.Config CONNECTION STRING

2013-11-12T00:56:00.003-08:00

Step to Encript Connection string :

Step 1: Open CMD As Administrator

step 2: cd C:\Windows\Microsoft.NET\Framework\v4.0.30319

step 3: aspnet_regiis -pc "MyKeys" -exp

Step 4:
**** For Local Machine ******
C:\Windows\Microsoft.NET\Framework\v4.0.30319>aspnet_regiis -pa "MyKeys" "Max70-PC\Max72"

**** For Server Machine ******
C:\Windows\Microsoft.NET\Framework\v4.0.30319>aspnet_regiis -pa "MyKeys" "NT AUTHORITY\NETWORK SERVICE"

Step 5 : Add This section to your Web.Config File in "configuration" Section

<add name="MyProvider" type="System.Configuration.RsaProtectedConfigurationProvider,System.Configuration, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"

description="Uses RsaCryptoServiceProvider to encrypt and decrypt"

keyContainerName="MyKeys"

useMachineContainer="true"

</providers>

</configProtectedData>

**** -each site must have a identity in IIS. take that ID. i.e -Site "4" . ***

Step 6: C:\Windows\Microsoft.NET\Framework\v4.0.30319>aspnet_regiis -pe "connectionStrings" -site "4" -app "/" -prov "RsaProtectedConfigurationProvider"

Step to decript Connection string :
Step 1: Open CMD As Administrator

Step 2: cd C:\Windows\Microsoft.NET\Framework\v4.0.30319

Step 3: aspnet_regiis -pd "connectionStrings" -site "4" -app "/"

Ref : http://msdn.microsoft.com/en-us/library/2w117ede.aspx

Delete all the foreign key relation in your SQL Server database

2013-10-22T00:54:00.000-07:00

DECLARE @cmd nvarchar(1000)

DECLARE @fk_table_name nvarchar(1000)

DECLARE @fk_name nvarchar(1000)

DECLARE cursor_fkeys CURSOR FOR

SELECT OBJECT_NAME(fk.parent_object_id) AS fk_table_name,

fk.name as fk_name

FROM sys.foreign_keys fk JOIN

sys.tables tbl ON tbl.OBJECT_ID = fk.referenced_object_id

-- WHERE OBJECT_NAME(fk.parent_object_id) in ('table1', 'table2', 'table2')

OPEN cursor_fkeys

FETCH NEXT FROM cursor_fkeys

INTO @fk_table_name, @fk_name

WHILE @@FETCH_STATUS=0

BEGIN

-- build alter table statement

SET @cmd = 'ALTER TABLE [' + @fk_table_name + '] DROP CONSTRAINT [' + @fk_name + ']'

-- execute it

exec dbo.sp_executesql @cmd

FETCH NEXT FROM cursor_fkeys

INTO @fk_table_name, @fk_name

END

CLOSE cursor_fkeys

DEALLOCATE cursor_fkeys

How to copy directory using VB.Net

2013-08-24T04:10:00.001-07:00

Forder to folder copy :

Dim newWfFilePath As String = Web.HttpContext.Current.Server.MapPath(filepath)

Dim defaultPath As String = Web.HttpContext.Current.Server.MapPath(copyfrom)

Dim directorys() As String = Directory.GetDirectories(defaultPath)

For Each folder As String In directorys

Dim folderName() As String = folder.Split("\"c)

Dim directoryName As String = folderName(folderName.Length - 1)

If (Directory.Exists(newWfFilePath + "/" + directoryName)) Then

Else

Directory.CreateDirectory(newWfFilePath + "/" + directoryName)

Dim strFiles() As String = Directory.GetFiles(defaultPath + "/" + directoryName)

For Each strFile As String In strFiles

Dim FileName() As String = strFile.Split("\"c)

System.IO.File.Copy(strFile, newWfFilePath + "/" + directoryName +
"/"+FileName(FileName.Length - 1))

End If

Add JavaScript map to Html Header using VB.Net

2013-07-03T02:34:00.000-07:00

In Page Load event

Dim scripttag = New HtmlGenericControl("script")

scripttag.Attributes.Add("type", "text/javascript")

scripttag.InnerHtml = "var controls="[{‘key1’:’value1’, ‘key2’:’value2’}, {="[{‘key1’:’value3’, ‘key2’:’value4’}]"

Page.Header.Controls.Add(scripttag)

Jquery Date Picker in dd/mm/yyyy Format.

2013-06-30T11:05:00.004-07:00

$(document).ready(function () {
$('.datepicker').datepicker({
numberOfMonths: 2,
dateFormat: 'dd/mm/yy',
changeMonth: true,
changeYear: true,
autoSize: true,
minDate: new Date(),
maxDate: '+363d',
showAnim: 'fadeIn',
yearRange: '2013:2020',
showOn: 'focus',
buttonImage: '/Content/images/calendar.gif',
buttonImageOnly: 'false'
});
})

Select all Html Element whose ID start with 'txt_'

2013-02-24T23:43:00.006-08:00

<!DOCTYPE html>

<html>

<head>

</script>

$(document).ready(function () {

$("button").click(function () {

$("a[target='_blank']").hide();

$('[id^="txt_"]').hide();

});

</script>

</head>

<body>

<h2>This is a heading</h2>

<p id="txt_p">This is a paragraph.</p>

<p id="txt_p1">This is another paragraph.</p>

<button>Click me</button>

</body>

</html>

Kendo - KnockOut Grid Bind

2013-01-10T06:04:00.004-08:00

HTML

JavaScript

$(document).ready(function () {

$.ajaxSetup({ async: false });

//var Data= [{ "ShipCity": "Kolkata", "ShipName": "Pinaki GROUP" }, { "ShipCity": "Mumbai", "ShipName": "Pinaki SOL"}];

var Data = null;

function DataFunction() {

$.post("/BkCode/BookResult", null, function (d) {

Data = d;

});

return Data;

}

var ViewModel = function () {

this.gridConfig = {

data: null,

dataSource: {

type: "odata",

data: DataFunction(), //This is use to access data from database using jQuery

// and return data in Json format

//data: Data,

schema: {

model: {

fields: {

ShipCity: {

type: "string"

ShipName: {

type: "string"

}

pageSize: 10 //,

//serverPaging: true,

//serverFiltering: true,

//serverSorting: true

columns: [{

field: "ShipCity",

title: "Id",

filterable: false

{

field: "ShipName",

title: "Company Name",

filterable: true

{

command: ["edit", "destroy"],

filterable: false

}] ,

height: 550,

scrollable: false,

pageable: true,

sortable: true,

groupable: true,

filterable: true,

editable: "inline", //popup

save: function () {

this.refresh();

}

};

ko.applyBindings(new ViewModel());

})

</script>

C#

public JsonResult BookResult()

{

var result = from s in bk.GetPrmCompanies()

select new book{

ShipCity = s.Id,

ShipName = s.CoNames

};

DB.Configuration.ProxyCreationEnabled = false;

return Json(result, JsonRequestBehavior.AllowGet); //Content(sd, "text/xml");

}

How To Create A Trigger.

2012-12-10T23:44:00.003-08:00

Trigger is procedural code that is automatically executed in response to certain events on a specific table in a database. Triggers can restrict access to specific data, perform logging, or audit data modifications.

Triggers are of 3 types in SQL Server 2005:

1. DML Triggers
- AFTER Triggers
- INSTEAD OF Triggers { INSERT, UPDATE, and DELETE }
2. DDL Triggers {if any schema change.}
3. CLR Triggers

Create trigger Delete_TrigerName

on ReferanceTable

for Delete

--Checking for Table exist.

--if Table not exist then create a table with same schema of operation table

if NOT EXISTS(SELECT * FROM information_schema.tables

WHERE TABLE_CATALOG = 'DATABASE-NAME'

AND table_name = 'Backup-TABLE-NAME')

begin

-- Copy full table with creating table of copied table schema

select * into Backup-TABLE-NAME from deleted

--Set Identity column Off. Otherwise we will not able to track the previous position of table.

SET IDENTITY_INSERT [Backup-TABLE-NAME ] off

end

else

begin

INSERT INTO Backup-TABLE-NAME ([Column1],[ Column2],[ Column3])

SELECT [Column1],[ Column2],[ Column3]

FROM deleted

end

--select * from Backup-TABLE-NAME

--select * from AgentMaster

--delete from AgentMaster where Ag_ApplNo=22

How to Create Cursor

2012-12-10T05:20:00.002-08:00

declare @tempt table

(

ID int null,

Name varchar(100) null

)

DECLARE @vendor_id int, @vendor_name nvarchar(50),

@message varchar(80), @product nvarchar(50);

PRINT '-------- Vendor Products Report --------';

-- Declare Cursor – untill it deallocate

-- You Con’t declare another cursor with same name.

DECLARE vendor_cursor CURSOR FOR

SELECT ID,Ag_Fname

from AgentMaster

OPEN vendor_cursor

FETCH NEXT FROM vendor_cursor

INTO @vendor_id, @vendor_name

WHILE @@FETCH_STATUS = 0

BEGIN

SELECT @message = '----- Vendor: ' +

@vendor_name

PRINT @message

insert INTO @tempt values (@vendor_id, @vendor_name)

FETCH NEXT FROM vendor_cursor

INTO @vendor_id, @vendor_name

END

CLOSE vendor_cursor;

select * from @tempt

-- Deallocate Cursor

DEALLOCATE vendor_cursor;

How To Buy A Blogspot Domain

2012-12-09T23:06:00.000-08:00

1. First you login to blogspot.com

2. Then if you have account go to the dashboard

3. Click on the Setting. And select About Our New Look and click

4. Choose About URLs from left panel and click

5. Click custom domain. In newly open page.

6. Choose radio button Buy a custom domain through Blogger.

7. Click Google Checkout link in this page.

8. Google Wallet logging page will open. Login with your user name and password.

9. Now You will get the shopping page. Fill data with correct data including Payment method.

C# and Asp.net, MVC Professional Code: Convert string To float

2012-12-07T21:14:00.001-08:00

C# and Asp.net, MVC Professional Code: Convert string To float: string float_value="234.4567"; //If data come from databse then first convert it into string then this line; float fl=float.pars(float_val...

Pan Number format and Duplication entry validation in KendoUi

2012-11-22T21:40:00.003-08:00

Checking from database using json and Controler's action where controler is Validation and Action is CheckPanNo . Then we check format using test function. and error message set to messages section of kendoValidator function.

Java Script

///Pan No Duplication checking

var validatable = $("#Pan").kendoValidator({

onfocusout: true,

onkeyup: true,

rules: {

PanNo: function (input) {

$.post("/Validation/CheckPanNo", { PanNo: $("#Pan").val() }, function (data) { b1 = data; })

return b1;

PanFormat: function (input) {

// return validatePanCard('Pan');

var value = input.val();

var regex1 = /^[A-Z]{5}\d{4}[A-Z]{1}$/;

if (!regex1.test(value) || value.length != 10) {

return false;

}

return true;

}

messages: {

PanNo: "Already Exist",

PanFormat: "Not a currect format"

}

}).data("kendoValidator");

Action

[HttpPost]

public JsonResult CheckPanNo(string PanNo)

{

bool IsOk = projectRepository.CheckPanNumber(PanNo);

return Json(IsOk, JsonRequestBehavior.AllowGet);

}

How to Binding Dropdown Using Knockout JS

2012-11-21T05:42:00.003-08:00

Using jquery, we access date from Action called Ko_ShowBranch in a controller caller ListObject. This action access data from database using a function called ShowAll_Branch() and to return Json result in text and value property we write below line this way.

ShowAll_Branch().Select(p => new { text =p.BranchName , value = p.ID.ToString() });

In Html Value property and Text property are set using optionsValue: and optionsText:

Javascript

viewModel = {

Branch: ko.observableArray()

};

$(function () {

$.getJSON('http://localhost:3400/ListObject/Ko_ShowBranch', null,

function (response) {

viewModel.Branch(response);

});

ko.applyBindings(viewModel);

});

Html

<select data-bind="options: Branch, optionsCaption: 'Choose Branch...',

optionsValue: function(item) { return item.value; },

optionsText: function(item) { return item.text; }" id="Branch" name="Branch"> </select>

Controler

public JsonResult Ko_ShowBranch()

{

var result = projectRepository.ShowAll_Branch().Select(p => new { text = p.BranchName, value = p.ID.ToString() });

return Json(result, JsonRequestBehavior.AllowGet);

}

How can I format a json date in dd/mm/yy format in javascript

2012-11-19T21:18:00.002-08:00

Json return date as timestamp to convert that date to our normal date format we first convert timestamp to Date . then we get day, month, year from Date and format it as dd/mm/yyyy or mm/dd/yyyy or yyyy/mm/dd and other format.

function EditCheque(id) {

$.post("/Partner/ChqEdit", { id: id }, function (data) {

var date = new Date(parseInt(data.ChqDate.substr(6)));

$("#ChqDate").val( date.getDate() + '/' + (date.getMonth() + 1) + '/' + date.getFullYear());

});

Return Some/Specific Column from a table or Joined Table using LINQ

2012-11-16T04:29:00.000-08:00

How to fetch some column from table in linq

[HttpGet]

public JsonResult ShowAllMstStocklistScheme()

{

var v = PR.ShowAllMstStocklistScheme().Select(p => new { p.ID, p.Scheme });

return Json(v, JsonRequestBehavior.AllowGet);

}

in code "new { p.ID, p.Scheme }" is declare column name or table property name which you want to access through this query.

Some problem arise when we going to bind dropdown in kendo from a table which has a foreign key realtion. That time we need to access specific column from table.

we can use this way of return from LINQ data.

Transaction Commit And Rollback in LINQ

2012-11-16T04:18:00.004-08:00

How to Use transaction.

When we want to save data to multiple table or in multiple time in a table use transaction.

follow code snip below.

Class Abc {

//Object Declaration

ProjectRepository pr = new ProjectRepository();

DBDataContext DBObject = new DBDataContext();

//Action

public ActionResult FormEntry(FormCollection fc)

{

System.Data.Common.DbTransaction Tran=null;

DBObject.Connection.Open();

Tran = DBObject.Connection.BeginTransaction();

DBObject.Transaction = Tran;

try

{

//---Code of insert or Update---

DataTable dtc = (DataTable)SessionBag.Current.ChequeDetailsXV;

if (dtc.Rows.Count > 0)

{

foreach (DataRow dr in dtc.Rows)

{

CapitalDetail Pc = new CapitalDetail();

Pc.PrGroup_ID = Convert.ToInt32(dr["PrGroup_ID"]);

Pc.Capi_Amount = Convert.ToInt32(dr["Amount"]);

Pc.Capi_Bank = Convert.ToString(dr["ChqBankBranch"]);

Pc.Capi_Bank_Branch = Convert.ToString(dr["ChqBankBranch"]);

//Pc.Capi_OutStation = Convert.ToString(dr["DrawNo"]);

Pc.Capi_ChequeNo = Convert.ToInt32(dr["ChqNo"]);

Pc.Capi_Date = Convert.ToDateTime(dr["ChqDate"]);

Pc.Capi_EntryDate = Convert.ToDateTime(DateTime.Now);

Pc.Capi_Type = Convert.ToString("Cheque");

pr.Add(Pc);

}

pr.Save();

Tran.Commit();

}

catch (Exception ex)

{

Tran.Rollback();

}

finally

{

if (DBObject.Connection != null && DBObject.Connection.State == System.Data.ConnectionState.Open)

{

DBObject.Connection.Close();

}

Kendo UI Validation for Dublicate Value Checking

2012-11-09T21:13:00.000-08:00

I am faced a problem with validation for duplicate value checking from server using json. My code is runing fine in each click but error message show in second click(One click in side text box put value then click out side the text box - that time code execute but error message show . again i click in that text box and again click out side text box ,again my code run and this time error message show) . Please find my mistake and help me to show validation message in single escape or single click of text box.

Now I solve by adding ajax async clode in the to of the javascript. We get success if you use this.

script language="javascript" type="text/javascript"

//KendoUi Validation

    var validatable = $("#ApplicationNo").kendoValidator({
        onfocusout: true,
        onkeyup: true,
        rules: {
            ApplicationNo: function (input) {
                $.post("/Home/CheckAppNo",

               { ApplicationNo: $("#ApplicationNo").val() },

               function (data) { b1 = data; })
                return b1;
              }

        },

        messages: {
            ApplicationNo: "Already Exist"
        }
    }).data("kendoValidator");

   var validatable =

       $(".k-content").kendoValidator().data("kendoValidator");

script language="javascript" type="text/javascript"

//KendoUi Validation

$.ajaxSetup({ async: false });

    var validatable = $("#ApplicationNo").kendoValidator({
        onfocusout: true,
        onkeyup: true,
        rules: {
            ApplicationNo: function (input) {
                $.post("/Home/CheckAppNo",

              { ApplicationNo: $("#ApplicationNo").val() },

                function (data) { b1 = data; })
                return b1;
            }

        },

        messages: {
            ApplicationNo: "Already Exist"
        }
    }).data("kendoValidator");

   var validatable =

       $(".k-content").kendoValidator().data("kendoValidator");

C # Code

    public JsonResult CheckAppNo(string ApplicationNo)
    {
        bool IsOk = projectRepository.CheckAppNumber(ApplicationNo);
        return Json(IsOk, JsonRequestBehavior.AllowGet);
        //return new JsonResult { Data = IsOk };
    }

Html

< input type="text" id="ReferredBy" name="ReferredBy" class="k-textbox" required />