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());
}
}
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));
}
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());
}
}