i have two table one is supplier table another is product table..
inline i have taken html input and html button
used JavaScript.
and code behind
public static string UpdateStaff(string Supempdata)
{
bool status;
var serializeData = JsonConvert.DeserializeObject<List<Supplier>>(Supempdata);
try
{
using (var con = new SqlConnection(Constr))
{
foreach (var data in serializeData)
{
using (var cmd = new SqlCommand("insert into purchase values(@VoucherNo,@PurchasedateDate,@Suppliername,@Suppaddress,@SupContactno)"))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@VoucherNo", data.Contact);
cmd.Parameters.Add("@PurchasedateDate", data.EmailId);
cmd.Parameters.Add("@Suppliername", data.Contact);
cmd.Parameters.Add("@Suppaddress", data.Salary);
cmd.Parameters.Add("@SupContactno", data.Degnation);
cmd.Connection = con;
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd.ExecuteNonQuery();
con.Close();
}
}
}
return null;
}
catch (Exception ee)
{
}
return null;
}
[WebMethod]
public static string SaveData(string empdata)
{
var serializeData = JsonConvert.DeserializeObject<List<Employee>>(empdata);
using (var con = new SqlConnection(Constr))
{
foreach (var data in serializeData)
{
using (var cmd = new SqlCommand("insert into purchase1 values(@ItemName,@batchno,@expdate,@stock,@Qty,@Rate,@total)"))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@ItemName", data.FName);
cmd.Parameters.AddWithValue("@batchno", data.LName);
cmd.Parameters.AddWithValue("@expdate", data.EmailId);
cmd.Parameters.AddWithValue("@stock", data.STOCK);
cmd.Parameters.AddWithValue("@Qty", data.QUANTITY);
cmd.Parameters.AddWithValue("@Rate", data.RATE);
cmd.Parameters.AddWithValue("@total", data.TOTAL);
cmd.Connection = con;
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd.ExecuteNonQuery();
con.Close();
}
}
}
return null;
}
}
What I have tried:
<pre> <table class="table" id="maintable">
<thead>
<tr class="data-contact-person">
<th> </th>
<div class="table-toolbar">
<div class="row">
<input type="hidden" runat="server" id="mystaffid" />
<div class="col-md-12">
<div class="col-md-4">
<div class="form-group">
<label>Purchase ID</label>
<input type="text" id="staff_fullname" value="" placeholder="Full Name" runat="server" class="form-control Name" />
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label>Voucher No</label>
<input type="text" id="staff_contact" placeholder="Contact Number" runat="server" class="form-control Contact" />
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label>Supplier Name</label>
<input type="text" id="email_address" placeholder="Eg:- info@admin.com" runat="server" class="form-control Email" />
</div>
</div>
</div>
<div class="col-md-12">
<div class="col-md-4">
<div class="form-group">
<label>Address</label>
<input type="text" id="salary_details" placeholder="Enter Salary" runat="server" class="form-control Salary" />
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label>Contact no</label>
<input type="text" id="designation" placeholder="Enter Designation" runat="server" class="form-control Designation" />
</div>
</div>
<th> </th>
<th> </th>
<th> </th>
<th> </th>
</tr>
<tr>
<th>ITEMNAME</th>
<th>BATCHNO</th>
<th>EXPIRYDATE</th>
<th>STOCK</th>
<th>QTY</th>
<th>RATE</th>
<th>TOTAL</th>
</tr>
</thead>
<tbody>
<tr class="data-contact-person">
<td>
<input type="text" name="f-name" class="form-control f-name01" /></td>
<td>
<input type="text" name="l-name" class="form-control l-name01" /></td>
<td>
<input type="text" name="email" class="form-control email01" /></td>
<td>
<input type="text" name="stock" class="form-control stock01" /></td>
<td>
<input type="text" name="qty" class="form-control qty01" /></td>
<td>
<input type="text" name="rate" class="form-control rate01" /></td>
<td>
<input type="text" name="total" class="form-control total01" /></td>
<td>
<button type="button" id="btnAdd" class="btn btn-xs btn-primary classAdd">Add More</button>
</td>
</tr>
</tbody>
</table>
<%--<asp:Button ID="btnSubmit" class="btn btn-primary btn-md pull-right btn-sm col-md-4 text-center" runat="server" Text="Submit" />--%>
<button id="getAllEmp()">Submit1</button>
<button id="getAllEmpData()">Submit</button>
</div>
</form>
</body>
<script type="text/javascript">
$(document).ready(function () {
$(document).on("click", ".classAdd", function () {
var rowCount = $('.data-contact-person').length + 1;
var contactdiv = '<tr class="data-contact-person">' +
'<td><input type="text" name="f-name' + rowCount + '" class="form-control f-name01" /></td>' +
'<td><input type="text" name="l-name' + rowCount + '" class="form-control l-name01" /></td>' +
'<td><input type="text" name="email' + rowCount + '" class="form-control email01" /></td>' +
'<td><input type="text" name="stock' + rowCount + '" class="form-control stock01" /></td>' +
'<td><input type="text" name="qty' + rowCount + '" class="form-control qty01" /></td>' +
'<td><input type="text" name="rate' + rowCount + '" class="form-control rate01" /></td>' +
'<td><input type="text" name="total' + rowCount + '" class="form-control total01" /></td>' +
'<td><button type="button" id="btnAdd" class="btn btn-xs btn-primary classAdd">Add More</button>' +
'<button type="button" id="btnDelete" class="deleteContact btn btn btn-danger btn-xs">Remove</button></td>' +
'</tr>';
$('#maintable').append(contactdiv);
});
$(document).on("click", ".deleteContact", function () {
$(this).closest("tr").remove();
});
function getAllEmpData() {
console.log("getAllEmpData");
var data = [];
$('tr.data-contact-person').each(function () {
var firstName = $(this).find('.f-name01').val();
var lastName = $(this).find('.l-name01').val();
var emailId = $(this).find('.email01').val();
var Stock = $(this).find('.stock01').val();
var qty = $(this).find('.qty01').val();
var rate = $(this).find('.rate01').val();
var totalamount = $(this).find('.total01').val();
var alldata = {
'FName': firstName,
'LName': lastName,
'EmailId': emailId,
'STOCK': Stock,
'QUANTITY': qty,
'RATE': rate,
'TOTAL': totalamount
}
data.push(alldata);
});
console.log(data);
return data;
}
$("#btnSubmit").click(function () {
var data = JSON.stringify(getAllEmpData());
$.ajax({
url: 'Home.aspx/SaveData',
type: 'POST',
dataType: 'json',
contentType: 'application/json; charset=utf-8',
data: JSON.stringify({ 'Supempdata': data }),
success: function () {
alert("Data Added Successfully");
},
error: function () {
alert("Error while inserting data");
}
});
});
});
</script>
<script type="text/javascript">
$(document).ready(function () {
$(document).on("click", ".classAdd", function () {
var rowCount = $('.data-contact-person').length + 1;
var contactdiv = '<tr class="data-contact-person">' +
'<td><input type="text" name="f-name' + rowCount + '" class="form-control f-name01" /></td>' +
'<td><input type="text" name="l-name' + rowCount + '" class="form-control l-name01" /></td>' +
'<td><input type="text" name="email' + rowCount + '" class="form-control email01" /></td>' +
'<td><input type="text" name="stock' + rowCount + '" class="form-control stock01" /></td>' +
'<td><input type="text" name="qty' + rowCount + '" class="form-control qty01" /></td>' +
'<td><input type="text" name="rate' + rowCount + '" class="form-control rate01" /></td>' +
'<td><input type="text" name="total' + rowCount + '" class="form-control total01" /></td>' +
'<td><button type="button" id="btnAdd" class="btn btn-xs btn-primary classAdd">Add More</button>' +
'<button type="button" id="btnDelete" class="deleteContact btn btn btn-danger btn-xs">Remove</button></td>' +
'</tr>';
$('#maintable').append(contactdiv);
});
$(document).on("click", ".deleteContact", function () {
$(this).closest("tr").remove();
});
var getAllEmp;
$( document ).ready(function() {
getAllEmp = function () {
console.log(" getAllEmp");
var data = [];
$('tr.data-contact-person').each(function () {
var firstName = $(this).find('.Name').val();
var Con = $(this).find('.Contact').val();
var emailId = $(this).find('.Email').val();
var Sal = $(this).find('.Salary').val();
var Deg = $(this).find('.Designation').val();
var alldata = {
'FName': firstName,
'Contact': Con,
'EmailId': emailId,
'Salary': Sal,
'Degnation': Deg
}
data.push(alldata);
});
console.log(data);
return data;
}
$("#btnSubmit").click(function () {
var data = JSON.stringify(getAllEmp());
$.ajax({
url: 'Home.aspx/UpdateStaff',
type: 'POST',
dataType: 'json',
contentType: 'application/json; charset=utf-8',
data: JSON.stringify({ 'Supempdata': data }),
success: function () {
alert("Data Added Successfully");
},
error: function () {
alert("Error while inserting data");
}
});
});
});
});
</script>
//Code behind code here-----------
public static string UpdateStaff(string Supempdata)
{
bool status;
var serializeData = JsonConvert.DeserializeObject<List<Supplier>>(Supempdata);
try
{
using (var con = new SqlConnection(Constr))
{
foreach (var data in serializeData)
{
using (var cmd = new SqlCommand("insert into purchase values(@VoucherNo,@PurchasedateDate,@Suppliername,@Suppaddress,@SupContactno)"))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@VoucherNo", data.Contact);
cmd.Parameters.Add("@PurchasedateDate", data.EmailId);
cmd.Parameters.Add("@Suppliername", data.Contact);
cmd.Parameters.Add("@Suppaddress", data.Salary);
cmd.Parameters.Add("@SupContactno", data.Degnation);
cmd.Connection = con;
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd.ExecuteNonQuery();
con.Close();
}
}
}
return null;
}
catch (Exception ee)
{
}
return null;
}
[WebMethod]
public static string SaveData(string empdata)
{
var serializeData = JsonConvert.DeserializeObject<List<Employee>>(empdata);
using (var con = new SqlConnection(Constr))
{
foreach (var data in serializeData)
{
using (var cmd = new SqlCommand("insert into purchase1 values(@ItemName,@batchno,@expdate,@stock,@Qty,@Rate,@total)"))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@ItemName", data.FName);
cmd.Parameters.AddWithValue("@batchno", data.LName);
cmd.Parameters.AddWithValue("@expdate", data.EmailId);
cmd.Parameters.AddWithValue("@stock", data.STOCK);
cmd.Parameters.AddWithValue("@Qty", data.QUANTITY);
cmd.Parameters.AddWithValue("@Rate", data.RATE);
cmd.Parameters.AddWithValue("@total", data.TOTAL);
cmd.Connection = con;
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd.ExecuteNonQuery();
con.Close();
}
}
}
return null;
}
}