public MamaDogNote GetById(int id)
{
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetMamaDogNoteById";
cmd.Parameters.AddWithValue("@MamaDogNoteId", id);
conn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
MamaDogNote current = new MamaDogNote();
current.MamaDogNoteId = (int)dr["MamaDogNoteId"];
current.MamaDogId = (int)dr["MamaDogId"];
current.Note = dr["Note"].ToString();
current.NoteTitle = dr["NoteTitle"].ToString();
current.DateCreated = (DateTime)dr["DateCreated"];
return(current);
}
}
}
return(null);
}
public IEnumerable <MamaDogNote> GetRecent()
{
using (SqlConnection conn = new SqlConnection())
{
List <MamaDogNote> notes = new List <MamaDogNote>();
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetRecentMamaDogNotes";
conn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
MamaDogNote current = new MamaDogNote();
current.MamaDogNoteId = (int)dr["MamaDogNoteId"];
current.MamaDogId = (int)dr["MamaDogId"];
current.Note = dr["Note"].ToString();
current.NoteTitle = dr["NoteTitle"].ToString();
current.DateCreated = (DateTime)dr["DateCreated"];
notes.Add(current);
}
}
return(notes);
}
}
public int Update(MamaDogNote note)
{
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "UpdateMamaDogNote";
cmd.Parameters.AddWithValue("@MamaDogNoteId", note.MamaDogNoteId);
cmd.Parameters.AddWithValue("@Note", note.Note);
cmd.Parameters.AddWithValue("@NoteTitle", note.NoteTitle);
conn.Open();
cmd.ExecuteNonQuery();
}
return(note.MamaDogNoteId);
}
public int Create(MamaDogNote note)
{
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "CreateMamaDogNote";
cmd.Parameters.AddWithValue("@Note", note.Note);
cmd.Parameters.AddWithValue("@NoteTitle", note.NoteTitle);
cmd.Parameters.AddWithValue("@MamaDogId", note.MamaDogId);
cmd.Parameters.Add(new SqlParameter("@Id", SqlDbType.Int));
cmd.Parameters["@Id"].Direction = ParameterDirection.Output;
conn.Open();
cmd.ExecuteScalar();
return(System.Convert.ToInt32(cmd.Parameters["@Id"].Value));
}
}