public static void Delete(MediaData m) { //p_delete_media try { using (MySqlConnection conn = new MySqlConnection(App.setting.connectString)) { conn.Open(); string query = "`p_delete_media`"; using (MySqlCommand cmd = new MySqlCommand(query, conn)) { cmd.Parameters.Add(new MySqlParameter("@_media_id", MySqlDbType.Int32) { Direction = System.Data.ParameterDirection.Input, Value = m.ID }); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.ExecuteScalar(); }; conn.Close(); }; } catch (Exception) { } }
public static MediaData Info(int id) { MediaData m = null; //p_info_media try { using (MySqlConnection conn = new MySqlConnection(App.setting.connectString)) { conn.Open(); string query = "`p_info_media`"; using (MySqlCommand cmd = new MySqlCommand(query, conn)) { cmd.Parameters.Add(new MySqlParameter("@_media_id", MySqlDbType.Int32, 100) { 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.toMedia(); } } }; conn.Close(); }; } catch (Exception) { } return(m); }
public static int Insert(MediaData m) { int result = -1; //p_insert_media try { using (MySqlConnection conn = new MySqlConnection(App.setting.connectString)) { conn.Open(); string query = "`p_insert_media`"; using (MySqlCommand cmd = new MySqlCommand(query, conn)) { cmd.Parameters.Add(new MySqlParameter("@_media_name", MySqlDbType.VarChar, 255) { Direction = System.Data.ParameterDirection.Input, Value = m.Name }); cmd.Parameters.Add(new MySqlParameter("@_media_url", MySqlDbType.VarChar, 255) { Direction = System.Data.ParameterDirection.Input, Value = m.Url }); cmd.Parameters.Add(new MySqlParameter("@_media_type", MySqlDbType.Int32) { Direction = System.Data.ParameterDirection.Input, Value = m.Type }); cmd.Parameters.Add(new MySqlParameter("@_media_comment", MySqlDbType.Text) { Direction = System.Data.ParameterDirection.Input, Value = m.Comment }); cmd.Parameters.Add(new MySqlParameter("@_media_size", MySqlDbType.VarChar,100) { Direction = System.Data.ParameterDirection.Input, Value = m.FileSize }); cmd.Parameters.Add(new MySqlParameter("@_media_duration", MySqlDbType.VarChar, 100) { Direction = System.Data.ParameterDirection.Input, Value = m.Duration }); cmd.Parameters.Add(new MySqlParameter("@_media_user", MySqlDbType.Int32) { Direction = System.Data.ParameterDirection.Input, Value = m.User_ID }); cmd.Parameters.Add(new MySqlParameter("@_media_md5", MySqlDbType.VarChar,100) { Direction = System.Data.ParameterDirection.Input, Value = m.Md5 }); cmd.Parameters.Add(new MySqlParameter("@_media_id", MySqlDbType.Int32) { Direction = System.Data.ParameterDirection.Output, Value = 0 }); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.ExecuteScalar(); result = Convert.ToInt32(cmd.Parameters["@_media_id"].Value); }; conn.Close(); }; } catch (Exception ex) { Console.WriteLine(ex.ToString()); } return result; }
public static int Insert(MediaData m) { int result = -1; //p_insert_media try { using (MySqlConnection conn = new MySqlConnection(App.setting.connectString)) { conn.Open(); string query = "`p_insert_media`"; using (MySqlCommand cmd = new MySqlCommand(query, conn)) { cmd.Parameters.Add(new MySqlParameter("@_media_name", MySqlDbType.VarChar, 255) { Direction = System.Data.ParameterDirection.Input, Value = m.Name }); cmd.Parameters.Add(new MySqlParameter("@_media_url", MySqlDbType.VarChar, 255) { Direction = System.Data.ParameterDirection.Input, Value = m.Url }); cmd.Parameters.Add(new MySqlParameter("@_media_type", MySqlDbType.Int32) { Direction = System.Data.ParameterDirection.Input, Value = m.Type }); cmd.Parameters.Add(new MySqlParameter("@_media_comment", MySqlDbType.Text) { Direction = System.Data.ParameterDirection.Input, Value = m.Comment }); cmd.Parameters.Add(new MySqlParameter("@_media_size", MySqlDbType.VarChar, 100) { Direction = System.Data.ParameterDirection.Input, Value = m.FileSize }); cmd.Parameters.Add(new MySqlParameter("@_media_duration", MySqlDbType.VarChar, 100) { Direction = System.Data.ParameterDirection.Input, Value = m.Duration }); cmd.Parameters.Add(new MySqlParameter("@_media_user", MySqlDbType.Int32) { Direction = System.Data.ParameterDirection.Input, Value = m.User_ID }); cmd.Parameters.Add(new MySqlParameter("@_media_md5", MySqlDbType.VarChar, 100) { Direction = System.Data.ParameterDirection.Input, Value = m.Md5 }); cmd.Parameters.Add(new MySqlParameter("@_media_id", MySqlDbType.Int32) { Direction = System.Data.ParameterDirection.Output, Value = 0 }); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.ExecuteScalar(); result = Convert.ToInt32(cmd.Parameters["@_media_id"].Value); }; conn.Close(); }; } catch (Exception ex) { Console.WriteLine(ex.ToString()); } return(result); }
private void Item_DeleteCameraEvent(object sender, MediaData e) { if (e != null) { MessageBoxResult messageBoxResult = MessageBox.Show("Bạn có muốn xoá camera này không?", "Xoá camera", System.Windows.MessageBoxButton.YesNo); if (messageBoxResult == MessageBoxResult.Yes) { Code.Media.MediaData.Delete(e); UIcamera m = this.list_Box_Item.SelectedItem as UIcamera; m.Animation_Opacity_View_Frame(false, () => { this.list_Box_Item.Items.Remove(m); this.Datas.Remove(e); this.totalMedia -= 1; if (this.to < this.totalMedia) { if (this.User == null) { this.Datas = App.curUser.LoadMedias(this.from, this.to, out this.totalMedia, this.TypeMedia); } else { this.Datas = this.User.LoadMedias(this.from, this.to, out this.totalMedia, this.TypeMedia,true); } this.LoadGUI(); } }, 600); this.list_Box_Item.SelectedIndex = -1; } } }
public static MediaData toMedia(this MySqlDataReader reader) { if (reader.HasRows) { MediaData m = new MediaData(); while (reader.Read()) { if (!reader.IsDBNull(0)) { m.ID = reader.GetInt32(Define.media_id); m.Name = reader.GetString(Define.media_name); m.Url = reader.GetString(Define.media_url); m.Type = reader.GetInt32(Define.media_type); m.FileSize = reader.GetString(Define.media_size); try { m.Md5 = reader.GetString(Define.media_md5); } catch (Exception) { } try { m.FileSize = reader.GetString(Define.media_size); } catch (Exception) { } try { m.Duration = reader.GetString(Define.media_duration); } catch (Exception) { } try { m.Comment = reader.GetString(Define.media_comment); } catch (Exception) { } m.Status = reader.GetBoolean(Define.media_status); m.User_ID = reader.GetInt32(Define.media_user); m.Time = reader.GetDateTime(Define.media_time); } } return m; } return null; }