public ActionResult CreateHouseOrder(FoodOrder houseOrder)
{
ViewBag.MyID = false;
HouseOrder houseOrder1 = new HouseOrder();
houseOrder1.AlpinistID = houseOrder.AlpinistID;
return(View(houseOrder1));
}
public ActionResult CreateHouseOrder([Bind(Include = "AlpinistID,HouseID,DateStart,DateEnd")] HouseOrder houseOrder)
{
if (ModelState.IsValid)
{
ViewBag.MyID = true;
string queryString = "INSERT INTO [HouseOrders] ([AlpinistID], [HouseID], [DateStart], [DateEnd])" +
"VALUES" +
" ("+ houseOrder.AlpinistID + "," + houseOrder.HouseID +
", '" + houseOrder.DateStart.ToString("yyyy-MM-dd") + "', '" + houseOrder.DateEnd.ToString("yyyy-MM-dd") + "')";
SqlConnection connection = new SqlConnection(@"Data Source = VALENTINE\SQLEXPRESS;
Initial Catalog = Coursework; Integrated Security = True");
connection.Open();
SqlCommand command = new SqlCommand(queryString, connection);
command.ExecuteNonQuery();
connection.Close();
return(View(houseOrder));
}
ViewBag.MyID = false;
return(View(houseOrder));
}
