public ActionResult DeliOrder(DeliOrderModel order) { OrdersDAL dal = new OrdersDAL(); if (dal.SaveDeliOrder(order)) { return(RedirectToAction("Orders")); } else { return(View("DeliOrder", order)); } }
public IEnumerable <DeliOrderModel> GetDeliOrderModels(int id) { var output = new DeliOrderModel(); OrdersDAL dal = new OrdersDAL(); List <DeliOrderModel> orders = dal.GetAllDeliOrders(); for (int i = 0; i < orders.Count; i++) { if (orders[i].Id == id) { output = orders[i]; } } List <DeliOrderModel> outputt = new List <DeliOrderModel>(); outputt.Add(output); return(outputt); }
public List <DeliOrderModel> GetAllDeliOrdersForStore(int storeId) { List <DeliOrderModel> output = new List <DeliOrderModel>(); try { using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand(getDeliOrdersForStore_SQL, conn); cmd.Parameters.AddWithValue("@storeId", storeId); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { DeliOrderModel order = new DeliOrderModel(); order.Id = Convert.ToInt32(reader["id"]); order.IsActive = Convert.ToBoolean(reader["isActive"]); order.NumberOfPieces = Convert.ToInt32(reader["numberOfPieces"]); order.OrderName = Convert.ToString(reader["orderName"]); order.PhoneNumber = Convert.ToString(reader["phoneNumber"]); order.OrderTime = Convert.ToDateTime(reader["orderTime"]); order.PickUpTime = Convert.ToDateTime(reader["pickUpTime"]); order.StoreId = Convert.ToInt32(reader["storeId"]); order.UserInfoId = Convert.ToInt32(reader["userInfoId"]); output.Add(order); } } } catch (SqlException ex) { throw; } return(output); }
public bool SaveDeliOrder(DeliOrderModel order) { try { using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand(addOrderDeli_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("@numberOfPieces", order.NumberOfPieces); cmd.Parameters.AddWithValue("@storeId", order.StoreId); int rowsAffected = cmd.ExecuteNonQuery(); return(rowsAffected > 0); } } catch (SqlException ex) { throw; } }
public ActionResult DeliOrder() { DeliOrderModel model = new DeliOrderModel(); return(View("DeliOrder", model)); }