public void InsertUser(string user) { SongDA songDA = new SongDA(); List <SqlParameter> list = new List <SqlParameter>(); list.Add(new SqlParameter("@UserID", user)); songDA.UpdateData("INSERT_USER", list); }
public List <SongDTO> SelectTopWorldSong() { SongDA songDA = new SongDA(); DataTable dt = null; dt = songDA.GetData("SELECT_TOP_WORLD_SONG"); return(EntityHelper <SongDTO> .GetListObject(dt)); }
//public SongDTO GetSongByID(string songID) //{ // SongDTO songDTO = new SongDTO(); // SongDA songDA = new SongDA(); // List<SqlParameter> list = new List<SqlParameter>(); // list.Add(new SqlParameter("@SongID", songID)); // return songDTO; //} public List <SongDTO> GetDefaultList(string user) { SongDA songDA = new SongDA(); DataTable dt = null; List <SqlParameter> list = new List <SqlParameter>(); list.Add(new SqlParameter("@UserID", user)); dt = songDA.GetData("SELECT_DEFAULT_LIST", list); return(EntityHelper <SongDTO> .GetListObject(dt)); }
public bool InsertSong(IEnumerable <HttpPostedFileBase> files) { SongDA songDA = new SongDA(); DataTable dataTable = new DataTable(); dataTable.Columns.Add("SONG_NAME", typeof(string)); dataTable.Columns.Add("ARTIST", typeof(string)); dataTable.Columns.Add("ALBUM", typeof(string)); dataTable.Columns.Add("DURATION", typeof(Int16)); dataTable.Columns.Add("UPLOAD_USER", typeof(string)); dataTable.Columns.Add("DIRECTORY_PATH", typeof(string)); foreach (var file in files) { if (file.ContentLength > 0) { // Get file name string fileName = Path.GetFileName(file.FileName); // Get file name with path string path = Resource1.UploadPath + fileName; // Save file to server file.SaveAs(path); // Load info from .mp3 file TagLib.File tagFile = TagLib.File.Create(path); // Create data for datatable dataTable.Rows.Add( tagFile.Tag.Title, tagFile.Tag.Performers[0], tagFile.Tag.Album, tagFile.Properties.Duration.TotalSeconds, this.GetUserAccount(HttpContext.Current.Request.LogonUserIdentity.Name), path); } } // Insert info to database List <SqlParameter> listParam = new List <SqlParameter>(); listParam.Add(new SqlParameter("@SongDataTable", dataTable)); bool result = songDA.UpdateData("INSERT_SONG", listParam); return(result); }
public void AddToDefaultList(string songID) { SongDA songDA = new SongDA(); List <SqlParameter> list = new List <SqlParameter>(); list.Add(new SqlParameter("@UserID", GetUserAccount(HttpContext.Current.Request.LogonUserIdentity.Name))); list.Add(new SqlParameter("@SongID", songID)); System.Diagnostics.Debug.WriteLine(GetUserAccount(HttpContext.Current.Request.LogonUserIdentity.Name)); System.Diagnostics.Debug.WriteLine(songID); songDA.UpdateData("INSERT_SONG_TO_DEFAULT_LIST", list); }
public bool CheckUser(string user) { SongDA songDA = new SongDA(); DataTable dt = null; List <SqlParameter> list = new List <SqlParameter>(); list.Add(new SqlParameter("@UserID", user)); dt = songDA.GetData("CHECK_USER_EXIST", list); if (dt.Rows.Count > 0) { return(true); } else { return(false); } }
public string GetSongUrlByID(string songID) { string path = String.Empty; SongDA songDA = new SongDA(); List <SqlParameter> list = new List <SqlParameter>(); list.Add(new SqlParameter("@SongID", songID)); DataTable dt = songDA.GetData("SELECT_DIRECTORY_PATH_BY_ID", list); path = dt.Rows[0][0].ToString(); if (String.IsNullOrEmpty(path)) { System.Diagnostics.Debug.WriteLine("FUCKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKK"); } else { System.Diagnostics.Debug.WriteLine(path + "*********************"); } return(path); }