public ReminderView GetReminderByType(ReminderEnum type, int? EmployeeId)
{
SqlConnection conn = null;
SqlCommand cmd = null;
try
{
conn = DALHelper.CreateSqlDbConnection();
cmd = new SqlCommand("usp_GetCountOfRemindersByType", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Type", Convert.ToInt32(type));
if (EmployeeId != null)
{
cmd.Parameters.AddWithValue("@EmployeeId", EmployeeId);
}
SqlDataReader rdr = cmd.ExecuteReader();
ReminderView entity = new ReminderView();
if (rdr.Read())
{
entity.Count = Convert.ToInt32(rdr["Count"]);
entity.Url = Convert.ToString(rdr["Url"]);
}
return entity;
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
cmd.Dispose();
conn.Dispose();
}
}
public ReminderView GetReminderByType(ReminderEnum type, int?EmployeeId)
{
SqlConnection conn = null;
SqlCommand cmd = null;
try
{
conn = DALHelper.CreateSqlDbConnection();
cmd = new SqlCommand("usp_GetCountOfRemindersByType", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Type", Convert.ToInt32(type));
if (EmployeeId != null)
{
cmd.Parameters.AddWithValue("@EmployeeId", EmployeeId);
}
SqlDataReader rdr = cmd.ExecuteReader();
ReminderView entity = new ReminderView();
if (rdr.Read())
{
entity.Count = Convert.ToInt32(rdr["Count"]);
entity.Url = Convert.ToString(rdr["Url"]);
}
return(entity);
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
cmd.Dispose();
conn.Dispose();
}
}
