Error in Stored procedure

See more:

C#

SQL-Server

C#4.0

Hello friends
This is my c# code for getting workingdaytype. for example type 101 means half day, 100 means fullday for school project.

public int getdayforstaffattandence1(DateTime date)
        {
            try
            {
                Dob.open();
                cm = new SqlCommand();
                cm.CommandType = CommandType.StoredProcedure;
                cm.CommandText = "sp_getdayforstaffattandence";
                cm.Parameters.Add(new SqlParameter("@date", date));
                cm.Connection = Dob.con;
                dr = cm.ExecuteReader();
                int timeid=0;
                if (dr.HasRows)
                {

                    timeid =Convert.ToInt32( dr[0].ToString());
                }
                return timeid;
            }
            catch (SqlException ex)
            {
                throw ex;
            }
            finally
            {
                if (Dob.con != null)
                {
                    Dob.close();
                }
            }

And this is my stored procedure

alter procedure sp_getdayforstaffattandence(@date datetime)
as
set nocount on
begin
declare @dates date
set @dates=CONVERT(date,@date,111)
select Time_id from Workingday_details where Working_date=@dates
end

Actually when i run merely storedprocedure it return correct value with the given date. the date format has been copy from c# code. but run with c# code the error is

Invalid attempt to read when no data is present.

please solve this issue. thanks