private static void DropExistingConnectionToDatabase(ProjectTrackerIpDataContext context, string databaseName)
{
var sqlContent = Content(DropConnectionScript);
var modifiedSqlScript = sqlContent.Replace("@DatabaseName", databaseName);
context.Database.ExecuteSqlCommand(modifiedSqlScript);
}
private static void AddConstraints(ProjectTrackerIpDataContext context, string databaseName)
{
context.Database.CreateIfNotExists();
var sqlContent = Content(UniqueConstraintScript);
var modifiedSqlScript = sqlContent.Replace("@DatabaseName", databaseName);
context.Database.ExecuteSqlCommand(modifiedSqlScript);
}
private static void SeedMembershipData(ProjectTrackerIpDataContext context, string databaseName)
{
context.Database.CreateIfNotExists();
var sqlContent = Content(IndexScriptSeedMembershipLocation);
var modifiedSqlScript = sqlContent.Replace("@DatabaseName", databaseName);
context.Database.ExecuteSqlCommand(modifiedSqlScript);
}
public static void Seed(ProjectTrackerIpDataContext context)
{
AddConstraints(context, DatabaseName);
SeedMembershipData(context, DatabaseName);
AddDefaultProject(context);
AddDefaultStatus(context);
AddDefaultWeekData(context);
AddProjectMapping(context);
AddProjecStatusData(context);
AddProjectResouceUtilizationData(context);
}
private static void AddDefaultStatus(ProjectTrackerIpDataContext context)
{
context.Add(new Status
{
StatusName = "Green"
});
context.Add(new Status
{
StatusName = "Yellow"
});
context.Add(new Status
{
StatusName = "Red"
});
context.Add(new Status
{
StatusName = "Closed"
});
}
private static void AddProjectResouceUtilizationData(ProjectTrackerIpDataContext context)
{
context.Add(new ProjectResourceUtilization
{
ProjectId = 1,
WeekId = 61,
RoleName = "Software Engineer",
ResourceName = "Subeer",
AvailableEfforts = 800,
ConsumedEfforts = 800,
Status = "For Development and Testing",
IsActive = true,
CreatedBy = "shaldar",
CreatedDate = DateTime.Now,
ModifiedBy = "shaldar",
ModifiedDate = DateTime.Now
});
context.Add(new ProjectResourceUtilization
{
ProjectId = 3,
WeekId = 61,
RoleName = "Software Engineer",
ResourceName = "subeer",
AvailableEfforts = 400,
ConsumedEfforts = 100,
Status = "For Development",
IsActive = true,
CreatedBy = "shaldar",
CreatedDate = DateTime.Now,
ModifiedBy = "shaldar",
ModifiedDate = DateTime.Now
});
context.Add(new ProjectResourceUtilization
{
ProjectId = 2,
WeekId = 61,
RoleName = "Sr. Software Engineer",
ResourceName = "Sulekha",
AvailableEfforts = 400,
ConsumedEfforts = 200,
Status = "For Design and Development",
IsActive = true,
CreatedBy = "shaldar",
CreatedDate = DateTime.Now,
ModifiedBy = "shaldar",
ModifiedDate = DateTime.Now
});
context.Add(new ProjectResourceUtilization
{
ProjectId = 3,
WeekId = 61,
RoleName = "Sr. Software Engineer",
ResourceName = "Sulekha",
AvailableEfforts = 400,
ConsumedEfforts = 0,
Status = "For Design and Development",
IsActive = true,
CreatedBy = "shaldar",
CreatedDate = DateTime.Now,
ModifiedBy = "shaldar",
ModifiedDate = DateTime.Now
});
}
private static void AddProjecStatusData(ProjectTrackerIpDataContext context)
{
context.Add(new ProjectStatus
{
ProjectSummary = "Design Document Received.",
StatusId = 2,
WeekId = 60,
ProjectId = 4,
CreatedBy = "SRoy",
CreatedDate = DateTime.Now,
ModifiedBy = "SRoy",
ModifiedDate = DateTime.Now,
});
context.Add(new ProjectStatus
{
ProjectSummary = "Design Document Received. Kick off meeting this week",
StatusId = 4,
WeekId = 61,
ProjectId = 4,
CreatedBy = "SRoy",
CreatedDate = DateTime.Now,
ModifiedBy = "SHaldar",
ModifiedDate = DateTime.Now
});
context.Add(new ProjectStatus
{
ProjectSummary = "Project is in critical condition.",
StatusId = 3,
WeekId = 61,
ProjectId = 5,
CreatedBy = "SHaldar",
CreatedDate = DateTime.Now,
ModifiedBy = "SHaldar",
ModifiedDate = DateTime.Now
});
context.Add(new ProjectStatus
{
ProjectSummary = "Started Analysis for the requirement.",
StatusId = 1,
WeekId = 59,
ProjectId = 5,
CreatedBy = "shaldar",
CreatedDate = DateTime.Now,
ModifiedBy = "shaldar",
ModifiedDate = DateTime.Now
});
context.Add(new ProjectStatus
{
ProjectSummary = "Design and Setup is complete.",
StatusId = 2,
WeekId = 61,
ProjectId = 7,
CreatedBy = "shaldar",
CreatedDate = DateTime.Now,
ModifiedBy = "shaldar",
ModifiedDate = DateTime.Now
});
context.Add(new ProjectStatus
{
ProjectSummary = "Almost complete the final sprint.",
StatusId = 1,
WeekId = 61,
ProjectId = 3,
CreatedBy = "Shaldar",
CreatedDate = DateTime.Now,
ModifiedBy = "shaldar",
ModifiedDate = DateTime.Now
});
}
private static void AddDefaultProject(ProjectTrackerIpDataContext context)
{
context.Add(new Project
{
ProjectName = "SMART",
ProjectDescription = "Online Attendance System",
StartDate = DateTime.Now.AddMonths(-5),
PlannedEndDate = DateTime.Now.AddMonths(5),
IsActive = false,
CreatedBy = "SHaldar",
CreatedDate = DateTime.Now.AddMonths(-5),
ModifiedBy = "SBirthare",
ModifiedDate = DateTime.Now.AddMonths(-5)
});
context.Add(new Project
{
ProjectName = "RDBI",
ProjectDescription = "RigDig Business Intelligence",
StartDate = DateTime.Now.AddMonths(-4),
PlannedEndDate = DateTime.Now.AddMonths(4),
IsActive = true,
CreatedBy = "SBirthare",
CreatedDate = DateTime.Now.AddMonths(-4),
ModifiedBy = "SRoy",
ModifiedDate = DateTime.Now.AddMonths(-4)
});
context.Add(new Project
{
ProjectName = "Project Tracker",
ProjectDescription = "Project management System",
StartDate = DateTime.Now.AddMonths(-3),
PlannedEndDate = DateTime.Now.AddMonths(3),
IsActive = true,
CreatedBy = "SBirthare",
CreatedDate = DateTime.Now.AddMonths(-3),
ModifiedBy = "SRoy",
ModifiedDate = DateTime.Now.AddMonths(-3)
});
context.Add(new Project
{
ProjectName = "LandMark",
ProjectDescription = "Geological System",
StartDate = DateTime.Now.AddMonths(-2),
PlannedEndDate = DateTime.Now.AddMonths(3),
IsActive = true,
CreatedBy = "SHaldar",
CreatedDate = DateTime.Now.AddMonths(-2),
ModifiedBy = "SBirthare",
ModifiedDate = DateTime.Now.AddMonths(-2)
});
context.Add(new Project
{
ProjectName = "Entrac",
ProjectDescription = "Internal System",
StartDate = DateTime.Now.AddMonths(-1),
PlannedEndDate = DateTime.Now.AddMonths(2),
IsActive = true,
CreatedBy = "SHaldar",
CreatedDate = DateTime.Now.AddMonths(-1),
ModifiedBy = "SBirthare",
ModifiedDate = DateTime.Now.AddMonths(-1)
});
context.Add(new Project
{
ProjectName = "Morning Star",
ProjectDescription = "Internal System",
StartDate = DateTime.Now.AddMonths(-8),
PlannedEndDate = DateTime.Now.AddMonths(8),
IsActive = true,
CreatedBy = "SHaldar",
CreatedDate = DateTime.Now.AddMonths(-8),
ModifiedBy = "SBirthare",
ModifiedDate = DateTime.Now.AddMonths(-8)
});
context.Add(new Project
{
ProjectName = "Apache",
ProjectDescription = "ERP System",
StartDate = DateTime.Now.AddMonths(-9),
PlannedEndDate = DateTime.Now.AddMonths(8),
IsActive = true,
CreatedBy = "SHaldar",
CreatedDate = DateTime.Now.AddMonths(-9),
ModifiedBy = "SBirthare",
ModifiedDate = DateTime.Now.AddMonths(-9)
});
context.Add(new Project
{
ProjectName = "Jericho",
ProjectDescription = "ERP System",
StartDate = DateTime.Now.AddMonths(-10),
PlannedEndDate = DateTime.Now.AddMonths(9),
IsActive = true,
CreatedBy = "SHaldar",
CreatedDate = DateTime.Now.AddMonths(-10),
ModifiedBy = "SBirthare",
ModifiedDate = DateTime.Now.AddMonths(-10)
});
context.Add(new Project
{
ProjectName = "Johnas",
ProjectDescription = "Dental Plan System",
StartDate = DateTime.Now.AddMonths(-5),
PlannedEndDate = DateTime.Now.AddMonths(5),
IsActive = true,
CreatedBy = "SHaldar",
CreatedDate = DateTime.Now.AddMonths(-5),
ModifiedBy = "SBirthare",
ModifiedDate = DateTime.Now.AddMonths(-5)
});
}
private static void AddProjectMapping(ProjectTrackerIpDataContext context)
{
context.Add(new ProjectMapping
{
UserName = "******",
ProjectId = 1,
IsDeleted = false,
CreatedBy = "SBirthare",
CreatedDate = DateTime.Now.AddYears(-1),
ModifiedBy = "SBirthare",
ModifiedDate = DateTime.Now.AddDays(-10)
});
context.Add(new ProjectMapping
{
UserName = "******",
ProjectId = 3,
IsDeleted = false,
CreatedBy = "SHaldar",
CreatedDate = DateTime.Now.AddYears(-1),
ModifiedBy = "SBirthare",
ModifiedDate = DateTime.Now.AddDays(-10)
});
context.Add(new ProjectMapping
{
UserName = "******",
ProjectId = 2,
IsDeleted = false,
CreatedBy = "SBirthare",
CreatedDate = DateTime.Now.AddYears(-1),
ModifiedBy = "SBirthare",
ModifiedDate = DateTime.Now.AddDays(-10)
});
context.Add(new ProjectMapping
{
UserName = "******",
ProjectId = 4,
IsDeleted = false,
CreatedBy = "SRoy",
CreatedDate = DateTime.Now.AddYears(-1),
ModifiedBy = "SRoy",
ModifiedDate = DateTime.Now.AddDays(-10)
});
context.Add(new ProjectMapping
{
UserName = "******",
ProjectId = 5,
IsDeleted = false,
CreatedBy = "SRoy",
CreatedDate = DateTime.Now.AddYears(-1),
ModifiedBy = "SRoy",
ModifiedDate = DateTime.Now.AddDays(-10)
});
context.Add(new ProjectMapping
{
UserName = "******",
ProjectId = 6,
IsDeleted = false,
CreatedBy = "SHaldar",
CreatedDate = DateTime.Now.AddYears(-1),
ModifiedBy = "SHaldar",
ModifiedDate = DateTime.Now.AddDays(-10)
});
context.Add(new ProjectMapping
{
UserName = "******",
ProjectId = 7,
IsDeleted = false,
CreatedBy = "SHaldar",
CreatedDate = DateTime.Now.AddYears(-1),
ModifiedBy = "SHaldar",
ModifiedDate = DateTime.Now.AddDays(-10)
});
context.Add(new ProjectMapping
{
UserName = "******",
ProjectId = 9,
IsDeleted = false,
CreatedBy = "SHaldar",
CreatedDate = DateTime.Now.AddYears(-1),
ModifiedBy = "SHaldar",
ModifiedDate = DateTime.Now.AddDays(-10)
});
//context.Add(new ProjectMapping
//{
// UserName = "******",
// ProjectId = 9,
// IsDeleted = false,
// CreatedBy = "SBirthare",
// CreatedDate = DateTime.Now.AddYears(-1),
// ModifiedBy = "SBirthare",
// ModifiedDate = DateTime.Now.AddDays(-10)
//});
}
private static void AddDefaultWeekData(ProjectTrackerIpDataContext context)
{
string yearCounts = ConfigurationManager.AppSettings["YearCountsForPastYear"];
if (yearCounts == "0" || yearCounts == null)
{
yearCounts = "2";
}
int weekCount = 0;
///Get weeks of year
int year = DateTime.Now.Year;
//past data
for (int iYearCount = 0; iYearCount < Convert.ToInt16(yearCounts); iYearCount++)
{
int yearCalculate = year - iYearCount - 1;
var firstDayOfYear = new System.DateTime(yearCalculate, 1, 1);
var beginningDayOfWeek = firstDayOfYear.AddDays(-1 * Convert.ToInt32(firstDayOfYear.DayOfWeek));
var endingDayOfWeek = beginningDayOfWeek.AddDays(6);
var weekOfYear = 1;
List <WeekModel> weeksOfTheYear = new List <WeekModel>();
while (beginningDayOfWeek.Year < yearCalculate + 1)
{
var week = new WeekModel {
Number = weekOfYear, BeginningOfWeek = beginningDayOfWeek
};
weeksOfTheYear.Add(week);
beginningDayOfWeek = beginningDayOfWeek.AddDays(7);
endingDayOfWeek = beginningDayOfWeek.AddDays(6);
weekOfYear++;
context.Add(new Week
{
WeekId = weekCount++,
WeekNumber = week.Number,
Year = yearCalculate,
Text = String.Format(
"Week {0}: ({1} to {2})",
week.Number,
beginningDayOfWeek.ToShortDateString(),
endingDayOfWeek.ToShortDateString())
});
}
}
yearCounts = ConfigurationManager.AppSettings["YearCountsForFutureYear"];
//future data
for (int iYearCount = 0; iYearCount < Convert.ToInt16(yearCounts); iYearCount++)
{
int yearCalculate = year + iYearCount;
var firstDayOfYear = new System.DateTime(yearCalculate, 1, 1);
var beginningDayOfWeek = firstDayOfYear.AddDays(-1 * Convert.ToInt32(firstDayOfYear.DayOfWeek));
var endingDayOfWeek = beginningDayOfWeek.AddDays(6);
var weekOfYear = 1;
List <WeekModel> weeksOfTheYear = new List <WeekModel>();
while (beginningDayOfWeek.Year < yearCalculate + 1)
{
var week = new WeekModel {
Number = weekOfYear, BeginningOfWeek = beginningDayOfWeek
};
weeksOfTheYear.Add(week);
beginningDayOfWeek = beginningDayOfWeek.AddDays(7);
endingDayOfWeek = beginningDayOfWeek.AddDays(6);
weekOfYear++;
context.Add(new Week
{
WeekId = weekCount++,
WeekNumber = week.Number,
Year = yearCalculate,
Text = String.Format(
"Week {0}: ({1} to {2})",
week.Number,
beginningDayOfWeek.ToShortDateString(),
endingDayOfWeek.ToShortDateString())
});
}
}
}
