public int createSession(DateTime StartTime, DateTime EndTime) { String sql1 = "Insert into Session (StartTime, EndTime, Status) values (@StartTime, @EndTime, @Status) "; using (MySqlConnection conn = new DBConnection.DBConnection().conn) { MySqlCommand command1 = new MySqlCommand(sql1, conn); command1.Parameters.AddWithValue("@StartTime", StartTime.ToString("hh:mm:ss")); command1.Parameters.AddWithValue("@EndTime", EndTime.ToString("hh:mm:ss")); command1.Parameters.AddWithValue("@Status", true); conn.Open(); int result = command1.ExecuteNonQuery(); conn.Close(); if (result > 0) { string sql2 = "select max(id_Ses) as id_Ses from Session"; MySqlCommand command2 = new MySqlCommand(sql2, conn); conn.Open(); MySqlDataReader dr = command2.ExecuteReader(); conn.Close(); if (dr.Read()) { return(Convert.ToInt32(dr["id_Ses"])); } } return(result); } }
public Session getSessionByTime(DateTime StartTime, DateTime EndTime) { string sql = "select * from Session where StartTime = @Starttime and EndTime = @EndTime"; using (MySqlConnection conn = new DBConnection.DBConnection().conn) { MySqlCommand command = new MySqlCommand(sql, conn); command.Parameters.AddWithValue("@StartTime", StartTime.ToString()); command.Parameters.AddWithValue("@EndTime", EndTime.ToString()); conn.Open(); MySqlDataReader dr = command.ExecuteReader(); Session session = null; if (dr.Read()) { session = new Session { id_Ses = Convert.ToInt32(dr["id_Ses"]), StartTime = Convert.ToDateTime(dr["StartTime"]), EndTime = Convert.ToDateTime(dr["EndTime"]), Status = Convert.ToBoolean(dr["Status"]), }; } conn.Close(); return(session); } }