1. Table address
...........................................................................
public partial class address
{
public int address_id { get; set; }
public Nullable<int> user_id { get; set; }
public string user_address { get; set; }
}
............................................................................
[HttpPost]
public JsonResult SaveAddressList(ICollection<address> lstaddress)
{
using (cubitEntities db = new cubitEntities())
{
//var db = new ProductsDBEntities();
// db.Orders.Add(order);
//Order orderid = db.Orders.Find(order.CustomerName);
foreach (var item in lstaddress)
{
// Order orderid = db.Orders.Find(item.OrderId);
// Order orderid = new Order();
// {
//item.OrderId= ;
//orderid.CustomerName = item.CustomerName;
// }
// item.Id = order.OrderId;
db.addresses.Add(item);
}
db.SaveChanges();
}
return Json(true, JsonRequestBehavior.AllowGet);
}
http://localhost:51846/Home/SaveAddressList
lstaddress[0].user_id:2
lstaddress[0].user_address:nepal
lstaddress[1].user_id:3
lstaddress[1].user_address:nepal
lstaddress[2].user_id:4
lstaddress[2].user_address:nepal
---------------------------------------------
-----------------------------------------------------
2. Table::
---------------...............................
public partial class Product
{
public int Id { get; set; }
public Nullable<int> OrderId { get; set; }
public string ProductName { get; set; }
public Nullable<int> ProductRate { get; set; }
}
public partial class Order
{
public int OrderId { get; set; }
public string CustomerName { get; set; }
}
...............................................
[HttpPost]
public JsonResult SaveOrder(Order order, Product[] orditemdetails)
{
var db = new ProductsDBEntities();
db.Orders.Add(order);
Order orderid = db.Orders.Find(order.CustomerName);
foreach (var item in orditemdetails)
{
item.Id = order.OrderId;
db.Products.Add(item);
}
db.SaveChanges();
return Json(true, JsonRequestBehavior.AllowGet);
}
http://localhost:58786/Home/SaveOrder
CustomerName:Sitalmandal
orditemdetails[0].ProductName:Apple
orditemdetails[0].ProductRate:20
orditemdetails[1].ProductName:Banana
orditemdetails[1].ProductRate:20
orditemdetails[2].ProductName:Banana
orditemdetails[2].ProductRate:20
...........................................................................
public partial class address
{
public int address_id { get; set; }
public Nullable<int> user_id { get; set; }
public string user_address { get; set; }
}
............................................................................
[HttpPost]
public JsonResult SaveAddressList(ICollection<address> lstaddress)
{
using (cubitEntities db = new cubitEntities())
{
//var db = new ProductsDBEntities();
// db.Orders.Add(order);
//Order orderid = db.Orders.Find(order.CustomerName);
foreach (var item in lstaddress)
{
// Order orderid = db.Orders.Find(item.OrderId);
// Order orderid = new Order();
// {
//item.OrderId= ;
//orderid.CustomerName = item.CustomerName;
// }
// item.Id = order.OrderId;
db.addresses.Add(item);
}
db.SaveChanges();
}
return Json(true, JsonRequestBehavior.AllowGet);
}
http://localhost:51846/Home/SaveAddressList
lstaddress[0].user_id:2
lstaddress[0].user_address:nepal
lstaddress[1].user_id:3
lstaddress[1].user_address:nepal
lstaddress[2].user_id:4
lstaddress[2].user_address:nepal
---------------------------------------------
-----------------------------------------------------
2. Table::
---------------...............................
public partial class Product
{
public int Id { get; set; }
public Nullable<int> OrderId { get; set; }
public string ProductName { get; set; }
public Nullable<int> ProductRate { get; set; }
}
public partial class Order
{
public int OrderId { get; set; }
public string CustomerName { get; set; }
}
...............................................
[HttpPost]
public JsonResult SaveOrder(Order order, Product[] orditemdetails)
{
var db = new ProductsDBEntities();
db.Orders.Add(order);
Order orderid = db.Orders.Find(order.CustomerName);
foreach (var item in orditemdetails)
{
item.Id = order.OrderId;
db.Products.Add(item);
}
db.SaveChanges();
return Json(true, JsonRequestBehavior.AllowGet);
}
http://localhost:58786/Home/SaveOrder
CustomerName:Sitalmandal
orditemdetails[0].ProductName:Apple
orditemdetails[0].ProductRate:20
orditemdetails[1].ProductName:Banana
orditemdetails[1].ProductRate:20
orditemdetails[2].ProductName:Banana
orditemdetails[2].ProductRate:20
No comments:
Post a Comment