public void GetValuesOfPropertyOrFieldTest()
{
// FromTo - simple variables
FromTo ft = new FromTo(0, 1);
List <string> onlyNames = new List <string>();
var r = SH.Join(Environment.NewLine, RH.GetValuesOfPropertyOrField(ft, onlyNames.ToArray()));
onlyNames.Add("from");
var r2 = SH.Join(Environment.NewLine, RH.GetValuesOfPropertyOrField(ft, onlyNames.ToArray()));
// UploadFile - properties
UploadFile uf = new UploadFile();
uf.Filename = "d";
uf.Name = "name";
onlyNames.Clear();
var r3 = SH.Join(Environment.NewLine, RH.GetValuesOfPropertyOrField(uf, onlyNames.ToArray()));
onlyNames.Add("Name");
var r4 = SH.Join(Environment.NewLine, RH.GetValuesOfPropertyOrField(uf, onlyNames.ToArray()));
int i = 0;
}
public override async Task GetFibonacci(FromTo request, IServerStreamWriter <NumericResult> responseStream, ServerCallContext context)
{
// Check input parameters
if (request.From > request.To)
{
// Note simple error indication with status code and message
context.Status = new Status(StatusCode.InvalidArgument, "FromTo.From must be <= FromTo.To");
return;
}
foreach (var current in math.GetFibonacci())
{
if (current < request.From)
{
// Fibonacci number is too low
continue;
}
else if (current <= request.To)
{
// We got a Fibonacci number that the client is interested in
await responseStream.WriteAsync(new NumericResult { Result = current });
// Simulate some long running calculation
await Task.Delay(250);
}
else
{
// Fibonacci number is too high
break;
}
}
}
private void ButtonAdd(object sender, RoutedEventArgs e)
{
int Start = 0;
int Ende = 0;
if (int.TryParse(this.tbStart.Text.Trim(), out Start) && int.TryParse(this.tbEnde.Text.Trim(), out Ende))
{
try {
FromTo FT = new FromTo(Start, Ende);
List <int> ÜberschneidungenNummern = new List <int>();
IEnumerable <int> VorhandeNummern = this.m_Current.Select(Current => Current.Nummer);
foreach (int Current in FT.Generate())
{
if (VorhandeNummern.Contains(Current))
{
ÜberschneidungenNummern.Add(Current);
}
}
if (ÜberschneidungenNummern.Count > 0)
{
// Einige Einträge vorhanden
switch (MessageBox.Show(string.Format("Ja: Füge vorhande Einträge auch hinzu ({0})\nNein: Nur nicht vorhande Folgen hinzufügen\nAbbrechen: Vorgang Abbrechen", string.Join(", ", ÜberschneidungenNummern)), "",
MessageBoxButton.YesNoCancel, MessageBoxImage.Question, MessageBoxResult.Cancel)
)
{
case MessageBoxResult.Yes:
this.m_Current.AddRange(FT.Generate());
this.DialogResult = true;
this.Close();
break;
case MessageBoxResult.No:
this.m_Current.AddRange(FT.Generate().Where(Current => !ÜberschneidungenNummern.Contains(Current)));
this.DialogResult = true;
this.Close();
break;
case MessageBoxResult.Cancel:
break;
}
}
else
{
this.m_Current.AddRange(FT.Generate());
this.DialogResult = true;
this.Close();
}
}
catch (Exception ex) {
MessageBox.Show("Die Ende-Zahl muss größer als die Start Zahl sein\n" + ex.Message);
}
}
else
{
MessageBox.Show("Bitte nur Zahlen eintragen");
}
}
public void Stop()
{
FromTo fromto = Instance.GetInstance <FromTo>();
if (fromto)
{
fromto.UnRegishAgent(this);
}
}
protected void Load()
{
SetContext(typeof(Projekt), Session.Login.Load(this, Key, "Projekt"));
//SetContext(typeof(Kierunek), Session.Login.Load(this, Key, "KierunekMagazyn"));
//SetContext(typeof(ElemStruktListy), Session.Login.Load(this, Key, "Element"));
//SetContext(typeof(Magazyn), Session.Login.Load(this, Key, "Magazyn"));
//SetContext(typeof(Towar), Session.Login.Load(this, Key, "Towar"));
SetContext(typeof(FromTo), FromTo.Month(Date.Today));
}
public static List <T> To <P, T>(this List <P> list, FromTo <P, T> fromTo)
{
List <T> toList = new List <T>();
foreach (var p in list)
{
toList.Add(fromTo(p));
}
return(toList);
}
Observe(IGraph graph,
ICollection <INode> observers,
Tuple <String, Constraint <IEdge> > weightAndConstraint,
IAlgorithm algorithm)
{
var result = new Dictionary <FromTo <INode>, Tuple <ISet <Route>, ISet <Route> > >();
foreach (var fromNode in graph.AllNodes)
{
var from = fromNode.Value;
if (observers.Contains(from) && !from.IsObserverInclusive)
{
continue;
}
//KShortestPath shortestPath = new KShortestPath(this, from);
algorithm.Setup(from, weightAndConstraint.Item1, Constraint <INode> .Default, weightAndConstraint.Item2);
algorithm.Run();
foreach (var to in graph.AllNodes.Values.Where(to => !to.Equals(from)))
{
if (observers.Contains(to) && !to.IsObserverInclusive)
{
continue;
}
var fromTo = new FromTo <INode>(from, to);
var observedRoutes = new HashSet <Route>();
var unobservedRoutes = new HashSet <Route>();
var paths = algorithm.PathsTo(to);
foreach (Route path in paths)
{
foreach (var observer in observers)
{
if (path.Contains(observer))
{
observedRoutes.Add(path);
if (unobservedRoutes.Contains(path))
{
unobservedRoutes.Remove(path);
}
break;
}
else
{
unobservedRoutes.Add(path);
}
}
}
result[fromTo] = new Tuple <ISet <Route>, ISet <Route> >(observedRoutes, unobservedRoutes);
}
}
return(result);
}
public static double ConvertMemorySize(this long size, FromTo fromTo)
{
var degree = (int)fromTo;
var factor = Math.Pow(1024, degree < 0
? -degree
: degree);
return(degree <= 0
? size * factor
: size / factor);
}
public string ToXML(FromTo fromTo, int index)
{
if (fromTo == FromTo.From)
{
return("<From" + index + "><a>" + a + "</a><b>" + b + "</b><c>" + c + "</c></From" + index + ">");
}
else
{
return("<To" + index + "><a>" + a + "</a><b>" + b + "</b><c>" + c + "</c></To" + index + ">");
}
}
public void Start()
{
FromTo fromto = Instance.GetInstance <FromTo>();
if (fromto)
{
fromto.RegistAgent(this);
if (OnStart != null)
{
OnStart();
}
}
}
public static double ConvertMemorySize(this long size, FromTo fromTo)
{
int degree = (int)fromTo;
if (degree < 0)
{
double divide = Math.Pow(1024, -degree);
return(size / divide);
}
else
{
double multiplier = Math.Pow(1024, degree);
return(size * multiplier);
}
}
public static string ByFromToRozchodData(string filter, FromTo fromTo)
{
if (fromTo != null && (fromTo.From != null || fromTo.To != null))
{
if (fromTo.From != null)
{
filter = getFilter(filter) + "RozchodData >= '" + fromTo.From + "'";
}
if (fromTo.To != null)
{
filter = getFilter(filter) + "RozchodData <= '" + fromTo.To + "'";
}
}
return(filter);
}
static void Main(string[] args)
{
Console.WriteLine(About.ToString());
EpidLib.Virus v = new EpidLib.Virus();
Console.WriteLine(v.ToString());
RndGen rndGen = new RndGen();
rndGen.Reset();
Console.WriteLine(rndGen.ToString());
for (int i = 0; i < 250; i++)
{
Console.WriteLine(rndGen.NextNorm());
}
rndGen.ToCSV(0, 1, 1500);
Attribute attr = new Attribute();
Console.WriteLine(attr);
FreqTable ft = new FreqTable();
ft.Append("male", 0.48);
ft.Append("female", 0.52);
Console.WriteLine(ft);
ft.Cumulative = true;
Console.WriteLine(ft);
ft.Cumulative = false;
Console.WriteLine(ft);
FromTo diap1 = new FromTo()
{
From = 0, To = 1
};
Console.WriteLine(diap1);
FromToPercent diap2 = new FromToPercent()
{
FromPercent = 0.2, ToPercent = 0.3
};
Console.WriteLine(diap2);
}
public SubTable ObrotyWgOkresu(FromTo okres)
{
if (Kontrahent == null)
{
return(null);
}
// Obroty towaru w okresie dla kontrahenta
SubTable obrotyst = Magazyny.MagazynyModule.GetInstance(Kontrahent).Obroty.WgRozchodKontrahent[Kontrahent];
if (okres != FromTo.All && okres != FromTo.Empty)
{
obrotyst = obrotyst[new FieldCondition.Contain("Data", okres)];
}
return(obrotyst);
}
private void RecursivelyFlood(Item root, Item from, HashSet <Item> visited, Dictionary <FromTo, Dependency> checkPresence,
DependencyPattern idempotentPattern, Dictionary <Item, Dependency[]> outgoing, IEnumerable <ItemMatch> toItemMatches,
List <DependencyMatch> matches, List <DependencyMatch> excludes, Dictionary <string, int> markersToAddOrNull,
List <Dependency> result, Dependency collectedEdge, [NotNull] Action checkAbort, WorkingGraph workingGraph, bool ignoreCase)
{
if (outgoing.ContainsKey(from))
{
checkAbort();
foreach (var d in outgoing[from].Where(d => d.IsMarkerMatch(matches, excludes)))
{
Item target = d.UsedItem;
if (visited.Add(target))
{
Dependency rootToTarget = collectedEdge == null
? d
: workingGraph.CreateDependency(root, target, d.Source,
new MutableMarkerSet(ignoreCase,
markersToAddOrNull
?? MutableMarkerSet.ConcatOrUnionWithMarkers(collectedEdge.AbstractMarkerSet,
d.AbstractMarkerSet, ignoreCase)),
collectedEdge.Ct + d.Ct, collectedEdge.QuestionableCt + d.QuestionableCt,
collectedEdge.BadCt + d.BadCt, collectedEdge.NotOkReason ?? d.NotOkReason, d.ExampleInfo);
if (IsMatch(toItemMatches, target))
{
Dependency alreadyThere;
var rootTargetKey = new FromTo(root, target);
if (checkPresence.TryGetValue(rootTargetKey, out alreadyThere) && idempotentPattern.IsMatch(alreadyThere))
{
// we do not add a dependency
}
else
{
checkPresence[rootTargetKey] = rootToTarget;
result.Add(rootToTarget);
}
}
// Continue search
RecursivelyFlood(root, target, visited, checkPresence, idempotentPattern, outgoing,
toItemMatches, matches, excludes, markersToAddOrNull, result, rootToTarget,
checkAbort, workingGraph, ignoreCase);
}
}
}
}
public void ShowDictonary(FromTo mode)
{
if (mode == FromTo.EnToRu)
{
WriteLine("Англо-русский словарь.\n");
foreach (KeyValuePair<string, string> str in dictionaryEnToRu)
WriteLine($"{str.Key}\t-\t{str.Value}");
}
else if (mode == FromTo.RuToEn)
{
WriteLine("Русско-английский словарь.\n");
foreach (KeyValuePair<string, string> str in dictionaryRuToEn)
WriteLine($"{str.Key}\t-\t{str.Value}");
}
else
throw new ArgumentOutOfRangeException("Wrong mode!");
}
private AnimationTimeline CreateAnimation(FromTo fromTo, EventHandler whenDone = null)
{
IEasingFunction ease = new BackEase {
Amplitude = Amplitude, EasingMode = EasingMode.EaseOut
};
var duration = new Duration(TimeSpan.FromSeconds(Duration));
var anim = new DoubleAnimation(fromTo.From, fromTo.To, duration)
{
EasingFunction = ease
};
if (whenDone != null)
{
anim.Completed += whenDone;
}
anim.Freeze();
return(anim);
}
private FromTo DirectionForOldContent()
{
FromTo ret = null;
if (AnimatedContentControl.SlideDirection == SlidingDirection.FromRightToLeft)
{
ret = new FromTo()
{
From = 0, To = -this.ActualWidth
};
}
else
{
ret = new FromTo()
{
From = 0, To = this.ActualWidth
};
}
return(ret);
}
public void HasTextRightFormatTest()
{
FromTo requiredLength = new FromTo(1, 1);
var dash = CharFormatData.Get(null, new FromTo(1, 1), AllChars.dash);
var onlyNumbers = CharFormatData.GetOnlyNumbers(requiredLength);
TextFormatData textFormat = new TextFormatData(false, -1, onlyNumbers, dash, onlyNumbers, dash, onlyNumbers, dash, onlyNumbers);
string actual1 = " 01-1-1-1";
string actual2 = "1-1-1-1";
string actual3 = "123-1-1-1";
string actual4 = "1-1-1";
string actual5 = "1-1-1-1-1";
string actual6 = "12-1-1-1";
Assert.False(SH.HasTextRightFormat(actual1, textFormat));
Assert.True(SH.HasTextRightFormat(actual2, textFormat));
Assert.False(SH.HasTextRightFormat(actual3, textFormat));
Assert.False(SH.HasTextRightFormat(actual4, textFormat));
Assert.False(SH.HasTextRightFormat(actual5, textFormat));
Assert.False(SH.HasTextRightFormat(actual6, textFormat));
}
public List <FromTo> GetFromTO()
{
List <FromTo> fromToList = new List <FromTo>();
string query = "SELECT * FROM FromTo order by Name asc";
Command = new SqlCommand(query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
if (Reader.HasRows)
{
while (Reader.Read())
{
FromTo fromTo = new FromTo();
fromTo.ID = Convert.ToInt32(Reader["ID"]);
fromTo.Name = Reader["Name"].ToString();
fromToList.Add(fromTo);
}
Reader.Close();
}
Connection.Close();
return(fromToList);
}
public override int Transform([NotNull] GlobalContext globalContext, Ignore Ignore,
[NotNull] TransformOptions transformOptions, [NotNull][ItemNotNull] IEnumerable <Dependency> dependencies,
[NotNull] List <Dependency> transformedDependencies)
{
DependencyPattern idempotentPattern = transformOptions.MarkerToAdd == null ? null : new DependencyPattern("'" + transformOptions.MarkerToAdd, globalContext.IgnoreCase);
Dictionary <FromTo, Dependency> fromTos = transformOptions.Idempotent ? FromTo.AggregateAllDependencies(globalContext.CurrentGraph, dependencies) : null;
int added = 0;
int removed = 0;
foreach (var d in dependencies)
{
if (!transformOptions.RemoveOriginal)
{
transformedDependencies.Add(d);
}
else
{
removed++;
}
if (d.IsMarkerMatch(transformOptions.Matches, transformOptions.Excludes))
{
if (fromTos == null ||
!FromTo.ContainsMatchingDependency(fromTos, d.UsedItem, d.UsingItem, idempotentPattern))
{
var newDependency = globalContext.CurrentGraph.CreateDependency(d.UsedItem, d.UsingItem, d.Source, d.MarkerSet, d.Ct,
d.QuestionableCt, d.BadCt, d.NotOkReason, d.ExampleInfo);
if (transformOptions.MarkerToAdd != null)
{
newDependency.IncrementMarker(transformOptions.MarkerToAdd);
}
transformedDependencies.Add(newDependency);
added++;
}
}
}
Log.WriteInfo($"... added {added}{(removed > 0 ? " removed " + removed : "")} dependencies");
return(Program.OK_RESULT);
}
private void SearchFolgenVerpasst(object sender, RoutedEventArgs e)
{
Staffel CurrentStaffel = (Staffel)cbStaffeln.SelectedItem;
int NummerNeu = CurrentStaffel.Folgen.NummerNeueFolge();
IEnumerable <int> Lücken = new int[0];
if (NummerNeu > 1)
{
FromTo FT = new FromTo(1, NummerNeu - 1);
Lücken = FT.Generate().Where(Current => !CurrentStaffel.Folgen.Select(InnerCurrent => InnerCurrent.Nummer).Contains(Current));
}
if (Lücken.Count() > 0)
{
MessageBox.Show(string.Join(", ", Lücken), "Verpasste Folgen", MessageBoxButton.OK, MessageBoxImage.Warning);
}
else
{
MessageBox.Show("Keine verpassten Folgen!", string.Empty, MessageBoxButton.OK, MessageBoxImage.Information, MessageBoxResult.OK);
}
}
public override int Transform([NotNull] GlobalContext globalContext, Ignore Ignore,
[NotNull] TransformOptions transformOptions, [NotNull][ItemNotNull] IEnumerable <Dependency> dependencies,
[NotNull] List <Dependency> transformedDependencies)
{
_transformRunCt++;
MutableMarkerSet.AddComputedMarkerIfNoMarkers(transformOptions.MarkersToAdd,
transformOptions.FromItemMatches, transformOptions.ToItemMatches, "" + _transformRunCt);
WorkingGraph currentWorkingGraph = globalContext.CurrentGraph;
DependencyPattern idempotentPattern = new DependencyPattern("'" + string.Join("+", transformOptions.MarkersToAdd), globalContext.IgnoreCase);
Dictionary <FromTo, Dependency> checkPresence = transformOptions.Idempotent
? FromTo.AggregateAllDependencies(currentWorkingGraph, dependencies)
: new Dictionary <FromTo, Dependency>();
Dictionary <Item, Dependency[]> outgoing = Item.CollectOutgoingDependenciesMap(dependencies);
IEnumerable <Item> matchingFroms = outgoing.Keys.Where(i => IsMatch(transformOptions.FromItemMatches, i));
Dictionary <string, int> markersToAddAsDictionary = transformOptions.MarkersToAdd.Distinct().ToDictionary(s => s, s => 1);
var result = new List <Dependency>();
foreach (var from in matchingFroms)
{
RecursivelyFlood(from, from, new HashSet <Item> {
from
}, checkPresence, idempotentPattern, outgoing,
transformOptions.ToItemMatches, transformOptions.Matches, transformOptions.Excludes,
markersToAddAsDictionary, result, null, globalContext.CheckAbort,
currentWorkingGraph, globalContext.IgnoreCase);
}
transformedDependencies.AddRange(dependencies);
transformedDependencies.AddRange(result);
Log.WriteInfo($"... added {result.Count} new dependencies");
return(Program.OK_RESULT);
}
public override int Transform([NotNull] GlobalContext globalContext, [NotNull] ConfigureOptions configureOptions,
[NotNull] TransformOptions transformOptions, [NotNull][ItemNotNull] IEnumerable <Dependency> dependencies,
[NotNull] List <Dependency> transformedDependencies)
{
var leftSideCache = new Dictionary <Item, Item>();
var rightSideCache = new Dictionary <Item, Item>();
if (transformOptions.BackProjectionDependencies != null)
{
Dictionary <FromTo, Dependency> dependenciesForBackProjection = dependencies.ToDictionary(
d => new FromTo(d.UsingItem, d.UsedItem), d => d);
var backProjected = new List <Dependency>();
int missingPatternCount = 0;
//int notBackProjected = 0;
var localCollector = new Dictionary <FromTo, Dependency>(dependencies.Count());
var mapItems = new Dictionary <Item, Item>();
int dependencyProjectCountForLogging = 0;
foreach (var d in transformOptions.BackProjectionDependencies)
{
FromTo f = ProjectDependency(globalContext.CurrentGraph, d, leftSideCache, rightSideCache, localCollector,
++dependencyProjectCountForLogging, onMissingPattern: () => OnMissingPattern(ref missingPatternCount));
if (f != null)
{
Dependency projected;
if (dependenciesForBackProjection.TryGetValue(f, out projected))
{
//d.ResetBad(); <-- option
//d.ResetQuestionable(); <-- option
d.AggregateMarkersAndCounts(projected);
mapItems[d.UsedItem] = projected.UsedItem;
mapItems[d.UsingItem] = projected.UsingItem;
backProjected.Add(d);
}
else
{
//notBackProjected++;
}
}
}
foreach (var kvp in mapItems)
{
Item target = kvp.Key;
Item source = kvp.Value;
target.MergeWithMarkers(source.MarkerSet);
}
transformedDependencies.AddRange(backProjected);
}
else
{
// Forward projection
var localCollector = new Dictionary <FromTo, Dependency>();
int missingPatternCount = 0;
int dependencyProjectCountForLogging = 0;
foreach (var d in dependencies)
{
ProjectDependency(globalContext.CurrentGraph, d, leftSideCache, rightSideCache,
localCollector, ++dependencyProjectCountForLogging, () => OnMissingPattern(ref missingPatternCount));
}
transformedDependencies.AddRange(localCollector.Values);
}
AfterAllTransforms();
return(Program.OK_RESULT);
}
public void Translate(FromTo mode, string word)
{
if (mode == FromTo.EnToRu)
{
WordChecker(mode, word);
string result;
if (dictionaryEnToRu.TryGetValue(word, out result))
WriteLine($"From english to russian translate:\n{word} - {result}");
else
WriteLine("There is no such word in the dictionary!");
}
else if (mode == FromTo.RuToEn)
{
WordChecker(mode, word);
string result;
if (dictionaryRuToEn.TryGetValue(word, out result))
WriteLine($"Перевод с русского на английский:\n{word} - {result}");
else
WriteLine("Такого слова нет в словаре!");
}
else
throw new ArgumentOutOfRangeException("Wrong mode!");
}
public void ParseTest()
{
FromTo ft = new FromTo();
ft.Parse("20");
}
public static IEnumerable <DokumentHandlowy> ByPrzedstawicielDefinicja(Session session, string przedstawiciel, API.Magazyny.Magazyn magazyn, FromTo fromTo, DefDokHandlowego definicja,
StanDokumentuHandlowego stan = StanDokumentuHandlowego.Zatwierdzony)
{
List <DokumentHandlowy> list = new List <DokumentHandlowy>();
if (!string.IsNullOrEmpty(przedstawiciel))
{
var kontrahenci = CRMService.Kontrahenci.ByPrzedstawiciel(session, przedstawiciel).ToList();
var hm = GetModule(session);
foreach (var k in kontrahenci)
{
var dokumenty = hm.DokHandlowe.WgKontrahentDataDefinicja(k, magazyn, fromTo, definicja, stan);
foreach (var dok in dokumenty)
{
yield return(dok);
}
//list.AddRange(hm.DokHandlowe.WgKontrahentDataDefinicja(k, magazyn, fromTo, definicja, stan));
}
}
//return list;
}
public void Remove(FromTo mode, string word)
{
if (mode == FromTo.EnToRu)
dictionaryEnToRu.Remove(word);
else if (mode == FromTo.RuToEn)
dictionaryRuToEn.Remove(word);
else
throw new ArgumentOutOfRangeException("Wrong mode!");
}
public static void Initialize(TravelPlannerContext context)
{
context.Database.Migrate();
if (context.Travels.Any())
{
return;
}
var Linz = new City {
Name = "Linz"
};
var Vienna = new City {
Name = "Vienna"
};
var Salzburg = new City {
Name = "Salzburg"
};
var Graz = new City {
Name = "Graz"
};
context.Cities.Add(Linz);
context.Cities.Add(Vienna);
context.Cities.Add(Salzburg);
context.Cities.Add(Graz);
context.SaveChanges();
var fromto = new FromTo {
FromCity = Salzburg, ToCity = Linz
};
context.FromTo.Add(fromto);
context.SaveChanges();
double price = 10.5;
var travel = new Travel {
FromToID = fromto.FromToID, DepartureTime = DateTime.Parse("09:00"), ArrivalTime = DateTime.Parse("10:45"), Price = price
};
var travel1 = new Travel {
FromToID = fromto.FromToID, DepartureTime = DateTime.Parse("11:00"), ArrivalTime = DateTime.Parse("12:15"), Price = price
};
var travel2 = new Travel {
FromToID = fromto.FromToID, DepartureTime = DateTime.Parse("13:00"), ArrivalTime = DateTime.Parse("14:15"), Price = price
};
var travel3 = new Travel {
FromToID = fromto.FromToID, DepartureTime = DateTime.Parse("15:00"), ArrivalTime = DateTime.Parse("16:45"), Price = price
};
context.Travels.Add(travel);
context.Travels.Add(travel1);
context.Travels.Add(travel2);
context.Travels.Add(travel3);
context.SaveChanges();
var fromto1 = new FromTo {
FromCity = Linz, ToCity = Salzburg
};
context.FromTo.Add(fromto1);
context.SaveChanges();
var travel4 = new Travel {
FromToID = fromto1.FromToID, DepartureTime = DateTime.Parse("11:00"), ArrivalTime = DateTime.Parse("12:15"), Price = price
};
var travel5 = new Travel {
FromToID = fromto1.FromToID, DepartureTime = DateTime.Parse("12:30"), ArrivalTime = DateTime.Parse("13:45"), Price = price
};
var travel6 = new Travel {
FromToID = fromto1.FromToID, DepartureTime = DateTime.Parse("14:30"), ArrivalTime = DateTime.Parse("16:00"), Price = price
};
var travel7 = new Travel {
FromToID = fromto1.FromToID, DepartureTime = DateTime.Parse("17:00"), ArrivalTime = DateTime.Parse("18:45"), Price = price
};
context.Travels.Add(travel4);
context.Travels.Add(travel5);
context.Travels.Add(travel6);
context.Travels.Add(travel7);
context.SaveChanges();
var fromto2 = new FromTo {
FromCity = Vienna, ToCity = Linz
};
context.FromTo.Add(fromto2);
context.SaveChanges();
price = 30.20;
var travel8 = new Travel {
FromToID = fromto2.FromToID, DepartureTime = DateTime.Parse("08:00"), ArrivalTime = DateTime.Parse("10:30"), Price = price
};
var travel9 = new Travel {
FromToID = fromto2.FromToID, DepartureTime = DateTime.Parse("11:00"), ArrivalTime = DateTime.Parse("13:15"), Price = price
};
var travel10 = new Travel {
FromToID = fromto2.FromToID, DepartureTime = DateTime.Parse("14:00"), ArrivalTime = DateTime.Parse("16:30"), Price = price
};
var travel11 = new Travel {
FromToID = fromto2.FromToID, DepartureTime = DateTime.Parse("17:00"), ArrivalTime = DateTime.Parse("19:15"), Price = price
};
context.Travels.Add(travel8);
context.Travels.Add(travel9);
context.Travels.Add(travel10);
context.Travels.Add(travel11);
context.SaveChanges();
var fromto3 = new FromTo {
FromCity = Linz, ToCity = Vienna
};
context.FromTo.Add(fromto3);
context.SaveChanges();
var travel12 = new Travel {
FromToID = fromto3.FromToID, DepartureTime = DateTime.Parse("11:00"), ArrivalTime = DateTime.Parse("13:15"), Price = price
};
var travel13 = new Travel {
FromToID = fromto3.FromToID, DepartureTime = DateTime.Parse("13:30"), ArrivalTime = DateTime.Parse("15:45"), Price = price
};
var travel14 = new Travel {
FromToID = fromto3.FromToID, DepartureTime = DateTime.Parse("16:45"), ArrivalTime = DateTime.Parse("19:00"), Price = price
};
var travel15 = new Travel {
FromToID = fromto3.FromToID, DepartureTime = DateTime.Parse("19:30"), ArrivalTime = DateTime.Parse("21:45"), Price = price
};
context.Travels.Add(travel12);
context.Travels.Add(travel13);
context.Travels.Add(travel14);
context.Travels.Add(travel15);
context.SaveChanges();
var fromto4 = new FromTo {
FromCity = Graz, ToCity = Linz
};
context.FromTo.Add(fromto4);
context.SaveChanges();
price = 25;
var travel16 = new Travel {
FromToID = fromto4.FromToID, DepartureTime = DateTime.Parse("06:00"), ArrivalTime = DateTime.Parse("09:00"), Price = price
};
var travel17 = new Travel {
FromToID = fromto4.FromToID, DepartureTime = DateTime.Parse("12:00"), ArrivalTime = DateTime.Parse("15:00"), Price = price
};
var travel18 = new Travel {
FromToID = fromto4.FromToID, DepartureTime = DateTime.Parse("16:00"), ArrivalTime = DateTime.Parse("19:00"), Price = price
};
context.Travels.Add(travel16);
context.Travels.Add(travel17);
context.Travels.Add(travel18);
context.SaveChanges();
var fromto5 = new FromTo {
FromCity = Linz, ToCity = Graz
};
context.FromTo.Add(fromto5);
context.SaveChanges();
var travel19 = new Travel {
FromToID = fromto5.FromToID, DepartureTime = DateTime.Parse("10:00"), ArrivalTime = DateTime.Parse("13:00"), Price = price
};
var travel20 = new Travel {
FromToID = fromto5.FromToID, DepartureTime = DateTime.Parse("15:30"), ArrivalTime = DateTime.Parse("18:30"), Price = price
};
var travel21 = new Travel {
FromToID = fromto5.FromToID, DepartureTime = DateTime.Parse("19:45"), ArrivalTime = DateTime.Parse("22:30"), Price = price
};
context.Travels.Add(travel19);
context.Travels.Add(travel20);
context.Travels.Add(travel21);
context.SaveChanges();
}
public static View <RozrachunekIdx> ByKontrahent(Session session, Kontrahent kontrahent, FromTo dataFromTo, FromTo rozliczenieFromTo)
{
var view = new View <RozrachunekIdx>(GetModule(session).RozrachunkiIdx.WgPodmiot(kontrahent).CreateView());
if (dataFromTo != null)
{
view.And("Data >= '" + dataFromTo.From + "' AND Data <= '" + dataFromTo.To + "'");
}
if (rozliczenieFromTo != null)
{
view.And("DataRozliczenia >= '" + rozliczenieFromTo.From + "' AND DataRozliczenia <= '" + rozliczenieFromTo.To + "'");
}
return(view);
}
void WordChecker(FromTo mode, string word)
{
if (mode == FromTo.EnToRu)
{
for (int i = 0; i < word.Length; ++i)
if (!(word[i] >= 'a' && word[i] <= 'z' || word[i] >= 'A' && word[i] <= 'Z'))
throw new ArgumentException("Wrong word!");
}
else if (mode == FromTo.RuToEn)
{
for (int i = 0; i < word.Length; ++i)
if (!(word[i] >= 'а' && word[i] <= 'я' || word[i] >= 'А' && word[i] <= 'Я'))
throw new ArgumentException("Wrong word!");
}
else
throw new ArgumentOutOfRangeException("Wrong mode!");
}
