Stop JavaScript code running when C# validation failed

Few code changes:

Javascript

"button" id="btnAddConsent" value="Add Consent" onclick="insertData();" />
function insertData() {
var MBID = document.getElementById("txtConsentMBID").value;
var ConsentID = document.getElementById("DropDownListConsent").value;
var ConsentDate = document.getElementById("txtPatientConsentDate").value;
var xmlhttp = new XMLHttpRequest();
xmlhttp.onreadystatechange = function () {
if (xmlhttp.readyState == 4 && xmlhttp.status == 200) {
alert(xmlhttp.responseText);
}
}
xmlhttp.open("GET", "insertConsent.aspx?mb=" + MBID + " &ci= " + ConsentID + "&cd=" + ConsentDate, false);
xmlhttp.send(null);
ConsentID = document.getElementById("DropDownListConsent").value = "";
ConsentDate = document.getElementById("txtPatientConsentDate").value = "";
}

C# code

bool status= false;
using (SqlConnection con = new SqlConnection(WebConfigurationManager.ConnectionStrings["Molecular"].ConnectionString))
{
MBID = Request.QueryString["mb"].ToString();
ConsentID = Request.QueryString["ci"].ToString();
ConsentDate = Request.QueryString["cd"].ToString();
con.Open();
using (SqlCommand sc = new SqlCommand(@" select * from ConsentGroup where ConsentID = @ConsentID and MBID=@MBID ", con))
{
sc.Parameters.AddWithValue("@MBID", MBID);
sc.Parameters.AddWithValue("@ConsentID", ConsentID);
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(sc);
da.Fill(dt);
if (dt.Rows.Count <= 0)
{
using (SqlCommand sc1 = new SqlCommand(@"insert into ConsentGroup (MBID, ConsentID, ConsentDate, ConsentWithdraw, ConsentConfirm)
values('" + MBID + "','" + ConsentID + "','" + ConsentDate + "','NO','YES')", con))
{
sc1.ExecuteNonQuery();
}
status= true;
}
}
}
if (status){
// this message should displayed when count is more that 1
Response.Write("Consent Added Successfully");
}else{
Response.Write("This Patient already has this Concent saved in the Database'");
}

http://www.c-sharpcorner.com/UploadFile/manas1/implementing-ajax-concept-in-Asp-Net-using-xmlhttprequest/

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manas Mohapatra9y ago
Accepted answer
Few code changes:
Javascript
"button"  id="btnAddConsent" value="Add Consent"   onclick="insertData();" />

function insertData() {
    var MBID = document.getElementById("txtConsentMBID").value;
    var ConsentID = document.getElementById("DropDownListConsent").value;
    var ConsentDate = document.getElementById("txtPatientConsentDate").value;

    var xmlhttp = new XMLHttpRequest();

    xmlhttp.onreadystatechange = function () {
        if (xmlhttp.readyState == 4 && xmlhttp.status == 200) {
            alert(xmlhttp.responseText);
        }
    }

    xmlhttp.open("GET", "insertConsent.aspx?mb=" + MBID + " &ci= " + ConsentID + "&cd=" + ConsentDate, false);
    xmlhttp.send(null);

    ConsentID = document.getElementById("DropDownListConsent").value = "";
    ConsentDate = document.getElementById("txtPatientConsentDate").value = "";
}
C# code
bool status= false;

using (SqlConnection con = new SqlConnection(WebConfigurationManager.ConnectionStrings["Molecular"].ConnectionString))
{
    MBID = Request.QueryString["mb"].ToString();
    ConsentID = Request.QueryString["ci"].ToString();
    ConsentDate = Request.QueryString["cd"].ToString();

    con.Open();

    using (SqlCommand sc = new SqlCommand(@" select * from ConsentGroup where ConsentID = @ConsentID and MBID=@MBID ", con))
    {
        sc.Parameters.AddWithValue("@MBID", MBID);
        sc.Parameters.AddWithValue("@ConsentID", ConsentID);

        DataTable dt = new DataTable();
        SqlDataAdapter da = new SqlDataAdapter(sc);
        da.Fill(dt);
        if (dt.Rows.Count <= 0)
        {
            using (SqlCommand sc1 = new SqlCommand(@"insert into ConsentGroup (MBID, ConsentID, ConsentDate, ConsentWithdraw, ConsentConfirm)

            values('" + MBID + "','" + ConsentID + "','" + ConsentDate + "','NO','YES')", con))
            {
                sc1.ExecuteNonQuery();
            }

            status= true;
        }
    }
}

if (status){
    // this message should displayed when count is more that 1
    Response.Write("Consent Added Successfully");
}else{
    Response.Write("This Patient already has this Concent saved in the Database'");
}
http://www.c-sharpcorner.com/UploadFile/manas1/implementing-ajax-concept-in-Asp-Net-using-xmlhttprequest/
Manas Mohapatra9y ago
I think you need to write code inside page_load method. If that doesn't resolve your problem use jQuery AJAX. Follow below link that may help you:

https://www.mikesdotnetting.com/article/40/asp-net-and-ajax-using-xmlhttprequest

If it helps please accept the answer...
Eric Mbiada9y ago
Hi Manas,

Thanks for your help. The code works but I have an issue with the message displaying. The message is displaying HTML tags in the message box

Any idea how to solve this issue

Thanks

Eric