public void Insert(Achievement achievement)
{
String sql;
sql = "";
sql = "INSERT INTO 実績(日付,人ID,実績分,会ID) VALUES(#" + achievement.Date + "#," + achievement.PersonId + "," + achievement.Time + "," + achievement.MeetingId + ");";
IDbCommand command = this.conn.CreateCommand();
command.CommandText = sql;
command.ExecuteNonQuery();
}
static void Main(string[] args)
{
/* TODO:以下を実装
* 実績登録
* 実績出力
* 実績削除
* 人出力
* 人登録
* 人削除
* 会登録
* 会表示
* 会削除
* */
IDbConnection conn = GetConnection();
conn.Open();
MeetingRepository meetingRepository = new MeetingRepository(conn);
MeetingInputSequence meetingInputSequence = new MeetingInputSequence(meetingRepository);
meetingInputSequence.Start();
conn.Close();
conn.Open();
meetingRepository = new MeetingRepository(conn);
OutputMeetingListSequence outputMeetingListSequence = new OutputMeetingListSequence(meetingRepository);
outputMeetingListSequence.Start();
conn.Close();
Console.Write("会ID：");
string meetingID = Console.ReadLine();
Console.WriteLine("");
conn.Open();
PeopleRepository peopleRepository = new PeopleRepository(conn);
IEnumerable<Person> people = peopleRepository.GetAll();
foreach (Person p in people)
{
Console.WriteLine(p.PersonId + "-" + p.Name + "-" + p.Kana);
}
conn.Close();
Console.Write("参加者(カンマ区切り)：");
string InParticipant = Console.ReadLine();
Console.WriteLine("");
Console.Write("実績時間(分)：");
string time = Console.ReadLine();
Console.WriteLine("");
Participant participant = new Participant(InParticipant);
List<int> particiantList = participant.CreateParticiantList();
Achievement achivement = null;
foreach (int l in particiantList)
{
achivement = new Achievement();
achivement.PersonId = l;
//achivement.Date = DateTime.Parse(date);
if (meetingID == "")
{
achivement.MeetingId = 0;
}
else
{
achivement.MeetingId = int.Parse(meetingID);
}
achivement.Time = int.Parse(time);
conn.Open();
AchievementRepository achivementRepository = new AchievementRepository(conn);
achivementRepository.Insert(achivement);
conn.Close();
}
}