public ActionResult CreateActivity(int i = 0)
        {
            DateTime startTime = new DateTime();
            DateTime endTime   = new DateTime();

            string  name        = Request.Form[1];
            string  description = Request.Form[2];
            int     capacity    = int.Parse(Request.Form[3]);
            decimal price       = decimal.Parse(Request.Form[4]);

            if (DateTime.TryParse(Request.Form[5].ToString(), out DateTime resultStartTime))
            {
                startTime = resultStartTime;
            }
            if (DateTime.TryParse(Request.Form[6].ToString(), out DateTime resultEndTime))
            {
                endTime = resultEndTime;
            }
            int subjectId = int.Parse(Request.Form[7]);

            switch (subjectId)
            {
            //Jazz
            case 5:
                Jazz jazz = new Jazz {
                    Name = name, Description = description, Capacity = capacity, Price = price, StartTime = startTime, EndTime = endTime, LocationId = 21, SubjectId = subjectId
                };
                activityRepo.Insert(jazz);
                break;

            //Talking
            case 6:
                Talking talking = new Talking {
                    Name = name, Description = description, Capacity = capacity, Price = price, StartTime = startTime, EndTime = endTime, LocationId = 22, SubjectId = subjectId
                };
                activityRepo.Insert(talking);
                break;

            //Historic
            case 7:

                Walking walking = new Walking {
                    Name = name, Description = description, Capacity = capacity, Price = price, StartTime = startTime, EndTime = endTime, LocationId = 23, SubjectId = subjectId
                };
                activityRepo.Insert(walking);
                break;

            //Dining
            case 8:
                Dining dining = new Dining {
                    Name = name, Description = description, Capacity = capacity, Price = price, StartTime = startTime, EndTime = endTime, LocationId = 23, SubjectId = subjectId
                };
                activityRepo.Insert(dining);
                break;
            }

            return(RedirectToAction("ActivityDetails"));
        }
        public static IList<Dining1> GetRestaurants()
        {
            IList<Dining1> restaurants;
            using (var context = new Dining(ConnectionString))
            {
                restaurants = (from Dining1 d in context.Restaurants select d).ToList();
            }

            return restaurants;
        }
        public static IList <Dining1> GetRestaurants()
        {
            IList <Dining1> restaurants;

            using (var context = new Dining(ConnectionString))
            {
                restaurants = (from Dining1 d in context.Restaurants select d).ToList();
            }

            return(restaurants);
        }
 public static void DeleteDatabase()
 {
     using (var context = new Dining(ConnectionString))
     {
         if (context.DatabaseExists())
         {
             // delete database if it exist
             context.DeleteDatabase();
         }
     }
 }
 public static void CreateDatabase()
 {
     using (var context = new Dining(ConnectionString))
     {
         if (!context.DatabaseExists())
         {
             // create database if it does not exist
             context.CreateDatabase();
         }
     }
 }
 public static void DeleteDatabase()
 {
     using (var context = new Dining(ConnectionString))
     {
         if (context.DatabaseExists())
         {
             // delete database if it exist
             context.DeleteDatabase();
         }
     }
 }
 public static void CreateDatabase()
 {
     using (var context = new Dining(ConnectionString))
     {
         if (!context.DatabaseExists())
         {
             // create database if it does not exist
             context.CreateDatabase();
         }
     }
 }
Beispiel #8
0
        public ActionResult OrderDiningTicket(int id, int amount)
        {
            Dining dining = diningRepository.GetById(id);
            Ticket ticket = CreateTicketFromActivity(dining, amount);

            if (amount != 0)
            {
                shoppingCart.AddTicket(ticket);
            }
            else
            {
                ModelState.AddModelError("Please set a correct amount.", new ArgumentException("Incorrect ticket amount"));
            }

            return(Dining());
        }
        public bool CreateDining(DiningCreate model)
        {
            var entity =
                new Dining()
            {
                Id = model.Id,
                NameOfRestaurant  = model.NameOfRestaurant,
                Location          = model.Location,
                ReservationTime   = model.ReservationTime,
                ReservationNumber = model.ReservationNumber,
            };

            using (var ctx = new ApplicationDbContext())
            {
                ctx.Dinings.Add(entity);
                return(ctx.SaveChanges() == 1);
            }
        }
Beispiel #10
0
        protected void btnSave_Click(object sender, EventArgs e)
        {
            Dining dining = new Dining();

            dining.Name = txtAddDining.Text;

            db.Dinings.InsertOnSubmit(dining);

            db.SubmitChanges();
            this.gvDining.DataBind();

            //audit trail
            DBLogger.Log("Create", "Create Dining ", dining.Name);

            System.Text.StringBuilder sb = new System.Text.StringBuilder();
            sb.Append(@"<script type='text/javascript'>");
            sb.Append("$('#addModal').modal('hide');");
            sb.Append(@"</script>");
            ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "HideShowModalScript", sb.ToString(), false);
        }