public ActionResult Confirmation()
{
ViewModels.orderViewModel model = new ViewModels.orderViewModel();
var details = new ViewModels.eventViewModel();
return(View(model));
}
// GET: Order
public ActionResult Index()
{
if (Session["USER_ID"] == null)
{
return(RedirectToAction("Login", "USER"));
}
else
{
if (Session["ORDER_ID"] == null)
{
Session["ORDER_ID"] = 25;
ViewModels.orderViewModel model = new ViewModels.orderViewModel(25);
return(View(model));
}
else
{
ViewModels.orderViewModel model = new ViewModels.orderViewModel(Convert.ToInt32(Session["ORDER_ID"]));
var details = new ViewModels.eventViewModel();
return(View(model));
}
}
}
// GET: Event/Details/5
public ActionResult View(int id)
{
Session["EVENT_ID"] = id;
try
{
SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
builder.DataSource = "it484.database.windows.net";
builder.UserID = "krandall";
builder.Password = "******";
builder.InitialCatalog = "it484";
SqlConnection myConnection = new SqlConnection(builder.ConnectionString);
try
{
myConnection.Open();
}
catch (Exception e)
{
Console.WriteLine("error happened");
}
StringBuilder sb = new StringBuilder();
System.Diagnostics.Debug.WriteLine(Request.QueryString["id"]);
sb.Append("SELECT * FROM [EVENT] WHERE EVENT_ID='" + id + "'"); //Request.QueryString["id"].ToLower()
// Fetch the user info by their id
String sql = sb.ToString();
using (SqlCommand command = new SqlCommand(sql, myConnection))
{
//command.Parameters.AddWithValue("@time", Convert.ToString(Request.Form["time"]));
using (SqlDataReader reader = command.ExecuteReader())
{
var details = new ViewModels.eventViewModel();
while (reader.Read())
{
details.EVENT_ID = id;
details.EVENT_DATE = (string)reader["EVENT_DATE"];
details.EVENT_TIME = (string)reader["EVENT_TIME"];
details.EVENT_VENUE = (string)reader["EVENT_VENUE"];
details.EVENT_ADDRESS = (string)reader["EVENT_ADDRESS"];
details.EVENT_CITY = (string)reader["EVENT_CITY"];
details.EVENT_STATE = (string)reader["EVENT_STATE"];
details.EVENT_ZIP = (Int32)reader["EVENT_ZIP"];
details.EVENT_COUNTRY = (string)reader["EVENT_COUNTRY"];
details.EVENT_ICON_LOCATION = (string)reader["EVENT_ICON_LOCATION"];
details.EVENT_DESCRIPTION = (string)reader["EVENT_DESCRIPTION"];
details.CATEGORY_ID = (Int32)reader["CATEGORY_ID"];
}
reader.Close();
return(View(details));
}
}
}
catch (Exception e)
{
System.Diagnostics.Debug.WriteLine(e.ToString());
return(View());
}
return(View());
}
