public ActionResult Update(ClientProducer producer)
        {
            var prod = CSDLQLBH.GetSingleProducer(producer.ProducerID);

            prod.ProducerName = producer.ProducerName;
            CSDLQLBH.UpdateProducer(prod);
            return(RedirectToAction("Index"));
        }
        // GET: ManagerProducer/Update
        public ActionResult Update(int id)
        {
            var prod = CSDLQLBH.GetSingleProducer(id);

            return(View(prod));
        }