/// <summary> /// update row in the table /// </summary> /// <param name="businessObject">business object</param> /// <returns>true for successfully updated</returns> public bool Update(clsSongs businessObject) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandText = "dbo.[sp_Songs_Update]"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.Add(new SqlParameter("@IdSong", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.IdSong)); sqlCommand.Parameters.Add(new SqlParameter("@GENRE", SqlDbType.NVarChar, 400, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.GENRE)); sqlCommand.Parameters.Add(new SqlParameter("@LANGUAGE", SqlDbType.NVarChar, 400, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.LANGUAGE)); sqlCommand.Parameters.Add(new SqlParameter("@TVSHOW", SqlDbType.NVarChar, 400, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.TVSHOW)); sqlCommand.Parameters.Add(new SqlParameter("@ARTIST", SqlDbType.NVarChar, 400, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.ARTIST)); sqlCommand.Parameters.Add(new SqlParameter("@TITLE", SqlDbType.NVarChar, 400, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.TITLE)); sqlCommand.Parameters.Add(new SqlParameter("@VERSION", SqlDbType.NVarChar, 400, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.VERSION)); sqlCommand.Parameters.Add(new SqlParameter("@LABEL", SqlDbType.NVarChar, 400, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.LABEL)); sqlCommand.Parameters.Add(new SqlParameter("@FILENAME", SqlDbType.NVarChar, 400, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.FILENAME)); sqlCommand.Parameters.Add(new SqlParameter("@Spotify", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.Spotify)); sqlCommand.Parameters.Add(new SqlParameter("@CompanyId", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.CompanyId)); sqlCommand.Parameters.Add(new SqlParameter("@LabelId", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.LabelId)); sqlCommand.Parameters.Add(new SqlParameter("@RadioDate", SqlDbType.DateTime, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.RadioDate)); sqlCommand.Parameters.Add(new SqlParameter("@IncludeInFirstPlay", SqlDbType.Bit, 1, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.IncludeInFirstPlay)); sqlCommand.Parameters.Add(new SqlParameter("@IncludeInNewTalent", SqlDbType.Bit, 1, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.IncludeInNewTalent)); sqlCommand.Parameters.Add(new SqlParameter("@PromotionId", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.PromotionId)); sqlCommand.Parameters.Add(new SqlParameter("@SingRing", SqlDbType.BigInt, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.SingRing)); sqlCommand.Parameters.Add(new SqlParameter("@FirstPlayDate", SqlDbType.DateTime, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.FirstPlayDate)); sqlCommand.Parameters.Add(new SqlParameter("@ParentSongId", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.ParentSongId)); sqlCommand.Parameters.Add(new SqlParameter("@Lyric", SqlDbType.Text, 2147483647, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.Lyric)); MainConnection.Open(); sqlCommand.ExecuteNonQuery(); return(true); } catch (Exception ex) { throw new Exception("clsSongs::Update::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
/// <summary> /// Select by primary key /// </summary> /// <param name="keys">primary keys</param> /// <returns>clsSongs business object</returns> public clsSongs SelectByPrimaryKey(clsSongsKeys keys) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandText = "dbo.[sp_Songs_SelectByPrimaryKey]"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.Add(new SqlParameter("@IdSong", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, keys.IdSong)); MainConnection.Open(); IDataReader dataReader = sqlCommand.ExecuteReader(); if (dataReader.Read()) { clsSongs businessObject = new clsSongs(); PopulateBusinessObjectFromReader(businessObject, dataReader); return(businessObject); } else { return(null); } } catch (Exception ex) { throw new Exception("clsSongs::SelectByPrimaryKey::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
public Int32 InsertExist_Check(clsSongs businessObject) { SqlCommand sqlCommand = new SqlCommand(); try { MainConnection.Close(); sqlCommand.Dispose(); sqlCommand = new SqlCommand(); sqlCommand.CommandText = "dbo.[sp_Songs_Insert_Check]"; sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.Connection = MainConnection; sqlCommand.Parameters.Add(new SqlParameter("@IdSong", SqlDbType.Int, 4, ParameterDirection.Output, false, 0, 0, "", DataRowVersion.Proposed, businessObject.IdSong)); sqlCommand.Parameters.Add(new SqlParameter("@ARTIST", SqlDbType.NVarChar, 400, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.ARTIST)); sqlCommand.Parameters.Add(new SqlParameter("@TITLE", SqlDbType.NVarChar, 400, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.TITLE)); sqlCommand.Parameters.Add(new SqlParameter("@FILENAME", SqlDbType.NVarChar, 400, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.FILENAME)); MainConnection.Open(); sqlCommand.ExecuteNonQuery(); businessObject.IdSong = (int)sqlCommand.Parameters["@IdSong"].Value; return(businessObject.IdSong); } catch (Exception ex) { businessObject.IdSong = -1; return(-1); //throw new Exception("clsSongs::Insert::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["User"] != null) { Session["Songs"] = null; HtmlGenericControl ManageSongs = (HtmlGenericControl)Master.FindControl("ManageSongs"); ManageSongs.Attributes.Add("class", "select"); HtmlGenericControl ManageCompany = (HtmlGenericControl)Master.FindControl("ManageCompany"); ManageCompany.Attributes.Add("class", "select"); HtmlGenericControl ManageLabel = (HtmlGenericControl)Master.FindControl("ManageLabel"); ManageLabel.Attributes.Add("class", "select"); HtmlGenericControl ManageEmergenti = (HtmlGenericControl)Master.FindControl("ManageEmergenti"); ManageEmergenti.Attributes.Add("class", "select"); HtmlGenericControl ImportData = (HtmlGenericControl)Master.FindControl("ImportData"); ImportData.Attributes.Add("class", "select"); HtmlGenericControl audienceFigures = (HtmlGenericControl)Master.FindControl("audienceFigures"); audienceFigures.Attributes.Add("class", "select"); HtmlGenericControl digitalData = (HtmlGenericControl)Master.FindControl("digitalData"); digitalData.Attributes.Add("class", "select"); HtmlGenericControl MoveFiles = (HtmlGenericControl)Master.FindControl("MoveFiles"); MoveFiles.Attributes.Add("class", "select"); HtmlGenericControl Promoter = (HtmlGenericControl)Master.FindControl("Promoter"); Promoter.Attributes.Add("class", "select"); if (Request.QueryString != null && Request.QueryString["id"] != null) { hf.Value = Request.QueryString["id"]; hfprevid.Value = Request.QueryString["id"]; clsSongsFactory fac = new clsSongsFactory(); List <clsSongs> Songs = fac.GetAllByVersions(Convert.ToInt32(hf.Value)); LoadData(); if (Songs != null && Songs.Count > 0 && Session["eSongs"] == null) { grd.DataSource = Songs; grd.DataBind(); Session["eSongs"] = Songs; clsSongs Song = Songs.First(x => x.IdSong == Convert.ToInt32(hf.Value)); lblVersion.Text = Song.VERSION; chkAbsoluteBegin.Checked = Song.IncludeInNewTalent; chkAlternativeCharts.Checked = Song.AlternativeChart; chkFirstPlay.Checked = Song.IncludeInFirstPlay; //lblGenre.Text = Song.GENRE; ddlGenre.SelectedValue = Song.GENRE == "Pop" ? "0" : Song.GENRE == "Rock" ? "1" : Song.GENRE == "Dance" ? "2" : Song.GENRE == "Hip Hop / Rap" ? "3" : "0"; //lblLanguage.Text = Song.LANGUAGE; ddlLanguage.SelectedValue = Song.LANGUAGE == "ita" ? "1" : Song.LANGUAGE == "int" ? "0" : "0"; lblRadio.Text = Song.RadioDate.Value.ToString("dd/MM/yyyy"); lblTvShow.Text = Song.TVSHOW; lblArtist.Text = Song.ARTIST; lblTitle.Text = Song.TITLE; ddlLabel.SelectedValue = Songs[0].LabelId.ToString(); ddlPromoter.SelectedValue = Songs[0].PromotionId.ToString(); //clsCompaniesFactory facC = new clsCompaniesFactory(); //clsCompaniesKeys k = new clsCompaniesKeys(Songs[0].CompanyId.Value); //clsCompanies c = facC.GetByPrimaryKey(k); ddlCompany.SelectedValue = Song.CompanyId.ToString(); lblAuthor.Text = Song.Author; lblPublisher.Text = Song.Publisher; txtDuration.Text = Song.Duration; txtISRC.Text = Song.ISRC; } else { Songs = (List <clsSongs>)Session["eSongs"]; grd.DataSource = Songs; grd.DataBind(); clsSongs Song = Songs.Where(x => x.IdSong == Convert.ToInt32(hf.Value)).FirstOrDefault(); lblVersion.Text = Song.VERSION; chkAbsoluteBegin.Checked = Song.IncludeInNewTalent; chkAlternativeCharts.Checked = Song.AlternativeChart; chkFirstPlay.Checked = Song.IncludeInFirstPlay; //lblGenre.Text = Song.GENRE; Song.GENRE = ddlGenre.SelectedValue == "0" ? "Pop" : ddlGenre.SelectedValue == "1" ? "Rock" : ddlGenre.SelectedValue == "2" ? "Dance" : ddlGenre.SelectedValue == "3" ? "Hip Hop / Rap" : "Pop"; // txtGenre.Text; //lblLanguage.Text = Song.LANGUAGE; Song.LANGUAGE = ddlLanguage.SelectedValue == "1" ? "ita" : ddlLanguage.SelectedValue == "0" ? "int" : "int"; // txtLanguage.Text; lblRadio.Text = Song.RadioDate.Value.ToString("dd/MM/yyyy"); lblTvShow.Text = Song.TVSHOW; lblArtist.Text = Song.ARTIST; lblTitle.Text = Song.TITLE; ddlLabel.SelectedValue = Songs[0].LabelId.ToString(); ddlPromoter.SelectedValue = Songs[0].PromotionId.ToString(); //clsCompaniesFactory facC = new clsCompaniesFactory(); //clsCompaniesKeys k = new clsCompaniesKeys(Song.CompanyId.Value); //clsCompanies c = facC.GetByPrimaryKey(k); ddlCompany.SelectedValue = Songs[0].CompanyId.ToString(); lblAuthor.Text = Song.Author; lblPublisher.Text = Song.Publisher; txtDuration.Text = Song.Duration; txtISRC.Text = Song.ISRC; } } } else { Response.Redirect("Login.aspx"); } } }
/// <summary> /// insert new row in the table /// </summary> /// <param name="businessObject">business object</param> /// <returns>true of successfully insert</returns> public Int32 Insert(clsSongs businessObject) { SqlCommand sqlCommand = new SqlCommand(); try { MainConnection.Close(); sqlCommand.Dispose(); sqlCommand = new SqlCommand(); sqlCommand.CommandText = "dbo.[sp_Songs_Insert]"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; //sqlCommand.CommandTimeout = 60; sqlCommand.Parameters.Add(new SqlParameter("@IdSong", SqlDbType.Int, 4, ParameterDirection.Output, false, 0, 0, "", DataRowVersion.Proposed, businessObject.IdSong)); sqlCommand.Parameters.Add(new SqlParameter("@GENRE", SqlDbType.NVarChar, 400, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.GENRE)); sqlCommand.Parameters.Add(new SqlParameter("@LANGUAGE", SqlDbType.NVarChar, 400, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.LANGUAGE)); sqlCommand.Parameters.Add(new SqlParameter("@TVSHOW", SqlDbType.NVarChar, 400, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.TVSHOW)); sqlCommand.Parameters.Add(new SqlParameter("@ARTIST", SqlDbType.NVarChar, 400, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.ARTIST)); sqlCommand.Parameters.Add(new SqlParameter("@TITLE", SqlDbType.NVarChar, 400, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.TITLE)); sqlCommand.Parameters.Add(new SqlParameter("@VERSION", SqlDbType.NVarChar, 400, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.VERSION)); sqlCommand.Parameters.Add(new SqlParameter("@LABEL", SqlDbType.NVarChar, 400, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.LABEL)); sqlCommand.Parameters.Add(new SqlParameter("@FILENAME", SqlDbType.NVarChar, 400, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.FILENAME)); sqlCommand.Parameters.Add(new SqlParameter("@Spotify", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.Spotify)); sqlCommand.Parameters.Add(new SqlParameter("@CompanyId", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.CompanyId)); sqlCommand.Parameters.Add(new SqlParameter("@LabelId", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.LabelId)); sqlCommand.Parameters.Add(new SqlParameter("@RadioDate", SqlDbType.DateTime, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.RadioDate)); sqlCommand.Parameters.Add(new SqlParameter("@IncludeInFirstPlay", SqlDbType.Bit, 1, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.IncludeInFirstPlay)); sqlCommand.Parameters.Add(new SqlParameter("@IncludeInNewTalent", SqlDbType.Bit, 1, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.IncludeInNewTalent)); sqlCommand.Parameters.Add(new SqlParameter("@PromotionId", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.PromotionId)); sqlCommand.Parameters.Add(new SqlParameter("@SingRing", SqlDbType.BigInt, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.SingRing)); sqlCommand.Parameters.Add(new SqlParameter("@FirstPlayDate", SqlDbType.DateTime, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.FirstPlayDate)); sqlCommand.Parameters.Add(new SqlParameter("@ParentSongId", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.ParentSongId)); sqlCommand.Parameters.Add(new SqlParameter("@Lyric", SqlDbType.Text, 2147483647, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.Lyric)); sqlCommand.Parameters.Add(new SqlParameter("@AlternativeChart", SqlDbType.Bit, 1, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.AlternativeChart)); sqlCommand.Parameters.Add(new SqlParameter("@Author", SqlDbType.NVarChar, 400, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.Author)); sqlCommand.Parameters.Add(new SqlParameter("@Publisher", SqlDbType.NVarChar, 400, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.Publisher)); sqlCommand.Parameters.Add(new SqlParameter("@Duration", SqlDbType.NVarChar, 400, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.Duration)); sqlCommand.Parameters.Add(new SqlParameter("@ISRC", SqlDbType.NVarChar, 400, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.ISRC)); MainConnection.Open(); sqlCommand.ExecuteNonQuery(); businessObject.IdSong = (int)sqlCommand.Parameters["@IdSong"].Value; return(businessObject.IdSong); } catch (Exception ex) { businessObject.IdSong = -1; return(-1); //throw new Exception("clsSongs::Insert::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
/// <summary> /// Populate business object from data reader /// </summary> /// <param name="businessObject">business object</param> /// <param name="dataReader">data reader</param> internal void PopulateBusinessObjectFromReader(clsSongs businessObject, IDataReader dataReader) { businessObject.IdSong = dataReader.GetInt32(dataReader.GetOrdinal(clsSongs.clsSongsFields.IdSong.ToString())); if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsSongs.clsSongsFields.GENRE.ToString()))) { businessObject.GENRE = dataReader.GetString(dataReader.GetOrdinal(clsSongs.clsSongsFields.GENRE.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsSongs.clsSongsFields.LANGUAGE.ToString()))) { businessObject.LANGUAGE = dataReader.GetString(dataReader.GetOrdinal(clsSongs.clsSongsFields.LANGUAGE.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsSongs.clsSongsFields.TVSHOW.ToString()))) { businessObject.TVSHOW = dataReader.GetString(dataReader.GetOrdinal(clsSongs.clsSongsFields.TVSHOW.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsSongs.clsSongsFields.ARTIST.ToString()))) { businessObject.ARTIST = dataReader.GetString(dataReader.GetOrdinal(clsSongs.clsSongsFields.ARTIST.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsSongs.clsSongsFields.TITLE.ToString()))) { businessObject.TITLE = dataReader.GetString(dataReader.GetOrdinal(clsSongs.clsSongsFields.TITLE.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsSongs.clsSongsFields.VERSION.ToString()))) { businessObject.VERSION = dataReader.GetString(dataReader.GetOrdinal(clsSongs.clsSongsFields.VERSION.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsSongs.clsSongsFields.LABEL.ToString()))) { businessObject.LABEL = dataReader.GetString(dataReader.GetOrdinal(clsSongs.clsSongsFields.LABEL.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsSongs.clsSongsFields.FILENAME.ToString()))) { businessObject.FILENAME = dataReader.GetString(dataReader.GetOrdinal(clsSongs.clsSongsFields.FILENAME.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsSongs.clsSongsFields.Spotify.ToString()))) { businessObject.Spotify = dataReader.GetString(dataReader.GetOrdinal(clsSongs.clsSongsFields.Spotify.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsSongs.clsSongsFields.CompanyId.ToString()))) { businessObject.CompanyId = dataReader.GetInt32(dataReader.GetOrdinal(clsSongs.clsSongsFields.CompanyId.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsSongs.clsSongsFields.LabelId.ToString()))) { businessObject.LabelId = dataReader.GetInt32(dataReader.GetOrdinal(clsSongs.clsSongsFields.LabelId.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsSongs.clsSongsFields.RadioDate.ToString()))) { businessObject.RadioDate = dataReader.GetDateTime(dataReader.GetOrdinal(clsSongs.clsSongsFields.RadioDate.ToString())); } businessObject.IncludeInFirstPlay = dataReader.GetBoolean(dataReader.GetOrdinal(clsSongs.clsSongsFields.IncludeInFirstPlay.ToString())); businessObject.IncludeInNewTalent = dataReader.GetBoolean(dataReader.GetOrdinal(clsSongs.clsSongsFields.IncludeInNewTalent.ToString())); if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsSongs.clsSongsFields.PromotionId.ToString()))) { businessObject.PromotionId = dataReader.GetInt32(dataReader.GetOrdinal(clsSongs.clsSongsFields.PromotionId.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsSongs.clsSongsFields.SingRing.ToString()))) { businessObject.SingRing = dataReader.GetInt64(dataReader.GetOrdinal(clsSongs.clsSongsFields.SingRing.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsSongs.clsSongsFields.FirstPlayDate.ToString()))) { businessObject.FirstPlayDate = dataReader.GetDateTime(dataReader.GetOrdinal(clsSongs.clsSongsFields.FirstPlayDate.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsSongs.clsSongsFields.ParentSongId.ToString()))) { businessObject.ParentSongId = dataReader.GetInt32(dataReader.GetOrdinal(clsSongs.clsSongsFields.ParentSongId.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsSongs.clsSongsFields.Lyric.ToString()))) { businessObject.Lyric = dataReader.GetString(dataReader.GetOrdinal(clsSongs.clsSongsFields.Lyric.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsSongs.clsSongsFields.AlternativeChart.ToString()))) { businessObject.AlternativeChart = dataReader.GetBoolean(dataReader.GetOrdinal(clsSongs.clsSongsFields.AlternativeChart.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsSongs.clsSongsFields.Author.ToString()))) { businessObject.Author = dataReader.GetString(dataReader.GetOrdinal(clsSongs.clsSongsFields.Author.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsSongs.clsSongsFields.Publisher.ToString()))) { businessObject.Publisher = dataReader.GetString(dataReader.GetOrdinal(clsSongs.clsSongsFields.Publisher.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsSongs.clsSongsFields.Duration.ToString()))) { businessObject.Duration = dataReader.GetString(dataReader.GetOrdinal(clsSongs.clsSongsFields.Duration.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(clsSongs.clsSongsFields.ISRC.ToString()))) { businessObject.ISRC = dataReader.GetString(dataReader.GetOrdinal(clsSongs.clsSongsFields.ISRC.ToString())); } }
protected void btn_Click(object sender, EventArgs e) { CultureInfo cinfo = new CultureInfo("it-IT"); clsSongsFactory fac = new clsSongsFactory(); clsSongs Song = new clsSongs(); if (!String.IsNullOrEmpty(hfname.Value)) { if (IsEnglish(hfname.Value)) { if (filename.HasFile) { string FileName = Path.GetFileName(filename.PostedFile.FileName); string Extension = Path.GetExtension(filename.PostedFile.FileName); if (Extension == ".xls" || Extension == ".xlsx") { try { string FolderPath = Server.MapPath("~/ImportFiles"); if (!Directory.Exists(FolderPath)) { Directory.CreateDirectory(FolderPath); } Guid abc = Guid.NewGuid(); string FilePath = FolderPath + "/" + abc.ToString(); if (System.IO.File.Exists(FilePath)) { System.IO.File.Delete(FilePath); } filename.SaveAs(FilePath); string excelConnectionString = string.Empty; excelConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + FilePath + ";Extended Properties=\"Excel 12.0;HDR=" + "No" + ";IMEX=2\""; OleDbConnection excelConnection = new OleDbConnection(excelConnectionString); if (Extension == ".xls") { excelConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + FilePath + ";Extended Properties=\"Excel 8.0;HDR=" + "No" + ";IMEX=2\""; } else if (Extension == ".xlsx") { excelConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + FilePath + ";Extended Properties=\"Excel 12.0;HDR=" + "No" + ";IMEX=2\""; } excelConnection = new OleDbConnection(excelConnectionString); if (excelConnection.State == ConnectionState.Closed) { excelConnection.Open(); } DataSet ds = new DataSet(); DataTable dt = new DataTable(); ds = getExcelRecords(excelConnectionString, excelConnection); int totalcolumns = ds.Tables[0].Columns.Count; if (totalcolumns > 0) { dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { try { Song.GENRE = string.IsNullOrEmpty(dr[0].ToString()) ? null : dr[0].ToString(); Song.LANGUAGE = string.IsNullOrEmpty(dr[1].ToString()) ? null : dr[1].ToString(); if (!string.IsNullOrEmpty(Song.GENRE) && !string.IsNullOrEmpty(Song.LANGUAGE)) { Song.TVSHOW = string.IsNullOrEmpty(dr[2].ToString()) ? null : dr[2].ToString(); Song.ARTIST = string.IsNullOrEmpty(dr[3].ToString()) ? null : dr[3].ToString(); Song.TITLE = string.IsNullOrEmpty(dr[4].ToString()) ? null : dr[4].ToString(); Song.VERSION = string.IsNullOrEmpty(dr[5].ToString()) ? null : dr[5].ToString(); Song.LABEL = string.IsNullOrEmpty(dr[6].ToString()) ? null : dr[6].ToString(); Song.FILENAME = string.IsNullOrEmpty(dr[7].ToString()) ? null : dr[7].ToString(); Song.Spotify = string.IsNullOrEmpty(dr[8].ToString()) ? null : dr[8].ToString(); Song.CompanyId = Convert.ToInt32(dr[9].ToString()); Song.LabelId = Convert.ToInt32(dr[10].ToString()); Song.RadioDate = Convert.ToDateTime(dr[11].ToString()); Song.IncludeInFirstPlay = dr[12].ToString() == "0" ? false : true; Song.IncludeInNewTalent = dr[13].ToString() == "0" ? false : true; Song.PromotionId = null; Song.SingRing = null; Song.FirstPlayDate = null; Song.ParentSongId = null; Song.Lyric = null; int IdSong = fac.Insert(Song); } } catch (Exception ex) { } } Response.Redirect("Songs.aspx"); } } catch (Exception ex) { pnlError.Visible = true; lblError.Text = ex.Message.ToString();// "Error occured! Please try again later."; } } else { pnlError.Visible = true; lblError.Text = "Upload only excel files."; } } } else { pnlError.Visible = true; lblError.Text = "File name contains illegal characters"; } } else { pnlError.Visible = true; lblError.Text = "Please select a file first"; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["User"] != null) { Session["eSongs"] = null; HtmlGenericControl ManageSongs = (HtmlGenericControl)Master.FindControl("ManageSongs"); ManageSongs.Attributes.Add("class", "current"); HtmlGenericControl ManageCompany = (HtmlGenericControl)Master.FindControl("ManageCompany"); ManageCompany.Attributes.Add("class", "select"); HtmlGenericControl ManageLabel = (HtmlGenericControl)Master.FindControl("ManageLabel"); ManageLabel.Attributes.Add("class", "select"); HtmlGenericControl ManageEmergenti = (HtmlGenericControl)Master.FindControl("ManageEmergenti"); ManageEmergenti.Attributes.Add("class", "select"); HtmlGenericControl ImportData = (HtmlGenericControl)Master.FindControl("ImportData"); ImportData.Attributes.Add("class", "select"); HtmlGenericControl audienceFigures = (HtmlGenericControl)Master.FindControl("audienceFigures"); audienceFigures.Attributes.Add("class", "select"); HtmlGenericControl digitalData = (HtmlGenericControl)Master.FindControl("digitalData"); digitalData.Attributes.Add("class", "select"); HtmlGenericControl MoveFiles = (HtmlGenericControl)Master.FindControl("MoveFiles"); MoveFiles.Attributes.Add("class", "select"); HtmlGenericControl Promoter = (HtmlGenericControl)Master.FindControl("Promoter"); Promoter.Attributes.Add("class", "select"); if (Request.QueryString != null && Request.QueryString["id"] != null) { hf.Value = Request.QueryString["id"]; hfprevid.Value = Request.QueryString["id"]; clsSongsFactory fac = new clsSongsFactory(); List <clsSongs> Songs = fac.GetAllByVersions(Convert.ToInt32(hf.Value)); pnlButtons.Visible = true; pnlSave.Visible = false; if (Songs != null && Songs.Count > 0 && Session["Songs"] == null) { grd.DataSource = Songs; grd.DataBind(); Session["Songs"] = Songs; clsSongs Song = Songs.First(x => x.IdSong == Convert.ToInt32(hf.Value)); lblVersion.Text = Song.VERSION; chkAbsoluteBegin.Checked = Song.IncludeInNewTalent; chkAlternativeCharts.Checked = Song.AlternativeChart; chkFirstPlay.Checked = Song.IncludeInFirstPlay; lblGenre.Text = Song.GENRE; lblLanguage.Text = Song.LANGUAGE; lblRadio.Text = Song.RadioDate == null ? "" : Song.RadioDate.Value.ToString("dd/MM/yyyy"); lblTvShow.Text = Song.TVSHOW; lblArtist.Text = Song.ARTIST; lblTitle.Text = Song.TITLE; lblAuthor.Text = Song.Author; lblPublisher.Text = Song.Publisher; lblDuration.Text = Song.Duration; lblISRC.Text = Song.ISRC; lblLabel.Text = Song.LABEL; clsCompaniesFactory facC = new clsCompaniesFactory(); clsCompaniesKeys k = new clsCompaniesKeys(Songs[0].CompanyId.Value); clsCompanies c = facC.GetByPrimaryKey(k); lblCompany.Text = c.FullName; } else { Songs = (List <clsSongs>)Session["Songs"]; grd.DataSource = Songs; grd.DataBind(); clsSongs Song = Songs.Where(x => x.IdSong == Convert.ToInt32(hf.Value)).FirstOrDefault(); pnlButtons.Visible = false; pnlSave.Visible = true; lblVersion.Text = Song.VERSION; chkAbsoluteBegin.Checked = Song.IncludeInNewTalent; chkAlternativeCharts.Checked = Song.AlternativeChart; chkFirstPlay.Checked = Song.IncludeInFirstPlay; lblGenre.Text = Song.GENRE; lblLanguage.Text = Song.LANGUAGE; lblRadio.Text = Song.RadioDate.Value.ToString("dd/MM/yyyy"); lblTvShow.Text = Song.TVSHOW; lblArtist.Text = Song.ARTIST; lblTitle.Text = Song.TITLE; lblAuthor.Text = Song.Author; lblPublisher.Text = Song.Publisher; lblDuration.Text = Song.Duration; lblISRC.Text = Song.ISRC; lblLabel.Text = Song.LABEL; clsCompaniesFactory facC = new clsCompaniesFactory(); clsCompaniesKeys k = new clsCompaniesKeys(Song.CompanyId.Value); clsCompanies c = facC.GetByPrimaryKey(k); lblCompany.Text = c.FullName; } } } else { Response.Redirect("Login.aspx"); } } }
protected void btnSave_Click(object sender, EventArgs e) { bool error = false; if (Session["Songs"] != null) { string previd = hfprevid.Value; List <clsSongs> Songs1 = (List <clsSongs>)Session["Songs"]; for (int i = 0; i < Songs1.Count; i++) { if (Songs1[i].IdSong.ToString() == previd) { Songs1[i].VERSION = lblVersion.Text; string[] d = lblRadio.Text.Split('/'); DateTime date = new DateTime(Convert.ToInt16(d[2]), Convert.ToInt16(d[1]), Convert.ToInt16(d[0])); Songs1[i].RadioDate = date; Songs1[i].GENRE = lblGenre.Text; Songs1[i].LANGUAGE = lblLanguage.Text; Songs1[i].TVSHOW = lblTvShow.Text; Songs1[i].IncludeInNewTalent = chkAbsoluteBegin.Checked; Songs1[i].AlternativeChart = chkAlternativeCharts.Checked; Songs1[i].IncludeInFirstPlay = chkFirstPlay.Checked; Songs1[i].Duration = lblDuration.Text; Songs1[i].ISRC = lblISRC.Text; } } Session["Songs"] = Songs1; List <clsSongs> Songs = (List <clsSongs>)Session["Songs"]; if (Songs.Count > 0) { foreach (clsSongs s in Songs) { if (string.IsNullOrEmpty(s.VERSION) || string.IsNullOrEmpty(s.LANGUAGE) || string.IsNullOrEmpty(s.GENRE) || string.IsNullOrEmpty(s.RadioDate.ToString())) { error = true; break; } } if (!error) { foreach (clsSongs s in Songs) { clsSongsFactory fac = new clsSongsFactory(); clsSongsKeys key = new clsSongsKeys(s.IdSong); clsSongs _song = fac.GetByPrimaryKey(key); if (_song != null) { fac.Update(s); Session["SuccessMsg"] = "Record Updated Successfully."; } else { fac.Insert(s); Session["SuccessMsg"] = "Record Added Successfully."; } } Session["Songs"] = null; Response.Redirect("Songs.aspx"); } else { Session["ErrorMsg"] = "Error occured! Please try again later."; pnlError.Visible = true; lblError.Text = "Please provide all data."; } } else { pnlError.Visible = true; lblError.Text = "Some error ocurred please go back anf try again"; } } else { pnlError.Visible = true; lblError.Text = "Some error ocurred please go back anf try again"; } }
protected void btn_Click(object sender, EventArgs e) { CultureInfo cinfo = new CultureInfo("it-IT"); clsSongsFactory fac = new clsSongsFactory(); clsSongs Song = new clsSongs(); if (!String.IsNullOrEmpty(hfname.Value)) { if (IsEnglish(hfname.Value)) { if (!hfname.Value.ToLower().Contains(".part")) { Song.ARTIST = txtArtist.Text; Song.CompanyId = Convert.ToInt32(ddlCompany.SelectedValue); Song.FILENAME = hfname.Value; Song.GENRE = ddlGenre.SelectedValue == "0" ? "Pop" : ddlGenre.SelectedValue == "1" ? "Rock" : ddlGenre.SelectedValue == "2" ? "Dance" : ddlGenre.SelectedValue == "3" ? "Hip Hop / Rap" : "Pop";// txtGenre.Text; Song.IncludeInFirstPlay = ddlFirstPlayView.SelectedValue == "1" ? false : true; Song.LABEL = ddlLabel.SelectedItem.Text; Song.LabelId = Convert.ToInt32(ddlLabel.SelectedValue); Song.LANGUAGE = ddlLanguage.SelectedValue == "1" ? "ita" : ddlLanguage.SelectedValue == "0" ? "int" : "int";// txtLanguage.Text; string[] d = txtRadioDate.Text.Split('/'); DateTime date = new DateTime(Convert.ToInt16(d[2]), Convert.ToInt16(d[1]), Convert.ToInt16(d[0])); Song.RadioDate = date; Song.TITLE = txtTitle.Text; Song.Author = txtAuthor.Text; Song.Publisher = txtPublisher.Text; Song.Duration = txtDuration.Text; Song.ISRC = txtISRC.Text; Song.TVSHOW = txtTVShow.Text; Song.VERSION = txtVersion.Text; Song.IncludeInNewTalent = ddlAbsoluteBeginner.SelectedValue == "1" ? false : true; Song.PromotionId = Convert.ToInt32(ddlPromoter.SelectedValue); Song.AlternativeChart = chkAlternativeCharts.Checked; //string folderPath = ConfigurationManager.AppSettings["folder"]; int IsExist = fac.InsertExist_Check(Song); if (IsExist == 0) { int IdSong = fac.Insert(Song); if (IdSong == -1) { pnlError.Visible = true; lblError.Text = "Artist + Title + Version already exist."; } else if (IdSong == -2) { pnlError.Visible = true; lblError.Text = "File Name already exist."; } else { Response.Redirect("SongDetail.aspx?id=" + IdSong); Session["Songs"] = null; } } else if (IsExist == -1) { pnlError.Visible = true; lblError.Text = "Artist + Title already exist."; } else if (IsExist == -2) { pnlError.Visible = true; lblError.Text = "File Name already exist."; } } else { pnlError.Visible = true; lblError.Text = "filename must contains MP3."; } } else { pnlError.Visible = true; lblError.Text = "File name contains illegal characters"; } } else { pnlError.Visible = true; lblError.Text = "Please select a file first"; } }