private static void DropExistingConnectionToDatabase(SilicusIpDataContext context, string databaseName)
{
var sqlContent = Content(DropConnectionScript);
var modifiedSqlScript = sqlContent.Replace("@DatabaseName", databaseName);
context.Database.ExecuteSqlCommand(modifiedSqlScript);
}
private static void AddIndexes(SilicusIpDataContext context, string databaseName)
{
context.Database.CreateIfNotExists();
var sqlContent = Content(IndexScriptLocation);
var modifiedSqlScript = sqlContent.Replace("@DatabaseName", databaseName);
context.Database.ExecuteSqlCommand(modifiedSqlScript);
}
protected override bool AuthorizeCore(HttpContextBase httpContext)
{
bool authorize = false;
if (allowedroles.Contains(RoleName.Candidate.ToString()))
{
var commondbContext = new SilicusIpDataContext(ConfigurationManager.ConnectionStrings["SilicusIpDataContext"].ConnectionString);
var users = commondbContext.Query <User>().ToList();
var loggedInUser = HttpContext.Current.User.Identity.Name;
authorize = users.Find(x => x.Email.ToLower() == loggedInUser.ToLower()) != null;
}
else
{
var userRoles = MvcApplication.getCurrentUserRoles();
if (userRoles.Count > 0)
{
authorize = allowedroles.Intersect(userRoles).Any();
}
}
return(authorize);
}
public static void Seed(SilicusIpDataContext context)
{
//DropExistingConnectionToDatabase(context, DatabaseName);
//AddIndexes(context, DatabaseName);
// context.Add(new User
//{
// FirstName = "Test",
// LastName = "Admin",
// NewPassword = "******",
// ConfirmPassword = "******",
// // Address = "Test",
// Email = "*****@*****.**",
// IdentityUserId = new System.Guid("5C9DE1BA-083E-425F-AE0B-FCB222E9DBDF"),
// Role = RoleName.Admin.ToString(),
// IsActive = true,
// IsDeleted = false
//});
// context.Add(new User
// {
// FirstName = "Nilkanth",
// LastName = "Kapale",
// NewPassword = "******",
// ConfirmPassword = "******",
// // Address = "Sangvi",
// Email = "*****@*****.**",
// IdentityUserId = new System.Guid("88B34980-EDD3-420C-8387-621B629A4E9B"),
// Role = RoleName.Panel.ToString(),
// IsActive = true,
// IsDeleted = false
// });
// context.Add(new User
// {
// FirstName = "Lorem",
// LastName = "Lipsum",
// NewPassword = "******",
// ConfirmPassword = "******",
// // Address = "Pune",
// Email = "*****@*****.**",
// IdentityUserId = new System.Guid("50cad72d-4ff3-48ce-ba32-44675cfd2744"),
// Role = RoleName.Candidate.ToString(),
// Gender = "Male",
// // Department = "Delivery",
// TestStatus = Convert.ToString(TestStatus.NotAssigned),
// Position = "Dot Net Developer",
// // Experience = "5",
// IsActive = true,
// IsDeleted = false
// });
context.Add(new Project
{
ProjectDescription = "Landmark"
});
context.Add(new Project
{
ProjectDescription = "MorningStar"
});
context.Add(new ProjectDetail
{
ProjectName = "Landmark",
Status = "Red"
});
context.Add(new ProjectDetail
{
ProjectName = "MorningStar",
Status = "Green"
});
context.Add(new Manager
{
ManagerName = "Shailendra"
});
context.Add(new Manager
{
ManagerName = "Sulekha"
});
context.Add(new Position
{
PositionName = "Dot Net Developer"
});
context.Add(new Tags
{
TagName = "ASP.NET",
Description = "ASP.Net related questions",
IsActive = true
});
context.Add(new Tags
{
TagName = "MVC5",
Description = "ASP.Net MVC related questions.",
IsActive = true
});
context.Add(new TestSuite
{
TestSuiteName = "Dot Net Developer",
Position = 1,
Duration = 30,
Competency = 2,
IsDeleted = false,
PrimaryTags = "1,2",
Weights = "70,30",
Proficiency = "1,2",
Status = 1,
});
context.Add(new TestSuite
{
TestSuiteName = "MVC Developer",
Position = 1,
Duration = 30,
Competency = 2,
IsDeleted = false,
PrimaryTags = "1,2",
Weights = "30,70",
Proficiency = "1,2",
Status = 1,
});
context.Add(new Question
{
QuestionType = 1,
QuestionDescription = "Which component handle <strong>Memory management</strong> in ASP.NET?",
AnswerType = 1,
OptionCount = 5,
Option1 = "CLR",
Option2 = "CTS",
Option3 = "CLS",
Option4 = "BCL",
Option5 = "All",
Option6 = null,
Option7 = null,
Option8 = null,
CorrectAnswer = "1",
Answer = null,
Tags = "1,2",
ProficiencyLevel = 1,
Duration = 1,
Marks = 1,
IsPublishd = true,
IsDeleted = false,
CreatedOn = DateTime.Now,
CreatedBy = 0,
ModifiedOn = DateTime.Now,
ModifiedBy = 0
});
context.Add(new Question
{
QuestionType = 2,
QuestionDescription = "Write program of get name of employee from id from list using <strong>lymbda expression</strong>.",
AnswerType = 1,
OptionCount = 2,
Option1 = null,
Option2 = null,
Option3 = null,
Option4 = null,
Option5 = null,
Option6 = null,
Option7 = null,
Option8 = null,
CorrectAnswer = null,
Answer = "List<Emp> emp = emp.Select(x=>x.Id==2).Name;",
Tags = "1",
ProficiencyLevel = 1,
Duration = 1,
Marks = 2,
IsPublishd = true,
IsDeleted = false,
CreatedOn = DateTime.Now,
CreatedBy = 0,
ModifiedOn = DateTime.Now,
ModifiedBy = 0
});
context.Add(new Question
{
QuestionType = 1,
QuestionDescription = "Web.config file is used...",
AnswerType = 1,
OptionCount = 6,
Option1 = "Configures the time that the server-side codebehind module is called",
Option2 = "To store the global information and variable definitions for the application",
Option3 = "To configure the web server",
Option4 = "To configure the web browser",
Option5 = "All",
Option6 = "None",
Option7 = null,
Option8 = null,
CorrectAnswer = "2",
Answer = null,
Tags = "1",
ProficiencyLevel = 2,
Duration = 1,
Marks = 2,
IsPublishd = true,
IsDeleted = false,
CreatedOn = DateTime.Now,
CreatedBy = 0,
ModifiedOn = DateTime.Now,
ModifiedBy = 0
});
context.Add(new Question
{
QuestionType = 1,
QuestionDescription = "Which of the following object is not an ASP component?",
AnswerType = 1,
OptionCount = 3,
Option1 = "LinkCounter",
Option2 = "Counter",
Option3 = "AdRotator",
Option4 = null,
Option5 = null,
Option6 = null,
Option7 = null,
Option8 = null,
CorrectAnswer = "1,2",
Answer = null,
Tags = "1",
ProficiencyLevel = 2,
Duration = 1,
Marks = 1,
IsPublishd = true,
IsDeleted = false,
CreatedOn = DateTime.Now,
CreatedBy = 0,
ModifiedOn = DateTime.Now,
ModifiedBy = 0
});
context.Add(new Question
{
QuestionType = 1,
QuestionDescription = "The first event triggers in an aspx page is Page_Init().",
AnswerType = 1,
OptionCount = 2,
Option1 = "True",
Option2 = "False",
Option3 = null,
Option4 = null,
Option5 = null,
Option6 = null,
Option7 = null,
Option8 = null,
CorrectAnswer = "1",
Answer = null,
Tags = "1",
ProficiencyLevel = 2,
Duration = 1,
Marks = 1,
IsPublishd = true,
IsDeleted = false,
CreatedOn = DateTime.Now,
CreatedBy = 0,
ModifiedOn = DateTime.Now,
ModifiedBy = 0
});
context.Add(new Question
{
QuestionType = 2,
QuestionDescription = "How do we create a FileSystemObject?",
AnswerType = 1,
OptionCount = 2,
Option1 = null,
Option2 = null,
Option3 = null,
Option4 = null,
Option5 = null,
Option6 = null,
Option7 = null,
Option8 = null,
CorrectAnswer = null,
Answer = "Server.CreateObject('Scripting.FileSystemObject')",
Tags = "1,2",
ProficiencyLevel = 1,
Duration = 1,
Marks = 2,
IsPublishd = true,
IsDeleted = false,
CreatedOn = DateTime.Now,
CreatedBy = 0,
ModifiedOn = DateTime.Now,
ModifiedBy = 0
});
}
