public ArranModel read(long id)
{
openConnection();
ArranModel arrangement = new ArranModel();
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = connection;
cmd.CommandText = string.Format("select arrangementId, arrangementBeskrivelse, createTs, arrangementWeb, arrangementDt, arrangemnetTid, spiseSted, spiseTid from Arrangement where arrangementId={0}", id);
MySqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
arrangement.arrangementId = reader.GetInt64("arrangementId");
arrangement.arrangementBeskrivelse = reader.GetString("arrangementBeskrivelse");
arrangement.createTs = reader.GetDateTime("createTs");
arrangement.arrangementWeb = reader.GetString("arrangementWeb");
arrangement.arrangementDt = reader.GetDateTime("arrangementDt");
arrangement.arrangemnetTid = DateTime.Parse(reader.GetString("arrangemnetTid"));
arrangement.spiseSted = reader.GetString("spiseSted");
arrangement.spiseTid = DateTime.Parse(reader.GetString("spiseTid"));
}
closeConnection();
return(arrangement);
}
public List <ArranModel> readList()
{
List <ArranModel> arrangementer = new List <ArranModel>();
openConnection();
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = connection;
cmd.CommandText = string.Format("select arrangementId, arrangementBeskrivelse, createTs, arrangementWeb, arrangementDt, arrangemnetTid, spiseSted, spiseTid from Arrangement");
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
ArranModel arrangement = new ArranModel();
arrangement.arrangementId = reader.GetInt64("arrangementId");
arrangement.arrangementBeskrivelse = reader.GetString("arrangementBeskrivelse");
arrangement.createTs = reader.GetDateTime("createTs");
arrangement.arrangementWeb = reader.GetString("arrangementWeb");
arrangement.arrangementDt = reader.GetDateTime("arrangementDt");
arrangement.arrangemnetTid = DateTime.Parse(reader.GetString("arrangemnetTid"));
arrangement.spiseSted = reader.GetString("spiseSted");
arrangement.spiseTid = DateTime.Parse(reader.GetString("spiseTid"));
arrangementer.Add(arrangement);
}
closeConnection();
return(arrangementer);
}
public void update(ArranModel arrangement)
{
openConnection();
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = connection;
cmd.CommandText = string.Format(
"update Arrangement set arrangementBeskrivelse='{0}', arrangementWeb='{1}', arrangementDt='{2}', arrangemnetTid='{3}', spiseSted='{4}', spiseTid='{5}' where arrangementId={6} ",
arrangementBeskrivelse, arrangementWeb, arrangementDt.ToString("yyyy-MM-dd"), arrangemnetTid.ToString("HH:mm:ss"), spiseSted, spiseTid.ToString("HH:mm:ss"), arrangementId);
int cnt = cmd.ExecuteNonQuery();
closeConnection();
}
public void create(ArranModel arrangement)
{
openConnection();
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = connection;
cmd.CommandText = string.Format(
"insert into Arrangement(arrangementBeskrivelse, createTs, arrangementWeb, arrangementDt, arrangemnetTid, spiseSted, spiseTid) " +
"values('{0}', current_timestamp,'{1}','{2}','{3}','{4}','{5}');",
arrangementBeskrivelse, arrangementWeb, arrangementDt.ToString("yyyy-MM-dd"), arrangemnetTid.ToString("HH:mm:ss"), spiseSted, spiseTid.ToString("HH:mm:ss"));
int cnt = cmd.ExecuteNonQuery();
closeConnection();
}