private Meeting MapMeeting(MeetingInput meetingInnput)
{
Meeting meeting = new Meeting();
meeting.Date = (DateTime.Parse(meetingInnput.Date));
meeting.Description = (meetingInnput.Description);
meeting.DayDuty = (int.Parse(meetingInnput.DayDuty));
return meeting;
}
public List<Meeting> GetAll()
{
string sql;
sql = "";
sql = "SELECT * FROM 会 ;";
IDbCommand command = this.conn.CreateCommand();
command.CommandText = sql;
IDataReader reader = command.ExecuteReader();
List<Meeting> meeting = new List<Meeting>();
while (reader.Read())
{
Meeting m = new Meeting();
m.MeetingId = (reader.GetInt32(0));
m.Date = (reader.GetDateTime(1));
if (reader["内容"] == DBNull.Value)
{
m.Description = "";
}
else
{
m.Description = (reader.GetString(2));
}
if (reader["司会者"] == DBNull.Value)
{
m.DayDuty = 0;
}
else
{
m.DayDuty = (reader.GetInt32(3));
}
meeting.Add(m);
}
return meeting;
}
public Meeting Get(int id)
{
string sql;
sql = "";
sql = "SELECT 日付,内容,日直 FROM 会 WHERE 会ID = " + id + ";";
IDbCommand command = this.conn.CreateCommand();
command.CommandText = sql;
IDataReader reader = command.ExecuteReader();
Meeting meeting = null;
if (reader.Read())
{
meeting = new Meeting();
meeting.Date = (reader.GetDateTime(0));
meeting.Description = (reader.GetString(1));
meeting.DayDuty = (reader.GetInt32(2));
}
return meeting;
}
public RegisterMeetingCommand(Meeting meeting, MeetingRepository meetingRepository)
{
this.meeting = meeting;
this.meetingRepository = meetingRepository;
}
public int GetNotID(Meeting m)
{
string sql;
int meetingID;
meetingID = 0;
sql = "";
sql = "SELECT 会ID FROM 会 WHERE 内容 = '" + m.Description + "' AND 司会者 = " + m.DayDuty + " AND 日付 = #" + m.Date + "#;";
IDbCommand command = this.conn.CreateCommand();
command.CommandText = sql;
IDataReader reader = command.ExecuteReader();
if (reader.Read())
{
meetingID = (reader.GetInt32(0));
}
return meetingID;
}
public void Insert(Meeting meeting)
{
String sql;
sql = "";
sql = "INSERT INTO 会(日付,内容,司会者) VALUES(#" + meeting.Date + "#,'" + meeting.Description + "'," + meeting.DayDuty + ");";
IDbCommand command = this.conn.CreateCommand();
command.CommandText = sql;
command.ExecuteNonQuery();
}
