public void TestInitialize()
{
using (CalendarDBContext db = new CalendarDBContext())
{
expected = new List <Event>()
{
new Event()
{
Name = "Test Event 1",
Type = db.Types.Where(t => t.Id == 2).First(),
Start = new DateTime(2017, 11, 9, 12, 0, 0),
End = new DateTime(2017, 11, 9, 14, 0, 0)
},
new Event()
{
Name = "Test Event 2",
Type = db.Types.Where(t => t.Id == 4).First(),
Start = new DateTime(2017, 11, 9, 9, 0, 0),
End = new DateTime(2017, 11, 9, 10, 0, 0)
}
};
db.Events.AddRange(expected);
db.SaveChanges();
}
}
//
//Construction.
//
public CreateCalendarControl()
{
InitializeComponent();
db = new CalendarDBContext();
db.Calendars.Load();
ListHoliDays = new List <string>();
}
// private bool isFirstTime = true;
public HomeController(CalendarDBContext DBContext)
{
_dbContext = DBContext;
//load seed data
Seed.Initialize(_dbContext);
}
public static void EditPlans(List <Plan> newPlans)
{
using (CalendarDBContext db = new CalendarDBContext())
{
foreach (Plan plan in Plans)
{
if (newPlans.FindAll(p => p.Id == plan.Id).Count == 0)
{
if (db.Plans.Where(p => p.Id == plan.Id).First().Users.Count <= 1)
{
db.Plans.Remove(db.Plans.Where(p => p.Id == plan.Id).First());
}
db.Users.Where(u => u.Id == ActiveUser.Id).First().Plans.Remove(db.Plans.Where(p => p.Id == plan.Id).First());
}
}
foreach (Plan plan in newPlans)
{
if (Plans.FindAll(p => p.Id == plan.Id).Count == 0)
{
db.Plans.Add(plan);
db.Users.Where(u => u.Id == ActiveUser.Id).First().Plans.Add(plan);
}
}
db.SaveChanges();
}
}
public static bool SignUp(string username, string email, string password)
{
using (CalendarDBContext db = new CalendarDBContext())
{
var users = db.Users.Where(u => u.UserName == username || u.Mail.Address == email);
if (users.Count() > 0)
{
return(false);
}
db.Users.Add(new User()
{
UserName = username,
Password = password,
Mail = new EMailAddress()
{
Address = email
}
});
db.SaveChanges();
}
using (CalendarDBContext db = new CalendarDBContext())
{
List <User> tmp = db.Users.ToList();
ActiveUser = db.Users.Where(u => u.UserName == username && u.Mail.Address == email && u.Password == password).First();
}
return(true);
}
public static void EditEvent(Event ev, string name, DataAccess.Type type, DateTime start, DateTime end, List <int> plansId, List <int> usersId, bool accepted)
{
using (CalendarDBContext db = new CalendarDBContext())
{
ev = db.Events.Where(e => e.Id == ev.Id).First();
var plans = db.Plans;
foreach (Plan plan in plans)
{
plan.Events.Remove(ev);
}
foreach (int id in plansId)
{
db.Plans.AsEnumerable().Where(p => p.Id == id).First().Events.Add(ev);
ev.Plans.Add(db.Plans.AsEnumerable().Where(p => p.Id == id).First());
}
type = db.Types.Where(t => t.Id == type.Id).First();
ev.Change(name, type, start, end);
db.EventApprovals.Where(ea => ev.Id == ea.EventId && ActiveUser.Id == ea.UserId).First().Accepted = accepted;
foreach (int id in usersId)
{
Event thisEvent = db.Events.Where(e => e.Id == ev.Id).First();
User user = db.Users.Where(u => u.Id == id).First();
db.EventApprovals.Add(new EventApproval()
{
Event = thisEvent,
User = user,
Accepted = false
});
SendInvitationMail(thisEvent, user);
}
db.SaveChanges();
}
}
public static void AddEvent(string name, DataAccess.Type type, DateTime start, DateTime end, List <int> plansId, List <int> usersId, bool accepted)
{
using (CalendarDBContext db = new CalendarDBContext())
{
Event ev = new Event();
ev.Owner = db.Users.Where(u => u.Id == ActiveUser.Id).First();
foreach (int id in plansId)
{
db.Plans.AsEnumerable().Where(p => p.Id == id).First().Events.Add(ev);
ev.Plans.Add(db.Plans.AsEnumerable().Where(p => p.Id == id).First());
}
type = db.Types.Where(t => t.Id == type.Id).First();
ev.Change(name, type, start, end);
db.Events.Add(ev);
db.EventApprovals.Add(new EventApproval()
{
Event = ev,
User = db.Users.Where(u => u.Id == ActiveUser.Id).First(),
Accepted = accepted
});
foreach (int id in usersId)
{
User user = db.Users.Where(u => u.Id == id).First();
db.EventApprovals.Add(new EventApproval()
{
Event = ev,
User = user,
Accepted = false
});
SendInvitationMail(ev, user);
}
db.SaveChanges();
}
}
private void CalendarClosing(object sender, FormClosingEventArgs e)
{
using (CalendarDBContext db = new CalendarDBContext())
{
db.SaveChanges();
db.Dispose();
}
}
public static void EditEmailAddress(string emailAddress)
{
using (CalendarDBContext db = new CalendarDBContext())
{
db.Users.Where(u => u.Id == ActiveUser.Id).First().Mail.Address = emailAddress;
db.SaveChanges();
}
}
//
//Construction.
//
public OpenCalendarControl()
{
InitializeComponent();
db = new CalendarDBContext();
page = db.Calendars.First().NMonth;
db.Calendars.Load();
label3.Text = page.ToString();
dataGridView1.DataSource = db.Calendars.Local.ToBindingList();
}
public static bool IsEventAccepted(int eventId)
{
bool answer = false;
using (CalendarDBContext db = new CalendarDBContext())
{
answer = db.EventApprovals.Where(ea => ea.EventId == eventId && ea.UserId == ActiveUser.Id).First().Accepted;
}
return(answer);
}
//
//Construction.
//
public OpenEventsControl()
{
InitializeComponent();
NOW = DateTime.Today;
CheckingTodayEvent = new CheckingEvents();
db = new CalendarDBContext();
db.DbEvents.Load();
dataGridView1.DataSource = db.DbEvents.Local.ToBindingList();
}
public void TestCleanUp()
{
using (CalendarDBContext db = new CalendarDBContext())
{
foreach (Event ev in db.Events.AsEnumerable().Where(e => e.Name == expected[0].Name || e.Name == expected[1].Name))
{
db.Events.Remove(ev);
}
}
}
public static void DeleteEvent(Event ev)
{
using (CalendarDBContext db = new CalendarDBContext())
{
db.EventApprovals.RemoveRange(db.EventApprovals.Where(ea => ea.EventId == ev.Id && ea.UserId == ActiveUser.Id));
if (!db.EventApprovals.Any(ea => ea.EventId == ev.Id && ea.UserId != ActiveUser.Id))
{
db.Events.Remove(db.Events.Where(e => e.Id == ev.Id).First());
}
db.SaveChanges();
}
}
public static bool LogIn(string username, string password)
{
using (CalendarDBContext db = new CalendarDBContext())
{
var users = db.Users.Where(u => (u.UserName == username || u.Mail.Address == username) && u.Password == password);
if (users.Count() <= 0)
{
return(false);
}
ActiveUser = users.First();
}
return(true);
}
public static void InviteToEvent(Event myEvent, int userId)
{
using (CalendarDBContext db = new CalendarDBContext())
{
Event thisEvent = db.Events.Where(e => e.Id == myEvent.Id).First();
User user = db.Users.Where(u => u.Id == userId).First();
db.EventApprovals.Add(new EventApproval()
{
Event = myEvent,
User = user,
Accepted = false
});
db.SaveChanges();
SendInvitationMail(thisEvent, user);
}
}
public MailService()
{
InitializeComponent();
db = new CalendarDBContext();
client = new SmtpClient();
timer = new Timer();
client.Port = 587;
client.DeliveryMethod = SmtpDeliveryMethod.Network;
client.UseDefaultCredentials = false;
client.Host = ConfigurationManager.AppSettings["Host"];
client.EnableSsl = true;
client.Credentials = new NetworkCredential(ConfigurationManager.AppSettings["MailFrom"], ConfigurationManager.AppSettings["Password"]);
timer.Interval = 60000;
timer.Elapsed += new ElapsedEventHandler(SendMail);
timer.Start();
}
public static void Initialize(CalendarDBContext dbContext)
{
if (dbContext.ScheduleData.Any())
{
return; // DB has been seeded
}
dbContext.ScheduleData.AddRange(
new ScheduleData
{
Subject = "Ultimate1",
StartTime = DateTime.Now,
EndTime = DateTime.Now.AddHours(1),
RoomId = "1"
},
new ScheduleData
{
Subject = "Ultimate1",
StartTime = DateTime.Now,
EndTime = DateTime.Now.AddHours(1),
RoomId = "2"
},
new ScheduleData
{
Subject = "Ultimate1",
StartTime = DateTime.Now,
EndTime = DateTime.Now.AddHours(1),
RoomId = "3"
},
new ScheduleData
{
Subject = "Ultimate1",
StartTime = DateTime.Now,
EndTime = DateTime.Now.AddHours(1),
RoomId = "4"
}
);
dbContext.SaveChanges();
}
private static void SendInvitationMail(Event myEvent, User guest)
{
SmtpClient mailClient = new SmtpClient();
mailClient.Port = 587;
mailClient.DeliveryMethod = SmtpDeliveryMethod.Network;
mailClient.UseDefaultCredentials = false;
mailClient.Host = "smtp.gmail.com";
mailClient.EnableSsl = true;
mailClient.Credentials = new NetworkCredential("*****@*****.**", "ZMcal30!");
using (CalendarDBContext db = new CalendarDBContext())
{
var mailAddress = db.EMailAddresses.Where(em => em.Id == guest.MailId).First();
MailMessage mail = new MailMessage();
string body = $"User: {ActiveUser.UserName} invites you to event: {myEvent.Name}.\n";
mail.To.Add(mailAddress.Address);
mail.From = new MailAddress("*****@*****.**");
mail.Subject = "Invitation";
mail.Body = body;
mailClient.Send(mail);
}
}
private List <Event> GetEventsFromDatabaseWithPlan(int planId)
{
int year = dateTime.Year;
int month = dateTime.Month;
int day = dateTime.Day;
List <Event> result;
using (CalendarDBContext db = new CalendarDBContext())
{
result = db.Events
.Include("Type.Color")
.Include("Plans")
.Where(e => e.EventApprovals.Where(ea => ea.User.Id == DataModel.ActiveUser.Id).Count() > 0)
.Where(e => SqlFunctions.DatePart("year", e.Start) == year)
.Where(e => SqlFunctions.DatePart("month", e.Start) == month)
.Where(e => SqlFunctions.DatePart("day", e.Start) == day)
.Where(e => planId != -1 ? e.Plans.Any(p => p.Id == planId) : true)
.OrderBy(e => e.Start)
.ToList();
}
return(result);
}
public StartPageControl()
{
InitializeComponent();
db = new CalendarDBContext();
}
public CheckingEvents()
{
db = new CalendarDBContext();
}
public CalendarRequestRepository(CalendarDBContext dbContext)
{
_dbContext = dbContext;
}
public ScheduleDataController(CalendarDBContext sampleODataDbContext)
{
_appDbContext = sampleODataDbContext;
}
public AppointmentController(CalendarDBContext sampleODataDbContext)
{
_appDbContext = sampleODataDbContext;
}
public EventsController(CalendarDBContext context)
{
_context = context;
}
public CalendarController(CalendarDBContext dbContext)
{
throttler = new Throttle("maxrequest");
_calendarRequestRepository = new CalendarRequestRepository(dbContext);
}
public HomeController(CalendarDBContext DBContext)
{
_dbContext = DBContext;
}
