public bool SaveBakeryOrder(BakeryOrderModel order) { try { using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand(addOrderBakery_SQL, conn); cmd.Parameters.AddWithValue("@orderName", order.OrderName); cmd.Parameters.AddWithValue("@phoneNumber", order.PhoneNumber); cmd.Parameters.AddWithValue("@pickUpTime", order.PickupTime); cmd.Parameters.AddWithValue("@userInfoId", order.UserInfoId); cmd.Parameters.AddWithValue("@size", order.Size); cmd.Parameters.AddWithValue("@dough", order.Dough); cmd.Parameters.AddWithValue("@icing", order.Icing); cmd.Parameters.AddWithValue("@messageInfo", order.MessageInfo); cmd.Parameters.AddWithValue("@borderTrim", order.BorderTrim); cmd.Parameters.AddWithValue("@kitNumber", order.KitNumber); cmd.Parameters.AddWithValue("@kitName", order.Kitname); cmd.Parameters.AddWithValue("@storeId", order.StoreId); int rowsAffected = cmd.ExecuteNonQuery(); return(rowsAffected > 0); } } catch (SqlException ex) { throw; } }
public ActionResult BakeryOrder(BakeryOrderModel order) { if (order.Kitname == null) { order.Kitname = "n/a"; } OrdersDAL dal = new OrdersDAL(); if (dal.SaveBakeryOrder(order)) { return(RedirectToAction("Orders")); } else { return(View("BakeryOrder", order)); } }
public List <BakeryOrderModel> GetAllBakeryOrdersForStore(int storeId) { List <BakeryOrderModel> output = new List <BakeryOrderModel>(); try { using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand(getBakeryOrdersForStore_SQL, conn); cmd.Parameters.AddWithValue("@storeId", storeId); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { BakeryOrderModel order = new BakeryOrderModel(); order.BorderTrim = Convert.ToString(reader["borderTrim"]); order.Dough = Convert.ToString(reader["dough"]); order.Icing = Convert.ToString(reader["icing"]); order.Id = Convert.ToInt32(reader["id"]); order.IsActive = Convert.ToBoolean(reader["isActive"]); order.Kitname = Convert.ToString(reader["kitName"]); order.KitNumber = Convert.ToInt32(reader["kitNumber"]); order.MessageInfo = Convert.ToString(reader["messageInfo"]); order.PhoneNumber = Convert.ToString(reader["phoneNumber"]); order.OrderName = Convert.ToString(reader["orderName"]); order.OrderTime = Convert.ToDateTime(reader["orderTime"]); order.PickupTime = Convert.ToDateTime(reader["pickUpTime"]); order.Size = Convert.ToString(reader["size"]); order.StoreId = Convert.ToInt32(reader["storeId"]); order.UserInfoId = Convert.ToInt32(reader["userInfoId"]); output.Add(order); } } } catch (SqlException ex) { throw; } return(output); }
public ActionResult BakeryOrder() { BakeryOrderModel model = new BakeryOrderModel(); return(View("BakeryOrder", model)); }