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")); } }
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")); } }