public async Task <int> AddQueryRefDocument(QueryRefDocument queryrefdocument)
        {
            db.QueryRefDocuments.Add(queryrefdocument);
            int result = await db.SaveChangesAsync();

            return(result);
        }
        public async Task <int> UpdateQueryRefDocument(QueryRefDocument queryrefdocument)
        {
            QueryRefDocument existingqueryrefdocument = await FetchbyQueryRefDocumentId(queryrefdocument.QueryRefDocumentID);

            db.Entry(existingqueryrefdocument).State = EntityState.Detached;
            db.Entry(queryrefdocument).State         = EntityState.Modified;
            int result = await db.SaveChangesAsync();

            return(result);
        }
        public async Task <QueryRefDocument> FetchbyQueryRefDocumentId(int queryrefdocumentid)
        {
            QueryRefDocument queryrefdocuments = await db.QueryRefDocuments.FindAsync(queryrefdocumentid);

            return(queryrefdocuments);
        }