public static void ContactME()
{
MW.ShowInfo();
string mail = "mailto:[email protected]";
Process.Start(mail);
}
private int NonNaturalWeaponCount(List <string> weaponsList)
{
int count = 0;
Weapon weapon = null;
NaturalWeapon natural_weapon = null;
foreach (string MW in weaponsList)
{
weapon = null;
natural_weapon = null;
bool MagicWeapon;
bool GreaterMagicWeapon;
WeaponCommon weaponCommon = new WeaponCommon(_sbCheckerBaseInput, _equipmentData, _naturalWeaponBusiness);
if (weaponCommon.FindWeapon(ref weapon, ref natural_weapon, MW.Trim(), out MagicWeapon, out GreaterMagicWeapon))
{
if (weapon != null && weapon.name != "bite")
{
count++;
}
if (natural_weapon != null)
{
}
}
}
return(count);
}
private int NonNaturalWeaponCount(List <string> WeaponsList)
{
int count = 0;
Weapon weapon = null;
NaturalWeapon natural_weapon = null;
foreach (string MW in WeaponsList)
{
weapon = null;
natural_weapon = null;
bool MagicWeapon;
bool GreaterMagicWeapon;
WeaponCommon weaponCommon = new WeaponCommon(magicInEffect, Weapons, _indvSB, _messageXML, _monSBSearch, CharacterClasses, RaceName, DontUseRacialHD, RaceBaseType, HasRaceBase, RacialHDValue);
if (weaponCommon.FindWeapon(ref weapon, ref natural_weapon, MW.Trim(), out MagicWeapon, out GreaterMagicWeapon))
{
if (weapon != null && weapon.name != "bite")
{
count++;
}
if (natural_weapon != null)
{
}
}
}
return(count);
}
public void GenerateLibraryThreadPlaylist(object param)
{
var handler = (ManualResetEvent)param;
try
{
var files = Directory.GetFiles(PlaylistPath, "*" + PlaylistExtension, SearchOption.AllDirectories);
foreach (String file in files)
{
var playlist = new Playlist(file);
lock (Playlists)
Playlists.Add(playlist);
}
}
catch (DirectoryNotFoundException)
{
try
{
Directory.CreateDirectory(PlaylistPath);
}
catch (DirectoryNotFoundException) { }
}
lock (MW)
MW.UpdateCurrentPanel(ClickStyle.SELECTION);
handler.Set();
}
public void GenerateLibraryThreadMedia(object param)
{
var tmp = (Tuple <String, String[], ManualResetEvent, ClickStyle, int>)param;
var done = new List <MediaItem>();
try
{
foreach (var ext in tmp.Item2)
{
var files = Directory.GetFiles(tmp.Item1, "*" + ext, SearchOption.AllDirectories);
foreach (String file in files)
{
var cont = false;
lock (Paths)
{
cont = Paths.Contains(file);
if (!cont)
{
Paths.Add(file);
}
}
if (!cont)
{
var media = MediaItem.Create(file);
if (media != null)
{
done.Add(media);
if (done.Count >= tmp.Item5)
{
lock (Medias)
Medias.AddRange(done);
done.Clear();
lock (MW)
MW.UpdateCurrentPanel(tmp.Item4);
}
}
}
}
}
if (done.Count > 0)
{
lock (Medias)
Medias.AddRange(done);
done.Clear();
lock (MW)
MW.UpdateCurrentPanel(tmp.Item4);
}
}
catch (ArgumentException)
{
ConfigFile.Instance.Data.BiblioFiles.Remove(tmp.Item1);
}
catch (Exception) { }
tmp.Item3.Set();
}
private void InfoBox_OnMouseLeftButtonUp(object sender, MouseButtonEventArgs e)
{
var sb = (Storyboard)MW.FindResource("InfoDissolve");
sb.Children.OfType <DoubleAnimation>().First(animation => animation.Name == "OutOpacity")
.BeginTime = new TimeSpan(0, 0, 0);
sb.Children.OfType <ObjectAnimationUsingKeyFrames>()
.Where(oaukf => oaukf.Name == "OutVisibility")
.SelectMany(oaukf => oaukf.KeyFrames.Cast <DiscreteObjectKeyFrame>()).First().KeyTime = new TimeSpan(0, 0, 1);
sb.Begin();
}
private void Page_Loaded(object sender, RoutedEventArgs e)
{
if (App.CurrentUser != null)
{
MW.GoToMenu(App.CurrentUser.RoleId);
return;
}
var win = new AuthTypeWindow(MW);
win.ShowDialog();
ChosenType = win.ChosenType;
ChosenTypeString = Convert.ToString(ChosenType.ToString()[0]);
//MessageBox.Show(ChosenTypeString);
}
private void bt_load_Click(object sender, RoutedEventArgs e)
{
var today = DateTime.Now;
var yesterday = today.AddDays(-2);
string sd = yesterday.ToString("yyyyMMdd");
sd += "000000";
double sd_int = double.Parse(sd);
MW.LoadData(MW.myStats_csv);
List <dsreplay> fil_replays = new List <dsreplay>(MW.replays);
List <dsreplay> tmprep = new List <dsreplay>();
tmprep = new List <dsreplay>(fil_replays.Where(x => (x.GAMETIME > sd_int)).ToList());
tb_rep_mmid.Text = WM.tb_mmid.Text;
CheckValidRep(tmprep);
//dg_games.ItemsSource = tmprep;
}
private void AuthButton_Click(object sender, RoutedEventArgs e)
{
if (!(EmailTB.Text.IsNotNull() && PasswordPB.Password.IsNotNull()))
{
ShowError("Не все поля заполнены!");
return;
}
var user = App.DbContext.Users
.FirstOrDefault(x => x.Email == EmailTB.Text.Trim() &&
x.Password == PasswordPB.Password &&
x.RoleId == ChosenTypeString);
if (user == default)
{
ShowError("Неверный логин или пароль!");
return;
}
MW.Auth(user);
MW.GoToMenu(ChosenTypeString);
}
private bool HasNonNaturalWeapon(List <string> WeaponsList)
{
Weapon weapon = null;
NaturalWeapon natural_weapon = null;
foreach (string MW in WeaponsList)
{
weapon = null;
natural_weapon = null;
bool MagicWeapon;
bool GreaterMagicWeapon;
WeaponCommon weaponCommon = new WeaponCommon(magicInEffect, Weapons, _indvSB, _messageXML, _monSBSearch, CharacterClasses, RaceName, DontUseRacialHD, RaceBaseType, HasRaceBase, RacialHDValue);
if (weaponCommon.FindWeapon(ref weapon, ref natural_weapon, MW.Trim(), out MagicWeapon, out GreaterMagicWeapon))
{
if (weapon != null)
{
return(true);
}
}
}
return(false);
}
private bool HasNonNaturalWeapon(List <string> weaponsList)
{
Weapon weapon = null;
NaturalWeapon natural_weapon = null;
foreach (string MW in weaponsList)
{
weapon = null;
natural_weapon = null;
bool MagicWeapon;
bool GreaterMagicWeapon;
WeaponCommon weaponCommon = new WeaponCommon(_sbCheckerBaseInput, _equipmentData, _naturalWeaponBusiness);
if (weaponCommon.FindWeapon(ref weapon, ref natural_weapon, MW.Trim(), out MagicWeapon, out GreaterMagicWeapon))
{
if (weapon != null)
{
return(true);
}
}
}
return(false);
}
private void GoBack_Click(object sender, RoutedEventArgs e)
{
MW.FrameGoBack();
}
public string PingPong(string pong, string player, Socket client, string mmid)
{
string response = "";
string answer = "";
//string mmid = "0";
string pattern = @"^sc2dsmm: (.*)";
foreach (Match m in Regex.Matches(pong, pattern))
{
answer = m.Groups[1].ToString();
}
if (CheckPong(answer))
{
string pt_letmeplay = @"^Letmeplay: (.*)";
string pt_accept = @"^Accept: (.*)";
string pt_decline = @"^Decline: (.*)";
string pt_findgame = @"^Findgame: (.*)";
string pt_ready = @"^Ready: (.*)";
string pt_status = @"^Status: (.*)";
// Matchup ready to go
foreach (Match m_ready in Regex.Matches(answer, pt_ready))
{
string ent = m_ready.Groups[1].ToString();
if (ent == "0")
{
// Someone declined / timed out :(
MW.Dispatcher.Invoke(() =>
{
MW.ALL_DECLINED = true;
});
// Waiting again
// We need to responde too
if (MW.WAITING == false && MW.DECLINED == false)
{
Random rngesus = new Random();
int rng = rngesus.Next(0, 3000);
int mysleep = 5000 + rng;
Thread.Sleep(mysleep);
// response = "Findgame: 1";
response = "Letmeplay: 1";
mmid = "0";
//Console.WriteLine("PP: " + mmid + " " + player + " pt_ready => Someone declined => waiting again");
}
else
{
// we accepted
if (MW.ACCEPTED == true && STATUS == false)
{
response = "accept: " + mmid;
STATUS = true;
//Console.WriteLine("PP: " + mmid + " " + player + " pt_ready => Someone declined => we accepted");
}
// we declined
else if (MW.DECLINED == true && STATUS == false)
{
response = "decline: " + mmid;
STATUS = true;
mmid = "0";
//Console.WriteLine("PP: " + mmid + " " + player + " pt_ready => Someone declined => we declined");
}
else
{
Thread.Sleep(200);
response = "Status: " + mmid;
//Console.WriteLine("PP: " + mmid + " " + player + " pt_ready => Someone declined => wait(Status)");
}
}
}
else
{
// all accepted :)
MW.Dispatcher.Invoke(() =>
{
MW.ALL_ACCEPTED = true;
MW.SetupPos(ent, player);
});
response = "fin";
//Console.WriteLine("PP: " + mmid + " " + player + " pt_ready => Someone declined => all accepted");
}
goto Response;
}
// How many players accepted?
foreach (Match m_status in Regex.Matches(answer, pt_status))
{
response = "Status: " + mmid;
int i = 0;
int j = 0;
MW.Dispatcher.Invoke(() =>
{
var pl_cb = MW.gr_mmacc.Children.OfType <CheckBox>().Where(x => x.Name.StartsWith("mmcb_acc"));
CheckBox cb_last = null;
foreach (string acc in m_status.Groups[1].ToString().Split(';'))
{
i++;
if (pl_cb != null)
{
List <CheckBox> llcb = pl_cb.Where(x => x.Name.Contains(i.ToString())).ToList();
CheckBox lcb = null;
if (llcb.Count > 0)
{
lcb = llcb.ElementAt(0);
}
if (lcb != null)
{
if (acc == "1")
{
lcb.IsChecked = true;
j++;
}
else if (acc == "-1")
{
lcb.IsChecked = false;
}
if (i == 6)
{
cb_last = lcb;
}
}
}
}
if (cb_last != null)
{
cb_last.Content = j.ToString() + "/6";
}
});
// we accepted
if (MW.ACCEPTED == true && STATUS == false)
{
response = "accept: " + mmid;
STATUS = true;
//Console.WriteLine("PP: " + mmid + " " + player + " pt_status => we accepted");
// we declined
}
else if (MW.DECLINED == true && STATUS == false)
{
response = "decline: " + mmid;
STATUS = true;
mmid = "0";
//Console.WriteLine("PP: " + mmid + " " + player + " pt_status => we declined");
}
else
{
Thread.Sleep(400);
}
goto Response;
}
// We are ready!
foreach (Match m_accept in Regex.Matches(answer, pt_accept))
{
mmid = m_accept.Groups[1].ToString();
response = "Ready_v2: " + mmid;
if (mmid == "0")
{
// Someone already declined / timed out :(
MW.Dispatcher.Invoke(() =>
{
MW.ALL_DECLINED = true;
});
// Waiting again
Random rngesus = new Random();
int rng = rngesus.Next(0, 3000);
int mysleep = 5000 + rng;
Thread.Sleep(mysleep);
response = "Letmeplay: 1";
mmid = "0";
//Console.WriteLine("PP: " + mmid + " " + player + " pt_accept => already declined => wait");
}
goto Response;
}
// Searching ...
foreach (Match m_findgame in Regex.Matches(answer, pt_findgame))
{
string ent = m_findgame.Groups[1].ToString();
if (ent == "0")
{
// Waiting
Random rngesus = new Random();
int rng = rngesus.Next(0, 3000);
int mysleep = 5000 + rng;
Thread.Sleep(mysleep);
response = "Findgame: 0";
//Console.WriteLine("PP: " + mmid + " " + player + " pt_findgame => Searching");
}
else if (ent.StartsWith("Games"))
{
MW.Dispatcher.Invoke(() =>
{
MW.tb_info.Text = ent;
});
// Waiting
Random rngesus = new Random();
int rng = rngesus.Next(0, 3000);
int mysleep = 5000 + rng;
Thread.Sleep(mysleep);
response = "Findgame: 0";
//Console.WriteLine("PP: " + mmid + " " + player + " pt_findgame => Games");
}
else
{
mmid = ent;
// Matchup ready - waiting for Accept
MW.Dispatcher.Invoke(() =>
{
MW.GameFound(mmid);
});
// response = "wait";
response = "Status: " + mmid;
//Console.WriteLine("PP: " + mmid + " " + player + " pt_findgame => GameFound");
}
goto Response;
}
// we declined :(
foreach (Match m_decline in Regex.Matches(answer, pt_decline))
{
response = "fin";
mmid = "0";
MW.Dispatcher.Invoke(() =>
{
MW.DECLINED = false;
MW.bt_show.IsEnabled = true;
MW.tb_gamefound.Visibility = Visibility.Visible;
MW.tb_gamefound.Text = "Ready process declined :(";
try
{
MW._timer.Stop();
}
catch { }
});
//Console.WriteLine("PP: " + mmid + " " + player + " pt_decline => we declined");
goto Response;
}
// Find game
foreach (Match m_letmeplay in Regex.Matches(answer, pt_letmeplay))
{
//mmid = "0";
response = "Findgame: 0";
MW.Dispatcher.Invoke(() =>
{
MW.tb_gamefound.Text = "Searching ...";
MW.mmcb_ample.IsChecked = true;
MW.mmcb_ample.Content = "Online";
});
//Console.WriteLine("PP: " + mmid + " " + player + " pt_letmeplay => Searching");
goto Response;
}
}
Console.WriteLine("ERR: " + answer);
Response:
//Console.WriteLine(player + ": " + pong + " => " + response);
if (client != null)
{
if (response != "wait")
{
response = "Hello from [" + player + "]: " + response + "\r\n";
byte[] msgBuf = Encoding.UTF8.GetBytes(response);
try
{
client.Send(msgBuf);
}
catch (Exception e)
{
Console.WriteLine("Client closed: {0}", e.ToString());
}
}
if (response == "fin")
{
try
{
StopClient(client);
client.Dispose();
client = null;
}
catch (Exception e)
{
Console.WriteLine("Client closed: {0}", e.ToString());
}
MW.Dispatcher.Invoke(() =>
{
MW.mmcb_ample.IsChecked = false;
MW.mmcb_ample.Content = "Offline";
});
}
else
{
byte[] bytes = new byte[1024];
string fin = "";
int bytesRec = 0;
try
{
bytesRec = client.Receive(bytes);
fin = Encoding.UTF8.GetString(bytes, 0, bytesRec);
}
catch (Exception e)
{
Console.WriteLine("Client closed: {0}", e.ToString());
}
if (bytesRec > 0)
{
PingPong(Encoding.UTF8.GetString(bytes, 0, bytesRec), player, client, mmid);
}
}
}
else
{
MW.Dispatcher.Invoke(() =>
{
MW.mmcb_ample.IsChecked = false;
MW.mmcb_ample.Content = "Offline";
});
}
return(response);
}
private void bt_scan_Click(object sender, RoutedEventArgs e)
{
MW.mnu_Scan(null, null);
}
private void CheckOneMeleeOrBlock(List <string> foundWeapons, string meleeWeapon)
{
NaturalWeapon natural_weapon = null;
Weapon weapon = null;
bool twoWeaponFighting = false;
bool multipleWepons = false;
bool naturalMultipleWepons = false;
bool lightWeapon;
bool biteAttack;
List <string> meleeList = new List <string>();
string[] splitFind = new string[] { " and" };
meleeWeapon = meleeWeapon.Replace('\n', ' ');
//find "and"s in parenths
int posAnd = meleeWeapon.IndexOf("and");
if (posAnd > 0)
{
int startPos = 0;;
while (posAnd <= meleeWeapon.Length || posAnd == -1)
{
int openparen = meleeWeapon.IndexOf(PathfinderConstants.PAREN_LEFT, startPos);
if (openparen < 0)
{
break;
}
int closeparen = meleeWeapon.IndexOf(PathfinderConstants.PAREN_RIGHT, openparen);
if (posAnd > openparen && openparen < closeparen)
{
meleeWeapon = meleeWeapon.Insert(posAnd, "|");
}
posAnd = meleeWeapon.IndexOf("and", closeparen);
startPos = closeparen;
}
}
Utility.ParenCommaFix(ref meleeWeapon);
if (FindNonParenAnd(meleeWeapon))
{
meleeList = meleeWeapon.Split(splitFind, StringSplitOptions.RemoveEmptyEntries).ToList();
for (int a = 0; a <= meleeList.Count - 1; a++)
{
meleeList[a] = meleeList[a].Replace("|", string.Empty);
}
}
else if (meleeWeapon.Contains(", "))
{
splitFind = new string[] { ", " };
meleeList = meleeWeapon.Split(splitFind, StringSplitOptions.RemoveEmptyEntries).ToList();
}
else
{
meleeList.Add(meleeWeapon);
}
lightWeapon = false;
biteAttack = false;
if (meleeList.Any())
{
multipleWepons = true;
foreach (string weap in meleeList)
{
if (weap.Contains("bite"))
{
biteAttack = true;
}
if (FindLightWeapon(weap))
{
lightWeapon = true;
}
}
if (NonNaturalWeaponCount(meleeList) != 1)
{
twoWeaponFighting = true;
}
}
foundWeapons.Add(meleeWeapon);
if (HasNonNaturalWeapon(meleeList))
{
naturalMultipleWepons = true;
}
int weaponIndex = 0;
bool SimpleOne = false;
foreach (string MW in meleeList) // loop on "and" blocks
{
weapon = null;
natural_weapon = null;
weaponIndex++;
bool MagicWeapon;
bool GreaterMagicWeapon;
WeaponCommon weaponCommon = new WeaponCommon(_sbCheckerBaseInput, _equipmentData, _naturalWeaponBusiness);
if (weaponCommon.FindWeapon(ref weapon, ref natural_weapon, MW.Trim(), out MagicWeapon, out GreaterMagicWeapon))
{
foundWeapons.Add(MW);
CheckOneMeleeWeaponFound(natural_weapon, weapon, twoWeaponFighting, multipleWepons, lightWeapon,
biteAttack, meleeList.Count, weaponIndex, MW, MagicWeapon, GreaterMagicWeapon, ref SimpleOne, _raceWeapons, naturalMultipleWepons);
}
else
{
_sbCheckerBaseInput.MessageXML.AddFail("Melee Attack", "Missing Weapon-" + MW.Trim());
}
}
}
public List <EmployeeMinimumWagesReport> GetReportData(DateTime?DateFrom, DateTime?DateTo, int?DepartmentID, int?DesignationID, int?LocationID, int?EmployementTypeID)
{
using (dbVisionEntities db = new dbVisionEntities())
{
var Res = (from r in db.tblEmployees
join pe in db.tblEmployeeServiceDetails on r.EmployeeLastServiceDetailID equals pe.EmployeeServiceDetailID into PE
from ep in PE.DefaultIfEmpty()
join np in db.tblEmployeeNoPrefixes on r.EmployeeNoPrefixID equals np.EmployeeNoPrefixID into NP
from pn in NP.DefaultIfEmpty()
join qe in db.tblEmployeeDesignations on ep.EmployeeDesignationID equals qe.EmployeeDesignationID into QE
from eq in QE.DefaultIfEmpty()
join lc in db.tblLocations on ep.LocationID equals lc.LocationID into LC
from L in LC.DefaultIfEmpty()
join mw in db.tblMinimumWageCategories on ep.MinimumWageCategoryID equals mw.MinimumWageCategoryID into MW
from M in MW.DefaultIfEmpty()
where ((DateFrom == null || ep.EmploymentEffectiveDate <= DateTo) &&
(DateTo == null || ep.TerminationDate == null || ep.TerminationDate >= DateFrom)) &&
r.CompanyID == Model.CommonProperties.LoginInfo.LoggedInCompany.CompanyID &&
(DesignationID == null || ep.EmployeeDesignationID == DesignationID.Value) &&
(LocationID == null || ep.LocationID == LocationID.Value) &&
(DepartmentID == null || ep.EmployeeDepartmentID == DepartmentID.Value) &&
(EmployementTypeID == 3 ? (EmployementTypeID == null || ep.EmploymentType != 0) : (EmployementTypeID == null || ep.EmploymentType == EmployementTypeID.Value)) &&
r.rstate != (int)eRecordState.Deleted
select new EmployeeMinimumWagesReport()
{
EmployeeID = r.EmployeeID,
EmployeeNoPrefix = (pn != null ? pn.EmployeeNoPrefixName : null),
EmployeeNo = r.EmployeeNo,
EmployementTypeID = (eEmploymentType)ep.EmploymentType,
EmployeeName = r.EmployeeFirstName + " " + r.EmployeeLastName,
Designation = eq.EmployeeDesignationName,
Category = M.MinimumWageCategoryName,
Location = L.LocationName,
LocationTypeID = (eLocationType)L.LocationTypeID,
BasicSalary = ep.BasicSalary,
MinWagesSal = ((from d in db.tblMinimumWageRates
where d.MinimumWageCategoryID == ep.MinimumWageCategoryID &&
((DateFrom == null || d.WEDateFrom >= DateFrom) && (d.WEDateTo == null))
orderby d.MinimumWageRateID
select new
{
minsale = (eLocationType)L.LocationTypeID == eLocationType.Rural ? d.MinimumWageCategoryRuralRate : d.MinimumWageCategoryUrbanRate
}).FirstOrDefault() == null ?
0
:
(from d in db.tblMinimumWageRates
where d.MinimumWageCategoryID == ep.MinimumWageCategoryID &&
((DateFrom == null || d.WEDateFrom >= DateFrom) && (d.WEDateTo == null))
orderby d.MinimumWageRateID
select new
{
minsale = (eLocationType)L.LocationTypeID == eLocationType.Rural ? d.MinimumWageCategoryRuralRate : d.MinimumWageCategoryUrbanRate
}).FirstOrDefault().minsale),
}).ToList();
return(Res);
}
}
public DummyDataContext()
{
Europa = new Continent();
Europa.ContinentID = 1;
Europa.Name = "Europa";
Graad = new Grade(1);
Belgium = new Country("Belgie",Europa);
England = new Country("England",Europa);
Belgium.CountryID = 1;
England.CountryID = 2;
//Belgium.AboveEquator = true;
//England.AboveEquator = false; //voor te testen. England ligt obviously boven de Equator
int[] temp = new int[]{1,5,3,4,5,6,7,8,9,10,40,12};
int[] sed = new int[] {10, 206, 30, 200, 50, 60, 70, 80, 20, 100, 110, 120};
int[] temp2 = new int[] { 1, 2, 3, 0, -10, -12, 7, 8, 9, 10, 11, 12 };
int[] sed2 = new int[] { 10, 20, 30, 40, 50, 60, 70, 80, 90, 100, 110, 120 };
NegTempClimateChart = new ClimateChart("Chelsea",2000,2030,temp2,sed2, -20, 10);
NegTempClimateChart.Country = England;
NegTempClimateChart.ClimateChartID = 2;
England.ClimateCharts = new List<ClimateChart>{NegTempClimateChart};
Gent = new ClimateChart("gent",1950,1960,temp,sed, 55, 6);
Gent.Country = Belgium;
Gent.ClimateChartID = 1;
ClimateCharts = new List<ClimateChart>{ Gent };
Belgium.ClimateCharts = ClimateCharts;
Countries = new List<Country>{ Belgium,England };
Europa.Countries = Countries;
Continenten = new List<Continent>{ Europa };
Graad.Continents = Continenten;
Parameter tw = new TW("Wat is de temperatuur van de warmste maand (TW)?");
Parameter mw = new MW("Wat is de warmste maand?");
Parameter mk = new MK("Wat is de temperatuur van de koudste maand?");
Parameter tk = new TK("Wat is de temperatuur van de koudste maand (TK)?");
Parameter d = new D("Hoeveel droge maanden zijn er?");
Parameter nz = new NZ("Hoeveelheid neerslag in de zomer?");
Parameter nw = new NW("Hoeveelheid neerslag in de winter?");
Parameter tj = new TJ("");
Parameter nj = new NJ("");
Parameter tm = new TM("");
//ClauseComponent tw10 = new Clause("TW <= 10", tw, "<=", 10);
//ClauseComponent CC2 = new Clause("TW <= 10", tw, "<", 10);
//ClauseComponent CC3 = new Clause("TW <= 10", tw, ">=", 10);
//ClauseComponent CC4 = new Clause("TW <= 10", tw, ">", 10);
//ClauseComponent res1 = new Result("YES", "geen woestijn");
//ClauseComponent res2 = new Result("NO", "woestijn");
//tw10.ClauseComponentId = 1;
//res1.ClauseComponentId = 2;
//res2.ClauseComponentId = 3;
//tw10.Add(true, res1);
//tw10.Add(false, res2);
//CC2.Add(true, res1);
//CC2.Add(false, res2);
//CC3.Add(true, res1);
//CC3.Add(false, res2);
//CC4.Add(true, res1);
//CC4.Add(false, res2);
//DetTable = new DeterminateTable();
//DetTable2 = new DeterminateTable();
//DetTable3 = new DeterminateTable();
//DetTable4 = new DeterminateTable();
Graad.DeterminateTableProp = DetTable;
Country belgië = new Country { Name = "België" };
temps = new int[] { 10, 12, 12, 14, 15, 20, 28, 32, 28, 16, 6, 2 };
sed = new[] { 120, 145, 200, 120, 150, 100, 140, 40, 100, 120, 130, 100 };
chart = new ClimateChart("Gent", 1990, 1991, temps, sed, 55, 6);
chart.Country = belgië;
temps2 = new int[] { 14, 15, 17, 21, 25, 27, 28, 27, 26, 23, 19, 15 };
sed2 = new[] { 7, 4, 4, 2, 0, 0, 0, 0, 0, 1, 3, 5 };
chart2 = new ClimateChart("Kaïro", 1961, 1990, temps2, sed2, -20, 2);
Country egypte = new Country { Name = "Egypte" };
//egypte.AboveEquator = false;
chart2.Country = egypte;
temps3 = new int[] { 0, 1, 5, 11, 17, 22, 25, 24, 20, 14, 9, 3 };
sed3 = new[] { 77, 73, 91, 96, 97, 91, 103, 95, 86, 77, 97, 86 };
chart3 = new ClimateChart("New York", 1961, 1990, temps3, sed3, 50, -50);
Country newyork = new Country { Name = "New York" };
chart3.Country = newyork;
temps4 = new int[] { 25, 1, 5, 11, 17, 22, 25, 24, 20, 14, 9, 3 };
sed4 = new[] { 1, 2, 0, 0, 0, 100, 100, 100, 100, 100, 0, 0 };
chart4 = new ClimateChart("Fictief", 1961, 1990, temps4, sed4, 60, 20);
Country fictief = new Country { Name = "Fictief" };
chart4.Country = fictief;
byte[] picture = null;
ClauseComponent tw10 = new Clause("TW <= 10", tw, "<=", 10);
ClauseComponent tw0 = new Clause("TW <= 0", tw, "<=", 0);
ClauseComponent tw0Yes = new Result("Koud klimaat zonder dooiseizoen", "Ijswoestijnklimaat", picture);
ClauseComponent tw0No = new Result("Koud klimaat met dooiseizoen", "Toendraklimaat", picture);
tw0.Add(true, tw0Yes);
tw0.Add(false, tw0No);
tw10.Add(true, tw0);
ClauseComponent tj0 = new Clause("TJ <= 0", tj, "<=", 0);
tw10.Add(false, tj0);
ClauseComponent tj0Yes = new Result("Koudgematigd klimaat met strenge winter", "Taigaklimaat", picture);
tj0.Add(true, tj0Yes);
ClauseComponent nj200 = new Clause("NJ <= 200", nj, "<=", 200);
ClauseComponent tk15 = new Clause("TK <= 15", tk, "<=", 15);
ClauseComponent tk15Yes = new Result("Gematigd altijd droog klimaat", "Woestijnklimaat van de middelbreedten", picture);
ClauseComponent tk15No = new Result("Warm altijd droog klimaat", "Woestijnklimaat van de tropen", picture);
tk15.Add(true, tk15Yes);
tk15.Add(false, tk15Yes);
nj200.Add(true, tk15);
tj0.Add(false, nj200);
ClauseComponent tk18 = new Clause("TK <= 18", tk, "<=", 18);
ClauseComponent nj400 = new Clause("NJ <= 400", nj, "<=", 400);
ClauseComponent nj400Yes = new Result("Gematigd, droog klimaat", "Steppeklimaat", picture);
ClauseComponent tk10N = new Clause("TK <= -10", tk, "<=", -10);
ClauseComponent tk10NYes = new Result("Koudgematigd klimaat met strenge winter", "Taigaklimaat", picture);
ClauseComponent d1 = new Clause(" D <= 1", d, "<=", 1);
ClauseComponent tk3N = new Clause("TK <= -3", tk, "<=", -3);
ClauseComponent tk3NYes = new Result("Koelgematigd klimaat met koude winter", "Gemengd-woudklimaat", picture);
ClauseComponent tw22 = new Clause(" TW <= 22", tw, "<=", 22);
ClauseComponent tw22Yes = new Result("Koelgematigd klimaat met zachte winter", "Loofbosklimaat", picture);
ClauseComponent tw22No = new Result("Warmgematigd altijd nat klimaat", "Subtropisch regenwoudklimaat", picture);
ClauseComponent nznw = new Clause("NZ <= NW", nz, nw);
ClauseComponent tw222 = new Clause("TW <= 22", tw, "<=", 22);
ClauseComponent tw222Yes = new Result("Koelgematigd klimaat met natte winter", "Hardbladige-vegetatieklimaat van de centrale middelbreedten", picture);
ClauseComponent tw222No = new Result("Warmgematigd klimaat met natte winter", "Hardbladige-vegetatieklimaat van de subtropen", picture);
ClauseComponent nznwNo = new Result("Warmgematigd klimaat met natte zomer", "Subtropisch savanneklimaat", picture);
tw222.Add(true, tw222Yes);
tw222.Add(false, tw222No);
nznw.Add(true, tw222);
nznw.Add(false, nznwNo);
tw22.Add(true, tw22Yes);
tw22.Add(false, tw22No);
tk3N.Add(true, tk3NYes);
tk3N.Add(false, tw22);
d1.Add(true, tk3N);
d1.Add(false, nznw);
tk10N.Add(true, tk10NYes);
tk10N.Add(false, d1);
nj400.Add(true, nj400Yes);
nj400.Add(false, tk10N);
tk18.Add(true, nj400);
nj200.Add(false, tk18);
ClauseComponent d12 = new Clause("D <= 1", d, "<=", 1);
ClauseComponent d12Yes = new Result("Warm klimaat met nat seizoen", "Tropisch savanneklimaat", picture);
ClauseComponent d12No = new Result("Warm altijd nat klimaat", "Tropisch regenwoudklimaat", picture);
d12.Add(true, d12Yes);
d12.Add(false, d12No);
tk18.Add(false, d12);
dTable = new DeterminateTable();
List<ClauseComponent> results1 = (new ClauseComponent[]
{
tw0, tj0,nj200, tk15,tk18, nj400, tk10N, d1, tk3N, tw22, nznw, tw222, d12,
tw0Yes, tw0No, tj0Yes,
tk15Yes, tk15No, nj400Yes, tk10NYes, tk3NYes,
tw22Yes, tw22No, tw222Yes, tw222No, nznwNo,
d12Yes, d12No, tw10
}).ToList();
results1.ForEach(r => dTable.AllClauseComponents.Add(r));
}
private void CheckOneMeleeOrBlock(List <string> Found, string meleeWeapon)
{
NaturalWeapon natural_weapon = null;
Weapon weapon = null;
bool TwoWeaponFighting = false;
bool MultipleWepons = false;
bool NaturalMultipleWepons = false;
bool LightWeapon = false;
bool BiteAttack = false;
List <string> Melee2 = new List <string>();
string[] temp2 = new string[] { " and" };
Utility.ParenCommaFix(ref meleeWeapon);
if (FindNonParenAnd(meleeWeapon))
{
Melee2 = meleeWeapon.Split(temp2, StringSplitOptions.RemoveEmptyEntries).ToList <string>();
}
else if (meleeWeapon.IndexOf(", ") >= 0)
{
temp2 = new string[] { ", " };
Melee2 = meleeWeapon.Split(temp2, StringSplitOptions.RemoveEmptyEntries).ToList <string>();
}
else
{
Melee2.Add(meleeWeapon);
}
LightWeapon = false;
BiteAttack = false;
if (Melee2.Count > 1)
{
MultipleWepons = true;
foreach (string weap in Melee2)
{
if (weap.IndexOf("bite") >= 0)
{
BiteAttack = true;
}
if (FindLightWeapon(weap))
{
LightWeapon = true;
}
}
if (NonNaturalWeaponCount(Melee2) != 1)
{
TwoWeaponFighting = true;
}
}
Found.Add(meleeWeapon);
if (HasNonNaturalWeapon(Melee2))
{
NaturalMultipleWepons = true;
}
int weaponIndex = 0;
bool SimpleOne = false;
foreach (string MW in Melee2) // loop on "and" blocks
{
weapon = null;
natural_weapon = null;
weaponIndex++;
bool MagicWeapon;
bool GreaterMagicWeapon;
WeaponCommon weaponCommon = new WeaponCommon(magicInEffect, Weapons, _indvSB, _messageXML, _monSBSearch, CharacterClasses, RaceName, DontUseRacialHD, RaceBaseType, HasRaceBase, RacialHDValue);
if (weaponCommon.FindWeapon(ref weapon, ref natural_weapon, MW.Trim(), out MagicWeapon, out GreaterMagicWeapon))
{
Found.Add(MW);
CheckOneMeleeWeaponFound(natural_weapon, weapon, TwoWeaponFighting, MultipleWepons, LightWeapon,
BiteAttack, Melee2.Count, weaponIndex, MW, MagicWeapon, GreaterMagicWeapon, ref SimpleOne, RaceWeapons, NaturalMultipleWepons);
}
else
{
_messageXML.AddFail("Melee Attack", "Missing Weapon-" + MW.Trim());
}
}
}
internal void ScanReplays(string replay)
{
if (replay == REPLAY)
{
// already running;
}
else if (replay == DUMMY)
{
// stop it somhow ..
}
else
{
REPLAY = replay;
if (CheckAccess(replay))
{
var appSettings = ConfigurationManager.AppSettings;
int cores = 2;
if (appSettings["CORES"] != null && appSettings["CORES"] != "0")
{
cores = int.Parse(appSettings["CORES"]);
}
string ExecutableFilePath = MW.myScan_exe;
string Arguments = @"--priority=" + "NORMAL" + " "
+ "--cores=" + cores.ToString() + " "
+ "--player=\"" + appSettings["PLAYER"] + "\" "
+ "--stats_file=\"" + MW.myStats_csv + "\" "
+ "--replay_path=\"" + appSettings["REPLAY_PATH"] + "\" "
+ "--DEBUG=" + appSettings["DEBUG"] + " "
+ "--keep=" + appSettings["KEEP"] + " "
+ "--store_path=\"" + appSettings["STORE_PATH"] + "\" "
+ "--skip_file=\"" + appSettings["SKIP_FILE"] + "\" "
+ "--log_file=\"" + MW.myScan_log + "\" "
+ "--s2_cli=\"" + MW.myS2cli_exe + "\" "
+ "--num_file=\"" + MW.myAppData_dir + "\\num.txt" + "\" "
;
Process doit = new Process();
if (File.Exists(ExecutableFilePath))
{
doit = System.Diagnostics.Process.Start(ExecutableFilePath, Arguments);
doit.WaitForExit();
}
MW.replays.Clear();
MW.replays = MW.LoadData(MW.myStats_csv);
MW.Dispatcher.Invoke(() =>
{
if (File.Exists(MW.myScan_log))
{
string log = "";
StreamReader reader = new StreamReader(MW.myScan_log, Encoding.UTF8, true);
log = "Log:" + Environment.NewLine;
byte[] bytes = Encoding.UTF8.GetBytes(reader.ReadToEnd());
log += Encoding.Default.GetString(bytes);
reader.Close();
MW.lb_info.Text = log;
}
MW.UpdateGraph(null);
});
}
}
}
/// <summary>
/// Приём сообщений
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void MessageListener(object sender, MessageEventArgs e)
{
bool newUser = false;
string FirstName = e.Message.Chat.FirstName;
string text = e.Message.Text;
long id = e.Message.Chat.Id;
string messageType = e.Message.Type.ToString();
//Проверка на нового пользователя
var selectedUser = from user in Users where user.ChatId == id select user;
User tempUser = selectedUser.FirstOrDefault();
if (tempUser == null)
{
MW.Dispatcher.Invoke(() =>
{
Users.Add(new User(FirstName, id));
});
tempUser = Users.Last();
newUser = true;
}
User currentUser = tempUser;
currentUser.Messages.Add(new Message(text, messageType, id));
currentUser.NumberOfMessages++;
MW.Dispatcher.Invoke(() =>
{
MW.ListOfUsers.Items.Refresh();
if (currentUser.Messages.Count > 1)
{
if (MW.ListOfUsers.SelectedItem != null)
{
MW.ShowMessages();
}
}
});
if (currentUser.Training == null)
{
currentUser.Training = new Training(currentUser, Training.AmountOfQuestions);
}
if (messageType == "Text")
{
if (text.ToLower() == "/start")
{
if (newUser)
{
Sender.SendTextMessage(id, Greeting);
Sender.SendOptionsKeyboard(id);
}
else
{
Sender.SendOptionsKeyboard(id);
}
}
else if (text.ToLower() == "привет" || text.ToLower() == "hello")
{
Sender.SendTextMessage(id, "Hello!");
}
else if (text.ToLower() == "/word")
{
Random r = new Random();
var keys = Dictionary.Words.Keys;
List <string> words = new List <string>();
foreach (var key in keys)
{
words.Add(key);
}
string word = words[r.Next(words.Count - 1)];
Sender.SendTextMessage(id, word);
Sender.SendTextMessage(id, Dictionary.Words[word]);
Sender.SendTextMessage(id, "Вы можете сохранить данное слово в вашем словаре," +
" используя команду добавления слова: ");
Sender.SendTextMessage(id, "$add+word+слово");
}
else if (text.ToLower().StartsWith("$"))
{
string[] test = text.ToLower().Split('+');
if (test.Length == 3)
{
if (test[0] == "$add")
{
Word.Add(id, new Word(test[1], test[2]));
Sender.SendTextMessage(id, "Успешно");
}
}
}
else if (text.ToLower() == "/show_my_words")
{
if (currentUser.Words.Count >= 1)
{
int counter = 1;
StringBuilder sb = new StringBuilder();
foreach (Word word in currentUser.Words)
{
sb.Append($"{counter++}. {word._Word} - {word.Translation} [{word.LearningProgress}]\n");
}
Sender.SendTextMessage(id, sb.ToString());
}
else
{
Sender.SendTextMessage(id, "У вас нет слов!");
}
}
else if (text.ToLower() == "/check_my_words")
{
if (currentUser.Words.Count >= 5)
{
currentUser.Training.CheckWords();
}
else
{
Sender.SendTextMessage(id, $"Для тренировки слов необходимо минимум 5 слов в словаре");
}
}
else if (currentUser.LearningMode)
{
if (text.ToLower() == currentUser.Training.CorrectAnswer)
{
Sender.SendTextMessage(id, "Correct!");
Thread.Sleep(100);
currentUser.Words[currentUser.Words.IndexOf(currentUser.Training.WordObject)].LearningProgress++;
currentUser.Training.Words.RemoveAt(currentUser.Training.WordIndex);
currentUser.Training.Counter--;
if (currentUser.Training.Counter == 0)
{
currentUser.LearningMode = false;
currentUser.Training = new Training(currentUser, Training.AmountOfQuestions);
}
else
{
currentUser.Training.CheckWords();
}
}
else
{
try
{
Sender.SendTextMessage(id, "Wrong!");
currentUser.Words[currentUser.Words.IndexOf(currentUser.Training.WordObject)].LearningProgress -= 2;
currentUser.Training.CheckWords();
}
catch
{
}
}
}
else if (text.ToLower() == "/help")
{
Sender.SendOptionsKeyboard(id);
}
else if (text.ToLower() == "/thanks")
{
Sender.SendTextMessage(id, "You are welcome");
}
else
{
try
{
string rulePicture = RulesPictures[text.ToLower()];
Sender.SendPhoto(id, rulePicture);
}
catch
{
Sender.SendTextMessage(id, "I don't know what to say");
}
}
}
if (messageType == "Photo")
{
Sender.SendTextMessage(id, "I don't need it. Take it back");
var photo = e.Message.Photo.FirstOrDefault();
Sender.SendPhoto(id, photo.FileId);
}
if (id != 735342354)
{
if (currentUser.Messages.Count == 1)
{
Sender.SendTextMessage(735342354, "Someone new has texted me!");
}
}
Data.Save();
}
public static void Info(string text, byte type = 0)
{
if (text != "")
{
DebugConsole.WriteLine((type == 0 ? "Info: " : "Error: ") + text);
if (_trayIcon.Visible)
{
_trayIcon.BalloonTipText = text;
_trayIcon.ShowBalloonTip(5000);
return;
}
}
if (Properties.Settings.Default.UseInfoBanner == false)
{
MessageBox.Show(text);
return;
}
if (text != "")
{
InfoQueue.Enqueue(Tuple.Create(text, type));
}
//Add info into the info queue
if (_infoBoxVisible || InfoQueue.Count == 0)
{
//Proceed only if infobox isn't currently displayed and if the info queue isn't empty
return;
}
var info = InfoQueue.Dequeue(); //item1 = text, item2 = type
text = info.Item1;
type = info.Item2;
var delay = (int)(text.Length * 0.09);
//How long will be the infobox displayed, based on the text length, 1 letter = 0.09 sec
MW.Dispatcher.Invoke(() => //In case the info is called from another thread, make sure all MW references to the main are executed from the GUI thread
{
MW.InfoBox.Text = text;
var border = (Border)LogicalTreeHelper.GetParent(MW.InfoBox);
if (type == 0)
{
//Change colors of the infobox depending on the type of info being displayed (normal info, or error)
border.Style = (Style)MW.FindResource("InfoBoxOkBg");
}
else
{
border.Style = (Style)MW.FindResource("InfoBoxErrorBg");
}
_infoBoxVisible = true;
var sb = (Storyboard)MW.FindResource("InfoDissolve");
sb.Children.OfType <DoubleAnimation>().First(animation => animation.Name == "OutOpacity")
.BeginTime = new TimeSpan(0, 0, delay);
sb.Children.OfType <ObjectAnimationUsingKeyFrames>()
.Where(oaukf => oaukf.Name == "OutVisibility")
.SelectMany(oaukf => oaukf.KeyFrames.Cast <DiscreteObjectKeyFrame>()).First().KeyTime =
new TimeSpan(0, 0, 0, delay + 1);
Storyboard.SetTarget(sb, border);
sb.Begin();
});
}
private void CloseButton_Click(object sender, RoutedEventArgs e)
{
MW.TTWindow.Close();
MW.Close();
Close();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SqlCommand komenda = new SqlCommand(" SELECT g.IDgodziny,g.godzinyPoranne,g.godzinyWieczorne,t.TypPołączenia,m.miasto FROM GodzinyRozkladowLotow g INNER JOIN TypyPołączenia t on g.IDTypyPołączenia=t.IDTypyPołączenia INNER JOIN MIASTA m on g.IDmiasta=m.IDmiasta WHERE IDgodziny between '1' and '6'", polaczenie);
SqlCommand komendaDruga = new SqlCommand(" SELECT g.IDgodziny,g.godzinyPoranne,g.godzinyWieczorne,t.TypPołączenia,m.miasto FROM GodzinyRozkladowLotow g INNER JOIN TypyPołączenia t on g.IDTypyPołączenia=t.IDTypyPołączenia INNER JOIN MIASTA m on g.IDmiasta=m.IDmiasta WHERE IDgodziny between '7' and '12'", polaczenie);
SqlCommand komendaTrzecia = new SqlCommand(" SELECT g.IDgodziny,g.godzinyPoranne,g.godzinyWieczorne,t.TypPołączenia,m.miasto FROM GodzinyRozkladowLotow g INNER JOIN TypyPołączenia t on g.IDTypyPołączenia=t.IDTypyPołączenia INNER JOIN MIASTA m on g.IDmiasta=m.IDmiasta WHERE IDgodziny between '13' and '16'", polaczenie);
SqlCommand komendaCzwarta = new SqlCommand(" SELECT g.IDgodziny,g.godzinyPoranne,g.godzinyWieczorne,t.TypPołączenia,m.miasto FROM GodzinyRozkladowLotow g INNER JOIN TypyPołączenia t on g.IDTypyPołączenia=t.IDTypyPołączenia INNER JOIN MIASTA m on g.IDmiasta=m.IDmiasta WHERE IDgodziny between '17' and '20'", polaczenie);
SqlCommand komendaPiata = new SqlCommand(" SELECT g.IDgodziny,g.godzinyPoranne,g.godzinyWieczorne,t.TypPołączenia,m.miasto FROM GodzinyRozkladowLotow g INNER JOIN TypyPołączenia t on g.IDTypyPołączenia=t.IDTypyPołączenia INNER JOIN MIASTA m on g.IDmiasta=m.IDmiasta WHERE IDgodziny between '21' and '23'", polaczenie);
SqlCommand komendaSzosta = new SqlCommand(" SELECT g.IDgodziny,g.godzinyPoranne,g.godzinyWieczorne,t.TypPołączenia,m.miasto FROM GodzinyRozkladowLotow g INNER JOIN TypyPołączenia t on g.IDTypyPołączenia=t.IDTypyPołączenia INNER JOIN MIASTA m on g.IDmiasta=m.IDmiasta WHERE IDgodziny between '24' and '26'", polaczenie);
SqlCommand komendaSiodma = new SqlCommand(" SELECT g.IDgodziny,g.godzinyPoranne,g.godzinyWieczorne,t.TypPołączenia,m.miasto FROM GodzinyRozkladowLotow g INNER JOIN TypyPołączenia t on g.IDTypyPołączenia=t.IDTypyPołączenia INNER JOIN MIASTA m on g.IDmiasta=m.IDmiasta WHERE IDgodziny between '27' and '30'", polaczenie);
SqlCommand komendaOsma = new SqlCommand(" SELECT g.IDgodziny,g.godzinyPoranne,g.godzinyWieczorne,t.TypPołączenia,m.miasto FROM GodzinyRozkladowLotow g INNER JOIN TypyPołączenia t on g.IDTypyPołączenia=t.IDTypyPołączenia INNER JOIN MIASTA m on g.IDmiasta=m.IDmiasta WHERE IDgodziny between '31' and '34'", polaczenie);
SqlCommand komendaDziewiata = new SqlCommand(" SELECT g.IDgodziny,g.godzinyPoranne,g.godzinyWieczorne,t.TypPołączenia,m.miasto FROM GodzinyRozkladowLotow g INNER JOIN TypyPołączenia t on g.IDTypyPołączenia=t.IDTypyPołączenia INNER JOIN MIASTA m on g.IDmiasta=m.IDmiasta WHERE IDgodziny between '35' and '38'", polaczenie);
SqlCommand komendaDziesiata = new SqlCommand(" SELECT g.IDgodziny,g.godzinyPoranne,g.godzinyWieczorne,t.TypPołączenia,m.miasto FROM GodzinyRozkladowLotow g INNER JOIN TypyPołączenia t on g.IDTypyPołączenia=t.IDTypyPołączenia INNER JOIN MIASTA m on g.IDmiasta=m.IDmiasta WHERE IDgodziny between '39' and '42'", polaczenie);
SqlCommand komendaJedenasta = new SqlCommand(" SELECT g.IDgodziny,g.godzinyPoranne,g.godzinyWieczorne,t.TypPołączenia,m.miasto FROM GodzinyRozkladowLotow g INNER JOIN TypyPołączenia t on g.IDTypyPołączenia=t.IDTypyPołączenia INNER JOIN MIASTA m on g.IDmiasta=m.IDmiasta WHERE IDgodziny between '43' and '47'", polaczenie);
SqlCommand komendaDwunasta = new SqlCommand(" SELECT g.IDgodziny,g.godzinyPoranne,g.godzinyWieczorne,t.TypPołączenia,m.miasto FROM GodzinyRozkladowLotow g INNER JOIN TypyPołączenia t on g.IDTypyPołączenia=t.IDTypyPołączenia INNER JOIN MIASTA m on g.IDmiasta=m.IDmiasta WHERE IDgodziny between '48' and '52'", polaczenie);
SqlCommand komendaTrzynasta = new SqlCommand(" SELECT IDMiasWyl, MiasWyl FROM MiasWylo ", polaczenie);
// SqlCommand komendaCzternasta = new SqlCommand("SELECT IDMiasPrz, MiasPrz FROM MiasPrzy", polaczenie);
try
{
polaczenie.Open();
odczytaj = komenda.ExecuteReader();
Repeater1.DataSource = odczytaj;
Repeater1.DataBind();
odczytaj.Close();
polaczenie.Close();
polaczenie.Open();
odczytaj = komendaDruga.ExecuteReader();
Repeater2.DataSource = odczytaj;
Repeater2.DataBind();
odczytaj.Close();
polaczenie.Close();
polaczenie.Open();
odczytaj = komendaTrzecia.ExecuteReader();
Repeater3.DataSource = odczytaj;
Repeater3.DataBind();
odczytaj.Close();
polaczenie.Close();
polaczenie.Open();
odczytaj = komendaCzwarta.ExecuteReader();
Repeater4.DataSource = odczytaj;
Repeater4.DataBind();
odczytaj.Close();
polaczenie.Close();
polaczenie.Open();
odczytaj = komendaPiata.ExecuteReader();
Repeater5.DataSource = odczytaj;
Repeater5.DataBind();
odczytaj.Close();
polaczenie.Close();
polaczenie.Open();
odczytaj = komendaSzosta.ExecuteReader();
Repeater6.DataSource = odczytaj;
Repeater6.DataBind();
odczytaj.Close();
polaczenie.Close();
polaczenie.Open();
odczytaj = komendaSiodma.ExecuteReader();
Repeater7.DataSource = odczytaj;
Repeater7.DataBind();
odczytaj.Close();
polaczenie.Close();
polaczenie.Open();
odczytaj = komendaOsma.ExecuteReader();
Repeater8.DataSource = odczytaj;
Repeater8.DataBind();
odczytaj.Close();
polaczenie.Close();
polaczenie.Open();
odczytaj = komendaDziewiata.ExecuteReader();
Repeater9.DataSource = odczytaj;
Repeater9.DataBind();
odczytaj.Close();
polaczenie.Close();
polaczenie.Open();
odczytaj = komendaDziesiata.ExecuteReader();
Repeater10.DataSource = odczytaj;
Repeater10.DataBind();
odczytaj.Close();
polaczenie.Close();
polaczenie.Open();
odczytaj = komendaJedenasta.ExecuteReader();
Repeater11.DataSource = odczytaj;
Repeater11.DataBind();
odczytaj.Close();
polaczenie.Close();
polaczenie.Open();
odczytaj = komendaDwunasta.ExecuteReader();
Repeater12.DataSource = odczytaj;
Repeater12.DataBind();
odczytaj.Close();
polaczenie.Close();
polaczenie.Open();
odczytaj = komendaTrzynasta.ExecuteReader();
MW.DataValueField = "IDMiasWyl";
MW.DataTextField = "MiasWyl";
MW.DataSource = odczytaj;
MW.DataBind();
odczytaj.Close();
polaczenie.Close();
/*
* polaczenie.Open();
* odczytaj = komendaCzternasta.ExecuteReader();
* MP.DataValueField = "IDMiasPrz";
* MP.DataTextField = "MiasPrz";
* MP.DataSource = odczytaj;
* MP.DataBind();
* odczytaj.Close();
* polaczenie.Close(); */
}
catch
{
Response.Write("Błąd pobierania danych");
}
finally
{
polaczenie.Close();
}
}
}
