public ActionResult DeleteContact(int id)
 {
     using (TestBaseEntities dc = new TestBaseEntities())
     {
         var v = dc.Contacts.Where(a => a.ContactID.Equals(id)).FirstOrDefault();
         if (v != null)
         {
             dc.Contacts.Remove(v);
             dc.SaveChanges();
             return(RedirectToAction("Index"));
         }
         else
         {
             return(HttpNotFound());
         }
     }
 }
        public ActionResult Save(Contact c)
        {
            string message = "";
            bool   status  = false;

            //Save
            if (ModelState.IsValid)
            {
                using (TestBaseEntities dc = new TestBaseEntities())
                {
                    if (c.ContactID > 0)
                    {
                        //Update
                        var v = dc.Contacts.Where(a => a.ContactID.Equals(c.ContactID)).FirstOrDefault();
                        if (v != null)
                        {
                            v.ContactPerson = c.ContactPerson;
                            v.ContactNo     = c.ContactNo;
                            v.CountryID     = c.CountryID;
                            v.StateID       = c.StateID;
                        }
                        else
                        {
                            return(HttpNotFound());
                        }
                    }
                    else
                    {
                        //Add new
                        dc.Contacts.Add(c);
                    }
                    dc.SaveChanges();
                    status = true;
                    return(RedirectToAction("Index"));
                }
            }
            else
            {
                message           = "Error! Please try again.";
                ViewBag.Countries = new SelectList(GetCountry(), "CountryID", "CountryName", c.CountryID);
                ViewBag.States    = new SelectList(GetState(), "StateID", "StateName", c.StateID);
            }
            ViewBag.Message = message;
            ViewBag.Status  = status;
            return(View(c));
        }