// return list of information public List <InfoDTO> Infos(int ID) { using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[ConfigurationManager.AppSettings["connection"]].ConnectionString)) { conn.Open(); Object infoID; if (ID == 0) { infoID = DBNull.Value; } else { infoID = ID; } using (SqlCommand cmd = new SqlCommand("pInfoo", conn)) { cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@id", infoID)); // cmd.Parameters.Add(new SqlParameter("@parentId", infoID)); SqlDataReader dr = cmd.ExecuteReader(); List <InfoDTO> infoList = DataReader2Object.GetList <InfoDTO>(dr); return(infoList); } } }
// return info journal public List <InfoDTO> InfoJournal() { using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[ConfigurationManager.AppSettings["connection"]].ConnectionString)) { conn.Open(); using (SqlCommand cmd = new SqlCommand("pInfoGet", conn)) { cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@view", "list")); SqlDataReader dr = cmd.ExecuteReader(); List <InfoDTO> infoList = DataReader2Object.GetList <InfoDTO>(dr); return(infoList); } } }