private string findLeader(string factionName)
{
string leaderName = "Unknown";
using (var context = new StalkerP4Entities())
{
var factionID = context
.Frakcja.Where(x => x.Nazwa_frakcji == factionName)
.Select(x => x.Id_frakcji)
.First();
try
{
var stalkerID = context
.Czlonkostwo.Where(x => x.Id_frakcji == factionID && x.Stopien == "Leader")
.Select(x => x.Id_stalkera)
.First();
var leader = context
.Stalker.Where(x => x.Id_stalkera == stalkerID)
.Select(x => x.Pseudonim);
foreach (var lName in leader)
{
leaderName = lName.ToString();
}
}
catch (InvalidOperationException)
{
return(leaderName);
}
}
return(leaderName);
}
private void fillListBox()
{
using (var context = new StalkerP4Entities())
{
var factionList = context
.Frakcja.Select(x => x.Nazwa_frakcji)
.OrderBy(x => x);
foreach (var factionName in factionList)
{
factionListBox.Items.Add(factionName);
}
}
}
private string setStatus(string factionName)
{
string status = "Unknown";
using (var context = new StalkerP4Entities())
{
var getStatus = context
.Frakcja.Where(x => x.Nazwa_frakcji == factionName)
.Select(x => x.Status)
.First();
status = getStatus;
}
return(status);
}
private void fillCheckedListBox()
{
using (var context = new StalkerP4Entities())
{
var factionList = context
.Frakcja.Where(x => x.Status == "Exists")
.Select(x => x.Nazwa_frakcji)
.OrderBy(x => x);
foreach (var factionName in factionList)
{
relationCheckedListBox.Items.Add(factionName);
}
}
}
private int countMembers(string factionName)
{
int members = 0;
using (var context = new StalkerP4Entities())
{
var faction = context
.Frakcja.Where(x => x.Nazwa_frakcji == factionName)
.Select(x => x.Id_frakcji)
.First();
var numOfMembers = context
.Czlonkostwo.Where(x => x.Id_frakcji == faction)
.Count();
members = numOfMembers;
}
return(members);
}
private string getRelation(string factionName1, string factionName2)
{
int fId1 = 0, fId2 = 0;
string relation = "NEUTRAL";
using (var context = new StalkerP4Entities())
{
var factionId1 = context
.Frakcja.Where(x => x.Nazwa_frakcji == factionName1)
.Select(x => x.Id_frakcji);
foreach (var f in factionId1)
{
fId1 = f;
}
var factionId2 = context
.Frakcja.Where(x => x.Nazwa_frakcji == factionName2)
.Select(x => x.Id_frakcji);
foreach (var f in factionId2)
{
fId2 = f;
}
var relationType = context
.Relacja.Where(x => x.Id_frakcji_p == fId1 & x.Id_frakcji_d == fId2)
.Select(x => x.Rodzaj_relacji);
foreach (var rel in relationType)
{
relation = rel.ToUpper();
}
}
return(relation);
}
