private SoldierBundle SetCurrentSoldiers(string strFile, SoldierBundle currentBundle, StringBuilder statBlocks, string nextLine)
{
statBlocks.Clear();
statBlocks.Append(" soldiers:" + nextLine);
var excel = new ExcelQueryFactory(strFile);
var line = from c in excel.Worksheet("Soldiers")
//where c[3].Value listBox1.SelectedItems
//where c[2].Value.ToString() != "Team3" && c[2].Value.ToString() != "Team4"
select c;
foreach (var item in line)
{
if (!string.IsNullOrWhiteSpace(item[0] + " " + item[1]))
{
_soldierGen.statusStrip1.Text = currentBundle.soldierCount.ToString();
currentBundle.soldierCount++;
statBlocks.Append(" - type: STR_SOLDIER" + nextLine);
statBlocks.Append(" id: " + currentBundle.soldierCount.ToString() + nextLine);
statBlocks.Append(" name: " + item[0] + " " + item[1] + nextLine);
statBlocks.Append(" nationality: 0" + nextLine); // + item[0] + " " + item[1] + nextLine);
statBlocks.Append(" initialStats:" + nextLine);
statBlocks.Append(" tu: " + Convert.ToInt32(item[3].Value) + nextLine);
statBlocks.Append(" stamina: " + Convert.ToInt32(item[4].Value) + nextLine);
statBlocks.Append(" health: " + Convert.ToInt32(item[5].Value) + nextLine);
statBlocks.Append(" bravery: " + Convert.ToInt32(item[6].Value) + nextLine);
statBlocks.Append(" reactions: " + Convert.ToInt32(item[7].Value) + nextLine);
statBlocks.Append(" firing: " + Convert.ToInt32(item[8].Value) + nextLine);
statBlocks.Append(" throwing: " + Convert.ToInt32(item[9].Value) + nextLine);
statBlocks.Append(" strength: " + Convert.ToInt32(item[10].Value) + nextLine);
statBlocks.Append(" psiStrength: " + Convert.ToInt32(item[11].Value) + nextLine);
statBlocks.Append(" psiSkill: " + Convert.ToInt32(item[12].Value) + nextLine);
statBlocks.Append(" melee: " + Convert.ToInt32(item[13].Value) + nextLine);
statBlocks.Append(" currentStats:" + nextLine);
statBlocks.Append(" tu: " + Convert.ToInt32(item[3].Value) + nextLine);
statBlocks.Append(" stamina: " + Convert.ToInt32(item[4].Value) + nextLine);
statBlocks.Append(" health: " + Convert.ToInt32(item[5].Value) + nextLine);
statBlocks.Append(" bravery: " + Convert.ToInt32(item[6].Value) + nextLine);
statBlocks.Append(" reactions: " + Convert.ToInt32(item[7].Value) + nextLine);
statBlocks.Append(" firing: " + Convert.ToInt32(item[8].Value) + nextLine);
statBlocks.Append(" throwing: " + Convert.ToInt32(item[9].Value) + nextLine);
statBlocks.Append(" strength: " + Convert.ToInt32(item[10].Value) + nextLine);
statBlocks.Append(" psiStrength: " + Convert.ToInt32(item[11].Value) + nextLine);
statBlocks.Append(" psiSkill: " + Convert.ToInt32(item[12].Value) + nextLine);
statBlocks.Append(" melee: " + Convert.ToInt32(item[13].Value) + nextLine);
statBlocks.Append(" rank: 0" + nextLine);
statBlocks.Append(" gender: " + item[14] + nextLine);
statBlocks.Append(" look: " + item[15] + nextLine);
//statBlocks.Append(" lookVariant: 0" + nextLine); //What is this??
statBlocks.Append(" missions: 0" + nextLine);
statBlocks.Append(" kills: 0" + nextLine);
statBlocks.Append(" armor: STR_NONE_UC" + nextLine);
//statBlocks.Append(" armor: " + GetArmorName(Convert.ToInt32(item[16].Value)) + nextLine);
statBlocks.Append(" improvement: 0" + nextLine);
statBlocks.Append(" psiStrImprovement: 0" + nextLine);
statBlocks.Append(" tags: ~" + nextLine);
}
}
currentBundle.soldierText = statBlocks.ToString();
return(currentBundle);
}
public SoldierBundle LoadXLS(string strFile, SoldierBundle currentBundle, bool transit, string arrivalTime)
{
if (string.IsNullOrEmpty(arrivalTime))
{
arrivalTime = "12";
}
StringBuilder statBlocks = new StringBuilder();
currentBundle.soldierCount = 0;
string nextLine = "\r\n";
if (transit)
{
currentBundle = SetArrivalSoldiers(strFile, currentBundle, statBlocks, nextLine, arrivalTime);
}
else
{
currentBundle = SetCurrentSoldiers(strFile, currentBundle, statBlocks, nextLine);
}
return(currentBundle);
}
