public string Delete(Retailer st)
        {
            if (db == null)
            {
                db = new RouteOptimizationDBEntities();
            }

            db.Retailers.Remove(st);
            db.SaveChanges();
            return "";
        }
        public ActionResult Create(int ID, string Name, string RetailerNumber, string EmailID, string Phone)
        {
            Retailer ret=new Retailer();
            if (!ID.Equals(0))
            {
                ret.RetailerID = ID;
            }

            ret.Name = Name;
            ret.RetailerNumber = RetailerNumber;
            ret.EmailID = EmailID;
            ret.Phone = Phone;
               // ret.AddressID = AddressID;

            RetailerDAL retailerBO = new RetailerDAL();
            retailerBO.AddorUpdate(ret);

            return RedirectToAction("Index");
        }
        public IEnumerable<Retailer> AddorUpdate(Retailer rt)
        {
            if (db == null)
            {
                db = new RouteOptimizationDBEntities();
            }

            if (rt.RetailerID > 0)
            {
                Retailer retailer;
                retailer = GetById(rt.RetailerID);
                db.Entry(retailer).CurrentValues.SetValues(rt);

            }
            else
            {
                db.Retailers.Add(rt);
            }
            db.SaveChanges();
            return db.Retailers.ToList();
        }