public IEnumerable <NotesInnerJoinsProjectsDTO> GetAllNotesIJProjects()
{
var NotesIJProjectsList = new List <NotesInnerJoinsProjectsDTO>();
using (SqlConnection conn = new SqlConnection(connectionstring))
{
string sqlQuery =
"SELECT Notes.NoteId, Projects.ProjectName, Notes.NoteName, Notes.Description, Notes.Urgency FROM Notes INNER JOIN Projects On Notes.ProjectId=Projects.ProjectId";
SqlCommand cmd = new SqlCommand(sqlQuery, conn);
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
var NoteIJProjects = new NotesInnerJoinsProjectsDTO();
NoteIJProjects.NoteId = Convert.ToInt32(dr["NoteId"].ToString());
NoteIJProjects.ProjectName = (dr["ProjectName"].ToString());
NoteIJProjects.NoteName = dr["NoteName"].ToString();
NoteIJProjects.Description = dr["Description"].ToString();
NoteIJProjects.Urgency = dr["Urgency"].ToString();
NotesIJProjectsList.Add(NoteIJProjects);
}
conn.Close();
}
return(NotesIJProjectsList);
}
public NotesIJProjectsModel(NotesInnerJoinsProjectsDTO notesIJProjecstDto)
{
NoteId = notesIJProjecstDto.NoteId;
ProjectName = notesIJProjecstDto.ProjectName;
NoteName = notesIJProjecstDto.NoteName;
Description = notesIJProjecstDto.Description;
Urgency = notesIJProjecstDto.Urgency;
}
