public IActionResult EmailNotification(int id)
{
//MimeMessage message = new MimeMessage();
//MailboxAddress from = new MailboxAddress("User", "*****@*****.**");
//message.From.Add(from);
//MailboxAddress to = new MailboxAddress("Leader", "*****@*****.**");
//message.To.Add(to);
//message.Subject = "This is email subject";
//BodyBuilder bodyBuilder = new BodyBuilder();
//bodyBuilder.HtmlBody = "<h1>Hello World!</h1>";
//bodyBuilder.TextBody = "Hello World!";
//message.Body = bodyBuilder.ToMessageBody();
//SmtpClient client = new SmtpClient();
//client.Connect("Mail.yahoo.com", 587, true);
//client.Authenticate("*****@*****.**", "goldbook497");
//client.Send(message);
//client.Disconnect(true);
//client.Dispose();
var context = new OnlineWebPortalDbContext();
var join = new RegUserChurchGroup();
if (ModelState.IsValid)
{
var user = context.RegUsers.Where(u => u.FirstName == User.Identity.Name).Single();
join.ChurchGroupID = id;
join.RegUserID = user.ID;
context.Add(join);
context.SaveChanges();
ViewData["message"] = "Registration was successful!";
return(RedirectToAction("FindGroup", "Group"));
}
return(RedirectToAction("Portal", "Home"));
}
public IActionResult CreateEvent(CreateEventViewModel input)
{
var context = new OnlineWebPortalDbContext();
Event myEvent = new Event();
if (ModelState.IsValid)
{
try
{
myEvent.EventDate = input.EventDate;
myEvent.EventName = input.EventName;
myEvent.Description = input.Description;
context.Add(myEvent);
context.SaveChanges();
TempData["successMessage"] = " Event has been created successfully";
return(RedirectToAction("EventList", "Event"));
}
catch (Exception ex)
{
TempData["failMessage"] = " Oops! Something went wrong" + ex.Message;
return(RedirectToAction("EventList", "Event"));
}
}
return(View());
}
public IActionResult GroupDetail(int id)
{
var context = new OnlineWebPortalDbContext();
ChurchGroup group = context.ChurchGroups.Single(g => g.ID == id);
return(View(group));
}
public IActionResult EventDetail(int id)
{
var context = new OnlineWebPortalDbContext();
var myEvent = context.Events.Where(e => e.ID == id).SingleOrDefault();
return(View(myEvent));
}
public IActionResult Payment()
{
var context = new OnlineWebPortalDbContext();
List <Payment> payments = context.Payments.ToList();
return(View(payments));
}
public IActionResult EventList()
{
var context = new OnlineWebPortalDbContext();
var eve = context.Events.ToList();
return(View(eve));
}
public IActionResult Users(string sortField, string currentSortField, string currentSortOrder, string currentFilter, string SearchString,
int?pageNum)
{
var context = new OnlineWebPortalDbContext();
var users = context.RegUsers
.ToList();
if (SearchString != null)
{
pageNum = 1;
}
else
{
SearchString = currentFilter;
}
ViewData["CurrentSort"] = sortField;
ViewBag.CurrentFilter = SearchString;
if (!String.IsNullOrEmpty(SearchString))
{
users = users.Where(u => u.FirstName.Contains(SearchString)).ToList();
}
int pageSize = 10;
return(View(Paging <RegUser> .CreateAsync(users.AsQueryable <RegUser>(), pageNum ?? 1, pageSize)));
}
public IActionResult EnquiryList()
{
var context = new OnlineWebPortalDbContext();
var enq = context.Enquiries.ToList();
return(View(enq));
}
public IActionResult Detail(int id)
{
var context = new OnlineWebPortalDbContext();
var enquiry = context.Enquiries.Where(e => e.ID == id).SingleOrDefault();
return(View(enquiry));
}
public IActionResult CreateEnquiry(CreateEnquiryViewModel input)
{
var context = new OnlineWebPortalDbContext();
Enquiry enquiry = new Enquiry();
if (ModelState.IsValid && (input.EnquiryType != null))
{
try
{
enquiry.EnquiryType = input.EnquiryType;
enquiry.EnquiryDate = input.EnquiryDate;
enquiry.EnquiryBody = input.EnquiryBody;
enquiry.RegUser = input.RegUser;
context.Add(enquiry);
context.SaveChanges();
TempData["successMessage"] = " Your enquiry has been sent successfully";
return(RedirectToAction("CreateEnquiry", "Enquiry"));
}
catch (Exception ex)
{
TempData["failMessage"] = " Oops! Something went wrong" + ex.Message;
return(RedirectToAction("CreateEnquiry", "Enquiry"));
}
}
return(View());
}
public IActionResult Portal()
{
var context = new OnlineWebPortalDbContext();
var loggedUser = User.Identity.Name;
var usr = context.RegUsers.Where(u => (u.FirstName + " " + u.LastName) == loggedUser).SingleOrDefault();
return(View(usr));
}
//Get a user based on their id
public IActionResult UserProfile(int id)
{
var context = new OnlineWebPortalDbContext();
var user = context.RegUsers
.Where(u => u.ID == id).SingleOrDefault();
return(View(user));
}
public IActionResult Delete(int id)
{
var context = new OnlineWebPortalDbContext();
var eventId = context.Events.FirstOrDefault(e => e.ID == id);
context.Events.Remove(eventId);
context.SaveChanges();
return(RedirectToAction("EventList", "Event"));
}
public IActionResult Delete(int id)
{
var context = new OnlineWebPortalDbContext();
var enq = context.Enquiries.FirstOrDefault(e => e.ID == id);
context.Enquiries.Remove(enq);
context.SaveChanges();
return(RedirectToAction("EnquiryList", "Enquiry"));
}
public IActionResult DeleteGroup(int id)
{
var context = new OnlineWebPortalDbContext();
var groupId = context.ChurchGroups.FirstOrDefault(e => e.ID == id);
context.ChurchGroups.Remove(groupId);
context.SaveChanges();
return(RedirectToAction("FindGroup", "Group"));
}
public IActionResult FindGroup()
{
var context = new OnlineWebPortalDbContext();
var group = context.ChurchGroups
.Include(u => u.RegUserChurchGroups)
.ToList();
return(View(group));
}
public IActionResult OnlineGiving()
{
var context = new OnlineWebPortalDbContext();
var user = context.RegUsers.FirstOrDefault();
var name = user.FirstName + " " + user.LastName;
var usr = context.RegUsers.FirstOrDefault(u => name == User.Identity.Name);
return(View(usr));
}
public IActionResult UserChurchGroups(int id)
{
var context = new OnlineWebPortalDbContext();
var join = context.RegUserChurchGroups
.Include(g => g.ChurchGroups)
.Where(u => u.RegUsers.ID == id)
.ToList();
return(View(join));
}
//[HttpGet]
public IActionResult DeleteMember(int id)
{
var context = new OnlineWebPortalDbContext();
//RegUser user = new RegUser();
var join = context.RegUserChurchGroups
.Include(u => u.RegUsers)
.Where(u => u.ChurchGroupID == id).FirstOrDefault();
return(View(join));
}
public IActionResult GroupMembers(int id)
{
var context = new OnlineWebPortalDbContext();
var items = context.RegUserChurchGroups
.Include(item => item.RegUsers)
.Where(g => g.ChurchGroupID == id)
.ToList();
return(View(items));
}
public IActionResult StatementDetail(int id)
{
var context = new OnlineWebPortalDbContext();
//var usr = context.RegUsers.Where(u => u.ID == id).SingleOrDefault();
IList <Payment> payment = context.Payments
.Include(p => p.RegUser)
.Where(u => u.ID == id)
.ToList();
return(View(payment));
}
public IActionResult ListOfStatements()
{
var context = new OnlineWebPortalDbContext();
//var user = User.Identity.Name;
//var usr = context.RegUsers.Where(u => u.FirstName + " " + u.LastName == user).SingleOrDefault();
var pay = context.Payments
.Include(p => p.RegUser)
.ToList();
return(View(pay));
}
public IActionResult EditGroup(int id)
{
var context = new OnlineWebPortalDbContext();
var model = context.ChurchGroups.FirstOrDefault(e => e.ID == id);
if (model == null)
{
return(RedirectToAction("FindGroup", "Group"));
}
return(View(model));
}
public IActionResult EditAccount(int id)
{
var context = new OnlineWebPortalDbContext();
var user = context.RegUsers.FirstOrDefault(e => e.ID == id);
if (user == null)
{
return(RedirectToAction("UserProfile", "User"));
}
return(View(user));
}
public IActionResult AddMember(int id)
{
var context = new OnlineWebPortalDbContext();
var group = context.ChurchGroups.FirstOrDefault(g => g.ID == id);
ViewBag.GroupID = group.ID;
var users = context.RegUsers.ToList();
return(View(users));
}
public IActionResult AddMember(AddGroupMemberViewModel input)
{
var context = new OnlineWebPortalDbContext();
var join = new RegUserChurchGroup();
if (ModelState.IsValid)
{
join.ChurchGroupID = input.ChurchGroupID;
join.RegUserID = input.RegUserID;
context.Add(join);
context.SaveChanges();
ViewData["message"] = "Registration was successful!";
return(RedirectToAction("FindGroup", "Group"));
}
return(RedirectToAction("Portal", "Home"));
}
public IActionResult DeleteUserAccount(int id)
{
var context = new OnlineWebPortalDbContext();
try
{
var acc = context.RegUsers.SingleOrDefault(a => a.ID == id);
context.RegUsers.Remove(acc);
context.SaveChanges();
TempData["message"] = "Member has been deleted!";
return(RedirectToAction("Portal", "Home"));
}
catch (Exception ex)
{
TempData["message"] = " Oops! We have a problem here" + ex.Message;
return(RedirectToAction("Users", "User"));
}
}
public IActionResult Register(RegisterViewModel input)
{
var db = new OnlineWebPortalDbContext();
if (ModelState.IsValid)
{
RegUser user = new RegUser();
user.FirstName = input.FirstName;
user.LastName = input.LastName;
user.Username = input.Username;
user.Password = input.Password;
user.Roles = "Member";
user.Sex = input.Sex;
user.MaritalStatus = input.MaritalStatus;
user.DateOFBirth = input.DateOFBirth;
user.PhoneNumber = input.PhoneNumber;
user.Email = input.Email;
user.MemType = input.MemType;
user.DateOfMembership = input.DateOfMembership;
try
{
db.RegUsers.Add(user);
db.SaveChanges();
TempData["message"] = "Registration was successful!";
if (User.Identity.IsAuthenticated == true)
{
return(RedirectToAction("Users", "User"));
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
catch (Exception ex)
{
TempData["message"] = " Oops! We have a problem here" + ex.Message;
return(RedirectToAction("Register", "Account"));
}
}
return(View());
}
public IActionResult EditGroup(int id, GroupEditViewModel input)
{
var context = new OnlineWebPortalDbContext();
var group = context.ChurchGroups.FirstOrDefault(e => e.ID == id);
if (group != null && ModelState.IsValid)
{
group.GroupName = input.GroupName;
group.GroupDescription = input.GroupDescription;
group.MeetingDay = input.MeetingDay;
group.StartTime = input.StartTime;
group.EndTime = input.EndTime;
group.Location = input.Location;
group.LeaderName = input.LeaderName;
group.LeaderProfile = input.LeaderProfile;
context.SaveChanges();
return(RedirectToAction("FindGroup", "Group"));
}
return(View(group));
}
public IActionResult CreateGroup(GroupCreateViewModel input)
{
var context = new OnlineWebPortalDbContext();
ChurchGroup group = new ChurchGroup();
if (ModelState.IsValid && (input.GroupName != null))
{
group.GroupName = input.GroupName;
group.GroupDescription = input.GroupDescription;
group.MeetingDay = input.MeetingDay;
group.StartTime = input.StartTime;
group.EndTime = input.EndTime;
group.Location = input.Location;
group.LeaderName = input.LeaderName;
group.LeaderProfile = input.LeaderProfile;
context.Add(group);
context.SaveChanges();
return(RedirectToAction("FindGroup", "Group"));
}
return(View());
}
