示例#1
0
        public List <FolderDTO> getsubfolder(int folderid)
        {
            FolderDTO        dto        = new FolderDTO();
            List <FolderDTO> list       = new List <FolderDTO>();
            string           connString = @"Data Source=AZAZ-PC\SQLEXPRESS2012 ;Initial Catalog=Assignment8 ; User Id=sa;Password=1234";

            using (SqlConnection conn = new SqlConnection(connString))
            {
                conn.Open();
                var query = String.Format("Select f.ID , f.Name, f.ParentFolderId ,f.CreatedBy,f.CreatedOn  from Users u , Folder f where u.UserID = f.CreatedBy and f.ParentFolderId = '{0}';", folderid);

                SqlCommand    command = new SqlCommand(query, conn);
                SqlDataReader reader  = command.ExecuteReader();
                while (reader.Read())
                {
                    var dto1 = FillDTO(reader);

                    if (dto1 != null)
                    {
                        list.Add(dto1);
                    }
                }
            }

            return(list);
        }
示例#2
0
        private FolderDTO FillDTO(SqlDataReader reader)
        {
            var dto = new FolderDTO();

            dto.FolderId       = reader.GetInt32(0);
            dto.Name           = reader.GetString(1);
            dto.ParentFolderId = reader.GetInt32(2);
            dto.CreatedBy      = reader.GetInt32(3);
            dto.CreatedOn      = reader.GetDateTime(4);

            return(dto);
        }
示例#3
0
        public int Save(FolderDTO dto)
        {
            int    uid        = 0;
            string connString = @"Data Source=AZAZ-PC\SQLEXPRESS2012 ;Initial Catalog=Assignment8 ; User Id=sa;Password=1234";

            using (SqlConnection conn = new SqlConnection(connString))
            {
                conn.Open();
                String sqlQuery = "";
                {
                    sqlQuery = String.Format("INSERT INTO dbo.Folder(Name,ParentFolderId,CreatedBy,createdOn,IsActive) VALUES('{0}','{1}','{2}','{3}','{4}');",
                                             dto.Name, dto.ParentFolderId, dto.CreatedBy, dto.CreatedOn, dto.IsActive);
                }
                SqlCommand    command = new SqlCommand(sqlQuery, conn);
                SqlDataReader reader  = command.ExecuteReader();
                if (reader.Read())
                {
                    uid = reader.GetInt32(reader.GetOrdinal("ID"));
                }
            }

            return(uid);
        }