Пример #1
0
        // GET: Default/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }

            string  query = "SELECT Contact_ID, Name, Email, DOB FROM My_Gmail_Contacts WHERE Contact_ID = " + id + ";";
            DataSet ds    = My_Contacts.SendDataSet(query);

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

            My_Contacts contact = new My_Contacts();

            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                contact = new My_Contacts {
                    Contact_ID = Convert.ToInt32(dr["Contact_ID"]), Name = Convert.ToString(dr["Name"]), Email = Convert.ToString(dr["Email"]), DOB = Convert.ToString(dr["DOB"])
                };
            }

            return(View(contact));
        }
Пример #2
0
        public ActionResult DeleteConfirmed(int id)
        {
            try
            {
                // TODO: Add delete logic here
                //Movie movie = db.Movies.Find(id);
                string query = "DELETE FROM My_Gmail_Contacts WHERE Contact_ID = " + id + ";";
                My_Contacts.ExecuteCommand(query);

                return(RedirectToAction("Index"));
            }
            catch
            {
                return(View());
            }
        }
Пример #3
0
        // GET: Default
        public ActionResult Index()
        {
            string query = "SELECT Contact_ID, Name, Email, DOB FROM My_Gmail_Contacts ORDER BY Contact_ID";

            DataSet ds = My_Contacts.SendDataSet(query);

            List <My_Contacts> My_ContactsList = new List <My_Contacts>();

            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                My_ContactsList.Add(new My_Contacts {
                    Contact_ID = Convert.ToInt32(dr["Contact_ID"]), Name = Convert.ToString(dr["Name"]), Email = Convert.ToString(dr["Email"]), DOB = Convert.ToString(dr["DOB"])
                });
            }

            return(View(My_ContactsList));
        }
Пример #4
0
        public ActionResult Edit(int id, [Bind(Include = "Contact_ID,Name,Email,DOB")] My_Contacts contact)
        {
            try
            {
                // TODO: Add update logic here
                if (ModelState.IsValid)
                {
                    string query = "UPDATE My_Gmail_Contacts SET Name = '" + contact.Name + "', Email= '" + contact.Email + "', DOB = '" + contact.DOB + "' WHERE Contact_ID = " + id + ";";
                    My_Contacts.ExecuteCommand(query);

                    return(RedirectToAction("Index"));
                }
            }
            catch
            {
                return(View(contact));
            }
            return(View(id));
        }
Пример #5
0
        public ActionResult Create(My_Contacts My_Contacts)
        {
            try
            {
                if (ModelState.IsValid)
                {
                    //string query = "INSERT INTO My_Gmail_Contacts(Name,DOB,Email) VALUES('" + My_Contacts.Name + "','" + My_Contacts.DOB + "','" + My_Contacts.Email + "')";
                    Dictionary <string, object> data = new Dictionary <string, object>();
                    data.Add("Name", My_Contacts.Name);
                    data.Add("DOB", My_Contacts.DOB);
                    data.Add("Email", My_Contacts.Email);

                    My_Contacts.ExecuteCommand("Add_Contact", data);
                }

                return(RedirectToAction("Index"));
            }
            catch
            {
                return(View());
            }
        }