// Use this for initialization
void Start()
{
PlayerIcon.GetComponent <SpriteRenderer>().enabled = true;
A1.GetComponent <SpriteRenderer>().enabled = false;
A2.GetComponent <SpriteRenderer>().enabled = false;
A3.GetComponent <SpriteRenderer>().enabled = false;
A4.GetComponent <SpriteRenderer>().enabled = false;
A5.GetComponent <SpriteRenderer>().enabled = false;
A6.GetComponent <SpriteRenderer>().enabled = false;
A7.GetComponent <SpriteRenderer>().enabled = false;
A8.GetComponent <SpriteRenderer>().enabled = false;
A9.GetComponent <SpriteRenderer>().enabled = false;
A10.GetComponent <SpriteRenderer>().enabled = false;
A11.GetComponent <SpriteRenderer>().enabled = false;
B1.GetComponent <SpriteRenderer>().enabled = false;
B2.GetComponent <SpriteRenderer>().enabled = false;
B3.GetComponent <SpriteRenderer>().enabled = false;
B4.GetComponent <SpriteRenderer>().enabled = false;
B5.GetComponent <SpriteRenderer>().enabled = false;
B6.GetComponent <SpriteRenderer>().enabled = false;
B7.GetComponent <SpriteRenderer>().enabled = false;
B8.GetComponent <SpriteRenderer>().enabled = false;
B9.GetComponent <SpriteRenderer>().enabled = false;
B10.GetComponent <SpriteRenderer>().enabled = false;
B11.GetComponent <SpriteRenderer>().enabled = false;
C1.GetComponent <SpriteRenderer>().enabled = false;
C2.GetComponent <SpriteRenderer>().enabled = false;
C3.GetComponent <SpriteRenderer>().enabled = false;
C4.GetComponent <SpriteRenderer>().enabled = false;
C5.GetComponent <SpriteRenderer>().enabled = false;
C6.GetComponent <SpriteRenderer>().enabled = false;
C7.GetComponent <SpriteRenderer>().enabled = false;
C8.GetComponent <SpriteRenderer>().enabled = false;
C9.GetComponent <SpriteRenderer>().enabled = false;
C10.GetComponent <SpriteRenderer>().enabled = false;
C11.GetComponent <SpriteRenderer>().enabled = false;
D1.GetComponent <SpriteRenderer>().enabled = false;
D2.GetComponent <SpriteRenderer>().enabled = false;
D3.GetComponent <SpriteRenderer>().enabled = false;
D4.GetComponent <SpriteRenderer>().enabled = false;
D5.GetComponent <SpriteRenderer>().enabled = false;
D6.GetComponent <SpriteRenderer>().enabled = false;
D7.GetComponent <SpriteRenderer>().enabled = false;
D8.GetComponent <SpriteRenderer>().enabled = false;
D9.GetComponent <SpriteRenderer>().enabled = false;
D10.GetComponent <SpriteRenderer>().enabled = false;
D11.GetComponent <SpriteRenderer>().enabled = false;
E1.GetComponent <SpriteRenderer>().enabled = false;
E2.GetComponent <SpriteRenderer>().enabled = false;
E3.GetComponent <SpriteRenderer>().enabled = false;
E4.GetComponent <SpriteRenderer>().enabled = false;
E5.GetComponent <SpriteRenderer>().enabled = false;
E6.GetComponent <SpriteRenderer>().enabled = false;
E7.GetComponent <SpriteRenderer>().enabled = false;
E8.GetComponent <SpriteRenderer>().enabled = false;
E9.GetComponent <SpriteRenderer>().enabled = false;
E10.GetComponent <SpriteRenderer>().enabled = false;
E11.GetComponent <SpriteRenderer>().enabled = false;
F1.GetComponent <SpriteRenderer>().enabled = false;
F2.GetComponent <SpriteRenderer>().enabled = false;
F3.GetComponent <SpriteRenderer>().enabled = false;
F4.GetComponent <SpriteRenderer>().enabled = false;
F5.GetComponent <SpriteRenderer>().enabled = false;
F6.GetComponent <SpriteRenderer>().enabled = false;
F7.GetComponent <SpriteRenderer>().enabled = false;
F8.GetComponent <SpriteRenderer>().enabled = false;
F9.GetComponent <SpriteRenderer>().enabled = false;
F10.GetComponent <SpriteRenderer>().enabled = false;
F11.GetComponent <SpriteRenderer>().enabled = false;
G1.GetComponent <SpriteRenderer>().enabled = false;
G2.GetComponent <SpriteRenderer>().enabled = false;
G3.GetComponent <SpriteRenderer>().enabled = false;
G4.GetComponent <SpriteRenderer>().enabled = false;
G5.GetComponent <SpriteRenderer>().enabled = false;
G6.GetComponent <SpriteRenderer>().enabled = false;
G7.GetComponent <SpriteRenderer>().enabled = false;
G8.GetComponent <SpriteRenderer>().enabled = false;
G9.GetComponent <SpriteRenderer>().enabled = false;
G10.GetComponent <SpriteRenderer>().enabled = false;
G11.GetComponent <SpriteRenderer>().enabled = false;
H1.GetComponent <SpriteRenderer>().enabled = false;
H2.GetComponent <SpriteRenderer>().enabled = false;
H3.GetComponent <SpriteRenderer>().enabled = false;
H4.GetComponent <SpriteRenderer>().enabled = false;
H5.GetComponent <SpriteRenderer>().enabled = false;
H6.GetComponent <SpriteRenderer>().enabled = false;
H7.GetComponent <SpriteRenderer>().enabled = false;
H8.GetComponent <SpriteRenderer>().enabled = false;
H9.GetComponent <SpriteRenderer>().enabled = false;
H10.GetComponent <SpriteRenderer>().enabled = false;
H11.GetComponent <SpriteRenderer>().enabled = false;
I1.GetComponent <SpriteRenderer>().enabled = false;
I2.GetComponent <SpriteRenderer>().enabled = false;
I3.GetComponent <SpriteRenderer>().enabled = false;
I4.GetComponent <SpriteRenderer>().enabled = false;
I5.GetComponent <SpriteRenderer>().enabled = false;
I6.GetComponent <SpriteRenderer>().enabled = false;
I7.GetComponent <SpriteRenderer>().enabled = false;
I8.GetComponent <SpriteRenderer>().enabled = false;
I9.GetComponent <SpriteRenderer>().enabled = false;
I10.GetComponent <SpriteRenderer>().enabled = false;
I11.GetComponent <SpriteRenderer>().enabled = false;
J1.GetComponent <SpriteRenderer>().enabled = false;
J2.GetComponent <SpriteRenderer>().enabled = false;
J3.GetComponent <SpriteRenderer>().enabled = false;
J4.GetComponent <SpriteRenderer>().enabled = false;
J5.GetComponent <SpriteRenderer>().enabled = false;
J6.GetComponent <SpriteRenderer>().enabled = false;
J7.GetComponent <SpriteRenderer>().enabled = false;
J8.GetComponent <SpriteRenderer>().enabled = false;
J9.GetComponent <SpriteRenderer>().enabled = false;
J10.GetComponent <SpriteRenderer>().enabled = false;
J11.GetComponent <SpriteRenderer>().enabled = false;
K1.GetComponent <SpriteRenderer>().enabled = false;
K2.GetComponent <SpriteRenderer>().enabled = false;
K3.GetComponent <SpriteRenderer>().enabled = false;
K4.GetComponent <SpriteRenderer>().enabled = false;
K5.GetComponent <SpriteRenderer>().enabled = false;
K6.GetComponent <SpriteRenderer>().enabled = false;
K7.GetComponent <SpriteRenderer>().enabled = false;
K8.GetComponent <SpriteRenderer>().enabled = false;
K9.GetComponent <SpriteRenderer>().enabled = false;
K10.GetComponent <SpriteRenderer>().enabled = false;
K11.GetComponent <SpriteRenderer>().enabled = false;
float ratio = Screen.width / Screen.height;
if (ratio < 2)
{
int screenx = 543;
int screeny = 653;
}
else
{
int screenx = 743;
int screeny = 853;
}
}
public IActionResult xlsx(int id, int semester = 1)
{
var marks = new Manager(db)
.GetGroupMarksWithMarkBasedOrder(id)
.OrderBy(x => string.IsNullOrWhiteSpace(x.FirstOrDefault()?.StudentGroup?.Student?.Code))
.ThenBy(x => x.FirstOrDefault()?.StudentGroup?.Student?.Code.ForceParse())
.ThenBy(x => x.FirstOrDefault()?.Subject?.Old_SubOrder.ForceParse());
var g = marks.FirstOrDefault().FirstOrDefault().StudentGroup.Group;
var c = g.ClassYear.Class;
Jalaa a = null;
JalaaOld aa = null;
switch (double.Parse(c.Old_SubOrder))
{
case 1:
case 2:
case 3:
case 4:
a = new J14();
break;
case 5:
case 6:
a = new J56();
break;
case 7:
case 8:
a = new J78();
break;
case 9:
aa = new J9();
break;
case 10:
a = new J10();
break;
case 11.1:
a = new J11_1();
break;
case 11.2:
a = new J11_2();
break;
case 12.1:
aa = new J12_1();
break;
case 12.2:
aa = new J12_2();
break;
}
if (a == null && aa != null)
{
return(File(JalaaOld.Popluate(marks, semester, aa), "application/xlsx", c.Title + "-" + g.Title + ".xlsx"));
}
return(File(Jalaa.Popluate(marks, semester, a), "application/xlsx", c.Title + "-" + g.Title + ".xlsx"));
}