public async Task <IHttpActionResult> Putproductservice(int id, productservice productservice)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            if (id != productservice.id)
            {
                return(BadRequest());
            }

            db.Entry(productservice).State = EntityState.Modified;

            try
            {
                await db.SaveChangesAsync();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!productserviceExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(StatusCode(HttpStatusCode.NoContent));
        }
        public ActionResult DeleteConfirmed(int id)
        {
            productservice productservice = db.productservice.Find(id);

            db.productservice.Remove(productservice);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
        // POST: api/productservices
        public IHttpActionResult Postproductservice(productservice productservice)
        {
            db.Configuration.LazyLoadingEnabled = false;

            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }
            productservice.status = 1;
            try
            {
                if (productservice.image != null)
                {
                    var    myString = productservice.image.Split(new char[] { ',' });
                    byte[] bytes    = Convert.FromBase64String(myString[1]); using (MemoryStream ms = new MemoryStream(bytes))
                    {
                        try
                        {
                            string formatted = DateTime.Now.ToString("dd-M-yyyy");
                            var    id        = db.productservice.Max(p => p.id) + 1;
                            string name      = id + "_" + productservice.name + formatted + ".jpg";
                            //      Image image = Image.FromStream(ms);
                            string path1 = string.Format("{0}/{1}{2}", System.Web.HttpContext.Current.Server.MapPath("~/Images"), "image_", name);


                            productservice.image = "image_" + name;
                            //                        image.Save("./Image.jpg", ImageFormat.Jpeg);
                            File.WriteAllBytes(path1, bytes);
                        }
                        catch (Exception ce)
                        {
                            Console.WriteLine("");
                        }
                    }
                }

                db.productservice.Add(productservice);
                db.SaveChanges();
            }
            catch (DbEntityValidationException e)
            {
                foreach (var eve in e.EntityValidationErrors)
                {
                    Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
                                      eve.Entry.Entity.GetType().Name, eve.Entry.State);
                    foreach (var ve in eve.ValidationErrors)
                    {
                        Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
                                          ve.PropertyName, ve.ErrorMessage);
                    }
                }
                throw;
            }
            return(CreatedAtRoute("DefaultApi", new { id = productservice.id }, productservice));
        }
        public async Task <IHttpActionResult> stateproducto(int idproducto, int state)
        {
            db.Configuration.LazyLoadingEnabled = false;

            productservice productservice = await db.productservice.FindAsync(idproducto);

            productservice.status          = state;
            db.Entry(productservice).State = EntityState.Modified;
            db.SaveChanges();
            return(Ok(productservice));
        }
        public IHttpActionResult Deleteproductservice(int id)
        {
            productservice productservice = db.productservice.Find(id);

            if (productservice == null)
            {
                return(NotFound());
            }

            db.productservice.Remove(productservice);
            db.SaveChanges();

            return(Ok(productservice));
        }
        public ActionResult Delete(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            productservice productservice = db.productservice.Find(id);

            if (productservice == null)
            {
                return(HttpNotFound());
            }
            return(View(productservice));
        }
 public ActionResult Edit([Bind(Include = "id,type,idcategory,idowner,name,description,dateup,status,schedule,image")] productservice productservice)
 {
     if (ModelState.IsValid)
     {
         db.Entry(productservice).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.idcategory = new SelectList(db.category, "id", "name", productservice.idcategory);
     ViewBag.status     = new SelectList(db.user_state, "id", "name", productservice.status);
     ViewBag.type       = new SelectList(db.type_ps, "id", "name", productservice.type);
     ViewBag.idowner    = new SelectList(db.userapp, "id", "id_card", productservice.idowner);
     return(View(productservice));
 }
        public ActionResult Details(int?id)
        {
            db.Configuration.LazyLoadingEnabled = true;

            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            productservice productservice = db.productservice.Find(id);

            if (productservice == null)
            {
                return(HttpNotFound());
            }
            return(View(productservice));
        }
        public async Task <IHttpActionResult> rateProduct(int idpproducto, int value, string comment)
        {
            qualificationps rate = new qualificationps();

            rate.idproduct = idpproducto;
            rate.value     = value;
            rate.comment   = comment;
            rate.dateup    = DateTime.Now;
            db.qualificationps.Add(rate);
            db.SaveChanges();
            db.Configuration.LazyLoadingEnabled = false;

            productservice product = db.productservice.Find(idpproducto);

            product.calification    = productqualitity(idpproducto);
            db.Entry(product).State = EntityState.Modified;
            db.SaveChanges();

            return(Ok(rate));
        }
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            productservice productservice = db.productservice.Find(id);

            if (productservice == null)
            {
                return(HttpNotFound());
            }

            db.Configuration.LazyLoadingEnabled = true;
            ViewBag.idcategory = new SelectList(db.category, "id", "name", productservice.idcategory);
            ViewBag.status     = new SelectList(db.user_state, "id", "name", productservice.status);
            ViewBag.type       = new SelectList(db.type_ps, "id", "name", productservice.type);
            ViewBag.idowner    = new SelectList(db.userapp, "id", "id_card", productservice.idowner);
            return(View(productservice));
        }