public ActionResult Show4Survey1(Survey1 n) { int ID = 0; SqlConnectionStringBuilder builder = ConnString(); using (SqlConnection connection = new SqlConnection(builder.ConnectionString)) { connection.Open(); String sql = DBQuery(); using (SqlCommand command = new SqlCommand(sql, connection)) { using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { ID = reader.GetInt32(0); } } } } using (SqlConnection connection = new SqlConnection(builder.ConnectionString)) using (SqlCommand command = connection.CreateCommand()) { command.CommandText = "UPDATE [dbo].[UserInfo] SET Classification='" + n.Medium + "' WHERE ID=" + ID; connection.Open(); command.ExecuteNonQuery(); connection.Close(); } return(RedirectToAction("Survey2")); }
public ActionResult Show4Survey1(Survey1 n) { int ID = 0; string name = ""; string classification = ""; string culture = ""; string century = ""; SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(); builder.DataSource = "artserverfinal.database.windows.net"; builder.UserID = "finalproject"; builder.Password = "******"; builder.InitialCatalog = "ArtInfo"; using (SqlConnection connection = new SqlConnection(builder.ConnectionString)) { connection.Open(); StringBuilder sb = new StringBuilder(); sb.Append("SELECT TOP 1 [ID], [Name], [Classification], [Culture], [Century] "); sb.Append("FROM [dbo].[UserInfo] "); sb.Append("ORDER BY [ID] DESC"); String sql = sb.ToString(); using (SqlCommand command = new SqlCommand(sql, connection)) { using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { ID = reader.GetInt32(0); name = reader.GetString(1); //classification = reader.GetString(2); //culture = reader.GetString(3); //century = reader.GetString(4); } } } } using (SqlConnection connection = new SqlConnection(builder.ConnectionString)) using (SqlCommand command = connection.CreateCommand()) { command.CommandText = "UPDATE [dbo].[UserInfo] SET Classification='" + n.Medium + "' WHERE ID=" + ID; connection.Open(); command.ExecuteNonQuery(); connection.Close(); } //ViewBag.Name = n.Year; return(RedirectToAction("Index", "Survey2")); //return View("../Survey2/Index"); //Queries q = new Queries(); //string portfolio = q.ImageSearch(classification, culture, century); //ViewBag.ObjectID = portfolio; //ViewBag.Name = name; //return View(); }
public ActionResult DeleteConfirmed(string id) { Survey1 survey1 = db.Survey1.Find(id); db.Survey1.Remove(survey1); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Medium,ImageUrl")] Survey1 survey1) { if (ModelState.IsValid) { db.Entry(survey1).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(survey1)); }
public ActionResult Create([Bind(Include = "Medium,ImageUrl")] Survey1 survey1) { if (ModelState.IsValid) { db.Survey1.Add(survey1); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(survey1)); }
// GET: Survey1/Edit/5 public ActionResult Edit(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Survey1 survey1 = db.Survey1.Find(id); if (survey1 == null) { return(HttpNotFound()); } return(View(survey1)); }
public ActionResult TestSurvey(Survey1 n) { SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(); builder.DataSource = "artserverfinal.database.windows.net"; builder.UserID = "finalproject"; builder.Password = "******"; builder.InitialCatalog = "ArtInfo"; using (SqlConnection connection = new SqlConnection(builder.ConnectionString)) using (SqlCommand command = connection.CreateCommand()) { command.CommandText = "UPDATE [dbo].[HelgesonTestTable] SET Classification = '" + n.Medium + "' WHERE ID =(SELECT MAX(ID) FROM [dbo].[HelgesonTestTable])"; connection.Open(); command.ExecuteNonQuery(); connection.Close(); } ViewBag.Name = n.Medium; return(View("../Survey2/Index")); }
//[HttpPost] //[ValidateAntiForgeryToken] public ActionResult ClassEdit([Bind(Include = "ID,Classification")] UserInfo userInfo, Survey1 clsurv) { if (ModelState.IsValid) { db.Entry(userInfo).State = EntityState.Modified; clsurv.Medium = userInfo.Classification; //userInfo = db.UserInfoes.Find(ID); db.UserInfoes.Add(userInfo); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(userInfo)); }