public static void getTextData(String filepath, Constraints constraints) { categories = new Categories(); string[] lines = System.IO.File.ReadAllLines(filepath); string tmtName = ""; foreach (string line in lines) { Char delimiter = ':'; String[] substrings = line.Split(delimiter); if (line.Contains('*') || line.Contains('#') || line.Contains('@') || line.Contains('$') || line.Contains('%')) { Form1.Message = "Invalid Input Format"; break; } else if (substrings.Length > 0) { tmtName = substrings[0]; if (substrings[1].Contains("Adult")) { String[] longString = substrings[2].Split(')'); String[] nameString = longString[2].Split(null); String[] weightString = substrings[2].Split('('); string name = nameString[1] + " " + nameString[2]; string resultString = Regex.Match(weightString[2], @"\d+").Value; double weight = Double.Parse(resultString); Console.WriteLine(weight); if (substrings[1].Contains("MEN")) { if (substrings[2].Contains("White")) { if (weight <= constraints.MenzFin) { categories.MenzFinWhiteBelt.Add(name); } else if (weight >= constraints.MenzFlyLow && weight <= constraints.MenzFlyHigh) { categories.MenzFlyWhiteBelt.Add(name); } else if (weight >= constraints.MenzBantamLow && weight <= constraints.MenzFeatherHigh) { categories.MenzBantamWhiteBelt.Add(name); } else if (weight >= constraints.MenzFeatherLow && weight <= constraints.MenzFeatherHigh) { categories.MenzFeatherWhiteBelt.Add(name); } else if (weight >= constraints.MenzLightLow && weight <= constraints.MenzLightHigh) { categories.MenzLightWhiteBelt.Add(name); } else if (weight >= constraints.MenzWelterLow && weight <= constraints.MenzWelterHigh) { categories.MenzWelterWhiteBelt.Add(name); } else if (weight >= constraints.MenzMiddleLow && weight <= constraints.MenzWelterHigh) { categories.MenzMiddleWhiteBelt.Add(name); } else if (weight >= constraints.MenzHeavy) { categories.MenzHeavyWhiteBelt.Add(name); } else { categories.MenzError.Add(name); } } else if (substrings[2].Contains("Black")) { if (weight <= constraints.MenzFin) { categories.MenzFinBlackBelt.Add(name); } else if (weight >= constraints.MenzFlyLow && weight <= constraints.MenzFlyHigh) { categories.MenzFlyBlackBelt.Add(name); } else if (weight >= constraints.MenzBantamLow && weight <= constraints.MenzFeatherHigh) { categories.MenzBantamBlackBelt.Add(name); } else if (weight >= constraints.MenzFeatherLow && weight <= constraints.MenzFeatherHigh) { categories.MenzFeatherBlackBelt.Add(name); } else if (weight >= constraints.MenzLightLow && weight <= constraints.MenzLightHigh) { categories.MenzLightBlackBelt.Add(name); } else if (weight >= constraints.MenzWelterLow && weight <= constraints.MenzWelterHigh) { categories.MenzWelterBlackBelt.Add(name); } else if (weight >= constraints.MenzMiddleLow && weight <= constraints.MenzWelterHigh) { categories.MenzMiddleBlackBelt.Add(name); } else if (weight >= constraints.MenzHeavy) { categories.MenzHeavyBlackBelt.Add(name); } else { categories.MenzError.Add(name); } } else if (substrings[2].Contains("Blue")) { if (weight <= constraints.MenzFin) { categories.MenzFinBlueBelt.Add(name); } else if (weight >= constraints.MenzFlyLow && weight <= constraints.MenzFlyHigh) { categories.MenzFlyBlueBelt.Add(name); } else if (weight >= constraints.MenzBantamLow && weight <= constraints.MenzFeatherHigh) { categories.MenzBantamBlueBelt.Add(name); } else if (weight >= constraints.MenzFeatherLow && weight <= constraints.MenzFeatherHigh) { categories.MenzFeatherBlueBelt.Add(name); } else if (weight >= constraints.MenzLightLow && weight <= constraints.MenzLightHigh) { categories.MenzLightBlueBelt.Add(name); } else if (weight >= constraints.MenzWelterLow && weight <= constraints.MenzWelterHigh) { categories.MenzWelterBlueBelt.Add(name); } else if (weight >= constraints.MenzMiddleLow && weight <= constraints.MenzWelterHigh) { categories.MenzMiddleBlueBelt.Add(name); } else if (weight >= constraints.MenzHeavy) { categories.MenzHeavyBlueBelt.Add(name); } else { categories.MenzError.Add(name); } } else if (substrings[2].Contains("Purple")) { if (weight <= constraints.MenzFin) { categories.MenzFinPurpleBelt.Add(name); } else if (weight >= constraints.MenzFlyLow && weight <= constraints.MenzFlyHigh) { categories.MenzFlyPurpleBelt.Add(name); } else if (weight >= constraints.MenzBantamLow && weight <= constraints.MenzFeatherHigh) { categories.MenzBantamPurpleBelt.Add(name); } else if (weight >= constraints.MenzFeatherLow && weight <= constraints.MenzFeatherHigh) { categories.MenzFeatherPurpleBelt.Add(name); } else if (weight >= constraints.MenzLightLow && weight <= constraints.MenzLightHigh) { categories.MenzLightPurpleBelt.Add(name); } else if (weight >= constraints.MenzWelterLow && weight <= constraints.MenzWelterHigh) { categories.MenzWelterPurpleBelt.Add(name); } else if (weight >= constraints.MenzMiddleLow && weight <= constraints.MenzWelterHigh) { categories.MenzMiddlePurpleBelt.Add(name); } else if (weight >= constraints.MenzHeavy) { categories.MenzHeavyPurpleBelt.Add(name); } else { categories.MenzError.Add(name); } } else if (substrings[2].Contains("Brown")) { if (weight <= constraints.MenzFin) { categories.MenzFinBrownBelt.Add(name); } else if (weight >= constraints.MenzFlyLow && weight <= constraints.MenzFlyHigh) { categories.MenzFlyBrownBelt.Add(name); } else if (weight >= constraints.MenzBantamLow && weight <= constraints.MenzFeatherHigh) { categories.MenzBantamBrownBelt.Add(name); } else if (weight >= constraints.MenzFeatherLow && weight <= constraints.MenzFeatherHigh) { categories.MenzFeatherBrownBelt.Add(name); } else if (weight >= constraints.MenzLightLow && weight <= constraints.MenzLightHigh) { categories.MenzLightBrownBelt.Add(name); } else if (weight >= constraints.MenzWelterLow && weight <= constraints.MenzWelterHigh) { categories.MenzWelterBrownBelt.Add(name); } else if (weight >= constraints.MenzMiddleLow && weight <= constraints.MenzWelterHigh) { categories.MenzMiddleBrownBelt.Add(name); } else if (weight >= constraints.MenzHeavy) { categories.MenzHeavyBrownBelt.Add(name); } else { categories.MenzError.Add(name); } } else { categories.MenzError.Add(name); } } else if (substrings[1].Contains("FEMALE")) { if (substrings[2].Contains("White")) { if (weight <= constraints.WomenzFin) { categories.WomenzFinWhiteBelt.Add(name); } else if (weight >= constraints.WomenzFlyLow && weight <= constraints.WomenzFlyHigh) { categories.WomenzFlyWhiteBelt.Add(name); } else if (weight >= constraints.WomenzBantamLow && weight <= constraints.WomenzFeatherHigh) { categories.WomenzBantamWhiteBelt.Add(name); } else if (weight >= constraints.WomenzFeatherLow && weight <= constraints.WomenzFeatherHigh) { categories.WomenzFeatherWhiteBelt.Add(name); } else if (weight >= constraints.WomenzLightLow && weight <= constraints.WomenzLightHigh) { categories.WomenzLightWhiteBelt.Add(name); } else if (weight >= constraints.WomenzWelterLow && weight <= constraints.WomenzWelterHigh) { categories.WomenzWelterWhiteBelt.Add(name); } else if (weight >= constraints.WomenzMiddleLow && weight <= constraints.WomenzWelterHigh) { categories.WomenzMiddleWhiteBelt.Add(name); } else if (weight >= constraints.WomenzHeavy) { categories.WomenzHeavyWhiteBelt.Add(name); } else { categories.WomenzError.Add(name); } } else if (substrings[2].Contains("Black")) { if (weight <= constraints.WomenzFin) { categories.WomenzFinBlackBelt.Add(name); } else if (weight >= constraints.WomenzFlyLow && weight <= constraints.WomenzFlyHigh) { categories.WomenzFlyBlackBelt.Add(name); } else if (weight >= constraints.WomenzBantamLow && weight <= constraints.WomenzFeatherHigh) { categories.WomenzBantamBlackBelt.Add(name); } else if (weight >= constraints.WomenzFeatherLow && weight <= constraints.WomenzFeatherHigh) { categories.WomenzFeatherBlackBelt.Add(name); } else if (weight >= constraints.WomenzLightLow && weight <= constraints.WomenzLightHigh) { categories.WomenzLightBlackBelt.Add(name); } else if (weight >= constraints.WomenzWelterLow && weight <= constraints.WomenzWelterHigh) { categories.WomenzWelterBlackBelt.Add(name); } else if (weight >= constraints.WomenzMiddleLow && weight <= constraints.WomenzWelterHigh) { categories.WomenzMiddleBlackBelt.Add(name); } else if (weight >= constraints.WomenzHeavy) { categories.WomenzHeavyBlackBelt.Add(name); } else { categories.WomenzError.Add(name); } } else if (substrings[2].Contains("Blue")) { if (weight <= constraints.MenzFin) { categories.WomenzFinBlueBelt.Add(name); } else if (weight >= constraints.WomenzFlyLow && weight <= constraints.WomenzFlyHigh) { categories.WomenzFlyBlueBelt.Add(name); } else if (weight >= constraints.WomenzBantamLow && weight <= constraints.WomenzFeatherHigh) { categories.WomenzBantamBlueBelt.Add(name); } else if (weight >= constraints.WomenzFeatherLow && weight <= constraints.WomenzFeatherHigh) { categories.WomenzFeatherBlueBelt.Add(name); } else if (weight >= constraints.WomenzLightLow && weight <= constraints.WomenzLightHigh) { categories.WomenzLightBlueBelt.Add(name); } else if (weight >= constraints.WomenzWelterLow && weight <= constraints.WomenzWelterHigh) { categories.WomenzWelterBlueBelt.Add(name); } else if (weight >= constraints.WomenzMiddleLow && weight <= constraints.WomenzWelterHigh) { categories.WomenzMiddleBlueBelt.Add(name); } else if (weight >= constraints.WomenzHeavy) { categories.WomenzHeavyBlueBelt.Add(name); } else { categories.WomenzError.Add(name); } } else if (substrings[2].Contains("Purple")) { if (weight <= constraints.WomenzFin) { categories.WomenzFinPurpleBelt.Add(name); } else if (weight >= constraints.WomenzFlyLow && weight <= constraints.WomenzFlyHigh) { categories.WomenzFlyPurpleBelt.Add(name); } else if (weight >= constraints.WomenzBantamLow && weight <= constraints.WomenzFeatherHigh) { categories.WomenzBantamPurpleBelt.Add(name); } else if (weight >= constraints.WomenzFeatherLow && weight <= constraints.WomenzFeatherHigh) { categories.WomenzFeatherPurpleBelt.Add(name); } else if (weight >= constraints.WomenzLightLow && weight <= constraints.WomenzLightHigh) { categories.WomenzLightPurpleBelt.Add(name); } else if (weight >= constraints.WomenzWelterLow && weight <= constraints.WomenzWelterHigh) { categories.WomenzWelterPurpleBelt.Add(name); } else if (weight >= constraints.WomenzMiddleLow && weight <= constraints.WomenzWelterHigh) { categories.WomenzMiddlePurpleBelt.Add(name); } else if (weight >= constraints.MenzHeavy) { categories.WomenzHeavyPurpleBelt.Add(name); } else { categories.WomenzError.Add(name); } } else if (substrings[2].Contains("Brown")) { if (weight <= constraints.WomenzFin) { categories.WomenzFinBrownBelt.Add(name); } else if (weight >= constraints.WomenzFlyLow && weight <= constraints.WomenzFlyHigh) { categories.WomenzFlyBrownBelt.Add(name); } else if (weight >= constraints.WomenzBantamLow && weight <= constraints.WomenzFeatherHigh) { categories.WomenzBantamBrownBelt.Add(name); } else if (weight >= constraints.WomenzFeatherLow && weight <= constraints.WomenzFeatherHigh) { categories.WomenzFeatherBrownBelt.Add(name); } else if (weight >= constraints.WomenzLightLow && weight <= constraints.WomenzLightHigh) { categories.WomenzLightBrownBelt.Add(name); } else if (weight >= constraints.WomenzWelterLow && weight <= constraints.WomenzWelterHigh) { categories.WomenzWelterBrownBelt.Add(name); } else if (weight >= constraints.WomenzMiddleLow && weight <= constraints.WomenzWelterHigh) { categories.WomenzMiddleBrownBelt.Add(name); } else if (weight >= constraints.MenzHeavy) { categories.WomenzHeavyBrownBelt.Add(name); } else { categories.WomenzError.Add(name); } } else { categories.WomenzError.Add(name); } } } else if (substrings[1].Contains("Kids")) { String[] longString = substrings[1].Split(')'); String[] nameString = longString[1].Split(null); string name = nameString[2] + " " + nameString[3]; if (substrings[1].Contains("Novice")) { categories.KidsNovice.Add(name); } else if (substrings[1].Contains("Beginner")) { categories.KidsBeginner.Add(name); } else if (substrings[1].Contains("Intermediate")) { categories.KidsIntermediate.Add(name); } else if (substrings[1].Contains("Advanced")) { categories.KidsAdvanced.Add(name); } else { categories.KidzError.Add(name); } } } } Generate.generate(categories, tmtName); }
public static void getExcelFile(String filepath, Constraints constraints) { Excel.Application xlApp = new Excel.Application(); Excel.Workbook xlWorkbook = xlApp.Workbooks.Open(filepath); Excel._Worksheet xlWorksheet = xlWorkbook.Sheets[1]; Excel.Range xlRange = xlWorksheet.UsedRange; int rowCount = xlRange.Rows.Count + 1; int colCount = xlRange.Columns.Count; for (int i = 2; i <= rowCount; i++) { if (xlRange.Cells[i, 6] != null && xlRange.Cells[i, 6].Value2 != null) { if (Convert.ToInt16(xlRange.Cells[i, 5].Value2) <= Convert.ToInt16(constraints.KidsMaxAge)) { Console.WriteLine("Kids Found !"); if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "NOVICE") { categories.KidsNovice.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BEGINNER") { categories.KidsBeginner.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "INTERMEDIATE") { categories.KidsIntermediate.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "ADVANCED") { categories.KidsAdvanced.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else { categories.KidzError.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } } else if (xlRange.Cells[i, 6].Value2.ToString() == "male") { if (Convert.ToDouble(xlRange.Cells[i, 4].Value2) <= Convert.ToDouble(constraints.MenzFin)) { if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BLACK BELT") { categories.MenzFinBlackBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "WHITE BELT") { categories.MenzFinWhiteBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "PURPLE BELT") { categories.MenzFinPurpleBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BLUE BELT") { categories.MenzFinBlueBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BROWN BELT") { categories.MenzFinBrownBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else { categories.MenzError.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } } else if (Convert.ToDouble(xlRange.Cells[i, 4].Value2) >= Convert.ToDouble(constraints.MenzFlyLow) && Convert.ToDouble(xlRange.Cells[i, 4].Value2) <= Convert.ToDouble(constraints.MenzFlyHigh)) { if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BLACK BELT") { categories.MenzFlyBlackBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "WHITE BELT") { categories.MenzFlyWhiteBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "PURPLE BELT") { categories.MenzFlyPurpleBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BLUE BELT") { categories.MenzFlyBlueBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BROWN BELT") { categories.MenzFlyBrownBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else { categories.MenzError.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } } else if (Convert.ToDouble(xlRange.Cells[i, 4].Value2) >= Convert.ToDouble(constraints.MenzBantamLow) && Convert.ToDouble(xlRange.Cells[i, 4].Value2) <= Convert.ToDouble(constraints.MenzBantamHigh)) { if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BLACK BELT") { categories.MenzBantamBlackBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "WHITE BELT") { categories.MenzBantamWhiteBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "PURPLE BELT") { categories.MenzBantamPurpleBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BLUE BELT") { categories.MenzBantamBlueBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BROWN BELT") { categories.MenzBantamBrownBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else { categories.MenzError.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } } else if (Convert.ToDouble(xlRange.Cells[i, 4].Value2) >= Convert.ToDouble(constraints.MenzFeatherLow) && Convert.ToDouble(xlRange.Cells[i, 4].Value2) <= Convert.ToDouble(constraints.MenzFeatherHigh)) { if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BLACK BELT") { categories.MenzFeatherBlackBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "WHITE BELT") { categories.MenzFeatherWhiteBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "PURPLE BELT") { categories.MenzFeatherPurpleBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BLUE BELT") { categories.MenzFeatherBlueBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BROWN BELT") { categories.MenzFeatherBrownBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else { categories.MenzError.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } } else if (Convert.ToDouble(xlRange.Cells[i, 4].Value2) >= Convert.ToDouble(constraints.MenzLightLow) && Convert.ToDouble(xlRange.Cells[i, 4].Value2) <= Convert.ToDouble(constraints.MenzLightHigh)) { if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BLACK BELT") { categories.MenzLightBlackBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "WHITE BELT") { categories.MenzLightWhiteBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "PURPLE BELT") { categories.MenzLightPurpleBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BLUE BELT") { categories.MenzLightBlueBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BROWN BELT") { categories.MenzLightBrownBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else { categories.MenzError.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } } else if (Convert.ToDouble(xlRange.Cells[i, 4].Value2) >= Convert.ToDouble(constraints.MenzWelterLow) && Convert.ToDouble(xlRange.Cells[i, 4].Value2) <= Convert.ToDouble(constraints.MenzWelterHigh)) { if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BLACK BELT") { categories.MenzWelterBlackBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "WHITE BELT") { categories.MenzWelterWhiteBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "PURPLE BELT") { categories.MenzWelterPurpleBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BLUE BELT") { categories.MenzWelterBlueBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BROWN BELT") { categories.MenzWelterBrownBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else { categories.MenzError.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } } else if (Convert.ToDouble(xlRange.Cells[i, 4].Value2) >= Convert.ToDouble(constraints.MenzMiddleLow) && Convert.ToDouble(xlRange.Cells[i, 4].Value2) <= Convert.ToDouble(constraints.MenzMiddleHigh)) { if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BLACK BELT") { categories.MenzMiddleBlackBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "WHITE BELT") { categories.MenzMiddleWhiteBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "PURPLE BELT") { categories.MenzMiddlePurpleBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BLUE BELT") { categories.MenzMiddleBlueBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BROWN BELT") { categories.MenzMiddleBrownBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else { categories.MenzError.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } } else if (Convert.ToDouble(xlRange.Cells[i, 4].Value2) >= Convert.ToDouble(constraints.MenzHeavy)) { if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BLACK BELT") { categories.MenzHeavyBlackBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "WHITE BELT") { categories.MenzHeavyWhiteBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "PURPLE BELT") { categories.MenzHeavyPurpleBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BLUE BELT") { categories.MenzHeavyBlueBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BROWN BELT") { categories.MenzHeavyBrownBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else { categories.MenzError.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } } } else if (xlRange.Cells[i, 6].Value2.ToString() == "female") { if (Convert.ToDouble(xlRange.Cells[i, 4].Value2) <= Convert.ToDouble(constraints.WomenzFin)) { if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BLACK BELT") { categories.WomenzFinBlackBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "WHITE BELT") { categories.WomenzFinWhiteBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "PURPLE BELT") { categories.WomenzFinPurpleBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BLUE BELT") { categories.WomenzFinBlueBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BROWN BELT") { categories.WomenzFinBrownBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else { categories.WomenzError.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } } else if (Convert.ToDouble(xlRange.Cells[i, 4].Value2) >= Convert.ToDouble(constraints.WomenzFlyLow) && Convert.ToDouble(xlRange.Cells[i, 4].Value2) <= Convert.ToDouble(constraints.WomenzFlyHigh)) { if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BLACK BELT") { categories.WomenzFlyBlackBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "WHITE BELT") { categories.WomenzFlyWhiteBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "PURPLE BELT") { categories.WomenzFlyPurpleBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BLUE BELT") { categories.WomenzFlyBlueBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BROWN BELT") { categories.WomenzFlyBrownBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else { categories.WomenzError.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } } else if (Convert.ToDouble(xlRange.Cells[i, 4].Value2) >= Convert.ToDouble(constraints.WomenzBantamLow) && Convert.ToDouble(xlRange.Cells[i, 4].Value2) <= Convert.ToDouble(constraints.WomenzBantamHigh)) { if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BLACK BELT") { categories.WomenzBantamBlackBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "WHITE BELT") { categories.WomenzBantamWhiteBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "PURPLE BELT") { categories.WomenzBantamPurpleBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BLUE BELT") { categories.WomenzBantamBlueBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BROWN BELT") { categories.WomenzBantamBrownBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else { categories.WomenzError.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } } else if (Convert.ToDouble(xlRange.Cells[i, 4].Value2) >= Convert.ToDouble(constraints.WomenzFeatherLow) && Convert.ToDouble(xlRange.Cells[i, 4].Value2) <= Convert.ToDouble(constraints.WomenzFeatherHigh)) { if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BLACK BELT") { categories.WomenzFeatherBlackBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "WHITE BELT") { categories.WomenzFeatherWhiteBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "PURPLE BELT") { categories.WomenzFeatherPurpleBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BLUE BELT") { categories.WomenzFeatherBlueBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BROWN BELT") { categories.WomenzFeatherBrownBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else { categories.WomenzError.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } } else if (Convert.ToDouble(xlRange.Cells[i, 4].Value2) >= Convert.ToDouble(constraints.WomenzLightLow) && Convert.ToDouble(xlRange.Cells[i, 4].Value2) <= Convert.ToDouble(constraints.WomenzLightHigh)) { if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BLACK BELT") { categories.WomenzLightBlackBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "WHITE BELT") { categories.WomenzLightWhiteBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "PURPLE BELT") { categories.WomenzLightPurpleBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BLUE BELT") { categories.WomenzLightBlueBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BROWN BELT") { categories.WomenzLightBrownBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } } else if (Convert.ToDouble(xlRange.Cells[i, 4].Value2) >= Convert.ToDouble(constraints.WomenzWelterLow) && Convert.ToDouble(xlRange.Cells[i, 4].Value2) <= Convert.ToDouble(constraints.WomenzWelterHigh)) { if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BLACK BELT") { categories.WomenzWelterBlackBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "WHITE BELT") { categories.WomenzWelterWhiteBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "PURPLE BELT") { categories.WomenzWelterPurpleBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BLUE BELT") { categories.WomenzWelterBlueBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BROWN BELT") { categories.WomenzWelterBrownBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else { categories.WomenzError.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } } else if (Convert.ToDouble(xlRange.Cells[i, 4].Value2) >= Convert.ToDouble(constraints.WomenzMiddleLow) && Convert.ToDouble(xlRange.Cells[i, 4].Value2) <= Convert.ToDouble(constraints.WomenzMiddleHigh)) { if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BLACK BELT") { categories.WomenzMiddleBlackBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "WHITE BELT") { categories.WomenzMiddleWhiteBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "PURPLE BELT") { categories.WomenzMiddlePurpleBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BLUE BELT") { categories.WomenzMiddleBlueBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BROWN BELT") { categories.WomenzMiddleBrownBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else { categories.WomenzError.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } } else if (Convert.ToDouble(xlRange.Cells[i, 4].Value2) >= Convert.ToDouble(constraints.WomenzHeavy)) { if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BLACK BELT") { categories.WomenzHeavyBlackBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "WHITE BELT") { categories.WomenzHeavyWhiteBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "PURPLE BELT") { categories.WomenzHeavyPurpleBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BLUE BELT") { categories.WomenzHeavyBlueBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else if (xlRange.Cells[i, 3].Value2.ToString().ToUpper() == "BROWN BELT") { categories.WomenzHeavyBrownBelt.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } else { categories.WomenzError.Add(Convert.ToInt16(xlRange.Cells[i, 1].Value2)); } } } } } //categories.MenzHeavyBrownBelt.ForEach(Console.WriteLine); GC.Collect(); GC.WaitForPendingFinalizers(); Marshal.ReleaseComObject(xlRange); Marshal.ReleaseComObject(xlWorksheet); xlWorkbook.Close(); Marshal.ReleaseComObject(xlWorkbook); xlApp.Quit(); Marshal.ReleaseComObject(xlApp); }