public static void run()
{
List <Registrations> myRegs = new List <Registrations>();
var myTime = startTime;
for (uint i = 1; i < 5; i++)
{
while (myTime <= endTime)
{
if (myTime.Month == 3 && myTime.Day == 26 && myTime.Hour == 2)
{
myTime = myTime.AddHours(1);
}
myRegs.Add(new Registrations {
UserId = i, StatusId = getNextStatus(currentStatus), Time = myTime, DepartmentId = i % 2
});
myTime = myTime.AddHours(1);
counter++;
}
}
using (var dbContext = new WashingtonRedskinsContext())
{
foreach (Registrations r in myRegs)
{
dbContext.Add(r);
}
dbContext.SaveChanges();
}
}
public void run()
{
RegistrationsEdits regEdit;
using (var dbContext = new WashingtonRedskinsContext())
{
regEdit = dbContext.RegistrationsEdits.First();
}
StatisticsJobs.run(regEdit.Time ?? null);
}
private static void saveRegistrations()
{
using (var dbContext = new WashingtonRedskinsContext())
{
foreach (RegistrationSummary r in regSummary)
{
dbContext.Add(r);
}
dbContext.SaveChanges();
}
regSummary = null;
}
public static void run(DateTime?start = null)
{
using (var dbContext = new WashingtonRedskinsContext())
{
dbContext.RegistrationsEdits.First().Time = DateTime.Now.AddDays(1);
dbContext.SaveChanges();
}
if (start != null)
{
currentTime = (DateTime)start;
currentTime.setToMidnight();
}
calculateDaily(currentTime);
}
private static void calculateDaily(DateTime start)
{
using (var dbContext = new WashingtonRedskinsContext())
{
statuses = dbContext.Statuses.ToList();
regs = dbContext.Registrations.Where(r => r.Time >= start)
.OrderBy(r => r.UserId).ThenBy(r => r.Time).ToList();
}
regSummary = new List <RegistrationSummary>();
foreach (Registrations r in regs)
{
if (currentUser != r.UserId || date.Date != r.Time.Date)
{
if (currentUser != r.UserId)
{
changeUser(r);
}
else
{
changeDay(r);
}
}
else
{
if (regSummary == null)
{
initList(r);
}
regSummary.Where(d => d.StatusId == r.StatusId).First().Duration +=
(r.Time - lastReg.Time).toSeconds();
}
currentUser = r.UserId;
date = r.Time;
lastReg = r;
}
using (var dbContext = new WashingtonRedskinsContext())
{
var time = dbContext.RegistrationsEdits.First().Time;
if (time < DateTime.Now)
{
run(time);
}
}
}
public static bool validatePassword(string email, string password)
{
Users usr;
try
{
using (var dbContext = new WashingtonRedskinsContext())
{
usr = dbContext.Users.Where(u => u.Email == email).First();
}
if (BCrypt.Net.BCrypt.Verify(password, usr.Password))
{
return(true);
}
}
catch (Exception ex) { }
return(false);
}
public static IHttpContext registrationGetByUser(IHttpContext context)
{
try
{
uint userId = uint.Parse(context.Request.QueryString["userID"]);
List <Registrations> regs;
using (var dbContext = new WashingtonRedskinsContext())
{
regs = dbContext.Registrations.Where(r => r.UserId == userId).ToList();
}
context.Response.SendResponse(JsonConvert.SerializeObject(regs));
}
catch (Exception ex)
{
context.Response.SendResponse(ex.Message);
context.Response.StatusCode = HttpStatusCode.InternalServerError;
}
return(context);
}
public static void seed()
{
var dbcontext = new WashingtonRedskinsContext();
dbcontext.Database.EnsureDeleted();
dbcontext.Database.Migrate();
List <Users> myUsers = new List <Users>();
List <UserGroup> myUserGroups = new List <UserGroup>();
List <Privileges> myPrivileges = new List <Privileges>();
List <Departments> myDepartments = new List <Departments>();
List <Statuses> myStatuses = new List <Statuses>();
List <Registrations> myRegistrations = new List <Registrations>();
myStatuses.Add(new Statuses
{
Name = "Arbejde"
});
myStatuses.Add(new Statuses
{
Name = "Barns første sygedag"
});
myStatuses.Add(new Statuses
{
Name = "Ferie"
});
myStatuses.Add(new Statuses
{
Name = "Fri"
});
myStatuses.Add(new Statuses
{
Name = "Pause"
});
myStatuses.Add(new Statuses
{
Name = "Syg"
});
myStatuses.Add(new Statuses
{
Name = "Udeblevet"
});
myStatuses.Add(new Statuses
{
Name = "Ferie/Fridag"
});
//myRegistrations.Add(new Registrations
//{
// StatusId = 1,
// UserId = 1,
// Time = DateTime.Parse("2008, 5, 1, 8, 30, 52")
//});
//myRegistrations.Add(new Registrations
//{
// StatusId = 4,
// UserId = 1,
// Time = DateTime.Parse("2009, 5, 1, 8, 30, 52")
//});
//myRegistrations.Add(new Registrations
//{
// StatusId = 2,
// UserId = 1,
// Time = DateTime.Parse("2009, 6, 1, 8, 30, 52")
//});
//myRegistrations.Add(new Registrations
//{
// StatusId = 3,
// UserId = 1,
// Time = DateTime.Parse("2009, 7, 1, 8, 30, 52")
//});
//myRegistrations.Add(new Registrations
//{
// StatusId = 1,
// UserId = 1,
// Time = DateTime.Parse("2010, 5, 1, 8, 30, 52")
//});
//myRegistrations.Add(new Registrations
//{
// StatusId = 4,
// UserId = 1,
// Time = DateTime.Parse("2010, 5, 1, 16, 30, 52")
//});
myUsers.Add(new Users {
Email = "*****@*****.**",
UserGroupId = 1,
Address = "Adminvej 1",
Postcode = "1234",
CprNr = 1234567890,
Firstname = "Anders",
Lastname = "Admin",
Password = AuthController.hashPassword("password"),
DepartmentId = 1
});
myUsers.Add(new Users
{
Email = "*****@*****.**",
UserGroupId = 2,
Address = "Knudvej 1",
Postcode = "1235",
CprNr = 1234567891,
Firstname = "Knud",
Lastname = "Kundeservice",
Password = AuthController.hashPassword("password"),
DepartmentId = 2
});
myUsers.Add(new Users
{
Email = "*****@*****.**",
UserGroupId = 2,
Address = "BOB VEJ1",
Postcode = "1235",
CprNr = 231423121,
Firstname = "TLS",
Lastname = "Kundeservice",
Password = AuthController.hashPassword("password"),
DepartmentId = 2
});
myUsers.Add(new Users
{
Email = "*****@*****.**",
UserGroupId = 2,
Address = "Tur de France",
Postcode = "1235",
CprNr = 1234567801,
Firstname = "Bobby Olsen",
Lastname = "Kaptain",
Password = AuthController.hashPassword("password"),
DepartmentId = 2
});
myUserGroups.Add(new UserGroup
{
Name = "Administrator",
});
myUserGroups.Add(new UserGroup
{
Name = "Kundeservice",
});
myDepartments.Add(new Departments
{
Name = "IT",
});
myDepartments.Add(new Departments
{
Name = "Kundeservice",
});
myPrivileges.Add(new Privileges()
{
Name = "users.read"
});
myPrivileges.Add(new Privileges()
{
Name = "users.write"
});
myPrivileges.Add(new Privileges()
{
Name = "users.self.read"
});
myPrivileges.Add(new Privileges()
{
Name = "users.self.write"
});
myPrivileges.Add(new Privileges()
{
Name = "breaks.read"
});
myPrivileges.Add(new Privileges()
{
Name = "breaks.self.read"
});
myPrivileges.Add(new Privileges()
{
Name = "breaks.write"
});
myPrivileges.Add(new Privileges()
{
Name = "breaks.self.write"
});
myPrivileges.Add(new Privileges()
{
Name = "vacations.read"
});
myPrivileges.Add(new Privileges()
{
Name = "vacations.self.read"
});
myPrivileges.Add(new Privileges()
{
Name = "vacations.write"
});
myPrivileges.Add(new Privileges()
{
Name = "vacations.self.write"
});
myPrivileges.Add(new Privileges()
{
Name = "departments.read"
});
myPrivileges.Add(new Privileges()
{
Name = "departments.self.read"
});
myPrivileges.Add(new Privileges()
{
Name = "departments.write"
});
myPrivileges.Add(new Privileges()
{
Name = "departments.self.write"
});
myPrivileges.Add(new Privileges()
{
Name = "Statuses.read"
});
myPrivileges.Add(new Privileges()
{
Name = "Statuses.self.read"
});
myPrivileges.Add(new Privileges()
{
Name = "Statuses.write"
});
myPrivileges.Add(new Privileges()
{
Name = "Statuses.self.write"
});
myPrivileges.Add(new Privileges()
{
Name = "usergroups.read"
});
myPrivileges.Add(new Privileges()
{
Name = "usergroups.self.read"
});
myPrivileges.Add(new Privileges()
{
Name = "usergroups.write"
});
myPrivileges.Add(new Privileges()
{
Name = "usergroups.self.write"
});
myPrivileges.Add(new Privileges()
{
Name = "workhour.read"
});
myPrivileges.Add(new Privileges()
{
Name = "workhour.self.read"
});
myPrivileges.Add(new Privileges()
{
Name = "workhour.write"
});
myPrivileges.Add(new Privileges()
{
Name = "workhour.self.write"
});
myPrivileges.Add(new Privileges()
{
Name = "registrations.read"
});
myPrivileges.Add(new Privileges()
{
Name = "registrations.self.read"
});
myPrivileges.Add(new Privileges()
{
Name = "registrations.write"
});
myPrivileges.Add(new Privileges()
{
Name = "registrations.self.write"
});
myPrivileges.Add(new Privileges()
{
Name = "registrations.delete"
});
myPrivileges.Add(new Privileges()
{
Name = "statistics.read"
});
myPrivileges.Add(new Privileges()
{
Name = "statistics.self.read"
});
myPrivileges.Add(new Privileges()
{
Name = "statistics.write"
});
myPrivileges.Add(new Privileges()
{
Name = "statistics.self.write"
});
using (var dbContext = new WashingtonRedskinsContext())
{
foreach (UserGroup ug in myUserGroups)
{
dbContext.Add(ug);
}
foreach (Departments d in myDepartments)
{
dbContext.Add(d);
}
dbContext.SaveChanges();
foreach (Users u in myUsers)
{
dbContext.Add(u);
}
foreach (Privileges p in myPrivileges)
{
dbContext.Add(p);
dbContext.UserGroupsPrivileges.Add(new UserGroupsPriviliges()
{
UserGroupId = 1, Privilege = p, Isallowed = 1
});
}
foreach (Statuses s in myStatuses)
{
dbContext.Add(s);
}
dbContext.SaveChanges();
}
var regEdit = new RegistrationsEdits();
regEdit.Time = DateTime.Now;
RegistrationsEdits.add(regEdit);
RegistrationsSeeder.run();
}
