Esempio n. 1
0
        public JsonResult addSellsOrderItems(SellsOrderItems soi)
        {
            //Adding the SellsOrderItems
            soiAdd.addSellsOrderItems(soi);
            var response = " Sucessfully Save SellsOrderItems No : " + soi.Invoice_Id;

            return(Json(response, JsonRequestBehavior.AllowGet));
        }
Esempio n. 2
0
        public void updateSellsOrderItems(SellsOrderItems soi)
        {
            string command = "dbo.spInsertProductType";

            SqlParameter[] param = new SqlParameter[7];
            param[0] = new SqlParameter("@Invoice_Id", soi.Invoice_Id);
            param[1] = new SqlParameter("@product_Id", soi.product_Id);
            param[2] = new SqlParameter("@quantity", soi.quantity);
            param[3] = new SqlParameter("@unit_price", soi.unit_price);
            param[4] = new SqlParameter("@discount_price", soi.discount_price);
            param[5] = new SqlParameter("@total_ammount", soi.total_price);
            param[6] = new SqlParameter("@CreatedAt", soi.CreatedAt);
            da.InsertSP(param, command);
        }
Esempio n. 3
0
        public void addSellsOrderItems(SellsOrderItems soi)
        {
            string command = "dbo.spInsertSellOrderItems";

            SqlParameter[] param = new SqlParameter[7];
            param[0] = new SqlParameter("@Invoice_Id", soi.Invoice_Id);
            param[1] = new SqlParameter("@Invoice_number", soi.Invoice_number);
            param[2] = new SqlParameter("@product_id", soi.product_Id);
            param[3] = new SqlParameter("@quantity", soi.quantity);
            param[4] = new SqlParameter("@unit_price", soi.unit_price);
            param[5] = new SqlParameter("@discount_price", soi.discount_price);
            param[6] = new SqlParameter("@total_ammount", soi.total_price);
            da.InsertSP(param, command);
        }