using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.Services;
using System.Web.Script.Serialization;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;
using Newtonsoft.Json;
namespace ModelTest
{
public partial class PlayerEntry : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
[WebMethod]
public static string LoadData(int Flag)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Connection"].ToString());
string query = "select id, name, dob, gender, rating, status, Flag from tbl_Playersname where Flag="+Flag+" order by id desc";
SqlDataAdapter da = new SqlDataAdapter(query, con);
DataTable dt = new DataTable();
da.Fill(dt);
string jsonvalue = JsonConvert.SerializeObject(dt);
return jsonvalue;
}
[WebMethod]
public static string delete(int id)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Connection"].ToString());
string query = "update tbl_Playersname set Flag=0 where id="+id+"";
SqlDataAdapter da = new SqlDataAdapter(query, con);
DataTable dt = new DataTable();
da.Fill(dt);
string jsonvalue = "Successfully Deleted!!!";
return jsonvalue;
}
[WebMethod]
public static string adddata(string name, string dob, string gender, string rating, string status)
{
int rating1 = Convert.ToInt32(rating);
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Connection"].ToString());
con.Open();
string query = "insert into tbl_Playersname values('" + name + "','" + dob + "','" + gender + "'," + rating1 + ",'" + status + "',"+1+")";
SqlCommand cmd = new SqlCommand(query, con);
cmd.ExecuteNonQuery();
con.Close();
return "successfully inserted!!!!";
}
}
}
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="PlayerEntry.aspx.cs" Inherits="ModelTest.PlayerEntry" %>
.auto-style1 {
width: 100%;
}
#name-error {
color: red;
}
#mobile-error {
color: red;
}
.slidecontainer {
width: 100%;
}
.slider {
-webkit-appearance: none;
width: 35%;
height: 15px;
border-radius: 5px;
background: #d3d3d3;
outline: none;
opacity: 0.7;
-webkit-transition: .2s;
transition: opacity .2s;
}
.slider:hover {
opacity: 1;
}
.slider::-webkit-slider-thumb {
-webkit-appearance: none;
appearance: none;
width: 25px;
height: 25px;
border-radius: 50%;
background: #4CAF50;
cursor: pointer;
}
.slider::-moz-range-thumb {
width: 25px;
height: 25px;
border-radius: 50%;
background: #4CAF50;
cursor: pointer;
}
$(function () {
$("#datepicker").datepicker(
{ dateFormat: 'dd/mm/yy' })
});
function SaveDatas() {
var inputIsValid = $("#validationfrom").valid();
if (inputIsValid == true) {
var name = $('#name').val();
var dob = $('#datepicker').val();
var rating = $('#myRange').val();
var slider = document.getElementById("myRange");
var output = document.getElementById("demo");
rating = slider.value;
slider.oninput = function () {
output.innerHTML = this.value;
}
var date = dob;
var d = new Date(date.split("/").reverse().join("-"));
var dd = d.getDate();
var mm = d.getMonth() + 1;
var yy = d.getFullYear();
var newdate = yy + "/" + mm + "/" + dd;
//alert(newdate);
var checkbox = $('#status').is(':checked');
if (checkbox == true) {
var status = 'Active';
}
else {
var status = 'Deactive';
}
var RadioButton1 = $('#rdo1').is(':checked');
if (RadioButton1 == true) {
var gender = 'Male';
}
else {
var gender = 'Female';
}
$.ajax(
{
type: "POST",
url: "PlayerEntry.aspx/adddata",
data: JSON.stringify({ name: name, dob: newdate, gender: gender, rating: rating, status: status }),
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function (data) {
alert(data.d);
},
});
}
else {
alert('Please fill all fields..');
}
}
$(document).ready(function () {
$('#validationfrom').validate({ // initialize the plugin
rules: {
name: {
required: true,
},
mobile: {
required: true,
minlength: 10,
maxlength: 10,
number: true
}
},
messages: {
name: "*Please Enter the Name",
mobile: "*Mobile number should by Numeric format only"
}
});
});
$.ajax({
type: "POST",
url: "PlayerEntry.aspx/LoadData",
data: JSON.stringify({Flag:1}),
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function (msg) {
var jsonvalue = JSON.parse(msg.d);
$("#pbody").empty();
for (var k = 0; k < jsonvalue.length; k++) {
var id = jsonvalue[k]["id"];
var name = jsonvalue[k]["name"];
var dob = jsonvalue[k]["dob"];
var gender = jsonvalue[k]["gender"];
var rating = jsonvalue[k]["rating"];
var status = jsonvalue[k]["status"];
var appenddata = " "
$("#pbody").append(appenddata);
}
}
});
function Delete(id)
{
$.ajax({
type: "POST",
url: "PlayerEntry.aspx/Delete",
data: JSON.stringify({ id: id }),
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function (msg) {
},
});
}
<%--
$(document).ready(function () {
$.ajax({
type: "POST",
url: "Codepage.asmx/AddData",
data: JSON.stringify({}),
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function (data) {
var data = data.d;
var h = JSON.parse(data);
$('#tablePROJ1BODY').val('');
for (var i = 0; i < h.length; i++) {
var empid = h[i]['Emp_Id'];
var Emp_Name = h[i]['Emp_Name'];
var Dept = h[i]['Dept'];
var Disg = h[i]['Disg'];
var Salary = h[i]['Salary'];
var tbodydata = " "
$('#tablePROJ1BODY').append(tbodydata);
tbodydata = '';
}
},
});
});
function UpdateDate(id) {
var empid = $('#empid' + id + '').val();
var Emp_Name = $('#Emp_Name' + id + '').val();
var Dept = $('#Dept' + id + '').val();
var Disg = $('#Disg' + id + '').val();
var Salary = $('#Salary' + id + '').val();
$.ajax({
type: "POST",
url: "Codepage.asmx/UpdateData",
data: JSON.stringify({ empid: empid, Emp_Name: Emp_Name, Dept: Dept, Disg: Disg, Salary: Salary, Condition: id }),
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function (data) {
alert('Updated successfully !!!')
},
});
}
--%>
$(document).ready(function() {
$("button").click(function(){
var favorite = [];
$.each($("input[name='sport']:checked"), function(){
var records = $(this).val();
if(records=="showdeleted")
{
$.ajax({
type: "POST",
url: "PlayerEntry.aspx/LoadData",
data: JSON.stringify({Flag:0}),
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function (msg) {
var jsonvalue = JSON.parse(msg.d);
$("#pbody").empty();
for (var k = 0; k < jsonvalue.length; k++) {
var id = jsonvalue[k]["id"];
var name = jsonvalue[k]["name"];
var dob = jsonvalue[k]["dob"];
var gender = jsonvalue[k]["gender"];
var rating = jsonvalue[k]["rating"];
var status = jsonvalue[k]["status"];
var appenddata = " "
$("#pbody").append(appenddata);
}
}
});
}
});
});
});
| Player Name | Dob | Gender | Rating | Status |
|---|
| Player Name | |
| Dob | |
| Gender | Male Female |
| Rating | |
| Status | |
Laxmidhar SahooPosted Dec 2, 2018, 9:51 PM