private void button1_Click(object sender, EventArgs e)
{
var unitofwork = new UnitOfWork();
unitofwork.EmployeeAvailabilityRepository.Insert(GetFields(new EmployeeAvailabilityDay()));
unitofwork.Save();
DialogResult = DialogResult.OK;
}
private void AddEditBooking_Load(object sender, EventArgs e)
{
var unitOfWork = new UnitOfWork();
cbType.DataSource = unitOfWork.BookingClassificationRepository.Get().ToList();
cbType.DisplayMember = "ClassificationName";
cbType.ValueMember = "Id";
var startDate = DateTime.Today;
startDate.AddSeconds(-startDate.Second);
startDate.AddMinutes(-startDate.Minute);
dtpBookingTime.Value = startDate;
if (currentBookingID != null)
{
currentBooking = unitOfWork.BookingRepository.Get(null, null, "Employee,BookingClasification,BookingNotes").Where(x => x.Id == currentBookingID).FirstOrDefault();
btnSave.Text = "Save Changes";
dtpBookingTime.Value = currentBooking.BookingDate;
tbName.Text = currentBooking.Name;
tbContactNumber.Text = currentBooking.ContactNumber;
tbEmail.Text = currentBooking.Email;
cbType.SelectedValue = currentBooking.BookingClasification.Id;
newbookingNotes = currentBooking.BookingNotes.Where(x => x.DateInactive == null).ToList();
}
RebindNotes();
}
private void ManageRestaurantEmployees_Load(object sender, EventArgs e)
{
unitOfWork = new UnitOfWork();
accessLevel = unitOfWork.AccessLevelRepository.Get(x => x.Id == AccessLevelID,null,"Employees").FirstOrDefault();
lblRestaurantName.Text = accessLevel.Name;
Rebind();
}
public void BookingLockoutsForDate(RichTextBox rtb, DateTime date)
{
rtb.Text = "";
var unitOfWork = new UnitOfWork();
var today = date.Date;
var notes = unitOfWork.LockedOutDateRepository.Get(x => today < x.EndDate && today > x.StartDate,includeProperties:"LockOutTimes");
notes = notes.OrderBy(x => x.DateCreated);
if (notes.Count() > 0)
{
rtb.AppendBoldColoredLine("Locked:", System.Drawing.Color.Red);
int i = 1;
foreach (var note in notes)
{
rtb.AppendBoldColoredLine(i + ". " + note.Name, System.Drawing.Color.Red);
string reason = note.Reason;
rtb.AppendLine(reason);
if (note.LockOutTimes.Count>0)
{
foreach(var v in note.LockOutTimes)
{
rtb.AppendText(v.StartTime.ToShortTimeString() + " - "+ v.EndTime.ToShortTimeString()+", " );
}
}
}
}
}
private void btnLogin_Click(object sender, EventArgs e)
{
try
{
InitService.Initialize();
var unitofwork = new UnitOfWork();
int userID = int.Parse(tbUserId.Text);
var user = unitofwork.EmployeeRepository.Get(x => x.Id == userID).FirstOrDefault();
if (user == null)
{
throw new NullReferenceException();
}
NavigationMenu v = new NavigationMenu();
v.User = user;
v.ShowDialog();
}
catch (FormatException ex)
{
MessageBox.Show("Incorrect Format, Please input an integer number");
}
catch (NullReferenceException ex2)
{
MessageBox.Show("User Not Found");
}
catch (System.Data.Entity.Validation.DbEntityValidationException ex4)
{
MessageBox.Show(ex4.Message + " " + string.Join(", ", ex4.EntityValidationErrors.SelectMany(x => x.ValidationErrors.SelectMany(y => y.ErrorMessage))));
}
}
public void RebindNotes()
{
var unitOfWork = new UnitOfWork();
if(currentBooking!=null)
existingbookingnotes = unitOfWork.BookingNotesRepository.Get(y => y.Booking_Id == currentBooking.Id, null, "Employee").ToList();
allbookingnotes = existingbookingnotes.Union(newbookingNotes).Where(x=> x.DateInactive== null).ToList();
dataGridView1.DataSource = allbookingnotes.Select(x => new { Severity = x.Severity, Note = x.Note }).ToList();
}
public void Rebind()
{
var unitofwork = new UnitOfWork();
EmployeeList = unitofwork.EmployeeRepository.Get(Filter, x => x.OrderBy(y => y.FirstName)).ToList();
ddlUsers.DisplayMember = "FullName";
ddlUsers.ValueMember = "Id";
ddlUsers.DataSource = EmployeeList;
}
private void AddCommendationClassificationSkillCategory_Load(object sender, EventArgs e)
{
var unitofwork = new UnitOfWork();
var listofusedIDs = classification.EmployeeCommendationSkillCategories.Select(x => x.SkillCategory.Id);
availableskills = unitofwork.SkillCategoryRepository.Get(y => !(listofusedIDs.Contains(y.Id))).ToList();
comboBox1.DisplayMember = "Name";
comboBox1.DataSource = availableskills;
}
private void button2_Click(object sender, EventArgs e)
{
if (dgvLocked.SelectedRows.Count > 0)
{
var unitOfWork = new UnitOfWork();
int workingIndex = dgvLocked.SelectedRows[0].Index;
unitOfWork.LockedOutDateRepository.Delete(DateLockouts[workingIndex]);
RebindDateLockouts();
}
}
private void button3_Click(object sender, EventArgs e)
{
if (dgvPresetNotes.SelectedRows.Count > 0)
{
var unitofwork = new UnitOfWork();
unitofwork.BookingClassificationRepository.Delete(accessLevels[dgvPresetNotes.SelectedRows[0].Index].Id);
unitofwork.Save();
Rebind();
}
}
private void button3_Click(object sender, EventArgs e)
{
if (dgvNAs.SelectedRows.Count > 0)
{
var unitofwork = new UnitOfWork();
unitofwork.EmployeeNARepository.Delete(EmployeeNAs[dgvNAs.SelectedRows[0].Index]);
unitofwork.Save();
RebindEmployeeNAs();
}
}
private void AddEditAccessLevel_Load(object sender, EventArgs e)
{
if (AccessLevelId != null)
{
var unitOfWork = new UnitOfWork();
WorkingLevel = unitOfWork.AccessLevelRepository.GetByID(AccessLevelId);
textBox1.Text = WorkingLevel.Name;
numericUpDown1.Value = WorkingLevel.Level;
}
}
public EmployeeAvailabilityDay AvailabilityForDay(int userID, int DayOfTheWeek, DateTime? d = null)
{
if (d == null)
d = DateTime.Now;
var unitOfWork = new UnitOfWork();
var alldays = unitOfWork.EmployeeAvailabilityRepository.Get(x => x.Employee.Id == userID && x.StartDate < d && (x.EndDate == null || x.EndDate > d), includeProperties: "Employee").ToList();
var item = alldays.Where(x => x.DayOfWeek == DayOfTheWeek).OrderByDescending(x => x.DateAdded).FirstOrDefault();
return item;
}
private void AddEditLockedDate_Load(object sender, EventArgs e)
{
if(LockedDateID.HasValue)
{
var unitofwork = new UnitOfWork();
workinglockedDate = unitofwork.LockedOutDateRepository.Get(x => x.Id == LockedDateID.Value, includeProperties:"LockOutTimes").FirstOrDefault();
tbTitle.Text = workinglockedDate.Name;
tbDescription.Text = workinglockedDate.Reason;
dtpStart.Value = workinglockedDate.StartDate;
dtpEnd.Value = workinglockedDate.EndDate;
}
}
private void AddEditDateNote_Load(object sender, EventArgs e)
{
if(DateNoteID.HasValue)
{
var unitOfWork = new UnitOfWork();
workingnote = unitOfWork.DateNoteRepository.GetByID(DateNoteID);
dtpStart.Value = workingnote.StartDate;
dtpEnd.Value = workingnote.EndDate;
cbAppearOnBooking.Checked = workingnote.AppearOnAddingBooking;
cbAppearOnRoster.Checked = workingnote.AppearOnRoster;
tbNote.Text = workingnote.Note;
}
}
private void button3_Click(object sender, EventArgs e)
{
if (dataGridView1.SelectedRows.Count > 0)
{
var unitofwork = new UnitOfWork();
for (int i = 0; i < dataGridView1.SelectedRows.Count; i++)
{
unitofwork.SkillCategoryRepository.Delete(Categories[dataGridView1.SelectedRows[i].Index]);
}
unitofwork.Save();
Rebind();
}
}
public static void Initialize()
{
var unitofwork = new UnitOfWork();
if (unitofwork.EmployeeRepository.Get().Count() == 0)
{
unitofwork.BookingClassificationRepository.Insert(new BookingClasification() { ClassificationName = "Class 1", DisplayOrder = 1 });
unitofwork.BookingClassificationRepository.Insert(new BookingClasification() { ClassificationName = "Class 2", DisplayOrder = 1 });
unitofwork.BookingClassificationRepository.Insert(new BookingClasification() { ClassificationName = "Class 3", DisplayOrder = 1 });
unitofwork.BookingClassificationRepository.Insert(new BookingClasification() { ClassificationName = "Class 4", DisplayOrder = 1 });
unitofwork.BookingClassificationRepository.Insert(new BookingClasification() { ClassificationName = "Class 5", DisplayOrder = 1 });
var added = unitofwork.AccessLevelRepository.Insert(new AccessLevel { Name = "Level 1", Level = 1 });
var newRestaurant = new Restaurant() { Capacity = 100, Name = "Rebellion", Location = "Sydney", RosteringStartDay = (int)DayOfWeek.Monday, RosteringWeekDuration = 1, RosteringWeekOffset = 0 };
var newemployee = new Employee() { Id = 111, FirstName = "Scott", LastName = "Becker", AccessLevel = added, Email = "*****@*****.**", PhoneNumber = "999999999" };
var availabilities = new List<EmployeeAvailabilityDay>();
availabilities.Add(new EmployeeAvailabilityDay() { DayOfWeek = (int)DayOfWeek.Monday, StartDate = new DateTime(2014, 1, 1), Notes = "Initial Availability", StartTime = new DateTime(2014, 10, 10, 16, 30, 0),DateAdded= DateTime.Now });
availabilities.Add(new EmployeeAvailabilityDay() { DayOfWeek = (int)DayOfWeek.Tuesday, StartDate = new DateTime(2014, 1, 1), Notes = "Initial Availability", StartTime = new DateTime(2014, 10, 10, 18, 30, 0), DateAdded = DateTime.Now });
availabilities.Add(new EmployeeAvailabilityDay() { DayOfWeek = (int)DayOfWeek.Wednesday, StartDate = new DateTime(2014, 1, 1), Notes = "Initial Availability", StartTime = new DateTime(2014, 10, 10, 12, 30, 0), DateAdded = DateTime.Now });
availabilities.Add(new EmployeeAvailabilityDay() { DayOfWeek = (int)DayOfWeek.Thursday, StartDate = new DateTime(2014, 1, 1), Notes = "Initial Availability", StartTime = new DateTime(2014, 10, 10, 15, 30, 0), DateAdded = DateTime.Now });
availabilities.Add(new EmployeeAvailabilityDay() { DayOfWeek = (int)DayOfWeek.Friday, StartDate = new DateTime(2014, 1, 1), Notes = "Initial Availability", StartTime = new DateTime(2014, 10, 10, 13, 30, 0), DateAdded = DateTime.Now });
availabilities.Add(new EmployeeAvailabilityDay() { DayOfWeek = (int)DayOfWeek.Saturday, StartDate = new DateTime(2014, 1, 1), Notes = "Initial Availability", StartTime = new DateTime(2014, 10, 10, 16, 30, 0), DateAdded = DateTime.Now });
availabilities.Add(new EmployeeAvailabilityDay() { DayOfWeek = (int)DayOfWeek.Sunday, StartDate = new DateTime(2014, 1, 1), Notes = "Initial Availability", StartTime = new DateTime(2014, 10, 10, 14, 30, 0), DateAdded = DateTime.Now });
newemployee.EmployeeAvailabilityDays = availabilities;
newemployee.EmployeeNAs.Add(new EmployeeNA() { StartDate = DateTime.Now.AddDays(-7), EndDate = DateTime.Now.AddDays(-6), Notes = "Visiting Grandma", SubmittedBy = newemployee ,SubmittedDate=DateTime.Now});
newemployee.EmployeeNAs.Add(new EmployeeNA() { StartDate = DateTime.Now.AddDays(6), EndDate = DateTime.Now.AddDays(7), Notes = "Visiting Grandma Again", SubmittedBy = newemployee, SubmittedDate = DateTime.Now });
newemployee.EmployeeNAs.Add(new EmployeeNA() { StartDate = DateTime.Now.AddDays(9), EndDate = DateTime.Now.AddDays(10), Notes = "Visiting Grandma", SubmittedBy = newemployee, SubmittedDate = DateTime.Now });
newemployee.EmployeeAvailabilityHoursRequests.Add(new EmployeeAvailabilityHoursRequest() { StartDate = new DateTime(2014, 1, 1), RequestedMinimumHours = 8, RequestedMaximumHours = 30 });
unitofwork.AccessLevelRepository.Insert(new AccessLevel() { Name = "Level 2", Level = 2 });
unitofwork.AccessLevelRepository.Insert(new AccessLevel() { Name = "Level 3", Level = 3 });
unitofwork.AccessLevelRepository.Insert(new AccessLevel() { Name = "Level 4", Level = 4 });
unitofwork.EmployeeRepository.Insert(newemployee);
unitofwork.PresetNoteRepository.Insert(new PresetNote() { Name = "Gluten Free", Severity = 5 });
unitofwork.PresetNoteRepository.Insert(new PresetNote() { Name = "Dairy Free", Severity = 5 });
unitofwork.PresetNoteRepository.Insert(new PresetNote() { Name = "Window Seat", Severity = 2 });
unitofwork.LockedOutDateRepository.Insert(new LockOutDate() { Name = "Locked Out Date 1", Reason = "Cause", StartDate = DateTime.Now, EndDate = DateTime.Now.AddYears(1), DateCreated = DateTime.Now, Restaurant = newRestaurant });
unitofwork.LockedOutDateRepository.Insert(new LockOutDate() { Name = "Locked Out Date 2", Reason = "Cause", StartDate = DateTime.Now, EndDate = DateTime.Now.AddYears(1), DateCreated = DateTime.Now, Restaurant = newRestaurant });
unitofwork.LockedOutDateRepository.Insert(new LockOutDate() { Name = "Locked Out Date 3", Reason = "Cause", StartDate = DateTime.Now, EndDate = DateTime.Now.AddYears(1), DateCreated = DateTime.Now, Restaurant = newRestaurant });
unitofwork.LockedOutDateRepository.Insert(new LockOutDate() { Name = "Locked Out Date 4", Reason = "Cause", StartDate = DateTime.Now, EndDate = DateTime.Now.AddYears(1), DateCreated = DateTime.Now, Restaurant = newRestaurant });
unitofwork.DateNoteRepository.Insert(new DateNote() { Note = "Note1", AppearOnAddingBooking = true, AppearOnRoster = true, StartDate = DateTime.Now, EndDate = DateTime.Now.AddYears(1), Restaurant = newRestaurant, DateCreated = DateTime.Now });
unitofwork.DateNoteRepository.Insert(new DateNote() { Note = "Note2", AppearOnAddingBooking = false, AppearOnRoster = true, StartDate = DateTime.Now, EndDate = DateTime.Now.AddYears(1), DateCreated = DateTime.Now, Restaurant = newRestaurant });
unitofwork.DateNoteRepository.Insert(new DateNote() { Note = "Note3", AppearOnAddingBooking = true, AppearOnRoster = false, StartDate = DateTime.Now, EndDate = DateTime.Now.AddYears(1), DateCreated = DateTime.Now, Restaurant = newRestaurant });
unitofwork.ShiftCategoryRepository.Insert(new ShiftCategory() { CategoryName="Quiet Night" });
unitofwork.ShiftCategoryRepository.Insert(new ShiftCategory() { CategoryName="Busy Week Night" });
unitofwork.ShiftCategoryRepository.Insert(new ShiftCategory() { CategoryName="Saturday Night" });
unitofwork.ShiftCategoryRepository.Insert(new ShiftCategory() { CategoryName= "Banquets < 100" });
unitofwork.Save();
}
}
private void button3_Click(object sender, EventArgs e)
{
if (dataGridView1.SelectedRows.Count > 0)
{
var unitofwork = new UnitOfWork();
for(int i=0; i<dataGridView1.SelectedRows.Count;i++)
{
var comm = commendations[dataGridView1.SelectedRows[i].Index];
unitofwork.EmployeeCommendationClassificationRepository.Delete( comm);
}
unitofwork.Save();
Rebind();
}
}
private void AddEditShiftRoster_Load(object sender, EventArgs e)
{
var unitofwork = new UnitOfWork();
RebindPresets();
WorkingShift = unitofwork.ShiftRepository.Get(x => x.DayOfTheWeek == DayOfWeek && x.RosterId == RosterId, includeProperties: "EmployeeShifts.EmployeeShiftAssignments").FirstOrDefault();
if (WorkingShift != null)
{
ShiftSlots = WorkingShift.EmployeeShifts.ToList();
txtNotes.Text = WorkingShift.Notes;
RebindShiftSlots();
}
RebindBookingInformation();
}
private void AddEditStaffCommendation_Load(object sender, EventArgs e)
{
var unitOfWork = new UnitOfWork();
cbClassification.DisplayMember = "Name";
cbEmployee.Rebind();
cbClassification.DataSource = unitOfWork.EmployeeCommendationClassificationRepository.Get(x=> x.AvailableOnUser).ToList();
if (currentCommendationId!= null)
{
currentCommendation = unitOfWork.EmployeeCommendationRepository.Get(x => x.Id == currentCommendationId).FirstOrDefault();
txtNotes.Text = currentCommendation.Notes;
cbEmployee.SelectedEmployee = currentCommendation.RecievingEmployee;
}
}
private void button1_Click(object sender, EventArgs e)
{
var unitofwork = new UnitOfWork();
if (LockedDateID.HasValue)
{
unitofwork.LockedOutDateRepository.Update(GetFields(workinglockedDate));
}
else
{
unitofwork.LockedOutDateRepository.Insert(GetFields(new LockOutDate()));
}
unitofwork.Save();
this.DialogResult = DialogResult.OK;
}
private void AddEditBookingNote_Load(object sender, EventArgs e)
{
var unitOfWork = new UnitOfWork();
if(presetID!=null)
{
WorkingNote = unitOfWork.BookingClassificationRepository.GetByID(presetID.Value);
}
if(WorkingNote !=null)
{
tbNote.Text = WorkingNote.ClassificationName;
}
//stylesSheetManager1.ApplyStyles();
}
private void button1_Click(object sender, EventArgs e)
{
var unitOfWork = new UnitOfWork();
if (NAID!= null)
{
unitOfWork.EmployeeNARepository.Update(GetFields(workingNA));
}
else
{
unitOfWork.EmployeeNARepository.Insert(GetFields(new EmployeeNA()));
}
unitOfWork.Save();
this.DialogResult = DialogResult.OK;
}
private void AddEditBookingNote_Load(object sender, EventArgs e)
{
var unitOfWork = new UnitOfWork();
if(presetID!=null)
{
WorkingNote = unitOfWork.PresetNoteRepository.GetByID(presetID.Value);
}
if(WorkingNote !=null)
{
tbNote.Text = WorkingNote.Name;
nmudSeverity.Value = WorkingNote.Severity;
}
stylesSheetManager1.ApplyStyles();
}
private void AddEditEmployee_Load(object sender, EventArgs e)
{
var unitOfWork = new UnitOfWork();
comboBox1.DisplayMember = "Name";
comboBox1.ValueMember = "Id";
comboBox1.DataSource = unitOfWork.AccessLevelRepository.Get();
if (currentEmployeeId != null)
{
currentUser = unitOfWork.EmployeeRepository.Get(x => x.Id == currentEmployeeId.Value, null, "AccessLevel").FirstOrDefault();
tbFirstName.Text = currentUser.FirstName;
tbLastName.Text = currentUser.LastName;
tbEmail.Text = currentUser.Email;
tbPhoneNumber.Text = currentUser.PhoneNumber;
tbID.Text = currentUser.Id.ToString();
comboBox1.SelectedValue = currentUser.AccessLevel.Id;
}
}
private void button1_Click(object sender, EventArgs e)
{
var unitofwork = new UnitOfWork();
SkillCategory parent=null;
if(parentSkillCategoryId!= null)
parent= unitofwork.SkillCategoryRepository.Get(x => x.Id == parentSkillCategoryId).FirstOrDefault();
if (currentSkillCategoryId!=null)
{
unitofwork.SkillCategoryRepository.Update(GetFields(currentSkillCategory,parent));
}
else
{
unitofwork.SkillCategoryRepository.Insert(GetFields(new SkillCategory(),parent));
}
unitofwork.Save();
this.DialogResult = DialogResult.OK;
}
private void button1_Click(object sender, EventArgs e)
{
var unitOfWork = new UnitOfWork();
if(RestaurantID== null)
{
unitOfWork.RestaurantRepository.Insert(new Restaurant() { Location = tbLocation.Text, Name = tbName.Text, Capacity = (int)tbCapacity.Value });
}
else
{
Restaurant.Name = tbName.Text;
Restaurant.Capacity = (int)tbCapacity.Value;
Restaurant.Location = tbLocation.Text;
unitOfWork.RestaurantRepository.Update(Restaurant);
}
unitOfWork.Save();
this.DialogResult = DialogResult.OK;
}
private void AddEditCommendationClassification_Load(object sender, EventArgs e)
{
var unitofwork = new UnitOfWork();
if(workingClassificationID!=null)
{
workingClassification = unitofwork.EmployeeCommendationClassificationRepository.Get(x => x.Id == workingClassificationID,includeProperties: "EmployeeCommendationSkillCategories.SkillCategory").FirstOrDefault();
textBox1.Name = workingClassification.Name;
numericUpDown1.Value = workingClassification.Weighting;
checkBox1.Checked= workingClassification.AvailableOnUser ;
checkBox2.Checked= workingClassification.AvailableOnTeam ;
}
else
{
workingClassification = new EmployeeCommendationClassification();
}
RebindSkills();
}
private void ManagePermissions_Load(object sender, EventArgs e)
{
var unitOfWork = new UnitOfWork();
WorkingLevel = unitOfWork.AccessLevelRepository.Get(x => x.Id == AccessLevelId, includeProperties: "Permissions").FirstOrDefault();
label3.Text = WorkingLevel.Name;
foreach (var v in AllPermissions.PermissionList())
{
checkedListBox1.Items.Add(v.PermissionName, v.PermissionValue);
}
for(int i = 0; i<WorkingLevel.Permissions.Count; i++)
{
if(checkedListBox1.Items.IndexOf(WorkingLevel.Permissions.ElementAt(i).PermissionName)!=-1)
{
checkedListBox1.SetItemChecked(checkedListBox1.Items.IndexOf(WorkingLevel.Permissions.ElementAt(i).PermissionName), WorkingLevel.Permissions.ElementAt(i).PermissionValue);
}
}
}
private void AddEditRestaurant_Load(object sender, EventArgs e)
{
if(RestaurantID!=null)
{
var unitOfWork = new UnitOfWork();
Restaurant = unitOfWork.RestaurantRepository.Get(x => x.Id == RestaurantID).FirstOrDefault();
tbLocation.Text = Restaurant.Location;
tbName.Text = Restaurant.Name;
tbCapacity.Value = Restaurant.Capacity;
}
}
