public RegularMeeting GetRegularMeetingInfo()
{
var meeting = new RegularMeeting();
using (var excelObject = new ExcelObject(agenda))
{
if (Regex.IsMatch(agenda, "old"))
{
meeting.Date = excelObject.At(3, 2).Unify(checklist);
meeting.Room = excelObject.At(4, 2).Unify(checklist);
meeting.Theme = excelObject.At(5, 2).Unify(checklist);
meeting.Toastmaster = excelObject.At(6, 2).Unify(checklist);
meeting.SAA = excelObject.At(7, 2).Unify(checklist);
meeting.General_Evaluator = excelObject.At(8, 2).Unify(checklist);
meeting.Timer = excelObject.At(9, 2).Unify(checklist);
meeting.Grammarian = excelObject.At(10, 2).Unify(checklist);
meeting.Ah_Counter = excelObject.At(11, 2).Unify(checklist);
meeting.Table_Topic_Master = excelObject.At(12, 2).Unify(checklist);
meeting.Table_Topic_Evaluator = excelObject.At(13, 2).Unify(checklist);
meeting.Prepared_Speaker_1 = excelObject.At(14, 2).Unify(checklist);
meeting.Prepared_Speaker_2 = excelObject.At(18, 2).Unify(checklist);
meeting.Speech_Evaluator_1 = excelObject.At(17, 2).Unify(checklist);
meeting.Speech_Evaluator_2 = excelObject.At(21, 2).Unify(checklist);
meeting.Quiz_Master = excelObject.At(23, 2).Unify(checklist);
meeting.Photographer = excelObject.At(24, 2).Unify(checklist);
meeting.Video_Taker = excelObject.At(25, 2).Unify(checklist);
meeting.Meeting_Minutes_Taker = excelObject.At(26, 2).Unify(checklist);
meeting.Times = excelObject.At(28, 2).Unify(checklist);
}
else
{
meeting.Date = excelObject.At(3, 2).Unify(checklist);
meeting.Room = excelObject.At(4, 2).Unify(checklist);
meeting.Theme = excelObject.At(5, 2).Unify(checklist);
meeting.Toastmaster = excelObject.At(7, 2).Unify(checklist);
meeting.SAA = excelObject.At(8, 2).Unify(checklist);
meeting.General_Evaluator = excelObject.At(9, 2).Unify(checklist);
meeting.Timer = excelObject.At(10, 2).Unify(checklist);
meeting.Grammarian = excelObject.At(11, 2).Unify(checklist);
meeting.Ah_Counter = excelObject.At(12, 2).Unify(checklist);
meeting.Table_Topic_Master = excelObject.At(13, 2).Unify(checklist);
meeting.Table_Topic_Evaluator = excelObject.At(14, 2).Unify(checklist);
meeting.Prepared_Speaker_1 = excelObject.At(15, 2).Unify(checklist);
meeting.Prepared_Speaker_2 = excelObject.At(16, 2).Unify(checklist);
meeting.Speech_Evaluator_1 = excelObject.At(17, 2).Unify(checklist);
meeting.Speech_Evaluator_2 = excelObject.At(18, 2).Unify(checklist);
meeting.Quiz_Master = excelObject.At(20, 2).Unify(checklist);
meeting.Photographer = excelObject.At(21, 2).Unify(checklist);
meeting.Video_Taker = excelObject.At(22, 2).Unify(checklist);
meeting.Meeting_Minutes_Taker = excelObject.At(23, 2).Unify(checklist);
meeting.Times = excelObject.At(32, 2).Unify(checklist);
}
}
return(meeting);
}
public static string TrialOnly_DoSomething(this object o)
{
var rm = new RegularMeeting {
Times = "T200", Date = "Jan 8th, 2015"
};
var t = typeof(RegularMeeting);
var properties = t.GetProperties();
var property = properties[0];
var name = property.Name;
var value = property.GetValue(rm);
return("");
}
public static IEnumerable <RoleTakingRecord> ToRoleTakingRecords(this RegularMeeting meeting)
{
if (meeting == null)
{
return(null);
}
var times = meeting.Times;
var date = meeting.Date;
var properties = typeof(RegularMeeting).GetProperties();
var result = from property in properties
where property.IsRoleProperty()
select new RoleTakingRecord
{
Role_Name = property.Name.ReplaceUnderscoreWithSpace(),
Role_Taker_Name = property.GetValue(meeting).ToString(),
Times = times,
Date = date
};
return(result);
}
