public override string[] GetRolesForUser(string username) { if (!HttpContext.Current.User.Identity.IsAuthenticated) { return(null); } //check cache var cacheKey = string.Format("{0}_role", username); if (HttpRuntime.Cache[cacheKey] != null) { return((string[])HttpRuntime.Cache[cacheKey]); } string[] roles = new string[] { }; using (LibraryAssistantEntities db = new LibraryAssistantEntities()) { roles = (from a in db.Roles join b in db.Person_Role on a.Role_ID equals b.Role_ID join c in db.Registered_Person on b.Person_ID equals c.Person_ID where c.Person_ID.Equals(username) select a.Role_Name).ToArray <string>(); if (roles.Count() > 0) { HttpRuntime.Cache.Insert(cacheKey, roles, null, DateTime.Now.AddMinutes(_cacheTimeoutInMinute), Cache.NoSlidingExpiration); } } return(roles); }
public void Execute(IJobExecutionContext context) { LibraryAssistantEntities db = new LibraryAssistantEntities(); var tomorrow = DateTime.Today.AddDays(1).Date; var upcommingBookings = (from b in db.Venue_Booking where b.Booking_Status.Equals("Active") select b).ToList(); var temp = (from g in upcommingBookings where g.DateTime_From.Date.Equals(tomorrow) select g.Venue_Booking_Seq).ToList(); var upcommingBookingsPerson = (from p in db.Venue_Booking_Person where temp.Contains(p.Venue_Booking_Seq) select p).ToList(); foreach (var item in upcommingBookingsPerson) { var person = db.Registered_Person.Where(p => p.Person_ID.Equals(item.Person_ID)).FirstOrDefault(); var booking = db.Venue_Booking.Where(v => v.Venue_Booking_Seq.Equals(item.Venue_Booking_Seq)).FirstOrDefault(); var type = (from t in db.Booking_Type where t.Booking_Type_Seq.Equals(booking.Booking_Type_Seq) select t.Booking_Type_Name).FirstOrDefault(); var timeslot = booking.DateTime_From.TimeOfDay + " " + booking.DateTime_To.TimeOfDay; var date = booking.DateTime_From.ToShortDateString(); var campus = (from c in db.Campus where c.Campus_ID.Equals(booking.Campus_ID) select c.Campus_Name).FirstOrDefault(); var building = (from b in db.Buildings where b.Building_ID.Equals(booking.Building_ID) select b.Building_Name).FirstOrDefault(); var venue = (from v in db.Venues where v.Venue_ID.Equals(booking.Venue_ID) select v.Venue_Name).FirstOrDefault(); MailMessage message = new MailMessage(); SmtpClient client = new SmtpClient(); client.Host = "smtp.gmail.com"; client.Port = 587; message.From = new MailAddress("*****@*****.**"); message.To.Add(person.Person_Email); message.Subject = "Account Activation"; message.Body = "Hi, " + person.Person_Name + ", don't forget about your booking taking place tomorrow: <hr/> <p>Type: " + type + "</p> <p>Timeslot: " + timeslot + "</p> <p>Date: " + date + "</p> <p>Campus: " + campus + "</p> <p>Building: " + building + "</p> <p>Venue: " + venue; message.IsBodyHtml = true; client.EnableSsl = true; client.UseDefaultCredentials = true; client.Credentials = new System.Net.NetworkCredential("*****@*****.**", "tester123#"); client.Send(message); } }
public override bool ValidateUser(string username, string password) { //will write code for validate user from the database using (LibraryAssistantEntities dc = new LibraryAssistantEntities()) { var user = dc.Registered_Person.Where(a => a.Person_ID.Equals(username) && a.Person_Password.Equals(password)).FirstOrDefault(); if (user != null) { return(true); } } return(false); }