Monday, 27 February 2017

List of Object

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

No comments:

Post a Comment