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(); } }