Pages

▼

Sunday, August 16, 2015

.Net Sound Timer

This tutorial show you how to set sound timer depend on the number of order. It plays sound for notification whenever the number of order change.
Sound Timer

Firstly, copy the following javascript to <head> tage.
<script type="text/javascript">
    function EvalSound(soundobj) {
        var thissound = document.getElementById(soundobj);
        thissound.play();
    }
</script>
Secondly, copy the following code to <form> tag.
<asp:ScriptManager ID="ScriptManager1" runat="server" />
<asp:Timer ID="Timer1" runat="server" Interval="5000" OnTick="Timer1_Tick">
</asp:Timer>
<asp:UpdatePanel ID="UpdatePanel1" runat="server" UpdateMode="Conditional">
    <ContentTemplate>
        <asp:Label ID="lblOrder" runat="server" Text=""></asp:Label>
    </ContentTemplate>
    <Triggers>
        <asp:AsyncPostBackTrigger ControlID="Timer1" />
    </Triggers>
</asp:UpdatePanel>
<audio id="audio1" src="sound/Console_beep.mp3" preload="auto" autobuffer>
</audio>
In code-behind, the following snippet should be there.
protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        string dt = DateTime.Now.ToLongTimeString();
        string count = DAL.GetOrderCount();
        lblOrder.Text = string.Format("There are {0} records at {1}.", count, dt);
        Session["count"] = count;
        
    }
}
protected void Timer1_Tick(object sender, EventArgs e)
{
    string dt = DateTime.Now.ToLongTimeString();
    string count = DAL.GetOrderCount();
    if (count != Session["count"].ToString())
    {
        lblOrder.Text = string.Format("There are {0} records at {1}.", count, dt);
        ScriptManager.RegisterStartupScript(Page, GetType(), "PlaySound", "EvalSound('audio1');", true);
    }
    Session["count"] = count;
}
It uses "Northwind" database and connection string in web.config seem like below:
<connectionStrings>
<add name="sqlConn" providerName="System.Data.SqlClient" connectionString="Server='(local)';uid='sa';pwd='p@ssw0rd';Database='Northwind';Pooling=False;" />
</connectionStrings>
It has the following code snippet in the DAL class. It uses the Microsoft.Practices.EnterpriseLibrary.Data.dll to shorten the code.
private static Database getDatabase()
{
    Database database = null;
    try
    {
        database = DatabaseFactory.CreateDatabase("sqlConn");
    }
    catch (Exception exception)
    {
               
    }
    return database;
}
public static string GetOrderCount()
{
    string count = "";
    try
    {
        count = getDatabase().ExecuteScalar("GetOrderCount").ToString();
    }
    catch (Exception exception)
    {
        
    }
    return count;
}
The "GetOrderCount" stored procedure is as shown below:
USE [Northwind]
GO
ALTER PROCEDURE [dbo].[GetOrderCount]
AS
BEGIN
    SELECT COUNT(*) FROM Orders;
END
This application demonstrates a simple use of the Timer control with UpdatePanel combining HTML5 audio element in a real world example.
at

12 comments:

  1. UnknownNovember 17, 2017 at 5:29 PM

    Wonderful, just what a blog it is! This blog has provided the helpful data to us continue the good work.
    index

    ReplyDelete
  2. c2winDecember 15, 2017 at 11:56 AM

    Your are welcome!

    ReplyDelete
  3. saranyaApril 23, 2018 at 2:24 PM

    Updated information about html.Thanks for sharing such a information.
    selenium training in chennai

    ReplyDelete
  4. UnknownMay 16, 2018 at 12:44 PM

    I have to voice my passion for your kindness giving support to those people that should have guidance on this important matter.

    Hadoop Training in Chennai

    ReplyDelete
  5. MueeidNovember 23, 2018 at 8:29 PM

    Personally, I wouldn't go lower than 128kbps for mp3 - and even at that point, things like cymbals or quiet background sounds can have a strange, warbling sound to it. sound of waterfalls

    ReplyDelete
  6. Richard H. BlackJanuary 16, 2019 at 6:29 PM

    Thanks for sharing nice information with us. i like your post and all you share with us is uptodate and quite informative, i would like to bookmark the page so i can come here again to read you, as you have done a wonderful job. latest naija music

    ReplyDelete
  7. Chris HemsworthJuly 20, 2019 at 5:25 PM

    The article is so informative. This is more helpful for our
    Learn best software testing online certification course class in chennai with placement
    Best selenium testing online course training in chennai
    Best online software testing training course institute in chennai with placement
    Thanks for sharing.

    ReplyDelete
  8. kingsJuly 25, 2019 at 10:04 PM

    We require all the more such articles that we can read with such excitement.
    Vanessa Martel

    ReplyDelete
  9. Thiya AntonyAugust 20, 2019 at 2:46 PM

    Awesome, very interesting to read.Thanks for giving your post :) Kaashiv provides Best DotNet Training in Chennai with professional trainers who provide real-time training and also projects to the candidates for better understanding.

    Oracle Training in Chennai | Android training in chennai | Matlab Training in Chennai | CCNA Training in Chennai

    ReplyDelete
  10. PrwatechAugust 21, 2019 at 11:40 AM

    Oh, that's Great Post Thanks for sharing with us.
    This Big Data Hadoop Training in Pune Platform helped me to learn advanced concepts of all the trending technologies out there in the current IT market. really worth trying them.

    ReplyDelete
  11. Anjali VinuSeptember 21, 2019 at 4:44 PM


    Outstanding blog with lots of information. Keep posting more like this.
    ccna course in Chennai
    ccna institute in Chennai
    ccna Training center in Chennai
    gst classes in Chennai
    ReactJS Training in Chennai
    Salesforce Training in Chennai
    ccna course in Tambaram
    ccna course in Velachery
    CCNA course in Vadapalani

    ReplyDelete
  12. Richard H. BlackJanuary 16, 2020 at 7:42 PM

    Thanks for a very interesting blog. What else may I get that kind of info written in such a perfect approach? I’ve a undertaking that I am simply now operating on, and I have been at the look out for such info. Soundcloud downloader

    ReplyDelete