public async virtual Task <ActionResult> Index()
{
var submittedActivities = await SubmittedActivityCollection.GetSubmittedActivitiesByEmployeeIdAsync(AuthenticatedUser.EmployeeId, null, null);
var activityIndexViewModel = new ActivityIndexViewModel()
{
SubmittedActivity = SubmitActivity.CreateActivitySubmission(AuthenticatedUser.EmployeeId),
AvailableUsers = await UserCollection.GetAllAvailabileUsersForCurrentUserAsync(),
};
var allActivities = await ActivityCollection.GetAllActivitiesAsync(true);
activityIndexViewModel.PossibleActivities = allActivities.Select(ai => new SelectListItem()
{
Text = ai.Name, Value = ai.Id.ToString(CultureInfo.CurrentCulture)
});
activityIndexViewModel.PreviousActivities = await SubmittedActivityCollection.GetSubmittedActivitiesByEmployeeIdAsync(AuthenticatedUser.EmployeeId, null, null);
return(View(Mvc.Activities.Views.Index, activityIndexViewModel));
}
public async Task StartAsync()
{
while (true)
{
try
{
var fileName = FileLocation;
if (System.IO.File.Exists(fileName))
{
var connectionString =
string.Format(
"Provider=Microsoft.Jet.OLEDB.4.0; data source={0}; Extended Properties=Excel 8.0;",
fileName);
using (var adapter = new OleDbDataAdapter("SELECT * FROM [Data$]", connectionString))
{
var ds = new DataSet();
adapter.Fill(ds, "AnniversaryData");
DataTable data = ds.Tables["AnniversaryData"];
var activityId = ActivityId;
foreach (DataRow row in data.Rows)
{
var adName = row.Field <string>("Magenic Username");
var years = int.Parse(row.Field <string>("Years"));
var submittedActivities = await SubmittedActivityCollection.GetSubmittedActivitiesByADNameAsync(adName, activityId);
if (submittedActivities.Count < years)
{
ICslaPrincipal employee = null;
try
{
employee = await BusinessLogic.Security.CustomPrincipal.LoadAsync(adName);
}
catch (Exception ex)
{
Logger.Error <ADProcessor>(ex.Message, ex);
}
if (employee != null)
{
for (var i = 0; i < (years - submittedActivities.Count); i++)
{
var activitySubmission = SubmitActivity.CreateActivitySubmission(((ICustomIdentity)employee.Identity).EmployeeId);
activitySubmission.ActivityId = activityId;
activitySubmission.ActivitySubmissionDate = DateTime.UtcNow;
activitySubmission.Notes = "Created by automatic feed.";
await activitySubmission.SaveAsync();
}
}
}
}
}
System.IO.File.Delete(fileName);
}
}
catch (Exception ex)
{
Logger.Error <ADProcessor>(ex.Message, ex);
}
finally
{
Thread.Sleep(SleepInterval);
}
}
}
