public IActionResult SaveService(ChurchDay churchDay)
        {
            try
            {
                churchDay.DateCreated          = DateTime.Now;
                churchDay.RegistrationDeadline = churchDay.RegistrationDeadline.Value.AddHours(churchDay.RegistrationDeadlineTime.Value.Hour);
                churchDay.RegistrationDeadline = churchDay.RegistrationDeadline.Value.AddMinutes(churchDay.RegistrationDeadlineTime.Value.Minute);

                db.ChurchDay.Add(churchDay);
                db.SaveChanges();

                return(Json("success"));
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex);
                return(Json("error"));
            }
        }
Esempio n. 2
0
        public IActionResult SaveService(ChurchDay churchDay)
        {
            try
            {
                churchDay.DateCreated          = DateTime.Now;
                churchDay.RegistrationDeadline = churchDay.RegistrationDeadline.Value.AddHours(churchDay.RegistrationDeadlineTime.Value.Hour);
                churchDay.RegistrationDeadline = churchDay.RegistrationDeadline.Value.AddMinutes(churchDay.RegistrationDeadlineTime.Value.Minute);

                //here we are subtracting 3 hours because of the time difference in the server
                //churchDay.RegistrationDeadline = churchDay.RegistrationDeadline.Value.AddHours(-3);

                db.ChurchDay.Add(churchDay);
                db.SaveChanges();

                //here we get all permanent members and add them to this added service
                var permementMembers = db.PermanentMember.ToList();

                if (churchDay.NoOfServices > 0)
                {
                    foreach (var member in permementMembers)
                    {
                        for (int i = 1; i <= churchDay.NoOfServices; i++)
                        {
                            var actualMember = new Member()
                            {
                                Age         = member.Age,
                                DateCreated = DateTime.Now,
                                FullName    = member.FullName,
                                Gender      = member.Gender,
                                PhoneNumber = member.PhoneNumber,
                                Residence   = member.Residence
                            };

                            db.Members.Add(actualMember);
                            db.SaveChanges();


                            ServiceBooked serviceBooked = new ServiceBooked()
                            {
                                ChurchDayId = churchDay.Id,
                                MemberId    = actualMember.Id,
                                ServiceNo   = i,
                                DateCreated = DateTime.Now,
                                SeatNo      = member.SeatNo
                            };

                            db.ServiceBooked.Add(serviceBooked);
                        }
                    }
                }

                db.SaveChanges();


                return(Json("success"));
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex);
                return(Json("error"));
            }
        }