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