public LitterNote 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 = "GetLitterNoteById";
cmd.Parameters.AddWithValue("@LitterNoteId", id);
conn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
LitterNote current = new LitterNote();
current.LitterNoteId = (int)dr["LitterNoteId"];
current.LitterId = (int)dr["LitterId"];
current.Note = dr["Note"].ToString();
current.NoteTitle = dr["NoteTitle"].ToString();
current.DateCreated = (DateTime)dr["DateCreated"];
return(current);
}
}
}
return(null);
}
public IEnumerable <LitterNote> GetRecent()
{
using (SqlConnection conn = new SqlConnection())
{
List <LitterNote> notes = new List <LitterNote>();
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetRecentLitterNotes";
conn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
LitterNote current = new LitterNote();
current.LitterNoteId = (int)dr["LitterNoteId"];
current.LitterId = (int)dr["LitterId"];
current.Note = dr["Note"].ToString();
current.NoteTitle = dr["NoteTitle"].ToString();
current.DateCreated = (DateTime)dr["DateCreated"];
notes.Add(current);
}
}
return(notes);
}
}
public int Update(LitterNote 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 = "UpdateLitterNote";
cmd.Parameters.AddWithValue("@LitterNoteId", note.LitterNoteId);
cmd.Parameters.AddWithValue("@Note", note.Note);
cmd.Parameters.AddWithValue("@NoteTitle", note.NoteTitle);
conn.Open();
cmd.ExecuteNonQuery();
}
return(note.LitterNoteId);
}
public int Create(LitterNote 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 = "CreateLitterNote";
cmd.Parameters.AddWithValue("@Note", note.Note);
cmd.Parameters.AddWithValue("@NoteTitle", note.NoteTitle);
cmd.Parameters.AddWithValue("@LitterId", note.LitterId);
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));
}
}
