private void OrganizeViewBugs(StvContext db)
{
var lCourtTypes = new List <SelectListItem>();
lCourtTypes = db.CourtTypes.Select(x => new SelectListItem {
Text = x.CourtTypeName, Value = x.CourtTypeID.ToString()
}).ToList();
ViewBag.vbCourtTypes = lCourtTypes;
}
public SelectionController(StvContext db)
{
_db = db;
candidateService = new CandidateService(db);
credentialService = new CredentialService(db);
selectionService = new SelectionService(db);
settingService = new SettingService(db);
courtService = new CourtService(db);
}
private void OrganizeViewBugs(StvContext db)
{
var lGenders = new List <SelectListItem>();
lGenders = db.Genders.Select(x => new SelectListItem {
Text = x.GenderName, Value = x.GenderID.ToString()
}).ToList();
ViewBag.vbGenders = lGenders;
var lCourts = new List <SelectListItem>();
lCourts = db.Courts.Select(x => new SelectListItem {
Text = x.CourtName, Value = x.CourtID.ToString()
}).ToList();
ViewBag.vbCourts = lCourts;
var lSpecializations = new List <SelectListItem>();
lSpecializations = db.Specializations.Select(x => new SelectListItem {
Text = x.SpecializationName, Value = x.SpecializationID.ToString()
}).ToList();
ViewBag.vbSpecializations = lSpecializations;
}
public CandidateController(StvContext db)
{
_db = db;
service = new CandidateService(_db);
}
public HomeController(StvContext db)
{
_db = db;
}
public SettingController(StvContext db)
{
_db = db;
settingService = new SettingService(db);
}
public CourtController(StvContext db)
{
_db = db;
service = new CourtService(_db);
}
public SummaryController(StvContext db)
{
_db = db;
service = new SelectionService(_db);
}
public void GenerateData()
{
var optionsBuilder = new DbContextOptionsBuilder <StvContext>();
optionsBuilder.UseSqlServer(@"Data Source=.\SQL2014;Database=stvsystemDB;Integrated Security=True;Persist Security Info=False;Pooling=False;MultipleActiveResultSets=False;Connect Timeout=60;Encrypt=False;TrustServerCertificate=True", null);
StvContext db = new StvContext(optionsBuilder.Options);
db.Database.ExecuteSqlCommand("delete from dbo.setting");
db.Database.ExecuteSqlCommand("delete from dbo.credential");
db.Database.ExecuteSqlCommand("delete from dbo.result");
db.Database.ExecuteSqlCommand("delete from dbo.candidate");
db.Database.ExecuteSqlCommand(@"SET IDENTITY_INSERT[dbo].[Candidate] ON
INSERT[dbo].[Candidate] ([CandidateID], [FirstName], [LastName], [MiddleName], [BirthDate], [GenderID], [CourtID], [SpecializationID]) VALUES(1, N'Թեկնածու 1', N'Ազգանուն', N'Հայրանուն', NULL, 1, 1, 1)
INSERT[dbo].[Candidate] ([CandidateID], [FirstName], [LastName], [MiddleName], [BirthDate], [GenderID], [CourtID], [SpecializationID]) VALUES(2, N'Թեկնածու 2', N'Ազգանուն', N'Հայրանուն', NULL, 1, 2, 2)
INSERT[dbo].[Candidate] ([CandidateID], [FirstName], [LastName], [MiddleName], [BirthDate], [GenderID], [CourtID], [SpecializationID]) VALUES(3, N'Թեկնածու 3', N'Ազգանուն', N'Հայրանուն', NULL, 2, 3, 3)
INSERT[dbo].[Candidate] ([CandidateID], [FirstName], [LastName], [MiddleName], [BirthDate], [GenderID], [CourtID], [SpecializationID]) VALUES(4, N'Թեկնածու 4', N'Ազգանուն', N'Հայրանուն', NULL, 1, 4, 1)
INSERT[dbo].[Candidate] ([CandidateID], [FirstName], [LastName], [MiddleName], [BirthDate], [GenderID], [CourtID], [SpecializationID]) VALUES(5, N'Թեկնածու 5', N'Ազգանուն', N'Հայրանուն', NULL, 1, 5, 2)
SET IDENTITY_INSERT[dbo].[Candidate] OFF
SET IDENTITY_INSERT[dbo].[Setting] ON
INSERT[dbo].[Setting]([SettingID], [SelectionName], [SelectionDate], [StartTime], [FinishTime], [SelectionCount], [ParticipantCount], [SelectionStatus]) VALUES(1, N'Թեսթային ընտրություն', '2018-01-01', '08:00', '20:00', 3, 10, 1)
SET IDENTITY_INSERT[dbo].[Setting] OFF");
var setting = db.Settings.Single();
int participantCount = 30;
/////////
CredentialService credentialService = new CredentialService(db);
var dictionary = credentialService.GenerateCredentials((int)participantCount);
for (var i = 0; i < participantCount; i++)
{
Credential credential = new Credential
{
SettingID = setting.SettingID,
Password = dictionary.ElementAt(i).Key,
Status = CredentialStatus.NoSelection,
Setting = setting
};
db.Credentials.Add(credential);
}
db.SaveChanges();
//////////
int[] cycleCount = { 1, 2, 3, 4, 5 };
Random cycleRandom = new Random();
var candidates = (from p in db.Candidates select p.CandidateID).ToArray();
Random candidateRandom = new Random();
foreach (Credential credential in db.Credentials.ToList())
{
int credentialCycleCount = cycleCount[cycleRandom.Next(0, cycleCount.Length)];
int candidateID = 0;
for (int i = 1; i <= credentialCycleCount; i++)
{
bool isRecordExists = true;
while (isRecordExists)
{
candidateID = candidates[candidateRandom.Next(0, candidates.Length)];
var q = from p in db.Results where p.CredentialID == credential.CredentialID && p.CandidateID == candidateID select p;
if (q.Count() > 0)
{
isRecordExists = true;
}
else
{
isRecordExists = false;
}
}
Result result = new Result
{
CandidateID = candidateID,
CandidateIndex = i,
CredentialID = credential.CredentialID,
Status = ResultStatus.Permanent
};
db.Results.Add(result);
db.SaveChanges();
}
}
}
public MonitoringController(StvContext db)
{
_db = db;
credentialService = new CredentialService(_db);
settingService = new SettingService(_db);
}
public CredentialController(StvContext db)
{
_db = db;
service = new CredentialService(_db);
settingService = new SettingService(_db);
}
public JudgeController(StvContext db)
{
_db = db;
service = new JudgeService(_db);
}
