Exemplo n.º 1
0
        public IHttpActionResult GetI_OrderDetails(int id)
        {
            I_StockInventory             obj    = new I_StockInventory();
            IEnumerable <I_VenderMaster> vendor = db.I_VenderMaster;
            List <Orders> i_OrderDetailsNew     = new List <Orders>();
            List <Orders> i_OrderDetails        = db.I_OrderItemCatalog.Where(X => X.OrderId == id).Select(x => new Orders()
            {
                Id              = x.Id,
                OrderId         = x.OrderId,
                OrderName       = x.I_OrderDetails.OrderNo,
                ItemsId         = x.ItemsId,
                ItemName        = x.ItemName,
                Price           = x.Price,
                onHand          = x.onHand,
                onOrder         = x.onOrder,
                Qty             = x.Qty,
                Unit            = x.Unit,
                UnitName        = x.I_UnitMaster.UnitName,
                VendorName      = (from v in vendor where v.Id.ToString() == x.Vendor.ToString() select v.VenderName).FirstOrDefault(),
                VendorId        = x.Vendor,
                Status          = x.Status,
                TotalSum        = x.TotalSum,
                Createdby       = x.Createdby,
                CreatedOn       = x.CreatedOn,
                ModifiedBy      = x.ModifiedBy,
                ModifiedOn      = x.ModifiedOn,
                FixedorVariable = x.FixedorVariable,
            }).ToList();

            if ((i_OrderDetails == null) && (i_OrderDetails.Count == 0))
            {
                return(NotFound());
            }
            return(Ok(i_OrderDetails));
        }
Exemplo n.º 2
0
      public async Task <ActionResult> AddItems1(List <Ordertems> listObject)
      {
          bool success = false;

          I_StockInventory        obj;
          List <I_StockInventory> list = new List <I_StockInventory>();

          foreach (Ordertems objItem in listObject)
          {
              obj               = new I_StockInventory();
              obj.OrderNo       = objItem.OrderNo;
              obj.BusinessDate  = (objItem.BusinessDate);
              obj.Ref           = (objItem.Ref);
              obj.ReceiptNo     = objItem.ReceiptNo;
              obj.DiscountType  = objItem.DiscountType;
              obj.DiscountValue = objItem.DiscountValue;
              obj.ItemId        = objItem.itemId;
              obj.ItemName      = objItem.ItemName;
              obj.NetTotal      = objItem.NetTotal;
              obj.OrderType     = 1;// 1 mean Recieved Items
              obj.Price         = objItem.Price;
              obj.Qty           = objItem.Qty;
              obj.Tax           = objItem.Tax;
              obj.TotalAmount   = objItem.TotalAmount;
              obj.UnitId        = objItem.UnitId;
              obj.UnitName      = objItem.UnitName;
              obj.VendorId      = objItem.VendorId;
              obj.CreatedBy     = System.Web.HttpContext.Current.User.Identity.Name;
              obj.CreatedOn     = System.DateTime.Now;
              obj.StoreId       = objItem.StoreId;
              list.Add(obj);
          }
          url = uri + "/api/RecievingItemCatalog/PostItems";
          client.BaseAddress = new Uri(url);

          HttpResponseMessage responseMessage = await client.PostAsJsonAsync(url, list);

          if (responseMessage.IsSuccessStatusCode)
          {
              var responseData = responseMessage.Content.ReadAsStringAsync().Result;

              success = true;
          }
          if (success)
          {
              return(Json(new
                {
                    success = true
                },
                          JsonRequestBehavior.AllowGet));
          }
          return(Json(new
            {
                success = false
            },
                      JsonRequestBehavior.AllowGet));
      }