public bool TryGetProperty(string key, out DateTime value) { var result = DateTimeProperties.TryGetValue(key, out var offsetValue); value = offsetValue.LocalDateTime; return(result); }
public void Add(string key, object value) { if (value == null) { return; } if (value is string stringValue) { StringProperties.Add(key, stringValue); } else if (value is byte[] binaryValue) { BinaryProperties.Add(key, binaryValue); } else if (value is bool boolValue) { BooleanProperties.Add(key, boolValue); } else if (value is DateTimeOffset dateTimeOffsetValue) { DateTimeProperties.Add(key, dateTimeOffsetValue); } else if (value is DateTime dateTimeValue) { DateTimeProperties.Add(key, dateTimeValue); } else { IntegerProperties.Add(key, Convert.ToInt64(value)); } }
private static List <PropertyInfo> GetDateTimeProperties <TEntity>() { var key = typeof(TEntity); List <PropertyInfo> dateTimeProperties; if (!DateTimeProperties.TryGetValue(key, out dateTimeProperties)) { dateTimeProperties = key.GetProperties().Where(p => p.PropertyType == typeof(DateTime)).ToList(); DateTimeProperties.Add(key, dateTimeProperties); } return(dateTimeProperties); }
public async Task <ActionResult> ManagerDashboard(int employeeID) { //Set & store query var employeeDetails = await _rosterMeContext.Employees .Where(emp => emp.EmployeeId == employeeID) .OrderBy(emp => emp.FirstName) .ToListAsync(); var employeeBookedShifts = await _rosterMeContext.BookedShifts .Include(bS => bS.Employee) .Include(bS => bS.Shift) //.Where(bS => bS.EmployeeId == employeeID) .OrderBy(bS => bS.Employee.LastName) .Take(5) .ToListAsync(); var employeeAvailabilities = await _rosterMeContext.Availability .Include(avail => avail.Employee) //.Where(avail => avail.EmployeeId == employeeID) .OrderBy(avail => avail.Employee.LastName) .Take(5) .ToListAsync(); //Create String to store logged in employee details String details = ""; //Create variables to store data String employeeName = ""; int employeeAge = 0; //Loop through employee details for (int i = 0; i < employeeDetails.Count(); i++) { //Store details details += "Employee ID: " + employeeDetails[i].EmployeeId + "\n- Name: " + employeeDetails[i].FirstName + " " + employeeDetails[i].LastName + "\n- DOB: " + employeeDetails[i].DOB + "\n- Joining Date: " + employeeDetails[i].JoiningDate + "\n- Position: " + employeeDetails[i].Position + "\n- Role: " + employeeDetails[i].UserRole + "\n- Reporting Manager ID: " + employeeDetails[i].ReportingManagerId + "\n- Department ID: " + employeeDetails[i].DepartmentId + "\n"; //Store data employeeName = employeeDetails[i].FirstName + " " + employeeDetails[i].LastName; employeeAge = DateTimeProperties.calculateYearDifferenceBetweenDateTimes ( employeeDetails[i].DOB, DateTime.Now ); //Set Session HttpContext.Session.SetString(SessionName, employeeName); HttpContext.Session.SetInt32(SessionAge, employeeAge); } //Check if employee's details are null if (employeeDetails == null) { /* * //Return message * return Content(LOG_TAG + ": The Employee details are null" + * "\n- Employee Details query result: " + employeeDetails.Count * ); */ } else { /* * //Return message * return Content(LOG_TAG + ": The Employee details are not null" + * "\n- Employee Details query result: " + employeeDetails.Count + * "\n\nEmployee details:" + * "\n" + details * ); */ } //Store employee details in View Data ViewData["EmployeeDetails"] = employeeDetails; ViewData["EmployeeBookedShifts"] = employeeBookedShifts; ViewData["EmployeeAvailabilities"] = employeeAvailabilities; //Store employee details in Model var model = new Dashboard { Employees = employeeDetails }; //Return View return(View(model)); }
public bool TryGetProperty(string key, out DateTimeOffset value) { return(DateTimeProperties.TryGetValue(key, out value)); }