public ActionResult Show4Survey2(Survey2 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 Century='" + n.Year + "' WHERE ID=" + ID;
connection.Open();
command.ExecuteNonQuery();
connection.Close();
}
ViewBag.Name = n.Year;
return(RedirectToAction("Survey3"));
}
public ActionResult DeleteConfirmed(int id)
{
Survey2 survey2 = db.Survey2.Find(id);
db.Survey2.Remove(survey2);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Show4Survey2(Survey2 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 Century='" + n.Year + "' WHERE ID=" + ID;
connection.Open();
command.ExecuteNonQuery();
connection.Close();
}
ViewBag.Name = n.Year;
return(RedirectToAction("Index", "Survey3"));
//Queries q = new Queries();
//string portfolio = q.ImageSearch(classification, culture, century);
//ViewBag.ObjectID = portfolio;
//ViewBag.Name = name;
//return View();
}
public ActionResult Edit([Bind(Include = "Classification,ID,Year,ImageUrl")] Survey2 survey2)
{
if (ModelState.IsValid)
{
db.Entry(survey2).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(survey2));
}
public ActionResult Create([Bind(Include = "Classification,ID,Year,ImageUrl")] Survey2 survey2)
{
if (ModelState.IsValid)
{
db.Survey2.Add(survey2);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(survey2));
}
// GET: Survey2/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Survey2 survey2 = db.Survey2.Find(id);
if (survey2 == null)
{
return(HttpNotFound());
}
return(View(survey2));
}
public ActionResult TestSurvey2(Survey2 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 Century = '" + n.Year + "' WHERE ID =(SELECT MAX(ID) FROM [dbo].[HelgesonTestTable])";
connection.Open();
command.ExecuteNonQuery();
connection.Close();
}
//ViewBag.Name = n.Year;
return(View());
}
