public static void RemoveAllData(TdDomainContext context)
{
context.UserSettings.RemoveRange(context.UserSettings);
context.TicketTags.RemoveRange(context.TicketTags);
context.TicketEventNotifications.RemoveRange(context.TicketEventNotifications);
context.TicketSubscribers.RemoveRange(context.TicketSubscribers);
context.TicketEvents.RemoveRange(context.TicketEvents);
context.Tickets.RemoveRange(context.Tickets);
context.Projects.RemoveRange(context.Projects.Where(p => p.ProjectName != "Default"));
context.TicketDeskSettings = new ApplicationSetting() {};
context.SaveChanges();
}
public static void RemoveAllData(TdDomainContext context)
{
context.UserSettings.RemoveRange(context.UserSettings);
context.TicketTags.RemoveRange(context.TicketTags);
context.TicketEventNotifications.RemoveRange(context.TicketEventNotifications);
context.TicketSubscribers.RemoveRange(context.TicketSubscribers);
context.TicketEvents.RemoveRange(context.TicketEvents);
context.Tickets.RemoveRange(context.Tickets);
context.Projects.RemoveRange(context.Projects.Where(p => p.ProjectName != "Default"));
context.TicketDeskSettings = new ApplicationSetting()
{
};
context.SaveChanges();
}
public static async Task<int> GetUserSelectedProjectIdAsync(this UserSettingsManager userSettingsManager, TdDomainContext context)
{
//TODO: We have to take the source context as a param because we have sync callers (child action in navigation).
// Trying to use dependency resolver with a sync caller results in the context being invoked without a security provider.
// The entire concept of child actions are heavily refactored in MVC 6, so this should not be an issue in future versions.
var projects = context.Projects;
var settings = await userSettingsManager.GetSettingsForUserAsync(context.SecurityProvider.CurrentUserId);
var projectId = settings.SelectedProjectId ?? 0;
//if user's selected project points to a project that no longer exists, reset
// normally this wouldn't happen since the dbcontext will update user settings when projects are deleted
if (projectId != 0 && projects.All(p => p.ProjectId != projectId))
{
projectId = 0;
await UpdateUserSelectedProjectAsync(userSettingsManager, projectId, context.SecurityProvider.CurrentUserId);
context.SaveChanges();
}
return projectId;
}
public static async Task <int> GetUserSelectedProjectIdAsync(this UserSettingsManager userSettingsManager, TdDomainContext context)
{
//TODO: We have to take the source context as a param because we have sync callers (child action in navigation).
// Trying to use dependency resolver with a sync caller results in the context being invoked without a security provider.
// The entire concept of child actions are heavily refactored in MVC 6, so this should not be an issue in future versions.
var projects = context.Projects;
var settings = await userSettingsManager.GetSettingsForUserAsync(context.SecurityProvider.CurrentUserId);
var projectId = settings.SelectedProjectId ?? 0;
//if user's selected project points to a project that no longer exists, reset
// normally this wouldn't happen since the dbcontext will update user settings when projects are deleted
if (projectId != 0 && projects.All(p => p.ProjectId != projectId))
{
projectId = 0;
await UpdateUserSelectedProjectAsync(userSettingsManager, projectId, context.SecurityProvider.CurrentUserId);
context.SaveChanges();
}
return(projectId);
}
public static void SetupDemoData(TdDomainContext context)
{
RemoveAllData(context);
context.SaveChanges();
context.Projects.AddOrUpdate(p => p.ProjectName, new Project()
{
ProjectName = "NullSoft", ProjectDescription = "NullSoft Rocks"
});
var dProj = context.Projects.First();
context.Tickets.AddOrUpdate(t => t.Title,
new Ticket
{
ProjectId = dProj.ProjectId,
Title = "Test Unassigned Ticket",
AffectsCustomer = false,
Category = "Hardware",
CreatedBy = "17f78f38-fa68-445f-90de-38896140db28",
TicketStatus = TicketStatus.Active,
CurrentStatusDate = DateTimeOffset.Now,
CurrentStatusSetBy = "72bdddfb-805a-4883-94b9-aa494f5f52dc",
Details =
"Lorem ipsum dolor sit amet, consectetur adipiscing elit fusce vel sapien elit in malesuada semper mi, id sollicitudin urna fermentum ut fusce varius nisl ac ipsum gravida vel pretium tellus.",
IsHtml = false,
LastUpdateBy = "72bdddfb-805a-4883-94b9-aa494f5f52dc",
LastUpdateDate = DateTimeOffset.Now,
Owner = "17f78f38-fa68-445f-90de-38896140db28",
Priority = "Low",
TagList = "test,moretest",
TicketTags = new List <TicketTag> {
new TicketTag()
{
TagName = "test"
}, { new TicketTag()
{
TagName = "moretest"
} }
},
TicketType = "Problem",
TicketEvents = new[] { TicketEvent.CreateActivityEvent("17f78f38-fa68-445f-90de-38896140db28", TicketActivity.Create, null, null, null) }
});
var titles = new[] { "A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L", "M", "N", "O", "P", "Q", "R", "A1", "B1", "C1", "D1", "E1", "F1", "G1", "H1", "I1", "J1", "K1", "L1", "M1", "N1", "O1", "P1", "Q1", "R1" };
var n = 0;
foreach (var p in titles)
{
n--;
string cc;
string tt;
string oo;
if (Math.Abs(n) % 2 == 0)
{
tt = "Question";
cc = "Hardware";
oo = "64165817-9cb5-472f-8bfb-6a35ca54be6a";
}
else
{
tt = "Problem";
cc = "Software";
oo = "17f78f38-fa68-445f-90de-38896140db28";
}
var now = DateTimeOffset.Now.AddDays(n);
context.Tickets.AddOrUpdate(t => t.Title,
new Ticket
{
ProjectId = dProj.ProjectId,
Title = "Test Ticket " + p,
AffectsCustomer = false,
AssignedTo = "64165817-9cb5-472f-8bfb-6a35ca54be6a",
Category = cc,
CreatedBy = oo,
TicketStatus = (p == "L") ? TicketStatus.Closed : TicketStatus.Active,
CurrentStatusDate = now,
CurrentStatusSetBy = "72bdddfb-805a-4883-94b9-aa494f5f52dc",
Details =
"Lorem ipsum dolor sit amet, consectetur adipiscing elit fusce vel sapien elit in malesuada semper mi, id sollicitudin urna fermentum ut fusce varius nisl ac ipsum gravida vel pretium tellus.",
IsHtml = false,
LastUpdateBy = "72bdddfb-805a-4883-94b9-aa494f5f52dc",
LastUpdateDate = now.AddHours(2),
Owner = oo,
Priority = "Low",
TagList = "test,moretest",
TicketTags = new List <TicketTag> {
new TicketTag()
{
TagName = "test"
}, { new TicketTag()
{
TagName = "moretest"
} }
},
TicketType = tt,
TicketEvents = new[] { TicketEvent.CreateActivityEvent(oo, TicketActivity.Create, null, null, null) }
});
}
context.SaveChanges();
}
public static void SetupDemoData(TdDomainContext context)
{
RemoveAllData(context);
context.SaveChanges();
context.Projects.AddOrUpdate(p => p.ProjectName, new Project() {ProjectName = "NullSoft", ProjectDescription = "NullSoft Rocks"});
var dProj = context.Projects.First();
context.Tickets.AddOrUpdate(t => t.Title,
new Ticket
{
ProjectId = dProj.ProjectId,
Title = "Test Unassigned Ticket",
AffectsCustomer = false,
Category = "Hardware",
CreatedBy = "17f78f38-fa68-445f-90de-38896140db28",
TicketStatus = TicketStatus.Active,
CurrentStatusDate = DateTimeOffset.Now,
CurrentStatusSetBy = "72bdddfb-805a-4883-94b9-aa494f5f52dc",
Details =
"Lorem ipsum dolor sit amet, consectetur adipiscing elit fusce vel sapien elit in malesuada semper mi, id sollicitudin urna fermentum ut fusce varius nisl ac ipsum gravida vel pretium tellus.",
IsHtml = false,
LastUpdateBy = "72bdddfb-805a-4883-94b9-aa494f5f52dc",
LastUpdateDate = DateTimeOffset.Now,
Owner = "17f78f38-fa68-445f-90de-38896140db28",
Priority = "Low",
TagList = "test,moretest",
TicketTags = new List<TicketTag> { new TicketTag() { TagName = "test" }, { new TicketTag() { TagName = "moretest" } } },
TicketType = "Problem",
TicketEvents = new[] { TicketEvent.CreateActivityEvent("17f78f38-fa68-445f-90de-38896140db28", TicketActivity.Create, null, null, null) }
});
var titles = new[] { "A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L", "M", "N", "O", "P", "Q", "R", "A1", "B1", "C1", "D1", "E1", "F1", "G1", "H1", "I1", "J1", "K1", "L1", "M1", "N1", "O1", "P1", "Q1", "R1" };
var n = 0;
foreach (var p in titles)
{
n--;
string cc;
string tt;
string oo;
if (Math.Abs(n) % 2 == 0)
{
tt = "Question";
cc = "Hardware";
oo = "64165817-9cb5-472f-8bfb-6a35ca54be6a";
}
else
{
tt = "Problem";
cc = "Software";
oo = "17f78f38-fa68-445f-90de-38896140db28";
}
var now = DateTimeOffset.Now.AddDays(n);
context.Tickets.AddOrUpdate(t => t.Title,
new Ticket
{
ProjectId = dProj.ProjectId,
Title = "Test Ticket " + p,
AffectsCustomer = false,
AssignedTo = "64165817-9cb5-472f-8bfb-6a35ca54be6a",
Category = cc,
CreatedBy = oo,
TicketStatus = (p == "L") ? TicketStatus.Closed : TicketStatus.Active,
CurrentStatusDate = now,
CurrentStatusSetBy = "72bdddfb-805a-4883-94b9-aa494f5f52dc",
Details =
"Lorem ipsum dolor sit amet, consectetur adipiscing elit fusce vel sapien elit in malesuada semper mi, id sollicitudin urna fermentum ut fusce varius nisl ac ipsum gravida vel pretium tellus.",
IsHtml = false,
LastUpdateBy = "72bdddfb-805a-4883-94b9-aa494f5f52dc",
LastUpdateDate = now.AddHours(2),
Owner = oo,
Priority = "Low",
TagList = "test,moretest",
TicketTags = new List<TicketTag> { new TicketTag() { TagName = "test" }, { new TicketTag() { TagName = "moretest" } } },
TicketType = tt,
TicketEvents = new[] { TicketEvent.CreateActivityEvent(oo, TicketActivity.Create, null, null, null) }
});
}
context.SaveChanges();
}