Multiple Row insert in Asp.net.core

Sohag Ahamed

6y7kAJAX

How can I insert multiple row in database and use ajax and it use query Asp.net.core

3 Replies

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

Nazneen Saiyed6y ago
in Controlller
[HttpPost]
[ValidateAntiForgeryToken]
public IActionResult Create(CreateModel model)
{
CreateModel addModel = new CreateModel();
addModel.param1 = model.param1;
addModel.param2 = model.param2;
addModel.param3 = model.param3;
addModel.param4 = model.param4;
_context.CreateModel.Add(addModel);
_context.SaveChanges();
return RedirectToAction(nameof(Index));
}
Ecco Suprastyo6y ago
Hello,

you can use method this for insert data :

1. In controller
[HttpPost]
[ValidateAntiForgeryToken]
public IActionResult Create(CreateModel model)
{
    CreateModel addModel = new CreateModel();
    addModel.param1 = model.param1;
    addModel.param2 = model.param2;
    addModel.param3 = model.param3;
    addModel.param4 = model.param4;
    _context.CreateModel.Add(addModel);
    _context.SaveChanges();

    return RedirectToAction(nameof(Index));
}
3. In Javascript
Siddharth Gajbhiye6y ago
1. public class DBM2BillingViewModel
2. {
3. public List databaseM2List { get; set; }
5. [Display(Name = "Items")]
6. public string Name { get; set; }
8. [Display(Name = "PO Item No.")]
9. public int POItemNo { get; set; }
11. [Display(Name = "Date of Effect")]
12. public DateTime DateOfEffect { get; set; }
14. [Display(Name = "Baseline Volume")]
15. public float baselineVolume { get; set; }
17. [Display(Name = "Billing Month")]
18. public string BillingMonth { get; set; }
20. [Display(Name = "Monthly Device Count")]
21. public float DeviceCount { get; set; }
22. }
24. **Controller**
25. //Get Method
26. public IActionResult Create()
27. {
28. DBM2BillingViewModel dbm2billingVM = new DBM2BillingViewModel();
29. dbm2billingVM.databaseM2List = _context.databaseM2s.ToList();
30. return View(dbm2billingVM);
31. }
33. //Post Method
34. [HttpPost]
35. [ValidateAntiForgeryToken]
36. public IActionResult Create(DBM2BillingViewModel model)
37. {
38. foreach(var dbm2 in model.databaseM2List)
39. {
40. DeviceBilling addModel = new DeviceBilling();
41. addModel.Name = dbm2.Name;
42. addModel.TrackName = "Database M2";
43. addModel.POItemNo = dbm2.POItemNo;
44. addModel.DateOfEffect = dbm2.DateOfEffect;
45. addModel.baselineVolume = dbm2.BaselineVolume;
46. addModel.BillingMonth = model.BillingMonth;
47. addModel.DeviceCount = model.DeviceCount;
48. _context.deviceBillings.Add(addModel);
49. }
50. _context.SaveChanges();
51. return RedirectToAction(nameof(Index));
52. }
53. enter code here
View
@model FinancantPro.Models.DeviceCountModel.DBM2BillingViewModel
@{
    ViewData["Title"] = "Create";
}

class="container">
    class="table table-striped border">

            class="table-info">
                @Html.DisplayName("Item Name")
                @Html.DisplayName("PO Item No#")
                @Html.DisplayName("Date Of Effect")
                @Html.DisplayName("Baseline Volume")
                @Html.DisplayName("Billing Month")
                @Html.DisplayName("Device Count")




            @for (int i = 0; i < Model.databaseM2List.Count; i++)
            {


                        @Html.HiddenFor(d => d.databaseM2List[i].Id)
                        @Html.DisplayFor(d => d.databaseM2List[i].Name)


                        @Html.DisplayFor(d => d.databaseM2List[i].POItemNo)


                        @Html.DisplayFor(d => d.databaseM2List[i].DateOfEffect)


                        @Html.DisplayFor(d => d.databaseM2List[i].BaselineVolume)


                        @Html.TextBoxFor(d => d.BillingMonth, new { @class = "form-control" })


                        @Html.TextBoxFor(d => d.DeviceCount, new { @class = "form-control" })


            }


    class="form-group">
        "submit" class="btn btn-primary" value="Create" />