private List <ScaleLine> GetScaleLines(List <Rating> list, DateTime Dtt)
{
List <ScaleLine> scaleLines = new List <ScaleLine>();
List <string> emitents = list.Select(s => s.agency_name_rus).Distinct().ToList();
for (int i = 0; i < emitents.Count; i++)
{
ScaleLine scaleLine = new ScaleLine {
AgencyName = emitents[i]
};
for (int j = 0; j < list.Count; j++)
{
if (scaleLine.AgencyName == list[j].agency_name_rus)
{
List <ScalePart> scaleParts = ScalePartCrud.GetAllScalePart(Dtt, list[j].agency_id, list[j].scale_id);
if (scaleParts[0].typeF == "N" && (scaleLine.National == null))
{
scaleLine.PointNameN = list[j].point_name;
scaleLine.StatusN = list[j].name_rus;
scaleLine.National = scaleParts;
if (list[j].rating_date != null)
{
scaleLine.DateN = list[j].rating_date;
}
}
else if (scaleParts[0].typeF == "F" && (scaleLine.Foreign == null))
{
scaleLine.PointNameF = list[j].point_name;
scaleLine.StatusF = list[j].name_rus;
scaleLine.Foreign = scaleParts;
if (list[j].rating_date != null)
{
scaleLine.DateF = list[j].rating_date;
}
}
}
}
scaleLines.Add(scaleLine);
}
return(scaleLines);
}
private void PaintScale(List <Rating> list, DateTime Dtt)
{
Grid gridMain = new Grid();
ColumnDefinition leftColumnDef = new ColumnDefinition();
leftColumnDef.Width = new GridLength(450);
gridMain.ColumnDefinitions.Add(leftColumnDef);
ColumnDefinition rightColumnDef = new ColumnDefinition();
rightColumnDef.Width = new GridLength(10500);
gridMain.ColumnDefinitions.Add(rightColumnDef);
for (int j = 0; j < list.Count; j++)
{
RowDefinition rowM = new RowDefinition();
rowM.Height = new GridLength(150);
gridMain.RowDefinitions.Add(rowM);
Grid gridRight = new Grid();
gridRight.Background = new SolidColorBrush(Color.FromArgb(250, 255, 255, 250));
gridRight.Margin = new Thickness(2, 2, 2, 2);
List <ScalePart> listScaleParts = ScalePartCrud.GetAllScalePart(Dtt, list[j].agency_id, list[j].scale_id);
string Emitent = listScaleParts[0].name_of_emitent_rus;
RowDefinition row0 = new RowDefinition();
row0.Height = new GridLength(30);
gridRight.RowDefinitions.Add(row0);
RowDefinition row1 = new RowDefinition();
row1.Height = new GridLength(10);
gridRight.RowDefinitions.Add(row1);
RowDefinition row2 = new RowDefinition();
row2.Height = new GridLength(70);
gridRight.RowDefinitions.Add(row2);
string rating_scale_name_rus = "";
string rating_scale_name_eng = "";
string name_of_emitent_rus = "";
string name_of_emitent_eng = "";
string dt_act = "";
string typeScale = "F";
for (int i = 0; i < listScaleParts.Count; i++)
{
if (i == 0)
{
rating_scale_name_rus = listScaleParts[i].rating_scale_name_rus;
rating_scale_name_eng = listScaleParts[i].rating_scale_name_eng;
name_of_emitent_rus = listScaleParts[i].name_of_emitent_rus;
name_of_emitent_eng = listScaleParts[i].name_of_emitent_eng;
dt_act = listScaleParts[i].dt_act.ToString("D");
typeScale = listScaleParts[i].typeF;
}
#region row II
ColumnDefinition columnDefinition = new ColumnDefinition();
columnDefinition.Width = new GridLength(20);
gridRight.ColumnDefinitions.Add(columnDefinition);
TextBlock block = new TextBlock();
string name = listScaleParts[i].rating_scale_point_name;
block.Text = listScaleParts[i].rating_scale_point_name;
RotateTransform rotate = new RotateTransform(-90);
block.LayoutTransform = rotate;
block.ToolTip = listScaleParts[i].rating_scale_point_description_rus;
block.Margin = new Thickness(2, 2, 2, 2);
block.Background = new SolidColorBrush(Colors.LightGray);
block.TextAlignment = TextAlignment.Center;
// block.FontWeight = FontWeight.FromOpenTypeWeight(500);
block.FontSize = 10;
Grid.SetRow(block, 2);
Grid.SetColumn(block, i);
gridRight.Children.Add(block);
#endregion
#region TextBlock
TextBlock block1 = new TextBlock();
if (ScalePartCrud.GetGraceWorld().Contains(name))
{
block1.Background = new SolidColorBrush(Colors.Gray);
}
else if (i <= 3)
{
block1.Background = new SolidColorBrush(Colors.Green);
}
else if ((i > 3) && (i < 11))
{
block1.Background = new SolidColorBrush(Colors.Yellow);
}
else if ((i >= 11))
{
block1.Background = new SolidColorBrush(Colors.Red);
}
block1.Margin = new Thickness(1, 1, 1, 1);
Grid.SetRow(block1, 1);
Grid.SetColumn(block1, i);
gridRight.Children.Add(block1);
#endregion
#region Triangle
if (listScaleParts[i].rating_scale_point_name.Trim() == list[j].point_name.Trim())
{
Canvas canvas = new Canvas();
Grid.SetRow(canvas, 0);
Grid.SetColumn(canvas, i);
Polygon myPolygon = new Polygon();
myPolygon.Stroke = System.Windows.Media.Brushes.Black;
myPolygon.Fill = System.Windows.Media.Brushes.Blue;
myPolygon.StrokeThickness = 1;
myPolygon.HorizontalAlignment = HorizontalAlignment.Left;
myPolygon.VerticalAlignment = VerticalAlignment.Center;
Point Point1 = new Point(5, 15);
Point Point2 = new Point(10, 30);
Point Point3 = new Point(15, 15);
PointCollection myPointCollection = new PointCollection();
myPointCollection.Add(Point1);
myPointCollection.Add(Point2);
myPointCollection.Add(Point3);
myPolygon.Points = myPointCollection;
canvas.Children.Add(myPolygon);
gridRight.Children.Add(canvas);
}
#endregion
}
Grid.SetRow(gridRight, j);
Grid.SetColumn(gridRight, 1);
gridMain.Children.Add(gridRight);
//=========================================================================================================
Grid gridLeft = new Grid();
gridLeft.Background = new SolidColorBrush(Color.FromArgb(250, 255, 255, 250));
gridLeft.Margin = new Thickness(2);
//---------------------------------------------
//RowDefinition rowL1 = new RowDefinition();
//rowL1.Height = new GridLength(25);
//gridLeft.RowDefinitions.Add(rowL1);
//TextBlock textBlockL1 = new TextBlock();
//textBlockL1.Text = rating_scale_name_rus;
//textBlockL1.Margin = new Thickness(5, 0, 0, 1);
//Grid.SetRow(textBlockL1, 0);
//Grid.SetColumn(textBlockL1, 0);
//gridLeft.Children.Add(textBlockL1);
////---------------------------------------------
//RowDefinition rowL2 = new RowDefinition();
//rowL2.Height = new GridLength(25);
//gridLeft.RowDefinitions.Add(rowL2);
//TextBlock textBlockL2 = new TextBlock();
//textBlockL2.Text = rating_scale_name_eng;
//textBlockL2.Margin = new Thickness(5, 0, 0, 1);
//Grid.SetRow(textBlockL2, 1);
//Grid.SetColumn(textBlockL2, 0);
//gridLeft.Children.Add(textBlockL2);
////---------------------------------------------
RowDefinition rowL3 = new RowDefinition();
rowL3.Height = new GridLength(25);
gridLeft.RowDefinitions.Add(rowL3);
TextBlock textBlockL3 = new TextBlock();
textBlockL3.Text = name_of_emitent_rus;
textBlockL3.Margin = new Thickness(5, 0, 0, 1);
Grid.SetRow(textBlockL3, 0);
Grid.SetColumn(textBlockL3, 0);
gridLeft.Children.Add(textBlockL3);
//---------------------------------------------
//RowDefinition rowL4 = new RowDefinition();
//rowL4.Height = new GridLength(25);
//gridLeft.RowDefinitions.Add(rowL4);
//TextBlock textBlockL4 = new TextBlock();
//textBlockL4.Text = name_of_emitent_eng;
//textBlockL4.Margin = new Thickness(5, 0, 0, 1);
//Grid.SetRow(textBlockL4, 3);
//Grid.SetColumn(textBlockL4, 0);
//gridLeft.Children.Add(textBlockL4);
////---------------------------------------------
//RowDefinition rowL5 = new RowDefinition();
//rowL5.Height = new GridLength(25);
//gridLeft.RowDefinitions.Add(rowL5);
//TextBlock textBlockL5 = new TextBlock();
//textBlockL5.Text = dt_act;
//textBlockL5.Margin = new Thickness(5, 0, 0, 1);
//Grid.SetRow(textBlockL5, 4);
//Grid.SetColumn(textBlockL5, 0);
//gridLeft.Children.Add(textBlockL5);
//--------------------------------------------------------
RowDefinition rowL6 = new RowDefinition();
rowL6.Height = new GridLength(25);
gridLeft.RowDefinitions.Add(rowL6);
TextBlock textBlockL6 = new TextBlock();
textBlockL6.Text = list[j].name_rus;
textBlockL6.Margin = new Thickness(5, 0, 0, 1);
Grid.SetRow(textBlockL6, 1);
Grid.SetColumn(textBlockL6, 0);
gridLeft.Children.Add(textBlockL6);
//--------------------------------------------------------
Grid.SetRow(gridLeft, j);
Grid.SetColumn(gridLeft, 0);
gridMain.Children.Add(gridLeft);
}
ScalePanel.Children.Add(gridMain);
}
private Grid GetGridScale(Grid grid, List <ScalePart> scaleParts, DateTime?date, string PointName = "")
{
RowDefinition row0 = new RowDefinition();
row0.Height = new GridLength(30);
grid.RowDefinitions.Add(row0);
RowDefinition row1 = new RowDefinition();
row1.Height = new GridLength(10);
grid.RowDefinitions.Add(row1);
RowDefinition row2 = new RowDefinition();
row2.Height = new GridLength(70);
grid.RowDefinitions.Add(row2);
RowDefinition rowdata = new RowDefinition();
rowdata.Height = new GridLength(30);
grid.RowDefinitions.Add(rowdata);
TextBlock textBlockData = new TextBlock();
string strData = "";
if (date != null)
{
strData = ((DateTime)date).ToShortDateString();
}
textBlockData.Text = "от " + strData;
textBlockData.HorizontalAlignment = HorizontalAlignment.Center;
Grid.SetRow(textBlockData, 3);
Grid.SetColumn(textBlockData, 0);
Grid.SetColumnSpan(textBlockData, scaleParts.Count);
grid.Children.Add(textBlockData);
for (int j = 0; j < scaleParts.Count; j++)
{
#region row II
ColumnDefinition columnDefinition = new ColumnDefinition();
columnDefinition.Width = new GridLength(20);
grid.ColumnDefinitions.Add(columnDefinition);
TextBlock block = new TextBlock();
string name = scaleParts[j].rating_scale_point_name;
block.Text = scaleParts[j].rating_scale_point_name;
RotateTransform rotate = new RotateTransform(-90);
block.LayoutTransform = rotate;
TextBlock txtTooltip = new TextBlock();
txtTooltip.Width = 250;
int HeightBlock = (scaleParts[j].rating_scale_point_description_rus.Length / 25) * 20;
if (HeightBlock == 0)
{
HeightBlock = 20;
}
txtTooltip.Height = HeightBlock;
txtTooltip.TextWrapping = TextWrapping.WrapWithOverflow;
txtTooltip.TextAlignment = TextAlignment.Left;
txtTooltip.Text = scaleParts[j].rating_scale_point_description_rus;
block.ToolTip = txtTooltip;
block.Margin = new Thickness(2, 2, 2, 2);
block.Background = new SolidColorBrush(Colors.LightGray);
block.TextAlignment = TextAlignment.Center;
block.FontSize = 10;
Grid.SetRow(block, 2);
Grid.SetColumn(block, j);
grid.Children.Add(block);
#endregion
#region TextBlock
TextBlock block1 = new TextBlock();
if (ScalePartCrud.GetGraceWorld().Contains(name))
{
block1.Background = new SolidColorBrush(Colors.Gray);
}
else if (j <= 3)
{
block1.Background = new SolidColorBrush(Colors.Green);
}
else if ((j > 3) && (j < 11))
{
block1.Background = new SolidColorBrush(Colors.Yellow);
}
else if ((j >= 11))
{
block1.Background = new SolidColorBrush(Colors.Red);
}
block1.Margin = new Thickness(1, 1, 1, 1);
Grid.SetRow(block1, 1);
Grid.SetColumn(block1, j);
grid.Children.Add(block1);
#endregion
#region Triangle
if (!String.IsNullOrEmpty(PointName))
{
if (scaleParts[j].rating_scale_point_name.Trim() == PointName.Trim())
{
Canvas canvas = new Canvas();
Grid.SetRow(canvas, 0);
Grid.SetColumn(canvas, j);
Polygon myPolygon = new Polygon();
myPolygon.Stroke = Brushes.Black;
myPolygon.Fill = Brushes.Blue;
myPolygon.StrokeThickness = 1;
myPolygon.HorizontalAlignment = HorizontalAlignment.Left;
myPolygon.VerticalAlignment = VerticalAlignment.Center;
Point Point1 = new Point(5, 20);
Point Point2 = new Point(10, 30);
Point Point3 = new Point(15, 20);
PointCollection myPointCollection = new PointCollection();
myPointCollection.Add(Point1);
myPointCollection.Add(Point2);
myPointCollection.Add(Point3);
myPolygon.Points = myPointCollection;
canvas.Children.Add(myPolygon);
grid.Children.Add(canvas);
}
}
#endregion
}
return(grid);
}
