public static MediaEvent Info(int id)
{
//p_info_playlist_details
MediaEvent m = null;
try
{
using (MySqlConnection conn = new MySqlConnection(App.setting.connectString))
{
conn.Open();
string query = "`p_info_playlist_details`";
using (MySqlCommand cmd = new MySqlCommand(query, conn))
{
cmd.Parameters.Add(new MySqlParameter("@_id", MySqlDbType.Int32)
{
Direction = System.Data.ParameterDirection.Input, Value = id
});
cmd.CommandType = System.Data.CommandType.StoredProcedure;
var tmp = cmd.ExecuteScalar();
if (Convert.ToInt32(tmp) > 0)
{
using (MySqlDataReader reader = cmd.ExecuteReader())
{
m = reader.toMediaEvent();
}
}
};
conn.Close();
};
}
catch (Exception)
{
}
return(m);
}
public static int Insert(MediaEvent media)
{
//p_insert_playlist_details
try
{
using (MySqlConnection conn = new MySqlConnection(App.setting.connectString))
{
conn.Open();
string query = "`p_insert_playlist_details`";
using (MySqlCommand cmd = new MySqlCommand(query, conn))
{
cmd.Parameters.Add(new MySqlParameter("@_playlist_id", MySqlDbType.Int32)
{
Direction = System.Data.ParameterDirection.Input, Value = media.playlist_id
});
cmd.Parameters.Add(new MySqlParameter("@_media_id", MySqlDbType.Int32)
{
Direction = System.Data.ParameterDirection.Input, Value = media.media_id
});
cmd.Parameters.Add(new MySqlParameter("@_time_begin", MySqlDbType.Time)
{
Direction = System.Data.ParameterDirection.Input, Value = media.TimeBegin
});
cmd.Parameters.Add(new MySqlParameter("@_time_end", MySqlDbType.Time)
{
Direction = System.Data.ParameterDirection.Input, Value = media.TimeEnd
});
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.ExecuteScalar();
};
conn.Close();
};
return(1);
}
catch (Exception)
{
return(-1);
}
}
public static List<MediaEvent> toMediaEvents(this MySqlDataReader reader)
{
if (reader.HasRows)
{
List<MediaEvent> datas = new List<MediaEvent>();
while (reader.Read())
{
if (!reader.IsDBNull(0))
{
MediaEvent d = new MediaEvent();
d.ID = reader.GetInt32(Define.detail_id);
d.media_id = reader.GetInt32(Define.media_id);
d.playlist_id = reader.GetInt32(Define.playlist_id);
d.TimeBegin = reader.GetTimeSpan(Define.time_begin);
d.TimeEnd = reader.GetTimeSpan(Define.time_end);
d.Time = reader.GetDateTime(Define.detail_date);
datas.Add(d);
}
}
return datas;
}
return null;
}
public static int Insert(MediaEvent media)
{
//p_insert_playlist_details
try
{
using (MySqlConnection conn = new MySqlConnection(App.setting.connectString))
{
conn.Open();
string query = "`p_insert_playlist_details`";
using (MySqlCommand cmd = new MySqlCommand(query, conn))
{
cmd.Parameters.Add(new MySqlParameter("@_playlist_id", MySqlDbType.Int32) { Direction = System.Data.ParameterDirection.Input, Value = media.playlist_id });
cmd.Parameters.Add(new MySqlParameter("@_media_id", MySqlDbType.Int32) { Direction = System.Data.ParameterDirection.Input, Value = media.media_id });
cmd.Parameters.Add(new MySqlParameter("@_time_begin", MySqlDbType.Time) { Direction = System.Data.ParameterDirection.Input, Value = media.TimeBegin });
cmd.Parameters.Add(new MySqlParameter("@_time_end", MySqlDbType.Time) { Direction = System.Data.ParameterDirection.Input, Value = media.TimeEnd });
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.ExecuteScalar();
};
conn.Close();
};
return 1;
}
catch (Exception)
{
return -1;
}
}