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;
}
void UIE_DeleteEvent(object sender, MediaEvent e)
{
if (e != null)
{
if (MessageBox.Show("Bạn có muốn xóa media này không?", "Thông báo", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
e.delete();
this.LoadUI(this.playlist);
}
}
}
void UIE_ViewMediaEvent(object sender, MediaEvent e)
{
this.Event = e;
}
private void Button_Click(object sender, RoutedEventArgs e)
{
if (this.MediaSelect.SelectedItem == null)
{
MessageBox.Show("Hãy chọn Media mà bạn muốn thêm.", "Thông báo");
return;
}
if (this.UITimeBegin >= this.UITimeEnd)
{
MessageBox.Show("Thời gian bắt đầu phải nhỏ hơn thời gian kết thúc", "Thông báo");
return;
}
#region Validate
bool validate = true;
List<MediaEvent> Medias = this.playlist.LoadMediaEvent();
if (Medias != null)
{
foreach (MediaEvent mE in Medias)
{
if (this.Event == null || ((this.Event != null) && this.Event.ID != mE.ID))
{
if ((mE.TimeBegin <= this.UITimeBegin.Time.TimeOfDay && mE.TimeEnd >= this.UITimeBegin.Time.TimeOfDay) || (mE.TimeBegin <= this.UITimeEnd.Time.TimeOfDay && mE.TimeEnd >= this.UITimeEnd.Time.TimeOfDay) || (mE.TimeBegin >= this.UITimeBegin.Time.TimeOfDay && mE.TimeEnd <= this.UITimeEnd.Time.TimeOfDay))
{
validate = false;
break;
}
}
}
}
if (validate)
{
MediaEvent tmp = new MediaEvent();
tmp.media_id = Convert.ToInt32(this.MediaSelect.SelectedItem.key);
tmp.playlist_id = this.playlist.ID;
tmp.TimeBegin = this.UITimeBegin.Time.TimeOfDay;
tmp.TimeEnd = this.UITimeEnd.Time.TimeOfDay;
int result = 0;
if (this.Event == null)
{
result = MediaEvent.Insert(tmp);
}
else
{
tmp.ID = this._event.ID;
result =tmp.Save();
}
if (result != 1)
{
MessageBox.Show("Lưu dữ liệu không thành công", "Thông báo");
return;
}
else
{
this.Event = null;
this.LoadUI(this.playlist);
}
}
else
{
MessageBox.Show("Không thể thêm media trong thời gian này", "Thông báo");
}
#endregion
}
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;
}
}