예제 #1
0
        public ActionResult NewSale(FormCollection form)
        {
            var user      = User.Identity;
            var a         = 0;
            var salesHead = new Sales_Header();


            var sellerName = context.Users.Find(user.GetUserId()).UserName;
            var buyerName  = context.Users.Find(user.GetUserId()).UserName;

            salesHead.Sale_Date   = DateTime.Now;
            salesHead.Seller_Id   = user.GetUserId();
            salesHead.Seller_Name = sellerName;
            salesHead.Buyer_Name  = buyerName;


            context.Sales_Headers.Add(salesHead);
            context.SaveChanges();

            a = 1;

            //Sale Detail Process

            string[] itemNamesArr, itemPrcsArr, itemQtyArr, itemIdArr;
            itemNamesArr = form["ItemName"].Split(',');
            itemPrcsArr  = form["ItemPrice"].Split(',');
            itemQtyArr   = form["QtyRqstd"].Split(',');
            itemIdArr    = form["ItemId"].Split(',');
            var itemCount = itemNamesArr.Count();

            var saleDetail     = new Sales_Detail();
            var saleDetailList = new List <Sales_Detail>();


            for (int i = 0; i < itemCount; i++)
            {
                saleDetail.ItemName        = itemNamesArr[i];
                saleDetail.Qty             = Convert.ToInt32(itemQtyArr[i]);
                saleDetail.Price           = Convert.ToDecimal(itemPrcsArr[i]);
                saleDetail.Sales_Header_id = salesHead.Id;
                saleDetail.Item_id         = Convert.ToInt32(itemIdArr[i]);
                context.Sales_Details.Add(saleDetail);
                context.SaveChanges();
            }



            a = 2;



            return(RedirectToAction("Index", "Users"));
        }
예제 #2
0
        public HttpResponseMessage Sale(Sales_Detail sale)
        {
            try
            {
                var dt = sale.Sale_Date;
                db.Sales_Detail.Add(sale);

                var x = db.Items.FirstOrDefault(xn => xn.Item_No == sale.Item_No);
                x.Quantity        = x.Quantity - sale.Item_Quantity;
                db.Entry(x).State = EntityState.Modified;
                db.SaveChanges();

                return(Request.CreateResponse(HttpStatusCode.OK, sale));
            }catch (Exception ex)
            {
                return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message));
            }
        }