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