public ActionResult Show4Survey3(Survey3 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 Culture='" + n.Genre + "' WHERE ID=" + ID;
connection.Open();
command.ExecuteNonQuery();
connection.Close();
}
ViewBag.Name = n.Genre;
return(RedirectToAction("Show4Survey", "Home"));
}
public ActionResult DeleteConfirmed(int id)
{
Survey3 survey3 = db.Survey3.Find(id);
db.Survey3.Remove(survey3);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Classification,ID,Century,Genre,ImageUrl")] Survey3 survey3)
{
if (ModelState.IsValid)
{
db.Entry(survey3).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(survey3));
}
public ActionResult Create([Bind(Include = "Classification,ID,Century,Genre,ImageUrl")] Survey3 survey3)
{
if (ModelState.IsValid)
{
db.Survey3.Add(survey3);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(survey3));
}
public ActionResult Show4Survey3(Survey3 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 Culture='" + n.Genre + "' WHERE ID=" + ID;
connection.Open();
command.ExecuteNonQuery();
connection.Close();
}
ViewBag.Name = n.Genre;
return(RedirectToAction("Index", "Survey3"));
}
// GET: Survey3/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Survey3 survey3 = db.Survey3.Find(id);
if (survey3 == null)
{
return(HttpNotFound());
}
return(View(survey3));
}
