How to validate a field while updating table in jquery

Sourabh Choubey

8y1.1kLearn iOS Programming

//class Library studentmodel

//class name ModelStudentMarks

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace StudentMarks.Models

{

public class ModelStudentMarks

{

public int ID { get; set; }

public string Name { get; set; }

public string RollNumber { get; set; }

public string MobileNumber { get; set; }

public string Address { get; set; }

public Decimal Marks { get; set; }

public List GetstudentList { get; set; }

}

StudentMarksDL.DataLayer

class name-DbHandler

using StudentMarks.Models;

using System;

using System.Collections.Generic;

using System.Data.SqlClient;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace StudentMarksDL.DataLayer

{

public class StudentMarksDl

{

DbHandler db = new DbHandler();

public void Insert_update_del(ModelStudentMarks stdMarks)

{

try

{

SqlParameter[] spcol = null;

spcol = new SqlParameter[]

{

new SqlParameter("@id",stdMarks.ID),

new SqlParameter("name",stdMarks.Name),

new SqlParameter("@mobilenumber",stdMarks.MobileNumber),

new SqlParameter("@rollnumber",stdMarks.RollNumber),

new SqlParameter("@address",stdMarks.Address),

new SqlParameter("@marks",stdMarks.Marks)

};

if (spcol == null) return;

db.Insert_update("sp_InsertUpdateMarks", spcol);

}

catch(Exception ex)

{ throw ex; }

}

public void Delete(int id)

{

try

{

SqlParameter[] spcol = null;

spcol = new SqlParameter[]

{

new SqlParameter("@id",id),

};

if (spcol == null) return;

db.Delete("sp_DeleteStdMarks", spcol);

}

catch (Exception ex)

{ throw ex; }

}

public List StudentMarksList(ModelStudentMarks stdMarks)

{

try

{

List objlist = new List();

SqlParameter[] spcol = null;

if (stdMarks != null)

{

spcol = new SqlParameter[]

{

new SqlParameter("@id",stdMarks.ID),

};

}

else

{ spcol = null; }

objlist = db.StudentMarksList("sp_GetStdMarksList", spcol);

return objlist;

}

catch(Exception ex)

{

throw ex;

}

//class name-DbHandler

//StudentMarksBL.BuisnessLayer

classname-StudentMarksBl

using StudentMarks.Models;

using StudentMarksDL.DataLayer;

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace StudentMarksBL.BuisnessLayer

{

public class StudentMarksBl

{

StudentMarksDl objstdmarksbl = new StudentMarksDl();

public void Insert_update_del(ModelStudentMarks stdMarks)

{

try

{

objstdmarksbl.Insert_update_del(stdMarks);

}

catch(Exception ex)

{

throw ex;

}

public void Delete(int id)

{

try

{

objstdmarksbl.Delete(id);

}

catch (Exception ex)

{

throw ex;

}

public List StudentMarksList(ModelStudentMarks stdMarks)

{

try

{

List objlist = new List();

objlist = objstdmarksbl.StudentMarksList(stdMarks);

return objlist;

}

catch(Exception ex)

{

throw ex;

}

StudentMarks

controller-StudentController

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.Mvc;

using StudentMarks.Models;

using StudentMarksBL.BuisnessLayer;

namespace StudentMarks.Controllers

{

public class StudentController : Controller

{

StudentMarksBl objstdbl = new StudentMarksBl();

// GET: Student

public ActionResult Index()

{

ModelStudentMarks objlist = new ModelStudentMarks();

objlist.GetstudentList = objstdbl.StudentMarksList(null);

return View( objlist);

}

[HttpPost]

public ActionResult UpdateCustomer(ModelStudentMarks ModelStudentMarks)

{

try

{

objstdbl.Insert_update_del(ModelStudentMarks);

}

catch(Exception ex)

{ throw ex; }

return new EmptyResult();

}

[HttpPost]

public JsonResult InsertCustomer(ModelStudentMarks ModelStudentMarks)

{

try

{

objstdbl.Insert_update_del(ModelStudentMarks);

}

catch (Exception ex)

{ throw ex; }

return Json(ModelStudentMarks);

}

[HttpPost]

public ActionResult DeleteMarks(int customerId)

{

try

{

objstdbl.Delete(customerId);

}

catch (Exception ex)

{ throw ex; }

return new EmptyResult();

}

view- Index

@model StudentMarks.Models.ModelStudentMarks

Layout = null;

}

Index

@foreach (var items in Model.GetstudentList)

{

}

ID	Name	Address	RollNumber	MobileNumber	Marks	Action

@items.ID	@items.Name	@items.Address	@items.RollNumber	@items.MobileNumber	@items.Marks	Edit Update Cancel Delete

Name

Address:

MobileNumber:

RollNumber:

Marks:

4 Replies

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

Ramesh Palanivel8y ago
Accepted answer
Hi Sourbha,

Please mention your requirement and issue. Mention the code where you are getting error or where you want to implement ? We cannot read all your code and find the issue.
Sourabh Choubey8y ago
Yes i have commented that code
//var number = $('#txtmark').val();
//if (isNaN(number)) {
// alert("only number");
// return false;
//}
here i got error.Actually there are many controls with this id
Ramesh Palanivel8y ago
Hi sourabh,

you already validated your input fields.Are you getting error in the below lines?
function Validate() {
debugger;
var txtName = $("#txtName");
var txtAddress = $("#txtAddress");
var txtMobilenumber = $("#txtMobileNumber");
var txtRollNumber = $("#txtRollNumber");
var txtMarks = $("#txtMarks");
if (txtName.val() == "") {
alert("Enter name please")
return false;
}
if (txtAddress.val() == "") {
alert("Enter address please")
return false
}
if (txtMobilenumber.val() == "") {
alert("Enter MobileNumber please")
return false
}
if (txtRollNumber.val() == "") {
alert("Enter RollNumber please")
return false
}
if (txtMarks.val() == "") {
alert("Enter Marks please")
return false
}
var filter = /^((\+[1-9]{1,4}[ \-]*)|($[0-9]{2,3}$[ \-]*)|([0-9]{2,4})[ \-]*)*?[0-9]{3,4}?[ \-]*[0-9]{3,4}?$/;
var phoneNumber = txtMobilenumber.val();
if (filter.test(phoneNumber)) {
if (phoneNumber.length == 10) {
var validate = true;
} else {
alert('Please put 10 digit Mobile Number'); return false;
//var validate = false;
}
}
else {
alert('Not a valid Mobile Number'); return false;
//var validate = false;
}
//var number = $('#txtmark').val();
//if (isNaN(number)) {
// alert("only number");
// return false;
//}
}
Sourabh Choubey8y ago
Ok Thankyou.
using StudentMarks.Models;
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Web;
namespace StudentMarksDL.DataLayer
{
public class DbHandler
{
private string ConString = Convert.ToString(ConfigurationManager.AppSettings["ConDb"]);
public void Insert_update(string sp, SqlParameter[] spcol)
{
using (SqlConnection con = new SqlConnection(ConString))
{
using (SqlCommand cmd = new SqlCommand(sp, con))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
if (spcol != null && spcol.Length > 0)
cmd.Parameters.AddRange(spcol);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
}
public void Delete(string sp, SqlParameter[] spcol)
{
using (SqlConnection con = new SqlConnection(ConString))
{
using (SqlCommand cmd = new SqlCommand(sp, con))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
if (spcol != null && spcol.Length > 0)
cmd.Parameters.AddRange(spcol);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
}
public List StudentMarksList(string sp, SqlParameter[] spcol)
{
SqlDataReader dr;
List studentmarks = new List();
using (SqlConnection con = new SqlConnection(ConString))
{
using (SqlCommand cmd = new SqlCommand(sp, con))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
if (spcol != null && spcol.Length > 0)
cmd.Parameters.AddRange(spcol);
con.Open();
dr = cmd.ExecuteReader();
while (dr.Read())
{
studentmarks.Add(new ModelStudentMarks()
{
ID = dr.GetInt32(dr.GetOrdinal("ID")),
Name = dr.GetString(dr.GetOrdinal("Name")),
RollNumber = dr.GetString(dr.GetOrdinal("RollNumber")),
Address = dr.GetString(dr.GetOrdinal("Address")),
MobileNumber = dr.GetString(dr.GetOrdinal("MobileNumber")),
Marks = dr.GetDecimal(dr.GetOrdinal("Marks"))
});
}
dr.Close();
con.Close();
}
}
return studentmarks;
}
}

}