public static void WritePeople()
{
var workbook = new XLWorkbook();
var worksheet = workbook.Worksheets.Add("Хора");
for (int i = 0; i < Opinion.allOpinions.Count; i++)
{
Opinion o = Opinion.allOpinions[i];
int rowIdx = i + 2;
worksheet.Cell(f("A", rowIdx)).Value = o.age;
worksheet.Cell(f("B", rowIdx)).Value = o.freq.freq;
worksheet.Cell(f("C", rowIdx)).Value = lookup[(int)o.freq.type];
}
workbook.SaveAs("ало-ало.xlsx");
}
public static void WriteOpinion(Opinion op, StreamWriter writer)
{
WritePerson(op, writer);
op.opinions.ForEach(b => WriteBeachOpinion(b, writer));
}
/* Формат:
* [възраст] [честота] [честота - код: 0 - седмица, 1 - месец, 2 - година]
*/
private static void WritePerson(Opinion po, StreamWriter writer)
{
String data = String.Format("{0} {1} {2}\n", po.age, po.freq.freq, po.freq.type);
writer.Write(data);
}
private static void ReadPerson(String line)
{
String[] data = line.Split(' ');
Opinion o = new Opinion();
o.age = int.Parse(data[0]);
o.freq = new Frequency();
o.freq.freq = int.Parse(data[1]);
if (data[2][0] == 'W') o.freq.type = FType.Weekly;
else if (data[2][0] == 'M') o.freq.type = FType.Monthly;
else if (data[2][0] == 'Y') o.freq.type = FType.Yearly;
Opinion.allOpinions.Add(o);
}
/* Формат:
* [възраст] [честота] [честота - код: 0 - седмица, 1 - месец, 2 - година]
*/
private static void WritePerson(Opinion po, StreamWriter writer)
{
String data = String.Format("{0} {1} {2}\n", po.age, po.freq.freq, po.freq.type);
writer.Write(data);
}
public static void WriteOpinion(Opinion op, StreamWriter writer)
{
WritePerson(op, writer);
op.opinions.ForEach(b => WriteBeachOpinion(b, writer));
}
private void ReadPerson()
{
try
{
activeOp.age = int.Parse(tbAge.Text);
activeOp.freq = new Frequency();
activeOp.freq.freq = int.Parse(tbFreq.Text);
if (rbWeekly.Checked) activeOp.freq.type = FType.Weekly;
else if (rbMonthly.Checked) activeOp.freq.type = FType.Monthly;
else if (rbYearly.Checked) activeOp.freq.type = FType.Yearly;
Opinion.allOpinions.Add(activeOp);
activeOp = new Opinion();
ClearPerson();
}
catch (Exception e)
{
MessageBox.Show(e.Message, e.GetType().ToString());
}
}
